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;
}
