Examples of org.springframework.jdbc.core.PreparedStatementSetter

org.springframework.jdbc.core.PreparedStatementSetter
General callback interface used by the {@link JdbcTemplate} class.
This interface sets values on a {@link java.sql.PreparedStatement} providedby the JdbcTemplate class, for each of a number of updates in a batch using the same SQL. Implementations are responsible for setting any necessary parameters. SQL with placeholders will already have been supplied.
It's easier to use this interface than {@link PreparedStatementCreator}: The JdbcTemplate will create the PreparedStatement, with the callback only being responsible for setting parameter values.
Implementations do not need to concern themselves with SQLExceptions that may be thrown from operations they attempt. The JdbcTemplate class will catch and handle SQLExceptions appropriately. @author Rod Johnson @since March 2, 2003 @see JdbcTemplate#update(String,PreparedStatementSetter) @see JdbcTemplate#query(String,PreparedStatementSetter,ResultSetExtractor)


    String sql = "insert into library.toptag (tag_id)"
      + " select id from music.tag where tag_name in ("
      + getParameters(topTags.size()) + ")";


    jdbcTemplate.update(sql, new PreparedStatementSetter() {
      @Override
      public void setValues(PreparedStatement ps) throws SQLException {
        int index = 1;
        for (String topTag : topTags) {
          ps.setString(index++, topTag);

View Full Code Here

        Assert.notEmpty(findNow, "Items to find now required");


        String sql = computeRepeatingSql(lookupPrimaryKeysWhereClause, findNow.size());


        Set<Long> parentsToLookup = jdbcTemplate.query(sql,
            new PreparedStatementSetter() {
                public void setValues(PreparedStatement ps) throws SQLException {
                    int i = 0;


                    for (Long toFind : findNow) {
                        i++;

View Full Code Here

        // Make the "acls" map contain all requested objectIdentities
        // (including markers to each parent in the hierarchy)
        String sql = computeRepeatingSql(lookupObjectIdentitiesWhereClause, objectIdentities.size());


        Set<Long> parentsToLookup = jdbcTemplate.query(sql,
            new PreparedStatementSetter() {
                public void setValues(PreparedStatement ps) throws SQLException {
                    int i = 0;
                    for (ObjectIdentity oid : objectIdentities) {
                        // Determine prepared statement values for this iteration
                        String type = oid.getType();

View Full Code Here


    //~ UserDetailsManager implementation ==============================================================================


    public void createUser(final UserDetails user) {
        validateUserDetails(user);
        getJdbcTemplate().update(createUserSql, new PreparedStatementSetter() {
            public void setValues(PreparedStatement ps) throws SQLException {
                ps.setString(1, user.getUsername());
                ps.setString(2, user.getPassword());
                ps.setBoolean(3, user.isEnabled());
            }

View Full Code Here

        }
    }


    public void updateUser(final UserDetails user) {
        validateUserDetails(user);
        getJdbcTemplate().update(updateUserSql, new PreparedStatementSetter() {
            public void setValues(PreparedStatement ps) throws SQLException {
                ps.setString(1, user.getPassword());
                ps.setBoolean(2, user.isEnabled());
                ps.setString(3, user.getUsername());
            }

View Full Code Here


        final int groupId = findGroupId(groupName);


        for (GrantedAuthority a : authorities) {
            final String authority = a.getAuthority();
            getJdbcTemplate().update(insertGroupAuthoritySql, new PreparedStatementSetter() {
                public void setValues(PreparedStatement ps) throws SQLException {
                    ps.setInt(1, groupId);
                    ps.setString(2, authority);
                }
            });

View Full Code Here

    public void deleteGroup(String groupName) {
        logger.debug("Deleting group '" + groupName + "'");
        Assert.hasText(groupName);


        final int id = findGroupId(groupName);
        PreparedStatementSetter groupIdPSS = new PreparedStatementSetter() {
            public void setValues(PreparedStatement ps) throws SQLException {
                ps.setInt(1, id);
            }
        };
        getJdbcTemplate().update(deleteGroupMembersSql, groupIdPSS);

View Full Code Here

        logger.debug("Adding user '" + username + "' to group '" + groupName + "'");
        Assert.hasText(username);
        Assert.hasText(groupName);


        final int id = findGroupId(groupName);
        getJdbcTemplate().update(insertGroupMemberSql, new PreparedStatementSetter() {
            public void setValues(PreparedStatement ps) throws SQLException {
                ps.setInt(1, id);
                ps.setString(2, username);
            }
        });

View Full Code Here

        Assert.hasText(username);
        Assert.hasText(groupName);


        final int id = findGroupId(groupName);


        getJdbcTemplate().update(deleteGroupMemberSql, new PreparedStatementSetter() {
            public void setValues(PreparedStatement ps) throws SQLException {
                ps.setInt(1, id);
                ps.setString(2, username);
            }
        });

View Full Code Here

        Assert.hasText(groupName);
        Assert.notNull(authority);


        final int id = findGroupId(groupName);


        getJdbcTemplate().update(deleteGroupAuthoritySql, new PreparedStatementSetter() {


            public void setValues(PreparedStatement ps) throws SQLException {
                ps.setInt(1, id);
                ps.setString(2, authority.getAuthority());
            }

View Full Code Here

0 1 2 3

TOP

Related Classes of org.springframework.jdbc.core.PreparedStatementSetter

com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker

com.github.hakko.musiccabinet.dao.jdbc.JdbcTagDao

com.taobao.tddl.common.sync.RowBasedReplicationExecutor

org.acegisecurity.acls.jdbc.BasicLookupStrategy

org.geekhub.database.MovieDAO

org.jasig.portal.utils.HibernateStyleCounterStore

org.springframework.batch.core.repository.dao.JdbcExecutionContextDao

org.springframework.batch.item.database.StoredProcedureItemReaderCommonTests

org.springframework.batch.item.database.StoredprocedureItemReaderConfigTests

org.springframework.security.acls.jdbc.BasicLookupStrategy

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.