@Override @Deprecated public long insertMapGetGeneratedKey(String tableName, String keyName, Map<String, Object> mapParameter) { Assert.notNull(tableName, "表名不能为空!"); Assert.notNull(keyName, "自增字段名称不能为空!"); Assert.notNull(mapParameter, "对象map不能为空!"); jdbcInsert = jdbcInsert.withTableName(tableName).usingGeneratedKeyColumns(keyName); Number number = jdbcInsert.executeAndReturnKey(mapParameter); logger.info("生成 Key 为:[{}]:", number); return number.longValue(); }
@Override @Deprecated public long insertBeanGetGeneratedKey(String tableName, String keyName, Object beanParameter) { Assert.notNull(tableName, "表名不能为空"); Assert.notNull(keyName, "自增字段名称不能为空"); Assert.notNull(beanParameter, "对象bean不能为空"); jdbcInsert = jdbcInsert.withTableName(tableName).usingGeneratedKeyColumns(keyName); Number number = jdbcInsert.executeAndReturnKey(generateBeanSqlParamSource(beanParameter)); logger.info("生成 Key 为:[{}]:", number); return number.longValue(); }
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); }
@SuppressWarnings("SpringJavaAutowiringInspection") @Autowired public JDBCDataRepositoryImpl(NamedParameterJdbcTemplate jdbcTemplate) { this.jdbcTemplate = jdbcTemplate; this.insertIntoProject = new SimpleJdbcInsert((JdbcTemplate) jdbcTemplate.getJdbcOperations()) .withTableName("project") .usingGeneratedKeyColumns("pid"); }
public JdbcPurchaseOrderDao(DataSource dataSource) { insert = new SimpleJdbcInsert(dataSource) .withTableName("PURCHASE_ORDER") .usingGeneratedKeyColumns("PURCHASE_ORDER_ID") .usingColumns("ITEM_ID", "PAYMENT_INFO_ID", "ADDRESS"); }
public JdbcPaymentInfoDao(DataSource dataSource) { insert = new SimpleJdbcInsert(dataSource) .withTableName("PAYMENT_INFO") .usingGeneratedKeyColumns("PAYMENT_INFO_ID") .usingColumns("PRICE"); }
public ConferencenJdbcInsert(DataSource dataSource, Conference conference) { super(dataSource); this.conference = conference; this.withTableName("conference") .usingColumns("name", "slug", "description", "started_date", "ended_date") .usingGeneratedKeyColumns("id"); compile(); }
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])); } }
@Autowired(required = true) public void initialize(final DataSource dataSource) { this.jdbcTemplate = new SimpleJdbcTemplate(dataSource); this.bookInsert = new SimpleJdbcInsert(dataSource).withTableName("books") .usingGeneratedKeyColumns("id"); }
@Autowired(required = true) public void initialize(final DataSource dataSource) { this.jdbcTemplate = new NamedParameterJdbcTemplate(dataSource); this.bookInsert = new SimpleJdbcInsert(dataSource).withTableName("books") .usingGeneratedKeyColumns("id"); }
@Autowired(required = true) public void initialize(final DataSource dataSource) { this.jdbcTemplate = new NamedParameterJdbcTemplate(dataSource); this.bookInsert = new SimpleJdbcInsert(dataSource).withTableName("books") .usingGeneratedKeyColumns("id"); }
@Autowired(required = true) public void initialize(final DataSource dataSource) { this.jdbcTemplate = new NamedParameterJdbcTemplate(dataSource); this.bookInsert = new SimpleJdbcInsert(dataSource).withTableName("books") .usingGeneratedKeyColumns("id"); }
jdbcInsert.withTableName("channel").usingGeneratedKeyColumns("id"); Map<String, Object> parameters = new HashMap<>(); parameters.put("name", channel.getName());
@Override public Trigger addTrigger(Trigger trigger) { log.debug("addTrigger({})", trigger); try { validate(trigger); // if everything went ok so far, check access rights and perform additional custom validation if needed. final String uid = context.getAccessToken().getId(); userProfileHandler.validateTriggerAccess(uid, trigger); SimpleJdbcInsert jdbcInsert = new SimpleJdbcInsert(getJdbcTemplate()); jdbcInsert.withTableName("triggers").usingGeneratedKeyColumns("ID"); Map<String, Object> parameters = new HashMap<>(); parameters.put("name", trigger.getName()); parameters.put("triggercondition", trigger.getTriggerCondition()); parameters.put("bps_id", trigger.getBusinessProcessId()); parameters.put("cnl_id", trigger.getChannelId()); parameters.put("ugo_uid", uid); Number key = jdbcInsert.executeAndReturnKey(new MapSqlParameterSource(parameters)); int id = key.intValue(); commitTransaction(); Trigger result = getTrigger(id); notifier.notifyCreate(result); return result; } catch (RegistryException e) { log.error(e.getDescription()); throw e; } catch (SQLException e) { log.error("addTrigger({})", trigger, e); throw new RegistryException(e, UNKNOWN_TECHNICAL); } }
@Override public void addAvailableResource(AvailableResource availableResource) { log.trace("addAvailableResources(availableResource: {}", availableResource); try { validate(availableResource); // if everything went ok so far, check access rights and perform additional custom validation if needed. final String uid = context.getAccessToken().getId(); userProfileHandler.validateAvailableResourceAccess(uid, availableResource); SimpleJdbcInsert jdbcInsert = new SimpleJdbcInsert(getJdbcTemplate()); jdbcInsert.withTableName("available_resource").usingGeneratedKeyColumns("id"); Map<String, Object> parameters = new HashMap<>(); parameters.put("bps_id", availableResource.getBusinessProcessId()); parameters.put("uri", availableResource.getUri()); Number key = jdbcInsert.executeAndReturnKey(new MapSqlParameterSource(parameters)); // get the primary key of the inserted available resource int id = key.intValue(); log.debug("generated id {} for new availableResource", id); commitTransaction(); AvailableResource result = getAvailableResourceById(id); notifier.notifyCreate(result); } catch (RegistryException e) { log.error(e.getDescription()); throw e; } catch (SQLException e) { log.error("addAvailableResource({})", availableResource, e); throw new RegistryException("Error storing available resource " + availableResource, e, RegistryException.Type.UNKNOWN_TECHNICAL); } }
jdbcInsert.withTableName("capability").usingGeneratedKeyColumns("id"); Map<String, Object> parameters = new HashMap<>(); parameters.put("cte_id", capability.getCteId());
jdbcInsert.withTableName("capability_type").usingGeneratedKeyColumns("id"); Map<String, Object> parameters = new HashMap<>(); parameters.put("name", capabilityType.getName());
protected BaseSpringJdbcRepository(JdbcTemplate jdbcTemplate, SqlGenerator sqlGenerator) { this.sqlGenerator = sqlGenerator; this.jdbcTemplate = new NamedParameterJdbcTemplate(jdbcTemplate); this.jdbcInsert = new SimpleJdbcInsert(jdbcTemplate) .withTableName(entityMeta.getTable()) .usingGeneratedKeyColumns(entityMeta.getIdColumnName()); this.rowMapper = createRowMapper(entityMeta.getClassType()); }
jdbcInsert.withTableName("business_process_template").usingGeneratedKeyColumns("id"); Map<String, Object> parameters = new HashMap<>(); parameters.put("name", businessProcessTemplate.getName());