List return for Search ResultSet

(1)Search ResultSet (Return List)

public static List find(String fleet, String rank, int month) throws Exception { List lsDaily = new ArrayList(); Connection con = null; PreparedStatement ps = null; ResultSet rs = null; StringBuffer sqlSelect = new StringBuffer(); try { con = DBManager.getConnection(); sqlSelect.append("SELECT * "); sqlSelect.append("FROM FCLMS.ALD_DAILY_QUOTA "); sqlSelect.append("WHERE FLEET_CODE = ? "); sqlSelect.append("AND RANK_CODE =? "); sqlSelect.append("AND Month(FOR_DATE) = ? "); ps = con.prepareStatement(sqlSelect.toString()); ps.setString(1, fleet); ps.setString(2, rank); ps.setInt(3, month); rs = ps.executeQuery(); System.out.println("------------"+sqlSelect.toString()); while (rs.next()) { DailyQuota dq = new DailyQuota(); dq.setFleet(rs.getString("FLEET_CODE")); dq.setRank(rs.getString("RANK_CODE")); dq.setQuota(rs.getInt("QUOTA")); dq.setDate(rs.getDate("FOR_DATE")); dq.setLastUpdBy(rs.getString("LAST_UPD_BY")); dq.setLastUpdTime(rs.getDate("LAST_UPD_DATETIME")); lsDaily.add(dq); } if (ps != null) { ps.close(); } } catch (SQLException se) { DBManager.rollback(con); LogManager.log("Select DailyQuota error: " + se.getMessage(), LogManager.ERROR); se.printStackTrace(); } catch (Exception de) { DBManager.rollback(con); LogManager.log("Select DailyQuota error :" + de.toString(), LogManager.ERROR); de.printStackTrace(); throw de; } finally { if (rs != null) { rs.close(); } if (ps != null) { ps.close(); } if (con != null) { con.close(); } } return lsDaily; }

(2) invoke and read the  list

List lsDaily = new ArrayList(); lsDaily =DailyQuotaDAO.find("A330HKG", "ENG", 1); Iterator it = lsDaily.iterator(); while (it.hasNext()){ DailyQuota dq = (DailyQuota) it.next(); System.out.println("--------"+dq.getFleet()); System.out.println("--------"+dq.getQuota()); }