Package org.springframework.jdbc.core.namedparam

Examples of org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update()

132
133
134
135
136
137
138
139
140
141
142
   * 删除指定的表, 在删除期间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>());
    }

View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
    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
138
139
140
141
142
143
144
145
    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
80
81
82
83
84
85
86
87
88
89
90
       
        // Do line by line
        int insertCount = 0;
        for (i = 0; i < parameters.length; ++i) {
            try {
                npjt.update(insertQuery, parameters[i]);
                ++insertCount;
            } catch (RuntimeException ex) {
                log.warn(parameters[i].getRecord().toString(), ex);
            }
        }
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
       
            // Do line by line
            int insertCount = 0;
            for (int i = 0; i < parameters.size(); ++i) {
                try {
                    int affectedRows = npjt.update(insertQuery.getSql(), parameters.get(i));                   
                    insertCount += DatabaseUtils.getAffectedRowsNumber(affectedRows);
                   
                } catch (RuntimeException ex2) {
                    log.warn("Could not insert record: "
                            + DatabaseUtils.sqlParameterSourceToText(parameters.get(i)), ex2);
View Full Code Here
138
139
140
141
142
143
144
145
146
147
148
      printJob.setJobId(newId.longValue());
    }
    else {
      params.addValue("jobId", printJob.getJobId());
      NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
      namedTemplate.update(PRINT_JOB_UPDATE, params);
    }
    return printJob.getJobId();
  }

  public PrintJob get(long jobId) throws IOException {
View Full Code Here
411
412
413
414
415
416
417
418
419
420
421
      try {
        if (namingScheme.validateField("name", run.getName())) {
          params.addValue("runId", run.getId())
                .addValue("name", run.getName());
          NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
          namedTemplate.update(RUN_UPDATE, params);
        }
        else {
          throw new IOException("Cannot save Run - invalid field:" + run.toString());
        }
      }
View Full Code Here
741
742
743
744
745
746
747
748
749
750
751
          )
  )
  public boolean remove(Run r) throws IOException {
    NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
    if (r.isDeletable() &&
           (namedTemplate.update(RUN_DELETE,
                            new MapSqlParameterSource().addValue("runId", r.getId())) == 1)) {
      purgeListCache(r, false);
      return true;
    }
    return false;
View Full Code Here
221
222
223
224
225
226
227
228
229
230
231
      try {
        if (namingScheme.validateField("name", pcr.getName())) {
          params.addValue("pcrId", pcr.getId())
                .addValue("name", pcr.getName());
          NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
          namedTemplate.update(EMPCR_UPDATE, params);
        }
        else {
          throw new IOException("Cannot save emPCR - invalid field:" + pcr.toString());
        }
      }
View Full Code Here
307
308
309
310
311
312
313
314
315
316
317
          )
  )
  public boolean remove(emPCR e) throws IOException {
    NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
    if (e.isDeletable() &&
           (namedTemplate.update(EMPCR_DELETE,
                            new MapSqlParameterSource().addValue("pcrId", e.getId())) == 1)) {
      LibraryDilution ld = e.getLibraryDilution();
      if (this.cascadeType.equals(CascadeType.PERSIST)) {
        if (ld != null) libraryDilutionDAO.save(ld);
      }
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.