Examples of PreparedStatementSetter

com.volantis.mcs.accessors.jdbc.PreparedStatementSetter
Callback interface used by the JdbcTemplate class.
This interface sets values on a PreparedStatement provided by the JdbcTemplate class. Implementations are responsible for setting any necessary parameters. SQL with placeholders will already have been supplied.
It's easier to use this interface than PreparedStatementCreator, as the JdbcTemplate will create the prepared statement.
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.
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)

Examples of org.springframework.jdbc.core.PreparedStatementSetter

    return jdbcTemplate.query(findApprovalStatement, rowMapper, userName, clientId);
  }


  private boolean updateApproval(final String sql, final Approval approval) {
    logger.debug(String.format("refreshing approval: [%s]", approval));
    int refreshed = jdbcTemplate.update(sql, new PreparedStatementSetter() {
      @Override
      public void setValues(PreparedStatement ps) throws SQLException {
        ps.setTimestamp(1, new Timestamp(approval.getExpiresAt().getTime()));
        ps.setString(2, (approval.getStatus() == null ? APPROVED : approval.getStatus()).toString());
        ps.setTimestamp(3, new Timestamp(approval.getLastUpdatedAt().getTime()));

View Full Code Here

Examples of org.springframework.jdbc.core.PreparedStatementSetter


    //~ 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

Examples of org.springframework.jdbc.core.PreparedStatementSetter

        }
    }


    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

Examples of org.springframework.jdbc.core.PreparedStatementSetter


        final int groupId = findGroupId(groupName);


        for (int i=0; i < authorities.size(); i++) {
            final String authority = authorities.get(i).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

Examples of org.springframework.jdbc.core.PreparedStatementSetter

    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

Examples of org.springframework.jdbc.core.PreparedStatementSetter

        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

Examples of org.springframework.jdbc.core.PreparedStatementSetter

        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

Examples of org.springframework.jdbc.core.PreparedStatementSetter

        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

Examples of org.springframework.jdbc.core.PreparedStatementSetter

        logger.debug("Adding authority '" + authority + "' to group '" + groupName + "'");
        Assert.hasText(groupName);
        Assert.notNull(authority);


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

View Full Code Here

Examples of org.springframework.jdbc.core.PreparedStatementSetter

        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

0 1 2 3 4

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.