WebSVN - WebE - Diff - Rev 27 and 33 - /trunk/src/ch/ffhs/webE/dao/UserDAOImpl.java



import java.util.List;

import org.hibernate.Session;
import org.hibernate.Transaction;

import ch.ffhs.webE.domain.User;

import com.googlecode.s2hibernate.struts2.plugin.annotations.SessionTarget;
import com.googlecode.s2hibernate.struts2.plugin.annotations.TransactionTarget;
 

public class UserDAOImpl implements UserDAO
{

  @SessionTarget

  public List<User> listUser()
  {
    List<User> user = null;
    try
    {
      user = this.session.createQuery("from User").list();
    }
    catch (Exception e)
    {
      e.printStackTrace();
    }

  @Override
  public void saveOrUpdateUser(User user)
  {
    try
    {
      this.session.saveOrUpdate(user);
    }
    catch (Exception e)
    {
      this.transaction.rollback();
      e.printStackTrace();
    }
  }

  /**

  @Override
  public void deleteUser(int userId)
  {
    try
    {
      User user = (User) this.session.get(User.class, userId);
      this.session.delete(user);
    }
    catch (Exception e)
    {
      this.transaction.rollback();
      e.printStackTrace();
    }
  }

  /**
   * Returns a single user with this user name (used for login)
   *
   * @param username
   *          : String - entire user name
   * @return User: Returns a user object if something is found. If not, null is
   *         returned
   */
  public User searchUsername(String username)
  {
    User user = null;

    // Exec query
    try
    {
      user = (User) this.session
          .createQuery("FROM User " + "WHERE username = :username")
          .setParameter("username", username).uniqueResult();
    }
    catch (Exception e)
    {

  public User listUserById(int userId)
  {
    User user = null;
    try
    {
      user = (User) this.session.get(User.class, userId);
    }
    catch (Exception e)
    {
      e.printStackTrace();
    }

Rev 27	Rev 33
Line 4...	Line 4...
4	import java.util.List;	4	import java.util.List;
5		5
6	import org.hibernate.Session;	6	import org.hibernate.Session;
7	import org.hibernate.Transaction;	7	import org.hibernate.Transaction;
8		8
-		9	import ch.ffhs.webE.domain.User;
-		10
9	import com.googlecode.s2hibernate.struts2.plugin.annotations.SessionTarget;	11	import com.googlecode.s2hibernate.struts2.plugin.annotations.SessionTarget;
10	import com.googlecode.s2hibernate.struts2.plugin.annotations.TransactionTarget;	12	import com.googlecode.s2hibernate.struts2.plugin.annotations.TransactionTarget;
11	import ch.ffhs.webE.domain.*;	-
12		13
13	public class UserDAOImpl implements UserDAO	14	public class UserDAOImpl implements UserDAO
14	{	15	{
15		16
16	@SessionTarget	17	@SessionTarget
Line 29...	Line 30...
29	public List<User> listUser()	30	public List<User> listUser()
30	{	31	{
31	List<User> user = null;	32	List<User> user = null;
32	try	33	try
33	{	34	{
34	user = session.createQuery("from User").list();	35	user = this.session.createQuery("from User").list();
35	}	36	}
36	catch (Exception e)	37	catch (Exception e)
37	{	38	{
38	e.printStackTrace();	39	e.printStackTrace();
39	}	40	}
Line 57...	Line 58...
57	@Override	58	@Override
58	public void saveOrUpdateUser(User user)	59	public void saveOrUpdateUser(User user)
59	{	60	{
60	try	61	try
61	{	62	{
62	session.saveOrUpdate(user);	63	this.session.saveOrUpdate(user);
63	}	64	}
64	catch (Exception e)	65	catch (Exception e)
65	{	66	{
66	transaction.rollback();	67	this.transaction.rollback();
67	e.printStackTrace();	68	e.printStackTrace();
68	}	69	}
69	}	70	}
70		71
71	/**	72	/**
Line 76...	Line 77...
76	@Override	77	@Override
77	public void deleteUser(int userId)	78	public void deleteUser(int userId)
78	{	79	{
79	try	80	try
80	{	81	{
81	User user = (User) session.get(User.class, userId);	82	User user = (User) this.session.get(User.class, userId);
82	session.delete(user);	83	this.session.delete(user);
83	}	84	}
84	catch (Exception e)	85	catch (Exception e)
85	{	86	{
86	transaction.rollback();	87	this.transaction.rollback();
87	e.printStackTrace();	88	e.printStackTrace();
88	}	89	}
89	}	90	}
90		91
91	/**	92	/**
92	* Returns a single user with this user name (used for login)	93	* Returns a single user with this user name (used for login)
93	*	94	*
94	* @param username	95	* @param username
95	* : String - entire user name	96	* : String - entire user name
96	* @return User: Returns a user object if something is found. If not, null	97	* @return User: Returns a user object if something is found. If not, null is
97	* is returned	98	* returned
98	*/	99	*/
99	public User searchUsername(String username)	100	public User searchUsername(String username)
100	{	101	{
101	User user = null;	102	User user = null;
102		103
103	// Exec query	104	// Exec query
104	try	105	try
105	{	106	{
106	user = (User) session	107	user = (User) this.session
107	.createQuery("FROM User " + "WHERE username = :username")	108	.createQuery("FROM User " + "WHERE username = :username")
108	.setParameter("username", username).uniqueResult();	109	.setParameter("username", username).uniqueResult();
109	}	110	}
110	catch (Exception e)	111	catch (Exception e)
111	{	112	{
Line 121...	Line 122...
121	public User listUserById(int userId)	122	public User listUserById(int userId)
122	{	123	{
123	User user = null;	124	User user = null;
124	try	125	try
125	{	126	{
126	user = (User) session.get(User.class, userId);	127	user = (User) this.session.get(User.class, userId);
127	}	128	}
128	catch (Exception e)	129	catch (Exception e)
129	{	130	{
130	e.printStackTrace();	131	e.printStackTrace();
131	}	132	}

Subversion Repositories WebE

(root)/trunk/src/ch/ffhs/webE/dao/UserDAOImpl.java - Rev 27 → 33