userdaoimpl.java

struts

package com.wiely.dao.impl;

import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.wiely.commons.BaseDAO;
import com.wiely.dao.UserDAO;
import com.wiely.vo.User;

public class UserDAOImpl extends BaseDAO implements UserDAO {

	/*
	 * @see com.wiely.dao.UserDao#login(com.wiely.vo.Users) @the method login
	 *      test the user is valid or not.
	 */
	Query query;

	@SuppressWarnings("unchecked")
	public User login(User user) {
		try {
			Session session = getSession();
			String sql = "from User u where u.username =? and u.password =?";
			query = session.createQuery(sql);
			query.setString(0, user.getUsername());
			query.setString(1, user.getPassword());
			System.out.println(user.getUsername() + user.getPassword());
			List l = query.list();			
			System.out.println(l.size());
			if ((l.size() != 0)) {
				User u = (User) l.get(0);
				session.close();
				return u;
			} else {
				session.close();
				return null;
			}
		} catch (HibernateException e) {
			e.printStackTrace();
			return null;
		}

	}

	public User register(User user) {
		Session session=getSession();
		Transaction tx=session.beginTransaction();
		session.save(user);
		tx.commit();
		session.close();
		return user;
	}

	@SuppressWarnings("unchecked")
	public int findUser(User user) {
		Session session=getSession();
		String q="from User u where u.username=?";
		query=session.createQuery(q);
		query.setString(0, user.getUsername());
		int i=query.list().size();
		System.out.println(i);
		return i;
	}
}