JobConfigurationParameterDAO(final JdbcTemplate jdbcTemplate, final String tableName, final String schema) { this.jdbcTemplate = jdbcTemplate; this.tableName = tableName; this.simpleJdbcInsert = new SimpleJdbcInsert(jdbcTemplate) .withSchemaName(schema) .withTableName(String.format(TABLE_NAME, tableName)) .usingGeneratedKeyColumns(JobConfigurationParameterDomain.ID); this.dateFormat = new SimpleDateFormat(DomainParameterParser.DATE_FORMAT_WITH_TIMESTAMP); }
JobConfigurationDAO(final JdbcTemplate jdbcTemplate, final String tableName, final String schema) { this.jdbcTemplate = jdbcTemplate; this.tableName = tableName; this.simpleJdbcInsert = new SimpleJdbcInsert(jdbcTemplate) .withSchemaName(schema) .withTableName(String.format(TABLE_NAME, tableName)).usingGeneratedKeyColumns( JobConfigurationDomain.JOB_CONFIGURATION_ID); this.jobConfigurationRowMapper = new JobConfigurationRowMapper(); this.jobConfigurationJdbcWrapperRowMapper = new JobConfigurationJdbcWrapperRowMapper(this.jobConfigurationRowMapper); }
public InsertBatchOperate(boolean autoGeneratedKeys, Insert insert, TableMetaData metaData, SimpleJdbcInsert simpleJdbcInsert, SimpleDslSession simpleDslSession) { super(); this.insertContext = insert.getContext(); this.simpleJdbcInsert = simpleJdbcInsert; this.simpleDslSession = simpleDslSession; InsertContext insertContext = insert.getContext(); simpleJdbcInsert.withSchemaName(insertContext.getSchema()) .withTableName(insertContext.getTableName()); if (autoGeneratedKeys) { simpleJdbcInsert.usingColumns(insertContext.getColumnNameArray()) .usingGeneratedKeyColumns(metaData.getKeyNames()); } else { String[] keyNames = metaData.getKeyNames(); Set<String> columns = new HashSet<String>(); List<String> allColumns = insertContext.getColumnNames(); for (String columnName : allColumns) { columns.add(columnName.toUpperCase()); } for (String key : keyNames) { if (!columns.contains(key.toUpperCase())) { generateKeys.add(key); } } allColumns.addAll(generateKeys);// 主键值通过应用程序自动生成 simpleJdbcInsert.usingColumns(allColumns.toArray(new String[0])); } }