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

Package org.springframework.jdbc.core.namedparam

Class org.springframework.jdbc.core.namedparam.MapSqlParameterSource

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

org.springframework.jdbc.core.namedparam.MapSqlParameterSource.addValue()
Add a parameter to this parameter source. @param paramName the name of the parameter @param value the value of the parameter @return a reference to this parameter source,so it's possible to chain several calls together


  public long saveOverview(ProjectOverview overview) throws IOException {
    User user = securityManager.getUserByLoginName(SecurityContextHolder.getContext().getAuthentication().getName());


    MapSqlParameterSource params = new MapSqlParameterSource();
    params.addValue("principalInvestigator", overview.getPrincipalInvestigator())
            .addValue("startDate", overview.getStartDate())
            .addValue("endDate", overview.getEndDate())
            .addValue("numProposedSamples", overview.getNumProposedSamples())
            .addValue("locked", overview.getLocked())
            .addValue("allSampleQcPassed", overview.getAllSampleQcPassed())

View Full Code Here


      SimpleJdbcInsert pInsert = new SimpleJdbcInsert(template)
              .withTableName("Project_ProjectOverview");


      MapSqlParameterSource poParams = new MapSqlParameterSource();
      poParams.addValue("project_projectId", p.getProjectId())
              .addValue("overviews_overviewId", overview.getOverviewId());


      try {
        pInsert.execute(poParams);
      }

View Full Code Here

  }


  @Transactional(readOnly = false, rollbackFor = IOException.class)
  public long save(LibraryQC libraryQC) throws IOException {
    MapSqlParameterSource params = new MapSqlParameterSource();
    params.addValue("library_libraryId", libraryQC.getLibrary().getId())
            //.addValue("qcUserName", SecurityContextHolder.getContext().getAuthentication().getName())
            .addValue("qcUserName", libraryQC.getQcCreator())
            .addValue("qcDate", libraryQC.getQcDate())
            .addValue("qcMethod", libraryQC.getQcType().getQcTypeId())
            .addValue("results", libraryQC.getResults())

View Full Code Here

                              .usingGeneratedKeyColumns("qcId");
      Number newId = insert.executeAndReturnKey(params);
      libraryQC.setId(newId.longValue());
    }
    else {
      params.addValue("qcId", libraryQC.getId());
      NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
      namedTemplate.update(LIBRARY_QC_UPDATE, params);
    }


    if (this.cascadeType != null) {

View Full Code Here

  }


  public long save(Platform platform) throws IOException {
    // execute this procedure...
    MapSqlParameterSource params = new MapSqlParameterSource();
    params.addValue("name", platform.getPlatformType().getKey())
            .addValue("instrumentModel", platform.getInstrumentModel())
            .addValue("description", platform.getDescription())
            .addValue("numContainers", platform.getNumContainers());


    if (platform.getPlatformId() == null) {

View Full Code Here

              .usingGeneratedKeyColumns("platformId");
      Number newId = insert.executeAndReturnKey(params);
      platform.setPlatformId(newId.longValue());
    }
    else {
      params.addValue("platformId", platform.getPlatformId());
      NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
      namedTemplate.update(PLATFORM_UPDATE, params);
    }
    
    return platform.getPlatformId();

View Full Code Here

    if (this.cascadeType != null) {// && this.cascadeType.equals(CascadeType.PERSIST)) {
      securityProfileId = securityProfileDAO.save(study.getSecurityProfile());
    }


    MapSqlParameterSource params = new MapSqlParameterSource();
    params.addValue("alias", study.getAlias())
            .addValue("accession", study.getAccession())
            .addValue("description", study.getDescription())
            .addValue("securityProfile_profileId", securityProfileId)
            .addValue("project_projectId", study.getProject().getProjectId())
            .addValue("studyType", study.getStudyType());

View Full Code Here


        String name = namingScheme.generateNameFor("name", study);
        study.setName(name);


        if (namingScheme.validateField("name", study.getName())) {
          params.addValue("name", name);


          Number newId = insert.executeAndReturnKey(params);
          if (newId.longValue() != study.getId()) {
            log.error("Expected Study ID doesn't match returned value from database insert: rolling back...");
            new NamedParameterJdbcTemplate(template).update(STUDY_DELETE, new MapSqlParameterSource().addValue("studyId", newId.longValue()));

View Full Code Here


      SimpleJdbcInsert pInsert = new SimpleJdbcInsert(template)
                            .withTableName("Project_Study");


      MapSqlParameterSource poParams = new MapSqlParameterSource();
      poParams.addValue("Project_projectId", p.getProjectId())
              .addValue("studies_studyId", study.getId());
      try {
        pInsert.execute(poParams);
      }
      catch(DuplicateKeyException dke) {

View Full Code Here

  }


  @Transactional(readOnly = false, rollbackFor = IOException.class)
  public long save(PoolQC poolQC) throws IOException {
    MapSqlParameterSource params = new MapSqlParameterSource();
    params.addValue("pool_poolId", poolQC.getPool().getId())
            .addValue("qcUserName", poolQC.getQcCreator())
            .addValue("qcDate", poolQC.getQcDate())
            .addValue("qcMethod", poolQC.getQcType().getQcTypeId())
            .addValue("results", poolQC.getResults());

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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.