Package org.springframework.jdbc.core.namedparam

Examples of org.springframework.jdbc.core.namedparam.MapSqlParameterSource.addValue()

409
410
411
412
413
414
415
416
417
418
419
  public void testUpdateWithSqlParameterSource() throws Exception {
    MapSqlParameterSource args = new MapSqlParameterSource();
    args.addValue("1", 1);
    args.addValue("2", 2);
    args.addValue("3", 3);
    testDelegation("update", new Object[]{"sql"}, new Object[]{args}, 666);
  }

  private Object testDelegation(String methodName, Object[] typedArgs, Object[] varargs, Object expectedResult) throws Exception {
    Class[] unifiedTypes;
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
    parameters.add(new SqlParameter("id", Types.NUMERIC));
    parameters.add(new SqlInOutParameter("name", Types.NUMERIC));
    parameters.add(new SqlOutParameter("customer_no", Types.NUMERIC));

    MapSqlParameterSource parameterSource = new MapSqlParameterSource();
    parameterSource.addValue("id", 1);
    parameterSource.addValue("name", "Sven");
    parameterSource.addValue("customer_no", "12345XYZ");

    context.setProcedureName(TABLE);
    context.initializeMetaData(mockDataSource);
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
    parameters.add(new SqlInOutParameter("name", Types.NUMERIC));
    parameters.add(new SqlOutParameter("customer_no", Types.NUMERIC));

    MapSqlParameterSource parameterSource = new MapSqlParameterSource();
    parameterSource.addValue("id", 1);
    parameterSource.addValue("name", "Sven");
    parameterSource.addValue("customer_no", "12345XYZ");

    context.setProcedureName(TABLE);
    context.initializeMetaData(mockDataSource);
    context.processParameters(parameters);
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
    parameters.add(new SqlOutParameter("customer_no", Types.NUMERIC));

    MapSqlParameterSource parameterSource = new MapSqlParameterSource();
    parameterSource.addValue("id", 1);
    parameterSource.addValue("name", "Sven");
    parameterSource.addValue("customer_no", "12345XYZ");

    context.setProcedureName(TABLE);
    context.initializeMetaData(mockDataSource);
    context.processParameters(parameters);
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
    ctrlMetaDataResultSet.replay();
    ctrlColumnsResultSet.replay();
    replay();
   
    MapSqlParameterSource map = new MapSqlParameterSource();
    map.addValue("id", 1);
    map.addValue("name", "Sven");
    map.addValue("customersince", new Date());
    map.addValue("version", 0);   
    map.registerSqlType("customersince", Types.DATE);
    map.registerSqlType("version", Types.NUMERIC);
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
    ctrlColumnsResultSet.replay();
    replay();
   
    MapSqlParameterSource map = new MapSqlParameterSource();
    map.addValue("id", 1);
    map.addValue("name", "Sven");
    map.addValue("customersince", new Date());
    map.addValue("version", 0);   
    map.registerSqlType("customersince", Types.DATE);
    map.registerSqlType("version", Types.NUMERIC);
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
    replay();
   
    MapSqlParameterSource map = new MapSqlParameterSource();
    map.addValue("id", 1);
    map.addValue("name", "Sven");
    map.addValue("customersince", new Date());
    map.addValue("version", 0);   
    map.registerSqlType("customersince", Types.DATE);
    map.registerSqlType("version", Types.NUMERIC);

    context.setTableName(TABLE);
View Full Code Here
147
148
149
150
151
152
153
154
155
156
157
   
    MapSqlParameterSource map = new MapSqlParameterSource();
    map.addValue("id", 1);
    map.addValue("name", "Sven");
    map.addValue("customersince", new Date());
    map.addValue("version", 0);   
    map.registerSqlType("customersince", Types.DATE);
    map.registerSqlType("version", Types.NUMERIC);

    context.setTableName(TABLE);
    context.processMetaData(mockDataSource, new ArrayList<String>(), new String[] {});
View Full Code Here
337
338
339
340
341
342
343
344
345
346
347
          }
          if (Enum.class.isAssignableFrom(f.getType())) {
            sps.registerSqlType(f.getName(), Types.VARCHAR);
          }

          msp.addValue(fn, sps.getValue(fn), sps.getSqlType(fn), sps.getTypeName(fn));
          logger.debug(String.format("prepared sql arg: name=%s, value=%s, type=%s", fn, sps.getValue(fn),
              sps.getTypeName(fn)));
        } catch (Exception e) {
          Throwables.propagate(e);
        }
View Full Code Here
444
445
446
447
448
449
450
451
452
453
454
            re = m.end();
            insertSql = insertSql.substring(0, re) +":histId, :histOperation, CURRENT_TIMESTAMP, :histUserId," +insertSql.substring(re);
   
            insertHistorySql = insertSql;
          }
          params.addValue("histId",0);
          params.addValue("histOperation", operation);
          params.addValue("histStamp","");
          params.addValue("histUserId", (String)params.getValue("userId"));
          insert("__insertHistory", insertHistorySql, params, original);
        } catch (Throwable e) {
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.