/**
* 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);
}
}
