Examples with PreparedStatementSetter org.springframework.jdbc.core.PreparedStatementSetter used on opensource projects

Example 1 with PreparedStatementSetter

use of org.springframework.jdbc.core.PreparedStatementSetter in project spring-security by spring-projects.

the class JdbcUserDetailsManager method updateUser.

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());
        }
    });
    if (getEnableAuthorities()) {
        deleteUserAuthorities(user.getUsername());
        insertUserAuthorities(user);
    }
    userCache.removeUserFromCache(user.getUsername());
}

Example 2 with PreparedStatementSetter

use of org.springframework.jdbc.core.PreparedStatementSetter in project spring-security by spring-projects.

the class JdbcUserDetailsManager method addUserToGroup.

public void addUserToGroup(final String username, final String groupName) {
    logger.debug("Adding user '" + username + "' to group '" + groupName + "'");
    Assert.hasText(username, "username should have text");
    ;
    Assert.hasText(groupName, "groupName should have text");
    ;
    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);
        }
    });
    userCache.removeUserFromCache(username);
}

Example 3 with PreparedStatementSetter

use of org.springframework.jdbc.core.PreparedStatementSetter in project spring-security by spring-projects.

the class JdbcUserDetailsManager method removeGroupAuthority.

public void removeGroupAuthority(String groupName, final GrantedAuthority authority) {
    logger.debug("Removing authority '" + authority + "' from group '" + groupName + "'");
    Assert.hasText(groupName, "groupName should have text");
    Assert.notNull(authority, "authority cannot be null");
    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());
        }
    });
}

Example 4 with PreparedStatementSetter

use of org.springframework.jdbc.core.PreparedStatementSetter in project spring-security by spring-projects.

the class JdbcUserDetailsManager method addGroupAuthority.

public void addGroupAuthority(final String groupName, final GrantedAuthority authority) {
    logger.debug("Adding authority '" + authority + "' to group '" + groupName + "'");
    Assert.hasText(groupName, "groupName should have text");
    ;
    Assert.notNull(authority, "authority cannot be null");
    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());
        }
    });
}

Example 5 with PreparedStatementSetter

use of org.springframework.jdbc.core.PreparedStatementSetter in project spring-security by spring-projects.

the class BasicLookupStrategy method lookupPrimaryKeys.

/**
	 * Locates the primary key IDs specified in "findNow", adding AclImpl instances with
	 * StubAclParents to the "acls" Map.
	 *
	 * @param acls the AclImpls (with StubAclParents)
	 * @param findNow Long-based primary keys to retrieve
	 * @param sids
	 */
private void lookupPrimaryKeys(final Map<Serializable, Acl> acls, final Set<Long> findNow, final List<Sid> sids) {
    Assert.notNull(acls, "ACLs are required");
    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++;
                ps.setLong(i, toFind);
            }
        }
    }, new ProcessResultSet(acls, sids));
    // connection (SEC-547)
    if (parentsToLookup.size() > 0) {
        lookupPrimaryKeys(acls, parentsToLookup, sids);
    }
}