/** * アカウント設定を更新する * * @param bean WML_ADM_CONF Data Bindding JavaBean * @return 更新件数 * @throws SQLException SQL実行例外 */ public int updateAdmConf(WmlAdmConfModel bean) throws SQLException { PreparedStatement pstmt = null; int count = 0; Connection con = null; con = getCon(); boolean receiveUpFlg = bean.getWadAutoreceive() == GSConstWebmail.MAIL_AUTO_RSV_ON; try { // SQL文 SqlBuffer sql = new SqlBuffer(); sql.addSql(" update"); sql.addSql(" WML_ADM_CONF"); sql.addSql(" set "); sql.addSql(" WAD_ACNT_MAKE=?,"); sql.addSql(" WAD_ACCT_SENDFORMAT=?,"); sql.addSql(" WAD_ACCT_LOG_REGIST=?,"); sql.addSql(" WAD_PERMIT_KBN=?,"); if (receiveUpFlg) { sql.addSql(" WAD_AUTO_RECEIVE_TIME=?,"); } sql.addSql(" WAD_DISK=?,"); sql.addSql(" WAD_DISK_SIZE=?,"); sql.addSql(" WAD_DISK_COMP=?,"); sql.addSql(" WAD_DELRECEIVE=?,"); sql.addSql(" WAD_AUTORECEIVE=?,"); sql.addSql(" WAD_SEND_HOST=?,"); sql.addSql(" WAD_SEND_PORT=?,"); sql.addSql(" WAD_SEND_SSL=?,"); sql.addSql(" WAD_RECEIVE_HOST=?,"); sql.addSql(" WAD_RECEIVE_PORT=?,"); sql.addSql(" WAD_RECEIVE_SSL=?,"); sql.addSql(" WAD_CHECK_ADDRESS=?,"); sql.addSql(" WAD_CHECK_FILE=?,"); sql.addSql(" WAD_COMPRESS_FILE=?,"); sql.addSql(" WAD_TIMESENT=?,"); sql.addSql(" WAD_SEND_LIMIT=?,"); sql.addSql(" WAD_SEND_LIMIT_SIZE=?,"); sql.addSql(" WAD_FWLIMIT=?,"); sql.addSql(" WAD_BCC=?,"); sql.addSql(" WAD_BCC_TH=?,"); sql.addSql(" WAD_WARN_DISK=?,"); sql.addSql(" WAD_WARN_DISK_TH=?,"); sql.addSql(" WAD_SETTING_SERVER=?,"); sql.addSql(" WAD_PROXY_USER=?,"); sql.addSql(" WAD_COMPRESS_FILE_DEF=?,"); sql.addSql(" WAD_TIMESENT_DEF=?"); pstmt = con.prepareStatement(sql.toSqlString()); sql.addIntValue(bean.getWadAcntMake()); sql.addIntValue(bean.getWadAcctSendformat()); sql.addIntValue(bean.getWadAcctLogRegist()); sql.addIntValue(bean.getWadPermitKbn()); if (receiveUpFlg) { sql.addIntValue(bean.getWadAutoReceiveTime()); } sql.addIntValue(bean.getWadDisk()); sql.addIntValue(bean.getWadDiskSize()); sql.addIntValue(bean.getWadDiskComp()); sql.addIntValue(bean.getWadDelreceive()); sql.addIntValue(bean.getWadAutoreceive()); sql.addStrValue(bean.getWadSendHost()); sql.addIntValue(bean.getWadSendPort()); sql.addIntValue(bean.getWadSendSsl()); sql.addStrValue(bean.getWadReceiveHost()); sql.addIntValue(bean.getWadReceivePort()); sql.addIntValue(bean.getWadReceiveSsl()); sql.addIntValue(bean.getWadCheckAddress()); sql.addIntValue(bean.getWadCheckFile()); sql.addIntValue(bean.getWadCompressFile()); sql.addIntValue(bean.getWadTimesent()); sql.addIntValue(bean.getWadSendLimit()); sql.addIntValue(bean.getWadSendLimitSize()); sql.addIntValue(bean.getWadFwlimit()); sql.addIntValue(bean.getWadBcc()); sql.addIntValue(bean.getWadBccTh()); sql.addIntValue(bean.getWadWarnDisk()); sql.addIntValue(bean.getWadWarnDiskTh()); sql.addIntValue(bean.getWadSettingServer()); sql.addIntValue(bean.getWadProxyUser()); sql.addIntValue(bean.getWadCompressFileDef()); sql.addIntValue(bean.getWadTimesentDef()); log__.info(sql.toLogString()); sql.setParameter(pstmt); count = pstmt.executeUpdate(); } catch (SQLException e) { throw e; } finally { JDBCUtil.closeStatement(pstmt); } return count; }
/** * Insert WML_ADM_CONF Data Bindding JavaBean * * @param bean WML_ADM_CONF Data Bindding JavaBean * @throws SQLException SQL実行例外 */ public void insert(WmlAdmConfModel 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(" WML_ADM_CONF("); sql.addSql(" WAD_ACNT_MAKE,"); sql.addSql(" WAD_ACCT_SENDFORMAT,"); sql.addSql(" WAD_ACCT_LOG_REGIST,"); sql.addSql(" WAD_PERMIT_KBN,"); sql.addSql(" WAD_AUTO_RECEIVE_TIME,"); sql.addSql(" WAD_DISK,"); sql.addSql(" WAD_DISK_SIZE,"); sql.addSql(" WAD_DISK_COMP,"); sql.addSql(" WAD_DELRECEIVE,"); sql.addSql(" WAD_AUTORECEIVE,"); sql.addSql(" WAD_SEND_HOST,"); sql.addSql(" WAD_SEND_PORT,"); sql.addSql(" WAD_SEND_SSL,"); sql.addSql(" WAD_RECEIVE_HOST,"); sql.addSql(" WAD_RECEIVE_PORT,"); sql.addSql(" WAD_RECEIVE_SSL,"); sql.addSql(" WAD_CHECK_ADDRESS,"); sql.addSql(" WAD_CHECK_FILE,"); sql.addSql(" WAD_COMPRESS_FILE,"); sql.addSql(" WAD_TIMESENT,"); sql.addSql(" WAD_SEND_LIMIT,"); sql.addSql(" WAD_SEND_LIMIT_SIZE,"); sql.addSql(" WAD_FWLIMIT,"); sql.addSql(" WAD_BCC,"); sql.addSql(" WAD_BCC_TH,"); sql.addSql(" WAD_WARN_DISK,"); sql.addSql(" WAD_WARN_DISK_TH,"); sql.addSql(" WAD_SETTING_SERVER,"); sql.addSql(" WAD_PROXY_USER,"); sql.addSql(" WAD_COMPRESS_FILE_DEF,"); sql.addSql(" WAD_TIMESENT_DEF"); 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(" ?,"); 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.getWadAcntMake()); sql.addIntValue(bean.getWadAcctSendformat()); sql.addIntValue(bean.getWadAcctLogRegist()); sql.addIntValue(bean.getWadPermitKbn()); sql.addIntValue(bean.getWadAutoReceiveTime()); sql.addIntValue(bean.getWadDisk()); sql.addIntValue(bean.getWadDiskSize()); sql.addIntValue(bean.getWadDiskComp()); sql.addIntValue(bean.getWadDelreceive()); sql.addIntValue(bean.getWadAutoreceive()); sql.addStrValue(bean.getWadSendHost()); sql.addIntValue(bean.getWadSendPort()); sql.addIntValue(bean.getWadSendSsl()); sql.addStrValue(bean.getWadReceiveHost()); sql.addIntValue(bean.getWadReceivePort()); sql.addIntValue(bean.getWadReceiveSsl()); sql.addIntValue(bean.getWadCheckAddress()); sql.addIntValue(bean.getWadCheckFile()); sql.addIntValue(bean.getWadCompressFile()); sql.addIntValue(bean.getWadTimesent()); sql.addIntValue(bean.getWadSendLimit()); sql.addIntValue(bean.getWadSendLimitSize()); sql.addIntValue(bean.getWadFwlimit()); sql.addIntValue(bean.getWadBcc()); sql.addIntValue(bean.getWadBccTh()); sql.addIntValue(bean.getWadWarnDisk()); sql.addIntValue(bean.getWadWarnDiskTh()); sql.addIntValue(bean.getWadSettingServer()); sql.addIntValue(bean.getWadProxyUser()); sql.addIntValue(bean.getWadCompressFileDef()); sql.addIntValue(bean.getWadTimesentDef()); log__.info(sql.toLogString()); sql.setParameter(pstmt); pstmt.executeUpdate(); } catch (SQLException e) { throw e; } finally { JDBCUtil.closeStatement(pstmt); } }