logindaoimpl.java

这是大唐电信的一个管理系统

package com.tatang.dao.impl;

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

import com.tatang.dao.ILoginDao;
import com.tatang.util.HibernateSessionFactory;

public class LoginDaoImpl implements ILoginDao{

	public boolean validate(String name, String pwd, String position, boolean is) {
		Session session = null;
		Transaction tx = null;
		Query q = null;
		Integer it = -1;
		String sql="select count(*) from TEmployee where name=? and password=? and position=?";
		try{
			session = HibernateSessionFactory.getSession();
			tx = session.beginTransaction();
			q = session.createQuery(sql);
			q.setString(0,name);
			q.setString(1, pwd);
			q.setString(2,position);
			
			it = (Integer)q.uniqueResult();
			tx.commit();
			if(it != 0){
				return true;
			}else{
				return false;
			}
		}catch(HibernateException e){
			tx.rollback();
			e.printStackTrace();
			return false;
		}finally{
			HibernateSessionFactory.closeSession();
		}
	}

	public Integer validate(String name, String pwd, String position) {
		Session session = null;
		Transaction tx = null;
		Query q = null;
		int is = 0;
		String sql="select id from TEmployee where name=? and password=? and position=?";
		try{
			session = HibernateSessionFactory.getSession();
			tx = session.beginTransaction();
			q = session.createQuery(sql);
			q.setString(0,name);
			q.setString(1,pwd);
			q.setString(2,position);
			is =(Integer)q.uniqueResult();
			tx.commit();
			return is;
		}catch(HibernateException e){
			tx.rollback();
			e.printStackTrace();
			return 0;
		}finally{
			HibernateSessionFactory.closeSession();
		}
	}
}