1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17 package net.sf.fridaymvc.sample.hibernate.dao.impl;
18
19 import java.io.Serializable;
20 import java.util.List;
21
22 import net.sf.fridaymvc.sample.hibernate.HibernateUser;
23 import net.sf.fridaymvc.sample.hibernate.dao.UserDao;
24 import net.sf.fridaymvc.security.accesscontroller.User;
25 import net.sf.hibernate.Hibernate;
26 import net.sf.hibernate.HibernateException;
27 import net.sf.hibernate.Session;
28
29 import org.springframework.orm.hibernate.HibernateCallback;
30 import org.springframework.orm.hibernate.support.HibernateDaoSupport;
31
32 /***
33 * @author <a href="mailto:arto.pastinen@ofw.fi">Arto Pastinen</a>
34 * @version $Id: UserDaoImpl.java,v 1.1 2004/11/23 20:36:57 artsi Exp $
35 *
36 * @@org.springframework.transaction.interceptor.DefaultTransactionAttribute()
37 */
38
39 public class UserDaoImpl extends HibernateDaoSupport implements UserDao {
40 public List findAllUsers() {
41 return getHibernateTemplate().find("from HibernateUser");
42 }
43
44
45 public User findByUsernamePassword(final String username, final String password) {
46 return (User) getHibernateTemplate().execute(new HibernateCallback() {
47
48
49
50 public Object doInHibernate(Session session) throws HibernateException {
51 return session.createQuery("from HibernateUser as u where u.username = :username and u.password = :password")
52 .setString("username", username)
53 .setString("password", password)
54 .uniqueResult();
55 }
56 });
57
58 }
59
60 public Serializable save(HibernateUser hu) {
61 return getHibernateTemplate().save(hu);
62 }
63
64 /***
65 * @param user
66 */
67 public void update(User user) {
68 getHibernateTemplate().update(user);
69 }
70
71
72
73
74 public int removeUserByUserUid(Integer userUid) {
75 return getHibernateTemplate().delete("from HibernateUser as u where u.userUid = ?", userUid, Hibernate.INTEGER);
76 }
77 }