public SubscribersettopboxbindBean[] findByoutdate(Date outdate) throws Exception { DatabaseHandler dbDatabaseHandler = DatabaseHandler.getNewInstance(); Connection conn = dbDatabaseHandler.getConnection(); PreparedStatement preparedStatement = null; ResultSet resultSet = null; SubscribersettopboxbindBean[] beans = null; ArrayList beansList = new ArrayList(); String sqlSelectByOutdate = "SELECT id, subscriber_id, settopbox_id, indate, mode, outdate FROM subscribersettopboxbind WHERE outdate = ? "; try { preparedStatement = conn.prepareStatement(sqlSelectByOutdate); preparedStatement.setDate(1, outdate); resultSet = preparedStatement.executeQuery(); while (resultSet.next()) { SubscribersettopboxbindBean bean = new SubscribersettopboxbindBean(); bean.setId(resultSet.getInt("id")); bean.setSubscriber_id(resultSet.getInt("subscriber_id")); bean.setSettopbox_id(resultSet.getInt("settopbox_id")); bean.setIndate(resultSet.getDate("indate")); bean.setMode(resultSet.getString("mode")); bean.setOutdate(resultSet.getDate("outdate")); beansList.add(bean); } Object[] objectArray = beansList.toArray(); beans = new SubscribersettopboxbindBean[objectArray.length]; for (int jindex = 0; jindex < objectArray.length; jindex++) { beans[jindex] = (SubscribersettopboxbindBean) objectArray[jindex]; } } catch (Exception e) { e.printStackTrace(); } finally { try { dbDatabaseHandler.closeConnection(); preparedStatement.close(); } catch (SQLException ioe) { } } return beans; }