// 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) { } } }