Package org.springframework.jdbc.core.simple

Examples of org.springframework.jdbc.core.simple.SimpleJdbcInsert.execute()

140
141
142
143
144
145
146
147
148
149
150
      if (results.size() > 0) {
        log.error("SecurityProfile deletion failed!");
      }
      else {
        params.addValue("profileId", securityProfile.getProfileId());
        insert.execute(params);
      }
    }
    else {
      insert.usingGeneratedKeyColumns("profileId");
      Number newId = insert.executeAndReturnKey(params);
View Full Code Here
158
159
160
161
162
163
164
165
166
167
168
      for (User u : securityProfile.getReadUsers()) {
        MapSqlParameterSource uParams = new MapSqlParameterSource();
        uParams.addValue("SecurityProfile_profileId", securityProfile.getProfileId())
                .addValue("readUser_userId", u.getUserId());
        uInsert.execute(uParams);
      }
    }

    //profile write users
    if (securityProfile.getWriteUsers() != null && !securityProfile.getWriteUsers().isEmpty()) {
View Full Code Here
171
172
173
174
175
176
177
178
179
180
181
      for (User u : securityProfile.getWriteUsers()) {
        MapSqlParameterSource uParams = new MapSqlParameterSource();
        uParams.addValue("SecurityProfile_profileId", securityProfile.getProfileId())
                .addValue("writeUser_userId", u.getUserId());
        uInsert.execute(uParams);
      }
    }

    //profile read groups
    if (securityProfile.getReadGroups() != null && !securityProfile.getReadGroups().isEmpty()) {
View Full Code Here
184
185
186
187
188
189
190
191
192
193
194
      for (Group g : securityProfile.getReadGroups()) {
        MapSqlParameterSource uParams = new MapSqlParameterSource();
        uParams.addValue("SecurityProfile_profileId", securityProfile.getProfileId())
                .addValue("readGroup_groupId", g.getGroupId());
        uInsert.execute(uParams);
      }
    }

    //profile read groups
    if (securityProfile.getWriteGroups() != null && !securityProfile.getWriteGroups().isEmpty()) {
View Full Code Here
197
198
199
200
201
202
203
204
205
206
207
      for (Group g : securityProfile.getWriteGroups()) {
        MapSqlParameterSource uParams = new MapSqlParameterSource();
        uParams.addValue("SecurityProfile_profileId", securityProfile.getProfileId())
                .addValue("writeGroup_groupId", g.getGroupId());
        uInsert.execute(uParams);
      }
    }
   
    return securityProfile.getProfileId();
  }
View Full Code Here
270
271
272
273
274
275
276
277
278
279
280
                      .withTableName("Submission_Experiment");
              try {
                MapSqlParameterSource poParams = new MapSqlParameterSource();
                poParams.addValue("submission_submissionId", submission.getId())
                        .addValue("experiments_experimentId", experiment.getId());
                pInsert.execute(poParams);
              }
              catch (DuplicateKeyException dke) {
                log.warn("This Submission_Experiment combination already exists - not inserting: " + dke.getMessage());
              }
View Full Code Here
283
284
285
286
287
288
289
290
291
292
293
                      .withTableName("Submission_Study");
              try {
                MapSqlParameterSource poParams = new MapSqlParameterSource();
                poParams.addValue("submission_submissionId", submission.getId())
                        .addValue("studies_studyId", study.getId());
                sInsert.execute(poParams);
              }
              catch (DuplicateKeyException dke) {
                log.warn("This Submission_Study combination already exists - not inserting: " + dke.getMessage());
              }
            }
View Full Code Here
299
300
301
302
303
304
305
306
307
308
309
                      .withTableName("Submission_Sample");
              try {
                MapSqlParameterSource poParams = new MapSqlParameterSource();
                poParams.addValue("submission_submissionId", submission.getId())
                        .addValue("samples_sampleId", sample.getId());
                sInsert.execute(poParams);
              }
              catch (DuplicateKeyException dke) {
                log.warn("This Submission_Sample combination already exists - not inserting: " + dke.getMessage());
              }
View Full Code Here
313
314
315
316
317
318
319
320
321
322
323
              try {
                MapSqlParameterSource poParams = new MapSqlParameterSource();
                poParams.addValue("submission_submissionId", submission.getId())
                        .addValue("partition_partitionId", l.getId())
                        .addValue("dilution_dilutionId", dil.getId());
                sInsert.execute(poParams);

              }
              catch (DuplicateKeyException dke) {
                log.warn("This Submission_Partition_Dilution combination already exists - not inserting: " + dke.getMessage());
              }
View Full Code Here
331
332
333
334
335
336
337
338
339
340
341
                    .withTableName(tableName);
            try {
              MapSqlParameterSource poParams = new MapSqlParameterSource();
              poParams.addValue("submission_submissionId", submission.getId())
                      .addValue(priKey, priValue);
              pInsert.execute(poParams);
            }
            catch (DuplicateKeyException dke) {
              log.warn("This " + tableName + " combination already exists - not inserting: " + dke.getMessage());
            }
          }
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.