KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > mvnforum > phpbb2mvnforum > db > jdbc > PhpbbRanksDAOImpl


1 package org.mvnforum.phpbb2mvnforum.db.jdbc;
2
3 import java.sql.Connection JavaDoc;
4 import java.sql.PreparedStatement JavaDoc;
5 import java.sql.ResultSet JavaDoc;
6 import java.sql.SQLException JavaDoc;
7 import java.util.ArrayList JavaDoc;
8 import java.util.Collection JavaDoc;
9
10 import net.myvietnam.mvncore.exception.DatabaseException;
11
12 import org.mvnforum.phpbb2mvnforum.db.PhpbbRanks;
13 import org.mvnforum.phpbb2mvnforum.db.PhpbbRanksDAO;
14 import org.mvnforum.util.DBUtils;
15
16 public class PhpbbRanksDAOImpl implements PhpbbRanksDAO {
17
18     public Collection JavaDoc getBeans() throws DatabaseException {
19             Connection JavaDoc connection = null;
20             PreparedStatement JavaDoc statement = null;
21             ResultSet JavaDoc resultSet = null;
22             Collection JavaDoc retValue = new ArrayList JavaDoc();
23             StringBuffer JavaDoc sql = new StringBuffer JavaDoc(512);
24             sql.append("SELECT rank_id, rank_title, rank_min, rank_special, rank_image");
25             sql.append(" FROM " + TABLE_NAME);
26             //sql.append(" WHERE "); // @todo: uncomment as needed
27
//sql.append(" ORDER BY ColumnName ASC|DESC "); // @todo: uncomment as needed
28
try {
29                 connection = DBUtils.getPhpbbConnection();
30                 statement = connection.prepareStatement(sql.toString());
31                 resultSet = statement.executeQuery();
32                 while (resultSet.next()) {
33                     PhpbbRanks bean = new PhpbbRanks();
34                     bean.setrank_id(resultSet.getInt("rank_id"));
35                     bean.setrank_title(resultSet.getString("rank_title"));
36                     bean.setrank_min(resultSet.getInt("rank_min"));
37                     bean.setrank_special(resultSet.getInt("rank_special"));
38                     bean.setrank_image(resultSet.getString("rank_image"));
39                     retValue.add(bean);
40                 }
41                 return retValue;
42             } catch(SQLException JavaDoc sqle) {
43                 throw new DatabaseException("Error executing SQL in phpbb_ranksDAOImplJDBC.getBeans.");
44             } finally {
45                 DBUtils.closeResultSet(resultSet);
46                 DBUtils.closeStatement(statement);
47                 DBUtils.closeConnection(connection);
48             }
49         }
50
51
52     }
53
54
55
Popular Tags