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

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


    if (this.cascadeType != null) {

View Full Code Here

      securityProfileId = securityProfileDAO.save(sequencerPartitionContainer.getSecurityProfile());
    }


    MapSqlParameterSource params = new MapSqlParameterSource();


    params.addValue("securityProfile_profileId", securityProfileId);
    params.addValue("identificationBarcode", sequencerPartitionContainer.getIdentificationBarcode());
    params.addValue("locationBarcode", sequencerPartitionContainer.getLocationBarcode());
    params.addValue("validationBarcode", sequencerPartitionContainer.getValidationBarcode());


    if (sequencerPartitionContainer.getPlatformType() != null) {

View Full Code Here

    }


    MapSqlParameterSource params = new MapSqlParameterSource();


    params.addValue("securityProfile_profileId", securityProfileId);
    params.addValue("identificationBarcode", sequencerPartitionContainer.getIdentificationBarcode());
    params.addValue("locationBarcode", sequencerPartitionContainer.getLocationBarcode());
    params.addValue("validationBarcode", sequencerPartitionContainer.getValidationBarcode());


    if (sequencerPartitionContainer.getPlatformType() != null) {
      params.addValue("platformType", sequencerPartitionContainer.getPlatformType().getKey());

View Full Code Here


    MapSqlParameterSource params = new MapSqlParameterSource();


    params.addValue("securityProfile_profileId", securityProfileId);
    params.addValue("identificationBarcode", sequencerPartitionContainer.getIdentificationBarcode());
    params.addValue("locationBarcode", sequencerPartitionContainer.getLocationBarcode());
    params.addValue("validationBarcode", sequencerPartitionContainer.getValidationBarcode());


    if (sequencerPartitionContainer.getPlatformType() != null) {
      params.addValue("platformType", sequencerPartitionContainer.getPlatformType().getKey());
    }

View Full Code Here

    MapSqlParameterSource params = new MapSqlParameterSource();


    params.addValue("securityProfile_profileId", securityProfileId);
    params.addValue("identificationBarcode", sequencerPartitionContainer.getIdentificationBarcode());
    params.addValue("locationBarcode", sequencerPartitionContainer.getLocationBarcode());
    params.addValue("validationBarcode", sequencerPartitionContainer.getValidationBarcode());


    if (sequencerPartitionContainer.getPlatformType() != null) {
      params.addValue("platformType", sequencerPartitionContainer.getPlatformType().getKey());
    }

View Full Code Here

    params.addValue("identificationBarcode", sequencerPartitionContainer.getIdentificationBarcode());
    params.addValue("locationBarcode", sequencerPartitionContainer.getLocationBarcode());
    params.addValue("validationBarcode", sequencerPartitionContainer.getValidationBarcode());


    if (sequencerPartitionContainer.getPlatformType() != null) {
      params.addValue("platformType", sequencerPartitionContainer.getPlatformType().getKey());
    }


    if (sequencerPartitionContainer.getId() == AbstractSequencerPartitionContainer.UNSAVED_ID) {
      SimpleJdbcInsert insert = new SimpleJdbcInsert(template)
              .withTableName(TABLE_NAME)

View Full Code Here

      catch (MisoNamingException e) {
        throw new IOException("Cannot save SequencerPartitionContainer - issue with naming scheme", e);
      }
      */


      params.addValue("containerId", sequencerPartitionContainer.getId());
      NamedParameterJdbcTemplate namedTemplate = new NamedParameterJdbcTemplate(template);
      namedTemplate.update(SEQUENCER_PARTITION_CONTAINER_UPDATE, params);
    }


    //MapSqlParameterSource delparams = new MapSqlParameterSource();

View Full Code Here

        long partitionId = partitionDAO.save(l);


        //log.info(sequencerPartitionContainer.getName()+":: Saved partition " + l.getPartitionNumber() + " ("+partitionId+")");


        MapSqlParameterSource flParams = new MapSqlParameterSource();
        flParams.addValue("container_containerId", sequencerPartitionContainer.getId())
                .addValue("partitions_partitionId", partitionId);
        try {
          eInsert.execute(flParams);
        }
        catch (DuplicateKeyException dke) {

View Full Code Here

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


    MapSqlParameterSource params = new MapSqlParameterSource();
    params.addValue("alias", library.getAlias())
            .addValue("accession", library.getAccession())
            .addValue("description", library.getDescription())
            .addValue("locationBarcode", library.getLocationBarcode())
            .addValue("paired", library.getPaired())
            .addValue("sample_sampleId", library.getSample().getId())

View Full Code Here

            .addValue("concentration", library.getInitialConcentration())
            .addValue("creationDate", library.getCreationDate());
            //.addValue("qcPassed", library.getQcPassed());


    if (library.getQcPassed() != null) {
      params.addValue("qcPassed", library.getQcPassed().toString());
    }
    else {
      params.addValue("qcPassed", library.getQcPassed());
    }

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.