1 package org.mvnforum.phpbb2mvnforum.db.jdbc; 2 3 import java.sql.Connection ; 4 import java.sql.PreparedStatement ; 5 import java.sql.ResultSet ; 6 import java.sql.SQLException ; 7 import java.util.ArrayList ; 8 import java.util.Collection ; 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 getBeans() throws DatabaseException { 19 Connection connection = null; 20 PreparedStatement statement = null; 21 ResultSet resultSet = null; 22 Collection retValue = new ArrayList (); 23 StringBuffer sql = new StringBuffer (512); 24 sql.append("SELECT rank_id, rank_title, rank_min, rank_special, rank_image"); 25 sql.append(" FROM " + TABLE_NAME); 26 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 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 |