コード例 #1
0
  // 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) {
      }
    }
  }
コード例 #2
0
  public void deleteByoutdate(Date outdate) throws Exception {

    DatabaseHandler dbDatabaseHandler = DatabaseHandler.getNewInstance();

    Connection conn = dbDatabaseHandler.getConnection();

    PreparedStatement preparedStatement = null;

    String sqlDeleteByOutdate = "DELETE FROM subscribersettopboxbind WHERE outdate = ? ";

    try {

      preparedStatement = conn.prepareStatement(sqlDeleteByOutdate);

      preparedStatement.setDate(1, outdate);

      preparedStatement.executeUpdate();

    } catch (Exception e) {

      e.printStackTrace();

    } finally {

      try {
        dbDatabaseHandler.closeConnection();
        preparedStatement.close();
      } catch (SQLException ioe) {
      }
    }

    // no return value here

  }
コード例 #3
0
  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) {
      }
    }
  }
コード例 #4
0
  public int insertAllCols(SubscribersettopboxbindBean bean, Connection conn) throws Exception {

    // DatabaseHandler dbDatabaseHandler = DatabaseHandler.getNewInstance();

    // Connection conn = dbDatabaseHandler.getConnection();

    PreparedStatement preparedStatement = null;

    ResultSet resultSet = null;

    int generatedsubscriberstbbindId = 0;

    // String sqlInsertAllStmt = "INSERT INTO subscribersettopboxbind( id, subscriber_id,
    // settopbox_id, indate, mode, outdate ) VALUES ( ? , ? , ? , ? , ? , ?  )" ;
    String sqlInsertAllStmt =
        "INSERT INTO subscribersettopboxbind(subscriber_id,settopbox_id,indate) VALUES (?,?,?)";

    try {

      preparedStatement =
          conn.prepareStatement(sqlInsertAllStmt, preparedStatement.RETURN_GENERATED_KEYS);

      /*preparedStatement.setInt(1, bean.getId());*/

      preparedStatement.setInt(1, bean.getSubscriber_id());

      preparedStatement.setInt(2, bean.getSettopbox_id());

      preparedStatement.setDate(3, bean.getIndate());

      /*preparedStatement.setString(5, bean.getMode());*/

      /*preparedStatement.setDate(6, bean.getOutdate());*/

      preparedStatement.executeUpdate();

      resultSet = preparedStatement.getGeneratedKeys();

      if (resultSet.next()) {

        System.out.println("generatedsubscriberstbbindId: " + resultSet.getInt(1));

        generatedsubscriberstbbindId = resultSet.getInt(1);
      }

    } catch (Exception e) {

      e.printStackTrace();

      throw new Exception();

    } finally {

      try {
          /*dbDatabaseHandler.closeConnection();*/
        preparedStatement.close();
      } catch (SQLException ioe) {
      }
    }
    return generatedsubscriberstbbindId;
  }
コード例 #5
0
  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;
  }