Esempio n. 1
0
  /**
   * 自動削除設定をアップデートする
   *
   * @param bean SCH_ADM_CONF Data Bindding JavaBean
   * @return 更新件数
   * @throws SQLException SQL実行例外
   */
  public int updateAutoDelete(NtpAdmConfModel bean) throws SQLException {

    PreparedStatement pstmt = null;
    int count = 0;
    Connection con = null;
    con = getCon();

    try {
      // SQL文
      SqlBuffer sql = new SqlBuffer();
      sql.addSql(" update");
      sql.addSql("   NTP_ADM_CONF");
      sql.addSql(" set ");
      sql.addSql("   NAC_ATDEL_FLG=?,");
      sql.addSql("   NAC_ATDEL_Y=?,");
      sql.addSql("   NAC_ATDEL_M=?,");
      sql.addSql("   NAC_EUID=?,");
      sql.addSql("   NAC_EDATE=?");

      pstmt = con.prepareStatement(sql.toSqlString());
      sql.addIntValue(bean.getNacAtdelFlg());
      sql.addIntValue(bean.getNacAtdelY());
      sql.addIntValue(bean.getNacAtdelM());
      sql.addIntValue(bean.getNacEuid());
      sql.addDateValue(bean.getNacEdate());

      log__.info(sql.toLogString());
      sql.setParameter(pstmt);
      count = pstmt.executeUpdate();
    } catch (SQLException e) {
      throw e;
    } finally {
      JDBCUtil.closeStatement(pstmt);
    }
    return count;
  }
Esempio n. 2
0
 /**
  * Create NTP_ADM_CONF Data Bindding JavaBean From ResultSet
  *
  * @param rs ResultSet
  * @return created NtpAdmConfModel
  * @throws SQLException SQL実行例外
  */
 private NtpAdmConfModel __getNtpAdminConfiFromRs(ResultSet rs) throws SQLException {
   NtpAdmConfModel bean = new NtpAdmConfModel();
   bean.setNacCrange(rs.getInt("NAC_CRANGE"));
   bean.setNacAtdelFlg(rs.getInt("NAC_ATDEL_FLG"));
   bean.setNacAtdelY(rs.getInt("NAC_ATDEL_Y"));
   bean.setNacAtdelM(rs.getInt("NAC_ATDEL_M"));
   bean.setNacHourDiv(rs.getInt("NAC_HOUR_DIV"));
   bean.setNacSmlKbn(rs.getInt("NAC_SML_KBN"));
   bean.setNacSmlNoticeKbn(rs.getInt("NAC_SML_NOTICE_KBN"));
   bean.setNacSmlNoticeGrp(rs.getInt("NAC_SML_NOTICE_GRP"));
   bean.setNacCsmlKbn(rs.getInt("NAC_CSML_KBN"));
   bean.setNacCsmlNoticeKbn(rs.getInt("NAC_CSML_NOTICE_KBN"));
   bean.setNacGsmlKbn(rs.getInt("NAC_GSML_KBN"));
   bean.setNacGsmlNoticeKbn(rs.getInt("NAC_GSML_NOTICE_KBN"));
   bean.setNacAuid(rs.getInt("NAC_AUID"));
   bean.setNacAdate(UDate.getInstanceTimestamp(rs.getTimestamp("NAC_ADATE")));
   bean.setNacEuid(rs.getInt("NAC_EUID"));
   bean.setNacEdate(UDate.getInstanceTimestamp(rs.getTimestamp("NAC_EDATE")));
   return bean;
 }
Esempio n. 3
0
  /**
   * Update NTP_ADM_CONF Data Bindding JavaBean
   *
   * @param bean NTP_ADM_CONF Data Bindding JavaBean
   * @return 更新件数
   * @throws SQLException SQL実行例外
   */
  public int update(NtpAdmConfModel bean) throws SQLException {

    PreparedStatement pstmt = null;
    int count = 0;
    Connection con = null;
    con = getCon();

    try {
      // SQL文
      SqlBuffer sql = new SqlBuffer();
      sql.addSql(" update");
      sql.addSql("   NTP_ADM_CONF");
      sql.addSql(" set ");
      sql.addSql("   NAC_CRANGE=?,");
      sql.addSql("   NAC_ATDEL_FLG=?,");
      sql.addSql("   NAC_ATDEL_Y=?,");
      sql.addSql("   NAC_ATDEL_M=?,");
      sql.addSql("   NAC_HOUR_DIV=?,");
      sql.addSql("   NAC_SML_KBN=?,");
      sql.addSql("   NAC_SML_NOTICE_KBN=?,");
      sql.addSql("   NAC_SML_NOTICE_GRP=?,");
      sql.addSql("   NAC_CSML_KBN=?,");
      sql.addSql("   NAC_CSML_NOTICE_KBN=?,");
      sql.addSql("   NAC_GSML_KBN=?,");
      sql.addSql("   NAC_GSML_NOTICE_KBN=?,");
      sql.addSql("   NAC_AUID=?,");
      sql.addSql("   NAC_ADATE=?,");
      sql.addSql("   NAC_EUID=?,");
      sql.addSql("   NAC_EDATE=?");

      pstmt = con.prepareStatement(sql.toSqlString());
      sql.addIntValue(bean.getNacCrange());
      sql.addIntValue(bean.getNacAtdelFlg());
      sql.addIntValue(bean.getNacAtdelY());
      sql.addIntValue(bean.getNacAtdelM());
      sql.addIntValue(bean.getNacHourDiv());
      sql.addIntValue(bean.getNacSmlKbn());
      sql.addIntValue(bean.getNacSmlNoticeKbn());
      sql.addIntValue(bean.getNacSmlNoticeGrp());
      sql.addIntValue(bean.getNacCsmlKbn());
      sql.addIntValue(bean.getNacCsmlNoticeKbn());
      sql.addIntValue(bean.getNacGsmlKbn());
      sql.addIntValue(bean.getNacGsmlNoticeKbn());
      sql.addIntValue(bean.getNacAuid());
      sql.addDateValue(bean.getNacAdate());
      sql.addIntValue(bean.getNacEuid());
      sql.addDateValue(bean.getNacEdate());

      log__.info(sql.toLogString());
      sql.setParameter(pstmt);
      count = pstmt.executeUpdate();
    } catch (SQLException e) {
      throw e;
    } finally {
      JDBCUtil.closeStatement(pstmt);
    }
    return count;
  }
Esempio n. 4
0
  /**
   * Insert NTP_ADM_CONF Data Bindding JavaBean
   *
   * @param bean NTP_ADM_CONF Data Bindding JavaBean
   * @throws SQLException SQL実行例外
   */
  public void insert(NtpAdmConfModel bean) throws SQLException {

    PreparedStatement pstmt = null;
    Connection con = null;
    con = getCon();

    try {
      // SQL文
      SqlBuffer sql = new SqlBuffer();
      sql.addSql(" insert ");
      sql.addSql(" into ");
      sql.addSql(" NTP_ADM_CONF(");
      sql.addSql("   NAC_CRANGE,");
      sql.addSql("   NAC_ATDEL_FLG,");
      sql.addSql("   NAC_ATDEL_Y,");
      sql.addSql("   NAC_ATDEL_M,");
      sql.addSql("   NAC_HOUR_DIV,");
      sql.addSql("   NAC_SML_KBN,");
      sql.addSql("   NAC_SML_NOTICE_KBN,");
      sql.addSql("   NAC_SML_NOTICE_GRP,");
      sql.addSql("   NAC_CSML_KBN,");
      sql.addSql("   NAC_CSML_NOTICE_KBN,");
      sql.addSql("   NAC_GSML_KBN,");
      sql.addSql("   NAC_GSML_NOTICE_KBN,");
      sql.addSql("   NAC_AUID,");
      sql.addSql("   NAC_ADATE,");
      sql.addSql("   NAC_EUID,");
      sql.addSql("   NAC_EDATE");
      sql.addSql(" )");
      sql.addSql(" values");
      sql.addSql(" (");
      sql.addSql("   ?,");
      sql.addSql("   ?,");
      sql.addSql("   ?,");
      sql.addSql("   ?,");
      sql.addSql("   ?,");
      sql.addSql("   ?,");
      sql.addSql("   ?,");
      sql.addSql("   ?,");
      sql.addSql("   ?,");
      sql.addSql("   ?,");
      sql.addSql("   ?,");
      sql.addSql("   ?,");
      sql.addSql("   ?,");
      sql.addSql("   ?,");
      sql.addSql("   ?,");
      sql.addSql("   ?");
      sql.addSql(" )");

      pstmt = con.prepareStatement(sql.toSqlString());
      sql.addIntValue(bean.getNacCrange());
      sql.addIntValue(bean.getNacAtdelFlg());
      sql.addIntValue(bean.getNacAtdelY());
      sql.addIntValue(bean.getNacAtdelM());
      sql.addIntValue(bean.getNacHourDiv());
      sql.addIntValue(bean.getNacSmlKbn());
      sql.addIntValue(bean.getNacSmlNoticeKbn());
      sql.addIntValue(bean.getNacSmlNoticeGrp());
      sql.addIntValue(bean.getNacCsmlKbn());
      sql.addIntValue(bean.getNacCsmlNoticeKbn());
      sql.addIntValue(bean.getNacGsmlKbn());
      sql.addIntValue(bean.getNacGsmlNoticeKbn());
      sql.addIntValue(bean.getNacAuid());
      sql.addDateValue(bean.getNacAdate());
      sql.addIntValue(bean.getNacEuid());
      sql.addDateValue(bean.getNacEdate());
      log__.info(sql.toLogString());
      sql.setParameter(pstmt);
      pstmt.executeUpdate();
    } catch (SQLException e) {
      throw e;
    } finally {
      JDBCUtil.closeStatement(pstmt);
    }
  }