Example usage for org.springframework.jdbc.core PreparedStatementSetter PreparedStatementSetter

List of usage examples for org.springframework.jdbc.core PreparedStatementSetter PreparedStatementSetter

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.jdbc.core.*
  5. PreparedStatementSetter
  6. PreparedStatementSetter

Introduction

In this page you can find the example usage for org.springframework.jdbc.core PreparedStatementSetter PreparedStatementSetter.

Prototype

PreparedStatementSetter

Source Link

Usage

From source file:org.obiba.onyx.jade.instrument.holologic.APEXScanDataExtractor.java

/**
 * Called by extractDataImpl(). Implementation is specific to child classes which define Apex PatScan db table names
 * corresponding to the type of scan. Adds all analysis variables to data collection.
 *
 * @param table// www .j  av a2 s.  c o m
 * @param data
 * @param rsExtractor
 * @return
 */
protected Map<String, Data> extractScanData(String table, Map<String, Data> data,
        ResultSetExtractor<Map<String, Data>> rsExtractor) {
    return getPatScanDb().query("SELECT * FROM " + table + " WHERE PATIENT_KEY = ? AND SCANID = ?",
            new PreparedStatementSetter() {
                public void setValues(PreparedStatement ps) throws SQLException {
                    ps.setString(1, getParticipantKey());
                    ps.setString(2, getScanID());
                }
            }, rsExtractor);
}

From source file:org.LexGrid.lexevs.metabrowser.impl.MetaBrowserServiceImpl.java

@SuppressWarnings("unchecked")
public List<SemanticTypeHolder> getSemanticType(final List<String> cuis) throws LBException {
    if (SemTypeCache.instance().isDone()) {

        LoggerFactory.getLogger().info("Using Semantic Type cache");

        List<SemanticTypeHolder> returnList = new ArrayList<SemanticTypeHolder>();

        for (String cui : cuis) {
            String semanticType = SemTypeCache.instance().getSemanticType(cui);
            returnList.add(new SemanticTypeHolder(cui, semanticType));
        }// w  w  w. j av  a  2 s.  c  o m

        return returnList;
    } else {
        LoggerFactory.getLogger().info("Semantic Type Cache not ready -- querying database.");

        return this.getJdbcTemplate().query(createSemanticTypeSelectSql(cuis.size()),
                new PreparedStatementSetter() {

                    public void setValues(PreparedStatement ps) throws SQLException {
                        for (int i = 0; i < cuis.size(); i++) {
                            ps.setString(i + 1, cuis.get(i));
                        }
                    }

                }, SEMANTIC_TYPE_ROWMAPPER);
    }
}

From source file:org.cloudfoundry.identity.uaa.approval.JdbcApprovalStore.java

public boolean refreshApproval(final Approval approval) {
    logger.debug(String.format("refreshing approval: [%s]", approval));
    int refreshed = jdbcTemplate.update(REFRESH_AUTHZ_SQL, new PreparedStatementSetter() {
        @Override//from   w w  w. ja va 2s  . c  o m
        public void setValues(PreparedStatement ps) throws SQLException {
            ps.setTimestamp(1, new Timestamp(approval.getLastUpdatedAt().getTime()));
            ps.setTimestamp(2, new Timestamp(approval.getExpiresAt().getTime()));
            ps.setString(3, (approval.getStatus() == null ? APPROVED : approval.getStatus()).toString());
            ps.setString(4, approval.getUserId());
            ps.setString(5, approval.getClientId());
            ps.setString(6, approval.getScope());
        }
    });
    if (refreshed != 1) {
        throw new DataIntegrityViolationException("Attempt to refresh non-existent authorization");
    }
    return true;
}

From source file:org.cloudfoundry.identity.uaa.approval.JdbcApprovalStore.java

@Override
public boolean addApproval(final Approval approval) {
    logger.debug(String.format("adding approval: [%s]", approval));
    try {//from  w  w w .j  a va2s.  c  o  m
        refreshApproval(approval); // try to refresh the approval
    } catch (DataIntegrityViolationException ex) { // could not find the
                                                   // approval. add it.
        int count = jdbcTemplate.update(ADD_AUTHZ_SQL, new PreparedStatementSetter() {
            @Override
            public void setValues(PreparedStatement ps) throws SQLException {
                ps.setString(1, approval.getUserId());
                ps.setString(2, approval.getClientId());
                ps.setString(3, approval.getScope());
                ps.setTimestamp(4, new Timestamp(approval.getExpiresAt().getTime()));
                ps.setString(5, (approval.getStatus() == null ? APPROVED : approval.getStatus()).toString());
                ps.setTimestamp(6, new Timestamp(approval.getLastUpdatedAt().getTime()));
            }
        });
        if (count == 0)
            throw new EmptyResultDataAccessException("Approval add failed", 1);
    }
    Authentication authentication = SecurityContextHolder.getContext().getAuthentication();
    publish(new ApprovalModifiedEvent(approval, authentication));
    return true;
}

From source file:org.cloudfoundry.identity.uaa.db.StoreSubDomainAsLowerCase_V2_7_3.java

private IdentityZone updateIdentityZone(IdentityZone identityZone, JdbcTemplate jdbcTemplate) {
    String ID_ZONE_UPDATE_FIELDS = "version,lastmodified,name,subdomain,description".replace(",", "=?,") + "=?";
    String UPDATE_IDENTITY_ZONE_SQL = "update identity_zone set " + ID_ZONE_UPDATE_FIELDS + " where id=?";

    try {/*  ww w  . j a  va2s  .  c om*/
        jdbcTemplate.update(UPDATE_IDENTITY_ZONE_SQL, new PreparedStatementSetter() {
            @Override
            public void setValues(PreparedStatement ps) throws SQLException {
                ps.setInt(1, identityZone.getVersion() + 1);
                ps.setTimestamp(2, new Timestamp(new Date().getTime()));
                ps.setString(3, identityZone.getName());
                ps.setString(4, identityZone.getSubdomain().toLowerCase());
                ps.setString(5, identityZone.getDescription());
                ps.setString(6, identityZone.getId().trim());
            }
        });
    } catch (DuplicateKeyException e) {
        //duplicate subdomain
        throw new ZoneAlreadyExistsException(e.getMostSpecificCause().getMessage(), e);
    }
    return retrieveIdentityZone(identityZone.getId(), jdbcTemplate);
}

From source file:org.cloudfoundry.identity.uaa.provider.JdbcIdentityProviderProvisioning.java

@Override
public IdentityProvider create(final IdentityProvider identityProvider) {
    validate(identityProvider);// ww  w . j  a  v a 2s  .com
    final String id = UUID.randomUUID().toString();
    try {
        jdbcTemplate.update(CREATE_IDENTITY_PROVIDER_SQL, new PreparedStatementSetter() {
            @Override
            public void setValues(PreparedStatement ps) throws SQLException {
                int pos = 1;
                ps.setString(pos++, id);
                ps.setInt(pos++, identityProvider.getVersion());
                ps.setTimestamp(pos++, new Timestamp(System.currentTimeMillis()));
                ps.setTimestamp(pos++, new Timestamp(System.currentTimeMillis()));
                ps.setString(pos++, identityProvider.getName());
                ps.setString(pos++, identityProvider.getOriginKey());
                ps.setString(pos++, identityProvider.getType());
                ps.setString(pos++, JsonUtils.writeValueAsString(identityProvider.getConfig()));
                ps.setString(pos++, identityProvider.getIdentityZoneId());
                ps.setBoolean(pos++, identityProvider.isActive());
            }
        });
    } catch (DuplicateKeyException e) {
        throw new IdpAlreadyExistsException(e.getMostSpecificCause().getMessage());
    }
    return retrieve(id);
}

From source file:org.cloudfoundry.identity.uaa.provider.JdbcIdentityProviderProvisioning.java

@Override
public IdentityProvider update(final IdentityProvider identityProvider) {
    validate(identityProvider);/*  www  .  j  a va 2s  . c o  m*/
    final String zoneId = IdentityZoneHolder.get().getId();
    jdbcTemplate.update(UPDATE_IDENTITY_PROVIDER_SQL, new PreparedStatementSetter() {
        @Override
        public void setValues(PreparedStatement ps) throws SQLException {
            int pos = 1;
            ps.setInt(pos++, identityProvider.getVersion() + 1);
            ps.setTimestamp(pos++, new Timestamp(new Date().getTime()));
            ps.setString(pos++, identityProvider.getName());
            ps.setString(pos++, identityProvider.getType());
            ps.setString(pos++, JsonUtils.writeValueAsString(identityProvider.getConfig()));
            ps.setBoolean(pos++, identityProvider.isActive());
            ps.setString(pos++, identityProvider.getId().trim());
            ps.setString(pos++, zoneId);
        }
    });
    return retrieve(identityProvider.getId());
}

From source file:org.cloudfoundry.identity.uaa.provider.saml.idp.JdbcSamlServiceProviderProvisioning.java

@Override
public SamlServiceProvider create(final SamlServiceProvider serviceProvider) {
    validate(serviceProvider);/*from ww  w.  j  a  v  a  2s  . c om*/
    final String id = UUID.randomUUID().toString();
    try {
        jdbcTemplate.update(CREATE_SERVICE_PROVIDER_SQL, new PreparedStatementSetter() {
            @Override
            public void setValues(PreparedStatement ps) throws SQLException {
                int pos = 1;
                ps.setString(pos++, id);
                ps.setInt(pos++, serviceProvider.getVersion());
                ps.setTimestamp(pos++, new Timestamp(System.currentTimeMillis()));
                ps.setTimestamp(pos++, new Timestamp(System.currentTimeMillis()));
                ps.setString(pos++, serviceProvider.getName());
                ps.setString(pos++, serviceProvider.getEntityId());
                ps.setString(pos++, JsonUtils.writeValueAsString(serviceProvider.getConfig()));
                ps.setString(pos++, serviceProvider.getIdentityZoneId());
                ps.setBoolean(pos++, serviceProvider.isActive());
            }
        });
    } catch (DuplicateKeyException e) {
        throw new SamlSpAlreadyExistsException(e.getMostSpecificCause().getMessage());
    }
    return retrieve(id);
}

From source file:org.cloudfoundry.identity.uaa.provider.saml.idp.JdbcSamlServiceProviderProvisioning.java

@Override
public SamlServiceProvider update(final SamlServiceProvider serviceProvider) {
    validate(serviceProvider);//from   www.  ja v  a2  s  .c  o  m
    final String zoneId = IdentityZoneHolder.get().getId();
    jdbcTemplate.update(UPDATE_SERVICE_PROVIDER_SQL, new PreparedStatementSetter() {
        @Override
        public void setValues(PreparedStatement ps) throws SQLException {
            int pos = 1;
            ps.setInt(pos++, serviceProvider.getVersion() + 1);
            ps.setTimestamp(pos++, new Timestamp(new Date().getTime()));
            ps.setString(pos++, serviceProvider.getName());
            ps.setString(pos++, JsonUtils.writeValueAsString(serviceProvider.getConfig()));
            ps.setBoolean(pos++, serviceProvider.isActive());
            ps.setString(pos++, serviceProvider.getId().trim());
            ps.setString(pos++, zoneId);
        }
    });
    return retrieve(serviceProvider.getId());
}

From source file:org.cloudfoundry.identity.uaa.scim.dao.standard.JdbcScimGroupExternalMembershipManager.java

@Override
public ScimGroupExternalMemberInterface mapExternalGroup(final String groupId, final String externalGroup)
        throws ScimResourceNotFoundException, MemberAlreadyExistsException {
    ScimGroupInterface group = scimGroupProvisioning.retrieve(groupId);

    if (null != group) {
        try {/*w w w  .  j  a  va2s  . co m*/
            jdbcTemplate.update(ADD_EXTERNAL_GROUP_MAPPING_SQL, new PreparedStatementSetter() {
                @Override
                public void setValues(PreparedStatement ps) throws SQLException {
                    ps.setString(1, groupId);
                    ps.setString(2, externalGroup);
                    ps.setTimestamp(3, new Timestamp(new Date().getTime()));
                }
            });
        } catch (DuplicateKeyException e) {
            // we should not throw, if the mapping exist, we should leave it
            // there.
            logger.info("The mapping between group " + group.getDisplayName() + " and external group "
                    + externalGroup + " already exists");
            // throw new
            // MemberAlreadyExistsException("The mapping between group " +
            // group.getDisplayName() + " and external group " +
            // externalGroup + " already exists");
        }
        return getExternalGroupMap(groupId, externalGroup);
    } else {
        return null;
    }
}