Package org.springframework.jdbc.core.namedparam

Examples of org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate

54
55
56
57
58
59
60
  }
 
  @Autowired
  public void setDataSource(DataSource dataSource) {
    this.dataSource = dataSource;
    this.jdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
  }
View Full Code Here
48
49
50
51
52
53
54
  }
 
  @Autowired
  public void setDataSource(DataSource dataSource) {
    this.dataSource = dataSource;
    this.jdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
  }
View Full Code Here
61
62
63
64
65
66
67
  }
 
  @Autowired
  public void setDataSource(DataSource dataSource) {
    this.dataSource = dataSource;
    this.jdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
  }
View Full Code Here
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
  /**
   * 删除指定的表, 在删除期间disable外键的检查.
   */
  public static void deleteTable(DataSource h2DataSource, String... tableNames) {
    NamedParameterJdbcTemplate template = new NamedParameterJdbcTemplate(h2DataSource);

    template.update("SET REFERENTIAL_INTEGRITY FALSE",new HashMap<String, Object>());

    for (String tableName : tableNames) {
      template.update("DELETE FROM " + tableName,new HashMap<String, Object>());
    }

    template.update("SET REFERENTIAL_INTEGRITY TRUE",new HashMap<String, Object>());
  }
View Full Code Here
65
66
67
68
69
70
71
   * Create a new SimpleJdbcTemplate for the given DataSource.
   * <p>Creates a classic Spring JdbcTemplate and wraps it.
   * @param dataSource the JDBC DataSource to access
   */
  public SimpleJdbcTemplate(DataSource dataSource) {
    this.namedParameterJdbcOperations = new NamedParameterJdbcTemplate(dataSource);
  }
View Full Code Here
73
74
75
76
77
78
79
  /**
   * Create a new SimpleJdbcTemplate for the given classic Spring JdbcTemplate.
   * @param classicJdbcTemplate the classic Spring JdbcTemplate to wrap
   */
  public SimpleJdbcTemplate(JdbcOperations classicJdbcTemplate) {
    this.namedParameterJdbcOperations = new NamedParameterJdbcTemplate(classicJdbcTemplate);
  }
View Full Code Here
68
69
70
71
72
73
74
   * Create a new SimpleJdbcTemplate for the given DataSource.
   * <p>Creates a classic Spring JdbcTemplate and wraps it.
   * @param dataSource the JDBC DataSource to access
   */
  public SimpleJdbcTemplate(DataSource dataSource) {
    this.namedParameterJdbcOperations = new NamedParameterJdbcTemplate(dataSource);
  }
View Full Code Here
76
77
78
79
80
81
82
  /**
   * Create a new SimpleJdbcTemplate for the given classic Spring JdbcTemplate.
   * @param classicJdbcTemplate the classic Spring JdbcTemplate to wrap
   */
  public SimpleJdbcTemplate(JdbcOperations classicJdbcTemplate) {
    this.namedParameterJdbcOperations = new NamedParameterJdbcTemplate(classicJdbcTemplate);
  }
View Full Code Here
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
    new CallTemplate<Integer>() {
      @Override
      Integer doCall(String sql, MapSqlParameterSource params) {
        final RowMapper<T> mapper = new BeanPropertyRowMapper<T>(resultSetClass);

        NamedParameterJdbcTemplate template = new NamedParameterJdbcTemplate(dataSource) {
          @Override
          protected PreparedStatementCreator getPreparedStatementCreator(String sql,
              SqlParameterSource paramSource) {
            PreparedStatementCreator originalCreator = super.getPreparedStatementCreator(sql, paramSource);
            return new StreamingStatementCreator(originalCreator);
          }

        };
        final AtomicInteger rowNum = new AtomicInteger(0);
        template.query(sql, params, new RowCallbackHandler() {

          @Override
          public void processRow(ResultSet rs) throws SQLException {
            handler.handleRow(mapper.mapRow(rs, rowNum.incrementAndGet()));
          }
View Full Code Here
273
274
275
276
277
278
279
280
281
    return maxRowsResultSetExtractor;
  }

  private NamedParameterJdbcOperations getJdbcTemplate() {
    if (namedParameterJdbcTemplate == null)
      namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(dataSource);

    return namedParameterJdbcTemplate;
  }
View Full Code Here
TOP

Related Classes of org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate

  • com.iqbon.jcms.dao.business.ModelDAO
  • com.iqbon.jcms.dao.business.PushRecordDAO
  • com.opengamma.util.db.DbConnectorFactoryBean
  • com.opengamma.util.db.DbConnectorTest
  • org.butor.dao.AbstractDao
  • org.springframework.batch.item.database.JdbcBatchItemWriterClassicTests
  • org.springframework.batch.sample.domain.football.internal.JdbcPlayerDao
  • org.springframework.batch.sample.domain.football.internal.JdbcPlayerSummaryDao
  • org.springframework.jdbc.core.ColumnMapRowMapper
  • org.springframework.jdbc.core.JdbcTemplate
    • 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.