/** * * Executes {@link Connection#rollback() and * frees the connection object * @see org.geoserver.security.jdbc.JDBCUserGroupService#load() */ public void load() throws IOException { // Simply roll back the transaction try { getConnection().rollback(); releaseConnection(); } catch (SQLException ex) { throw new IOException(ex); } setModified(false); //fireUserGroupChangedEvent(); }
/** * Executes {@link Connection#commit()} and frees * the connection * * @see org.geoserver.security.GeoServerUserGroupStore#store() */ public void store() throws IOException { // Simply commit the transaction try { getConnection().commit(); releaseConnection(); } catch (SQLException ex) { throw new IOException(ex); } setModified(false); //fireUserGroupChangedEvent(); }
public void associateUserToGroup(GeoServerUser user, GeoServerUserGroup group) throws IOException { Connection con = null; PreparedStatement ps = null; try { con = getConnection(); ps = getDMLStatement("groupmembers.insert", con); ps.setString(1,group.getGroupname()); ps.setString(2,user.getUsername()); ps.execute(); } catch (SQLException ex) { throw new IOException(ex); } finally { closeFinally(con, ps, null); } setModified(true); }
public void disAssociateUserFromGroup(GeoServerUser user, GeoServerUserGroup group) throws IOException { Connection con = null; PreparedStatement ps = null; try { con = getConnection(); ps = getDMLStatement("groupmembers.delete", con); ps.setString(1,group.getGroupname()); ps.setString(2,user.getUsername()); ps.execute(); } catch (SQLException ex) { throw new IOException(ex); } finally { closeFinally(con, ps, null); } setModified(true); }
public boolean removeUser(GeoServerUser user) throws IOException { Connection con = null; PreparedStatement ps = null; boolean retval = false; try { con = getConnection(); ps = getDMLStatement("users.delete", con); ps.setString(1,user.getUsername()); ps.execute(); retval= ps.getUpdateCount()>0; ps.close(); ps = getDMLStatement("userprops.deleteForUser",con); ps.setString(1,user.getUsername()); ps.execute(); ps.close(); ps = getDMLStatement("groupmembers.deleteUser", con); ps.setString(1,user.getUsername()); ps.execute(); } catch (SQLException ex) { throw new IOException(ex); } finally { closeFinally(con, ps, null); } setModified(true); return retval; }
public void clear() throws IOException { Connection con = null; PreparedStatement ps = null; try { con = getConnection(); ps = getDMLStatement("groupmembers.deleteAll", con); ps.execute(); ps.close(); ps = getDMLStatement("groups.deleteAll", con); ps.execute(); ps.close(); ps = getDMLStatement("userprops.deleteAll", con); ps.execute(); ps.close(); ps = getDMLStatement("users.deleteAll", con); ps.execute(); } catch (SQLException ex) { throw new IOException(ex); } finally { closeFinally(con, ps, null); } setModified(true); } /**
public boolean removeGroup(GeoServerUserGroup group) throws IOException { Connection con = null; PreparedStatement ps = null; boolean retval=false; try { con = getConnection(); ps = getDMLStatement("groups.delete", con); ps.setString(1,group.getGroupname()); ps.execute(); retval = ps.getUpdateCount()>0; ps.close(); ps = getDMLStatement("groupmembers.deleteGroup", con); ps.setString(1,group.getGroupname()); ps.execute(); } catch (SQLException ex) { throw new IOException(ex); } finally { closeFinally(con, ps, null); } setModified(true); return retval; }
public void addGroup(GeoServerUserGroup group) throws IOException { Connection con = null; PreparedStatement ps = null; try { con = getConnection(); ps = getDMLStatement("groups.insert", con); ps.setString(1,group.getGroupname()); ps.setString(2,convertToString(group.isEnabled())); ps.execute(); } catch (SQLException ex) { throw new IOException(ex); } finally { closeFinally(con, ps, null); } setModified(true); }
public void updateGroup(GeoServerUserGroup group) throws IOException { Connection con = null; PreparedStatement ps = null; try { con = getConnection(); ps = getDMLStatement("groups.update", con); ps.setString(1,convertToString(group.isEnabled())); ps.setString(2,group.getGroupname()); ps.execute(); } catch (SQLException ex) { throw new IOException(ex); } finally { closeFinally(con, ps, null); } setModified(true); }
public void updateUser(GeoServerUser user) throws IOException,PasswordPolicyException { preparePassword(user); Connection con = null; PreparedStatement ps = null; try { con = getConnection(); ps = getDMLStatement("users.update", con); ps.setString(1,user.getPassword()); ps.setString(2,convertToString(user.isEnabled())); ps.setString(3,user.getUsername()); ps.execute(); ps.close(); ps = getDMLStatement("userprops.deleteForUser",con); ps.setString(1,user.getUsername()); ps.execute(); addUserProperties(user, con); } catch (SQLException ex) { throw new IOException(ex); } finally { closeFinally(con, ps, null); } setModified(true); }
public void addUser(GeoServerUser user) throws IOException, PasswordPolicyException { preparePassword(user); Connection con = null; PreparedStatement ps = null; try { con = getConnection(); ps = getDMLStatement("users.insert", con); ps.setString(1,user.getUsername()); if (user.getPassword() != null) { ps.setString(2,user.getPassword()); } else { ps.setNull(2, Types.VARCHAR); } ps.setString(3,convertToString(user.isEnabled())); ps.execute(); addUserProperties(user, con); } catch (SQLException ex) { throw new IOException(ex); } finally { closeFinally(con, ps, null); } setModified(true); }