userdaoimpl.java

来自「有简单的网上书店需求及设计流程」· Java 代码 · 共 78 行

package org.wiely.dao.impl;

import java.util.List;

import org.apache.log4j.Logger;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.wiely.dao.UserDAO;
import org.wiely.vo.User;

public class UserDAOImpl extends BaseDAO implements UserDAO {

	// use log4j.jar to provide logger provices
	static Logger logger = Logger.getLogger(UserDAOImpl.class);

	@SuppressWarnings("unchecked")
	@Override
	public User checkUser(User user) throws Exception {

		Session session = getSession();
		String hql = "from User user where user.username=? and user.password=?";
		Query query;
		
		query = session.createQuery(hql);
		query.setParameter(0, user.getUsername());
		query.setParameter(1, user.getPassword());
		
		List list = query.list();
		if (list.size()==1) {
			User u = (User) list.get(0);
			session.close();
			return u;

		} else {
			session.close();
			return null;
		}

	}

	@SuppressWarnings("unchecked")
	@Override
	public boolean exitsUser(String username) throws Exception {
		Session session = getSession();
		String hql = "from User user where user.username= '"+username+"'";
		Query query;
		Boolean flag;

		query = session.createQuery(hql);		
		
		List list = query.list();
		if (list.size()>=1) {
			flag = true;
			session.close();
			return flag;

		} else {
			flag = false;
			session.close();
			return flag;
		}

	}	

	@Override
	public void register(User user) throws Exception {
		Session session = getSession();
		Transaction tx = session.beginTransaction();
		session.save(user);
		tx.commit();
		session.close();

	}

}