@Override protected void initDao() throws Exception { super.initDao(); insertGame = new SimpleJdbcInsert(getDataSource()).withTableName("GAMES").usingColumns("player_id", "year_no", "team", "week", "opponent", " completes", "attempts", "passing_yards", "passing_td", "interceptions", "rushes", "rush_yards", "receptions", "receptions_yards", "total_td"); }
@Override protected void initDao() throws Exception { super.initDao(); insertGame = new SimpleJdbcInsert(getDataSource()).withTableName("GAMES").usingColumns("player_id", "year_no", "team", "week", "opponent", " completes", "attempts", "passing_yards", "passing_td", "interceptions", "rushes", "rush_yards", "receptions", "receptions_yards", "total_td"); }
public PaymentWriter(DataSource dataSource) { paymentInsert = new SimpleJdbcInsert(dataSource) .withTableName("PAYMENTS") .usingColumns("RECIPIENT", "PAYEE", "AMOUNT", "PAY_DATE"); accountUpdate = new JdbcTemplate(dataSource); }
public PaymentWriter(DataSource dataSource) { paymentInsert = new SimpleJdbcInsert(dataSource) .withTableName("PAYMENTS") .usingColumns("RECIPIENT", "PAYEE", "AMOUNT", "PAY_DATE"); accountUpdate = new JdbcTemplate(dataSource); }
public PaymentWriter(DataSource dataSource) { paymentInsert = new SimpleJdbcInsert(dataSource).withTableName("PAYMENTS").usingColumns("RECIPIENT", "PAYEE", "AMOUNT", "PAY_DATE"); accountUpdate = new JdbcTemplate(dataSource); }
public PaymentWriter(DataSource dataSource) { paymentInsert = new SimpleJdbcInsert(dataSource) .withTableName("PAYMENTS") .usingColumns("RECIPIENT", "PAYEE", "AMOUNT", "PAY_DATE"); accountUpdate = new JdbcTemplate(dataSource); }
public PaymentWriter(DataSource dataSource) { paymentInsert = new SimpleJdbcInsert(dataSource) .withTableName("PAYMENTS") .usingColumns("RECIPIENT", "PAYEE", "AMOUNT", "PAY_DATE"); accountUpdate = new JdbcTemplate(dataSource); }
public PaymentWriter(DataSource dataSource) { paymentInsert = new SimpleJdbcInsert(dataSource) .withTableName("PAYMENTS") .usingColumns("RECIPIENT", "PAYEE", "AMOUNT", "PAY_DATE"); accountUpdate = new JdbcTemplate(dataSource); }
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(); }
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 SimpleInsertMessageDao(DataSource dataSource) { simpleInsert = new SimpleJdbcInsert(dataSource); simpleInsert.withTableName("guestmessage") .usingColumns("name", "message", "creationTime") .setGeneratedKeyName("id"); delegate = new JdbcTemplateMessageDao(dataSource); }
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])); } }