/** * Insert CMN_LABEL_USR Data Bindding JavaBean * * @param bean CMN_LABEL_USR Data Bindding JavaBean * @throws SQLException SQL実行例外 */ public void insert(CmnLabelUsrModel 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(" CMN_LABEL_USR("); sql.addSql(" LAB_SID,"); sql.addSql(" LUC_SID,"); sql.addSql(" LAB_NAME,"); sql.addSql(" LAB_BIKO,"); sql.addSql(" LAB_AUID,"); sql.addSql(" LAB_ADATE,"); sql.addSql(" LAB_EUID,"); sql.addSql(" LAB_EDATE,"); sql.addSql(" LAB_SORT"); 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(" )"); pstmt = con.prepareStatement(sql.toSqlString()); sql.addIntValue(bean.getLabSid()); sql.addIntValue(bean.getLucSid()); sql.addStrValue(bean.getLabName()); sql.addStrValue(bean.getLabBiko()); sql.addIntValue(bean.getLabAuid()); sql.addDateValue(bean.getLabAdate()); sql.addIntValue(bean.getLabEuid()); sql.addDateValue(bean.getLabEdate()); sql.addIntValue(bean.getLabSort()); log__.info(sql.toLogString()); sql.setParameter(pstmt); pstmt.executeUpdate(); } catch (SQLException e) { throw e; } finally { JDBCUtil.closeStatement(pstmt); } }