// Call from MangingComposer.java
public void removeSubscriberStbBind(SubscribersettopboxbindBean bean, Connection conn)
throws Exception {
PreparedStatement preparedStatement = null;
String sqlUpdateAllStmt =
"UPDATE subscribersettopboxbind SET mode = ?, outdate = ? WHERE subscriber_id = ? ";
try {
preparedStatement = conn.prepareStatement(sqlUpdateAllStmt);
preparedStatement.setString(1, bean.getMode());
preparedStatement.setDate(2, bean.getOutdate());
preparedStatement.setInt(3, bean.getSubscriber_id());
preparedStatement.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
throw new Exception();
} finally {
try {
/*dbDatabaseHandler.closeConnection();*/
preparedStatement.close();
} catch (SQLException ioe) {
}
}
}
public void updateAllCols(SubscribersettopboxbindBean bean, Connection conn) throws Exception {
// DatabaseHandler dbDatabaseHandler = DatabaseHandler.getNewInstance();
// Connection conn = dbDatabaseHandler.getConnection();
PreparedStatement preparedStatement = null;
// String sqlUpdateAllStmt = "UPDATE subscribersettopboxbind SET id = ?, subscriber_id = ?,
// settopbox_id = ?, indate = ?, mode = ?, outdate = ?" ;
String sqlUpdateAllStmt =
"UPDATE subscribersettopboxbind SET mode = ?, outdate = ? WHERE id = ? ";
try {
preparedStatement = conn.prepareStatement(sqlUpdateAllStmt);
preparedStatement.setString(1, bean.getMode());
preparedStatement.setDate(2, bean.getOutdate());
preparedStatement.setInt(3, bean.getId());
/*preparedStatement.setInt(2, bean.getSubscriber_id());
preparedStatement.setInt(3, bean.getSettopbox_id());
preparedStatement.setDate(4, bean.getIndate());
*/
preparedStatement.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
throw new Exception();
} finally {
try {
/*dbDatabaseHandler.closeConnection();*/
preparedStatement.close();
} catch (SQLException ioe) {
}
}
}