Package org.springframework.jdbc.core.namedparam

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

239
240
241
242
243
244
245
246
247
248
249
   * matching named parameters specified in the SQL statement
   * @return the number of rows affected by the update
   */
  public int updateByNamedParam(Map<String, ?> paramMap) throws DataAccessException {
    validateNamedParameters(paramMap);
    ParsedSql parsedSql = getParsedSql();
    MapSqlParameterSource paramSource = new MapSqlParameterSource(paramMap);
    String sqlToUse = NamedParameterUtils.substituteNamedParameters(parsedSql, paramSource);
    Object[] params = NamedParameterUtils.buildValueArray(parsedSql, paramSource, getDeclaredParameters());
    int rowsAffected = getJdbcTemplate().update(newPreparedStatementCreator(sqlToUse, params));
    checkRowsAffected(rowsAffected);
View Full Code Here
258
259
260
261
262
263
264
265
266
267
268
   * @param generatedKeyHolder KeyHolder that will hold the generated keys
   * @return the number of rows affected by the update
   */
  public int updateByNamedParam(Map<String, ?> paramMap, KeyHolder generatedKeyHolder) throws DataAccessException {
    validateNamedParameters(paramMap);
    ParsedSql parsedSql = getParsedSql();
    MapSqlParameterSource paramSource = new MapSqlParameterSource(paramMap);
    String sqlToUse = NamedParameterUtils.substituteNamedParameters(parsedSql, paramSource);
    Object[] params = NamedParameterUtils.buildValueArray(parsedSql, paramSource, getDeclaredParameters());
    int rowsAffected = getJdbcTemplate().update(newPreparedStatementCreator(sqlToUse, params), generatedKeyHolder);
    checkRowsAffected(rowsAffected);
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
            }

            @Override
            public PreparedStatement createPreparedStatement(Connection con) throws SQLException {
                // substitute named params, see NamedParameterJdbcTemplate#getPreparedStatementCreator(String sql, SqlParameterSource paramSource)
                ParsedSql parsedSql = NamedParameterUtils.parseSqlStatement(insertSQL);
                MapSqlParameterSource paramSource = new MapSqlParameterSource();
                paramSource.addValue("id", id, Types.BIGINT);
                paramSource.addValue("data", data, Types.BLOB);
                String sqlToUse = NamedParameterUtils.substituteNamedParameters(parsedSql, paramSource);
            Object[] params = NamedParameterUtils.buildValueArray(parsedSql, paramSource, null);
View Full Code Here
363
364
365
366
367
368
369
370
371
372
373
      final List<Map<String, Object>> batchValues) {
    long cur = System.currentTimeMillis();
    try {
      int[] batchCount = null;
      String sql = sqlp.getValue(sqlId, sqlId);
      ParsedSql parsedSql = NamedParameterUtils.parseSqlStatement(sql);
      if (sqlTypes != null && !sqlTypes.isEmpty()) {
        MapSqlParameterSource[] batch = new MapSqlParameterSource[batchValues
            .size()];
        for (int i = 0; i < batchValues.size(); i++) {
          Map<String, Object> valueMap = batchValues.get(i);
View Full Code Here
257
258
259
260
261
262
263
264
265
266
267
//       
//       
//      }
//      this.rs = preparedStatement.executeQuery();
     
      ParsedSql parsedSql1 = this.getParsedSql(sql).getDelegate();
      String sqlToUse1 = NamedParameterUtils.substituteNamedParameters(parsedSql1, paramSource);
      Object[] params = NamedParameterUtils.buildValueArray(parsedSql1, paramSource, null);
      List<SqlParameter> declaredParameters = NamedParameterUtils.buildSqlParameterList(parsedSql1, paramSource);
      PreparedStatementCreatorFactory pscf = new PreparedStatementCreatorFactory(sqlToUse1, declaredParameters);
      pscf.setResultSetType( ResultSet.TYPE_FORWARD_ONLY );
View Full Code Here
TOP

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

  • com.alexkasko.springjdbc.blob.TempFileJdbcBlobTool$Persister$InsertPS
  • com.alexkasko.springjdbc.parallel.CancellableStatementCreator
  • com.danidemi.jlubricant.springbatch.NamedJdbcCursorItemReader
  • com.iisigroup.cap.jdbc.CapNamedJdbcTemplate
  • org.springframework.jdbc.core.simple.SimpleJdbcTemplate
  • org.springframework.jdbc.object.SqlQuery
  • org.springframework.jdbc.object.SqlUpdate
    • 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.