Struts2+Hibernate学生信息管理系统.zip

package sevice.impl; import java.util.List; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.Transaction; import db.MyHibernateSessionFactory; import entity.Students; import service.IStudentsDAO; public class StudentsDAOImpl implements IStudentsDAO{ @Override public List<Students> queryAllStudents() { // TODO Auto-generated method stub Transaction tx = null; List<Students> list = null; String hql = ""; try{ Session session = MyHibernateSessionFactory.getSessionFactory().getCurrentSession(); tx = session.beginTransaction(); hql = "from Students"; Query query = session.createQuery(hql); list = query.list(); tx.commit(); return list; }catch(Exception e){ e.printStackTrace(); tx.commit(); return list; }finally{ if(tx!=null){ tx = null; } } } @Override public Students queryStudentsBySid(String sid) { // TODO Auto-generated method stub Transaction tx = null; Students s = null; try{ Session session = MyHibernateSessionFactory.getSessionFactory().getCurrentSession(); tx = session.beginTransaction(); s =(Students) session.get(Students.class, sid); tx.commit(); return s; }catch(Exception e){ e.printStackTrace(); tx.commit(); return s; }finally{ if(tx!=null){ tx = null; } } } @Override public boolean addStudents(Students s) { // TODO Auto-generated method stub s.setSid(getNewSid());//设置学生学号 Transaction tx = null; try{ Session session = MyHibernateSessionFactory.getSessionFactory().getCurrentSession(); tx = session.beginTransaction(); session.save(s); tx.commit(); return true; }catch(Exception e){ e.printStackTrace(); return false; }finally{ if(tx!=null){ tx = null; } } } @Override public boolean updateStudents(Students s) { // TODO Auto-generated method stub Transaction tx = null; try{ Session session = MyHibernateSessionFactory.getSessionFactory().getCurrentSession(); tx = session.beginTransaction(); session.update(s); tx.commit(); return true; }catch(Exception e){ e.printStackTrace(); tx.commit(); return false; }finally{ if(tx!=null){ tx = null; } } } @Override public boolean deleteStudents(String sid) { // TODO Auto-generated method stub Transaction tx = null; try{ Session session = MyHibernateSessionFactory.getSessionFactory().getCurrentSession(); tx = session.beginTransaction(); Students s = (Students)session.get(Students.class, sid); session.delete(s); tx.commit(); return true; }catch(Exception e){ e.printStackTrace(); tx.commit(); return false; }finally{ if(tx!=null){ tx = null; } } } //生成学生学号 private String getNewSid(){ Transaction tx = null; String hql = ""; String sid=null; try{ Session session = MyHibernateSessionFactory.getSessionFactory().getCurrentSession(); tx = session.beginTransaction(); //获得当前学生的最大编号 hql = "select max(sid) from Students"; Query query = session.createQuery(hql); sid =(String) query.uniqueResult(); if(sid==null||"".equals(sid)){ //给一个默认的最大编号 sid = "S0000001"; }else{ String temp = sid.substring(1); int i = Integer.parseInt(temp); i++; temp = String.valueOf(i); int len = temp.length(); //凑够七位 for(int j=0;j<7-len;j++){ temp = "0"+temp; } sid = "S"+temp; } tx.commit(); return sid; }catch(Exception e){ e.printStackTrace(); tx.commit(); return sid; }finally{ if(tx!=null){ tx = null; } } } //根据姓名查询学生信息 @Override public List<Students> queryStudentsByName(String sname) { // TODO Auto-generated method stub Transaction tx = null; List<Students> list = null; String hql; try{ Session session = MyHibernateSessionFactory.getSessionFactory().getCurrentSession(); tx = session.beginTransaction(); hql = "from Students where sname=?"; Query query = session.createQuery(hql); query.setParameter(0, sname); list = query.list(); tx.commit(); return list; }catch(Exception e){ e.printStackTrace(); tx.commit(); return list; }finally{ if(tx!=null){ tx = null; } } } }