培训公司选课系统的B/S模式

package com.service; import java.util.List; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.cfg.AnnotationConfiguration; import com.model.Course; import com.model.SelectCourse; import com.model.Staff; public class CourseService { public Session getSession() { SessionFactory sessionFatory = new AnnotationConfiguration().configure().buildSessionFactory(); Session ss=sessionFatory.getCurrentSession(); return ss; } //录入员工基本信息 public void addStaff(Staff staff) { Session ss = getSession(); ss.beginTransaction(); ss.save(staff); ss.getTransaction().commit(); } //录入选定课程基本信息 public void addApply(SelectCourse sc) { Session ss = getSession(); ss.beginTransaction(); ss.save(sc); ss.getTransaction().commit(); } //录入课程基本信息 public void addCourse(Course c) { Session ss = getSession(); ss.beginTransaction(); ss.save(c); ss.getTransaction().commit(); } //登录判断 public int checkClient(int tablename,String userName,String password) { Session ss = getSession(); ss.beginTransaction(); Query q; if(tablename==0)//进行Staff admins表检验 { q = ss.createQuery("select s.id from Staff s where s.staff_password= :pw and s.staff_username= :user"); } else { q = ss.createQuery("select a.id from Admins a where a.password= :pw and a.userName= :user"); } q.setParameter("pw", password); q.setParameter("user", userName); Integer count = (Integer)q.uniqueResult(); ss.getTransaction().commit(); if(count==null) return 0; else return count; } //获取员工的对象 public Staff getStaff(int id) { Session ss=getSession(); ss.beginTransaction(); Staff hs=(Staff)ss.get(Staff.class,id); ss.getTransaction().commit(); return hs; } //获取员工的对象 public Course getCourse(int id) { Session ss=getSession(); ss.beginTransaction(); Course c=(Course)ss.get(Course.class,id); ss.getTransaction().commit(); return c; } //获取员工的对象 public Staff getStaffs(String userName) { Session ss=getSession(); ss.beginTransaction(); Query q; q = ss.createQuery("select s.id from Staff s where s.staff_username= :user"); q.setParameter("user", userName); Integer count = (Integer)q.uniqueResult(); Staff hs=(Staff)ss.get(Staff.class,count); ss.getTransaction().commit(); return hs; } //核实密码 public String checkOldPassword(String userName) { Session ss = getSession(); ss.beginTransaction(); Query q; q = ss.createQuery("select s.id from Staff s where s.staff_username= :user"); q.setParameter("user", userName); Integer count = (Integer)q.uniqueResult(); //获取员工对象 Staff sta=getStaff(count); String str=sta.getStaff_password(); ss.getTransaction().commit(); return str; } //设置新密码 public void setNewPassword(String userName,String newpw) { Session ss = getSession(); ss.beginTransaction(); Query q; q = ss.createQuery("select s.id from Staff s where s.staff_username= :user"); q.setParameter("user", userName); Integer count = (Integer)q.uniqueResult(); //获取员工对象 Staff sta=(Staff)ss.get(Staff.class,count); sta.setStaff_password(newpw); ss.getTransaction().commit(); } //判断是否有重复员工编号 public int checkNumber(String userName) { Session ss = getSession(); ss.beginTransaction(); Query q; q = ss.createQuery("select s.id from Staff s where s.staff_username= :user"); q.setParameter("user", userName); Integer count = (Integer)q.uniqueResult(); ss.getTransaction().commit(); if(count==null) return 0; else return count; } //获取所有课程信息 public List<Course> getAllCourse() { Session ss = getSession(); ss.beginTransaction(); StringBuffer buf = new StringBuffer("from Course "); String queryState=buf.toString(); Query q = ss.createQuery(queryState); List<Course> shops= (List<Course>)q.list();//a new method ss.getTransaction().commit(); return shops; } //获取所有课程信息 public List<SelectCourse> getSelectCourse() { Session ss = getSession(); ss.beginTransaction(); StringBuffer buf = new StringBuffer("from SelectCourse"); String queryState=buf.toString(); Query q = ss.createQuery(queryState); List<SelectCourse> sel= (List<SelectCourse>)q.list();//a new method ss.getTransaction().commit(); return sel; } //获取某个员工所选的课程信息 public List<SelectCourse> getStaffCourse(String sta) { Session ss = getSession(); ss.beginTransaction(); Staff staff=this.getStaffs(sta); int number=staff.getId(); //注意这里方法，提取属性是对象中的参数 Query q = ss.createQuery("from SelectCourse sc where sc.staffs.id= :number"); q.setParameter("number", number); List<SelectCourse> sel= (List<SelectCourse>)q.list();//a new method ss.getTransaction().commit(); return sel; } }