dbmanagerimpl.java

我们采用了JSP技术为主要手段,本系统采用了多级角色管理：包括系统管理员、系主任

package com.middle.graduate.biz.dao.impl;

import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Session;

import com.middle.graduate.biz.dao.DBManagerDao;
import com.middle.graduate.biz.entity.Student;
import com.middle.graduate.biz.entity.Teacher;
import com.middle.graduate.biz.exce.DataException;
import com.middle.graduate.util.HbnUtil;

public class DBManagerImpl implements DBManagerDao {

	public boolean login(int managerId, String password) throws DataException {
		Session session = HbnUtil.getSession();
		try {
			session.beginTransaction();
			String sql = "select t_password from t_manager where t_managerId = ?";
			String pwd = (String)session.createSQLQuery(sql).setInteger(0, managerId).uniqueResult();
			if(pwd.equals(password)) {
				return true;
			} else {
				return false;
			}
		} catch (HibernateException e) {
			e.printStackTrace();
			throw new DataException("manager login error");
		}
	}
	public void changePassword(int managerId, String password) throws DataException {
		Session session = HbnUtil.getSession();
		try {
			session.beginTransaction();
			String sql = "update t_manager set t_password = ? where t_managerId = ?";
			session.createSQLQuery(sql).setString(0, password).setInteger(1, managerId).executeUpdate();
			session.getTransaction().commit();
		} catch (HibernateException e) {
			e.printStackTrace();
			session.getTransaction().rollback();
			throw new DataException("db: manager change password error");
		} finally {
			HbnUtil.closeSession();
		}
	}
	public void insert(Teacher teacher) throws DataException {
		Session session = HbnUtil.getSession();
		try {
			session.beginTransaction();
			session.save(teacher);
			session.getTransaction().commit();
		} catch (HibernateException e) {
			e.printStackTrace();
			session.getTransaction().rollback();
			throw new DataException("db: manager insert teacher into db error");
		} finally {
			HbnUtil.closeSession();
		}
	}

	public void insert(Student student) throws DataException {
		Session session = HbnUtil.getSession();
		try {
			session.beginTransaction();
			session.save(student);
			session.getTransaction().commit();
		} catch (HibernateException e) {
			e.printStackTrace();
			session.getTransaction().rollback();
			throw new DataException("db: manager insert student into db error");
		} finally {
			HbnUtil.closeSession();
		}
	}

	public List<Student> queryAllStudent() throws DataException {
		Session session = HbnUtil.getSession();
		try {
			session.beginTransaction();
			String hql = "from Student";
			List<Student> list = (List<Student>)session.createQuery(hql).list();
			return list;
		} catch (HibernateException e) {
			e.printStackTrace();
			throw new DataException("db: manager query all student error");
		}
	}

	public List<Teacher> queryAllTeacher() throws DataException {
		Session session = HbnUtil.getSession();
		try {
			session.beginTransaction();
			String hql = "from Teacher";
			List<Teacher> list = (List<Teacher>)session.createQuery(hql).list();
			return list;
		} catch (HibernateException e) {
			e.printStackTrace();
			throw new DataException("db: manager query all teacher error");
		}
	}

}