logindao.java

来自「这是一个物流管理系统」· Java 代码 · 共 45 行

package dao;

import java.util.List;

import bean.Employeeinfo;
import bean.Userinfo;

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

import util.HibernateSessionFactory;

public class LoginDAO {
	
	@SuppressWarnings("unchecked")
	public boolean ispass(String username,String passwd){		
		
		Session s = HibernateSessionFactory.getSession();
		Transaction tr = s.beginTransaction();
		List<Userinfo> users = s.createQuery("from Userinfo u where u.username =:usern and u.userpass=:passw" )
				.setString("usern", username)
				.setString("passw", passwd)
				.list();
		tr.commit();
		s.close();
		if(users.size()==1)
			return true;
		else return false;		
	}
	public boolean marketUser(String username,String passwd){
		Session s = HibernateSessionFactory.getSession();
		Transaction tr = s.beginTransaction();
		String hql = "from Employeeinfo e where e.employeename=? and e.employeepass=?";
		Query q = s.createQuery(hql);
		q.setString(0, username);
		q.setString(1, passwd);
		List<Employeeinfo> employee = q.list(); 
		tr.commit();
		if(employee.size()!=0)
		   return true;
		else return false;		
	}
}