Mercurial > dive4elements > framework
comparison artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java @ 147:9a64e0c1c737
Added code to load user from database.
artifacts/trunk@1372 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Wed, 02 Mar 2011 18:08:37 +0000 |
| parents | 967dc552455d |
| children | 101a52d3ad08 |
comparison
equal
deleted
inserted
replaced
| 146:967dc552455d | 147:9a64e0c1c737 |
|---|---|
| 893 return null; | 893 return null; |
| 894 } | 894 } |
| 895 | 895 |
| 896 public void deleteUser(User user) { | 896 public void deleteUser(User user) { |
| 897 | 897 |
| 898 Connection conn = null; | 898 Connection conn = null; |
| 899 ResultSet result = null; | 899 ResultSet result = null; |
| 900 PreparedStatement stmnt = null; | 900 PreparedStatement stmnt = null; |
| 901 | 901 |
| 902 String identifier = user.identifier(); | 902 String identifier = user.identifier(); |
| 903 | |
| 904 if (!StringUtils.checkUUID(identifier)) { | |
| 905 return; | |
| 906 } | |
| 903 | 907 |
| 904 DataSource dataSource = DBConnection.getDataSource(); | 908 DataSource dataSource = DBConnection.getDataSource(); |
| 905 try { | 909 try { |
| 906 conn = dataSource.getConnection(); | 910 conn = dataSource.getConnection(); |
| 907 try { | 911 try { |
| 976 } | 980 } |
| 977 } | 981 } |
| 978 } | 982 } |
| 979 | 983 |
| 980 public User getUser(String identifier) { | 984 public User getUser(String identifier) { |
| 981 // TODO: implement me! | 985 |
| 986 Connection conn = null; | |
| 987 ResultSet result = null; | |
| 988 PreparedStatement stmnt = null; | |
| 989 | |
| 990 if (!StringUtils.checkUUID(identifier)) { | |
| 991 logger.debug("Invalid UUID: '" + identifier + "'"); | |
| 992 return null; | |
| 993 } | |
| 994 | |
| 995 DataSource dataSource = DBConnection.getDataSource(); | |
| 996 try { | |
| 997 conn = dataSource.getConnection(); | |
| 998 stmnt = conn.prepareStatement(SQL_USERS_SELECT_ID_BY_GID); | |
| 999 stmnt.setString(1, identifier); | |
| 1000 result = stmnt.executeQuery(); | |
| 1001 if (!result.next()) { // no such user | |
| 1002 return null; | |
| 1003 } | |
| 1004 // omit id | |
| 1005 String name = result.getString(2); | |
| 1006 byte [] roleData = result.getBytes(3); | |
| 1007 | |
| 1008 Document role = XMLUtils.fromByteArray(roleData); | |
| 1009 | |
| 1010 return new DefaultUser(identifier, name, role); | |
| 1011 } | |
| 1012 catch (SQLException sqle) { | |
| 1013 logger.error(sqle.getLocalizedMessage(), sqle); | |
| 1014 } | |
| 1015 finally { | |
| 1016 if (result != null) { | |
| 1017 try { result.close(); } | |
| 1018 catch (SQLException sqle) {} | |
| 1019 } | |
| 1020 if (stmnt != null) { | |
| 1021 try { stmnt.close(); } | |
| 1022 catch (SQLException sqle) {} | |
| 1023 } | |
| 1024 if (conn != null) { | |
| 1025 try { conn.close(); } | |
| 1026 catch (SQLException sqle) {} | |
| 1027 } | |
| 1028 } | |
| 1029 | |
| 982 return null; | 1030 return null; |
| 983 } | 1031 } |
| 984 | 1032 |
| 985 public User [] getUsers() { | 1033 public User [] getUsers() { |
| 986 // TODO: implement me! | 1034 // TODO: implement me! |