Rev 19 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed
| Rev 19 | Rev 22 | ||
|---|---|---|---|
| Line 8... | Line 8... | ||
| 8 | import com.googlecode.s2hibernate.struts2.plugin.annotations.SessionTarget; |
8 | import com.googlecode.s2hibernate.struts2.plugin.annotations.SessionTarget; |
| 9 | import com.googlecode.s2hibernate.struts2.plugin.annotations.TransactionTarget; |
9 | import com.googlecode.s2hibernate.struts2.plugin.annotations.TransactionTarget; |
| 10 | import ch.ffhs.webE.domain.*; |
10 | import ch.ffhs.webE.domain.*; |
| 11 | 11 | ||
| 12 | public class UserDAOImpl implements UserDAO { |
12 | public class UserDAOImpl implements UserDAO { |
| 13 | 13 | ||
| 14 | @SessionTarget |
14 | @SessionTarget |
| 15 | Session session;
|
15 | Session session;
|
| 16 | @TransactionTarget |
16 | @TransactionTarget |
| 17 | Transaction transaction;
|
17 | Transaction transaction;
|
| 18 | 18 | ||
| 19 | @SuppressWarnings("unchecked") |
19 | @SuppressWarnings("unchecked") |
| 20 | @Override |
20 | @Override |
| 21 | public List<User> listUser() { |
21 | public List<User> listUser() { |
| 22 | List<User> courses = null; |
22 | List<User> user = null; |
| 23 | try { |
23 | try { |
| 24 | courses = session.createQuery("from User").list(); |
24 | user = session.createQuery("from User").list(); |
| 25 | } catch (Exception e) { |
25 | } catch (Exception e) { |
| 26 | e.printStackTrace(); |
26 | e.printStackTrace(); |
| 27 | }
|
27 | }
|
| 28 | return courses; |
28 | return user; |
| 29 | }
|
29 | }
|
| 30 | 30 | ||
| 31 | @Override |
31 | @Override |
| 32 | public void saveUser(User user) { |
32 | public void saveUser(User user) { |
| 33 | try { |
33 | try { |
| 34 | session.save(user); |
34 | session.save(user); |
| 35 | } catch (Exception e) { |
35 | } catch (Exception e) { |
| 36 | transaction.rollback(); |
36 | transaction.rollback(); |
| 37 | e.printStackTrace(); |
37 | e.printStackTrace(); |
| 38 | }
|
38 | }
|
| - | 39 | }
|
|
| - | 40 | ||
| - | 41 | /**
|
|
| - | 42 | * Used to delete a user.
|
|
| - | 43 | */
|
|
| - | 44 | @Override |
|
| - | 45 | public void deleteUser(int userId) { |
|
| - | 46 | try { |
|
| - | 47 | User user = (User) session.get(User.class, userId); |
|
| - | 48 | session.delete(user); |
|
| - | 49 | } catch (Exception e) { |
|
| - | 50 | transaction.rollback(); |
|
| - | 51 | e.printStackTrace(); |
|
| - | 52 | }
|
|
| 39 | }
|
53 | }
|
| 40 | 54 | ||
| 41 | /**
|
55 | /**
|
| 42 | * Returns a single user with this user name (used for login)
|
56 | * Returns a single user with this user name (used for login)
|
| - | 57 | *
|
|
| - | 58 | * @param username
|
|
| 43 | * @param username: String - entire user name
|
59 | * : String - entire user name
|
| 44 | * @return User: Returns a user object if something is found. If not, null is returned
|
60 | * @return User: Returns a user object if something is found. If not, null
|
| - | 61 | * is returned
|
|
| 45 | */
|
62 | */
|
| 46 | public User searchUsername(String username) { |
63 | public User searchUsername(String username) { |
| 47 | User user = null; |
64 | User user = null; |
| 48 | 65 | ||
| 49 | try { |
66 | try { |
| 50 | user = (User) session.createQuery( |
67 | user = (User) session |
| 51 | "FROM User " +
|
- | |
| 52 | "WHERE username = :username") |
68 | .createQuery("FROM User " + "WHERE username = :username") |
| 53 | .setParameter("username", username) |
69 | .setParameter("username", username).uniqueResult(); |
| 54 | .uniqueResult(); |
- | |
| 55 | } catch (Exception e) { |
70 | } catch (Exception e) { |
| 56 | //TODO: Log error
|
71 | // TODO: Log error
|
| 57 | }
|
72 | }
|
| 58 | return user; |
73 | return user; |
| 59 | }
|
74 | }
|
| 60 | }
|
75 | }
|