Package org.springframework.jdbc.core

Examples of org.springframework.jdbc.core.PreparedStatementCreator

178
179
180
181
182
183
184
185
186
187
188
      final BagOfWordsData bagOfWordsData) {
    txNew.execute(new TransactionCallback<Object>() {

      @Override
      public Object doInTransaction(TransactionStatus txStatus) {
        jdbcTemplate.query(new PreparedStatementCreator() {

          @Override
          public PreparedStatement createPreparedStatement(
              Connection conn) throws SQLException {
            return conn.prepareStatement(sql,
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
   * @param sql
   * @param args
   */
  protected long insertWithIdReturn(final String sql, final Object... args) {
    KeyHolder keyHolder = new GeneratedKeyHolder();
    jdbcTemplate.update(new PreparedStatementCreator() {
      @Override
      public PreparedStatement createPreparedStatement(Connection conn) throws SQLException {
        PreparedStatement ps = conn.prepareStatement(sql, PreparedStatement.RETURN_GENERATED_KEYS);
        for (int i = 1; i <= args.length; i++) {
          ps.setObject(i, args[i - 1]);
View Full Code Here
128
129
130
131
132
133
134
135
136
137
138
   */
  @SuppressWarnings("unchecked")
  protected <T extends Number> List<T> batchInsertWithIdReturn(final String sql, final List<Object[]> argsList) {
    Assert.notEmpty(argsList, "args can not be empty while batch insert");
    final KeyHolder keyHolder = new GeneratedKeyHolder();
    jdbcTemplate.execute(new PreparedStatementCreator() {
      @Override
      public PreparedStatement createPreparedStatement(Connection con) throws SQLException {
        PreparedStatement ps = con.prepareStatement(sql, PreparedStatement.RETURN_GENERATED_KEYS);
        return ps;
      }
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
  }

  @Override
  public int update(String sql, KeyHolder keyHolder, Object... args) {
    boolean returnKeys = (keyHolder != null);
    PreparedStatementCreator psc = getPreparedStatementCreator(sql, args, returnKeys);
    if (keyHolder == null) {
      return jdbcTemplate.update(psc);
    } else {
      return jdbcTemplate.update(psc, getWrapperKeyHolder(keyHolder));
    }
View Full Code Here
49
50
51
52
53
54
55
56
  @Override
  public int[] batchUpdate(String sql, List<Object[]> argsList, KeyHolder generatedKeyHolder) {
    BatchPreparedStatementSetter pss = getBatchPreparedStatementSetter(argsList);
    PreparedStatementCallback<int[]> action = getPreparedStatementCallback(pss, generatedKeyHolder);
    boolean returnKeys = (generatedKeyHolder != null);
    PreparedStatementCreator psc = getPreparedStatementCreator(sql, returnKeys);
    return jdbcTemplate.execute(psc, action);
  }
View Full Code Here
14
15
16
17
18
19
20
21
22
23
24
  private PreparedStatementCreatorFactory() {
   
  }
 
  public static PreparedStatementCreator createPreparedStatementCreator(final String sql, final boolean returnKeys) {
    PreparedStatementCreator creator = new PreparedStatementCreator() {

      @Override
      public PreparedStatement createPreparedStatement(Connection con) throws SQLException {
        PreparedStatement ps = con.prepareStatement(sql);
        if (returnKeys) {
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
    return creator;
  }

  public static PreparedStatementCreator createPreparedStatementCreator(final String sql, final Object[] args,
      final boolean returnKeys) {
    PreparedStatementCreator creator = new PreparedStatementCreator() {

      @Override
      public PreparedStatement createPreparedStatement(Connection con) throws SQLException {
        PreparedStatement ps = con.prepareStatement(sql);
        if (returnKeys) {
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
 
  @Transactional
  @Override
  public void create(final InformationForm infoForm) {
    KeyHolder keyHolder = new GeneratedKeyHolder();
    getJdbcOperations().update(new PreparedStatementCreator() {
      @Override
      public PreparedStatement createPreparedStatement(Connection con)
          throws SQLException {
        String sql = "INSERT INTO " +quoteTable("information")+ "(sort_order, bottom, status) VALUES(?,?,?) ";
        PreparedStatement ps = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
 
  @Transactional
  @Override
  public void create(final AttributeGroupForm attrGrpForm) {
    KeyHolder keyHolder = new GeneratedKeyHolder();
    getJdbcOperations().update(new PreparedStatementCreator() {
      @Override
      public PreparedStatement createPreparedStatement(Connection con)
          throws SQLException {
        String sql = "INSERT INTO " +quoteTable("attribute_group")+ "(sort_order) VALUES(?) ";
        PreparedStatement ps = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
 
  @Transactional
  @Override
  public void create(final AttributeForm attrForm) {
    KeyHolder keyHolder = new GeneratedKeyHolder();
    getJdbcOperations().update(new PreparedStatementCreator() {
      @Override
      public PreparedStatement createPreparedStatement(Connection con)
          throws SQLException {
        String sql = "INSERT INTO " +quoteTable("attribute")+ "(attribute_group_id, sort_order) VALUES(?, ?) ";
        PreparedStatement ps = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
View Full Code Here
TOP

Related Classes of org.springframework.jdbc.core.PreparedStatementCreator

  • br.com.cwi.tnt.rfp.arquitetura2.repository.GridEntityDataRepository
  • br.com.cwi.tnt.rfp.arquitetura2.repository.SingleRowEntityDataRepository
  • com.alexkasko.springjdbc.parallel.CancellableStatementCreator
  • com.apress.prospring.ch8.spring.JdbcAbstractTestDao
  • com.cardence.lawshelf.model.impl.AttributeEnabledJdbcTemplateDao
  • com.cardence.lawshelf.model.impl.JdbcCodeAliasDao
  • com.cardence.lawshelf.model.impl.JdbcCodeCollectionDao
  • com.cardence.lawshelf.model.impl.JdbcCodeDao
  • com.cardence.lawshelf.model.impl.JdbcContentFullDao
  • com.cardence.lawshelf.model.impl.JdbcContentPartDao
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.