Hibernate入门（四）——DAO层分离

第一步，创建dao层接口

public interface ClassroomDAO {
	
	public List<Classroom> queryAllClassroom();

	public boolean addClassroom(Classroom classroom);
	
	public boolean deleteClassroom(int cid);
	
}

第二步，实现dao层接口的实现类

public class ClassroomDAOimpl implements ClassroomDAO {

    @Override
    public List<Classroom> queryAllClassroom() {
        // TODO Auto-generated method stub
        Transaction tx = null;
        List<Classroom> list = null;
        String hql = "";
        try {
            Session session = MyHibernateSessionFactory.getsessionFactory().getCurrentSession();
            tx = session.beginTransaction();
            hql = "from Classroom";
            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;
            }
        }
    }

    public String sum(String address) {

        Transaction tx = null;
        String hql = null;

        try {
            Session session = MyHibernateSessionFactory.getsessionFactory().getCurrentSession();
            tx = session.beginTransaction();
            hql = "SELECT COUNT(ADDRESS) FROM TeachersHelper.STUDENTS WHERE ADDRESS='" + address + "'";
            Query query = session.createQuery(hql);
            String sunmun = (String) query.uniqueResult();
            tx.commit();
            System.out.println(sunmun);
            return sunmun;
        } catch (Exception e) {
            e.printStackTrace();
            tx.commit();
            return null;

        } finally {
            if (tx != null) {
                tx = null;
            }
        }
    }

    @Override
    public boolean addClassroom(Classroom classroom) {
        // TODO Auto-generated method stub

        Transaction tx = null;
        try {
            Session session = MyHibernateSessionFactory.getsessionFactory().getCurrentSession();
            tx = session.beginTransaction();
            session.save(classroom);
            tx.commit();
            return true;

        } catch (Exception e) {
            e.printStackTrace();
            tx.commit();
            return false;
        } finally {
            if (tx != null)
                tx = null;
        }
    }


    @Override
    public boolean deleteClassroom(int cid) {
        // TODO Auto-generated method stub
        Transaction tx = null;
        //String hql = "";
        try {
            Session session = MyHibernateSessionFactory.getsessionFactory().getCurrentSession();
            tx = session.beginTransaction();
            Classroom c = (Classroom) session.get(Classroom.class, cid);
            session.delete(c);
            tx.commit();
            return true;
        } catch (Exception ex) {
            ex.printStackTrace();
            tx.commit();
            return false;
        } finally {
            if (tx != null) {
                tx = null;
            }
        }
    }
}

第三步，实现Action层编写

public class ClassroomAction extends superAction{
	private static final long serialVersionUID = 1L;
	
	public String query() {
		ClassroomDAO cDAO = new ClassroomDAOimpl();
		List<Classroom> list= cDAO.queryAllClassroom();
		if(list!=null&&list.size()>0) {
			session.setAttribute("classroom_list", list);
		}else {
			session.setAttribute("classroom_list", null);
		}
		System.out.println(list);
		return "query_success";
	}
	
	public String add() {
		Classroom classroom=new Classroom();
		classroom.setCname(this.request.getParameter("cname"));
		ClassroomDAO classroomDAO = new ClassroomDAOimpl();
		classroomDAO.addClassroom(classroom);
		return "add_success";
	}
	
	public String delete() {
		ClassroomDAO cDAO = new ClassroomDAOimpl();
		int cid = Integer.parseInt(request.getParameter("cid"));
		cDAO.deleteClassroom(cid);
		return "delete_success";
	}
}

第四步，将其他类按照同样的方法抽离

第五，项目截图展示