loginservice.java

学校的课程管理及选课系统

package org.wangsong.service;

import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import org.hibernate.Query;
import org.hibernate.Session;
import org.wangsong.dao.hibernate.HibernateUtil;
import org.wangsong.domain.Student;
import org.wangsong.domain.Teacher;

 
 

public class LoginService
{
	public boolean studentLogin(HttpServletRequest request,String username, String password)
	{
		try
		{
			HttpSession session=request.getSession();
			Session s = HibernateUtil.currentSession();
			HibernateUtil.beginTransaction();
			String str = " from Student as stu where stu.name=:stuName and stu.password=:stuPassword";
			Query query = s.createQuery(str);
			System.out.println(username + "  " + password);
			query.setString("stuName", username);
			query.setString("stuPassword", password);
			List list = query.list();
			if (list.size() > 0)
			{
 				session.setAttribute("stuid", ((Student) query.list()
						.get(0)).getId());
 				HibernateUtil.commitTransaction();
 				HibernateUtil.closeSession();

 				return true;
			}
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
		HibernateUtil.commitTransaction();
		HibernateUtil.closeSession();
		return false;
	}
	public boolean teacherLogin(HttpServletRequest request,String username, String password)
	{
		try
		{
			HttpSession session =request.getSession();
			Session s = HibernateUtil.currentSession();
			HibernateUtil.beginTransaction();
			String str = " from Teacher as tea where tea.name=:teaName and tea.password=:teaPassword";
			Query query = s.createQuery(str);
			System.out.println(username + "  " + password);
			query.setString("teaName", username);
			query.setString("teaPassword", password);
			List list = query.list();

			if (list.size() > 0)
			{
 				session.setAttribute("teaid", ((Teacher) query.list()
						.get(0)).getId());
 				HibernateUtil.commitTransaction();
 				HibernateUtil.closeSession();

				return true;
			}
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
		HibernateUtil.commitTransaction();
		HibernateUtil.closeSession();
		return false;
	}
	public boolean adminLogin(String username, String password)
	{
		try
		{
			Session session = HibernateUtil.currentSession();
			HibernateUtil.beginTransaction();
			String str = " from Admin as ad where ad.name=:adminName and ad.password=:adminPassword";
			Query query = session.createQuery(str);
			System.out.println(username + "  " + password);
			query.setString("adminName", username);
			query.setString("adminPassword", password);
			List list = query.list();
			HibernateUtil.commitTransaction();
			HibernateUtil.closeSession();

			if (list.size() > 0)
			{
				return true;
			}
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
		return false;
	}

}