jsp+servlet+javabean+hibernate租房系统

package com.accp.dao; import java.io.Serializable; import java.util.List; import org.hibernate.Criteria; import org.hibernate.Query; import org.hibernate.criterion.Restrictions; import com.accp.entity.Comment; import com.accp.entity.House; import com.accp.entity.Users; /** * 房屋信息的dao实现 * @author lenovo * */ public class HouseDaoImpl extends HibernateBaseDao implements HouseDao { public void alterHouse(int id) { } public void deleteHouse(int id){ try{ }catch(Exception e){ }finally{ } } @SuppressWarnings({ "static-access", "unchecked" }) public List<House> findAllHouse() { List<House> house = null; try{ super.session = super.getSession(); Criteria criteria = super.session.createCriteria(House.class); house = criteria.list(); }catch(Exception e){ e.printStackTrace(); }finally{ super.closeSession(); } return house; } @SuppressWarnings("static-access") public Serializable releaseHouse(House houses) { Serializable flag = null; try{ super.session = super.getSession(); super.tran = super.session.beginTransaction(); super.session.save(houses); super.tran.commit(); }catch(Exception e){ super.tran.rollback(); }finally{ super.getSession(); } return flag; } @SuppressWarnings("static-access") public House findHouseById(int id) { House house = null; try{ super.session = super.getSession(); Criteria criteria = super.session.createCriteria(House.class); criteria.add(Restrictions.eq("id", id)); house = (House)criteria.uniqueResult(); }catch(Exception e){ e.printStackTrace(); }finally{ super.closeSession(); } return house; } @SuppressWarnings("static-access") public int getTotalPageByUsers(Users user)throws NullPointerException{ super.session = super.getSession(); int pageSize = 3; Query query = super.session.createQuery("from House h inner join " + "fetch h.user where h.user.username=? "); query.setString(0, user.getUsername()); int count = query.list().size(); int totalPage = (count%pageSize == 0)?(count/pageSize):(count/pageSize+1); System.out.println(totalPage); return totalPage; } @SuppressWarnings({ "static-access", "unchecked" }) public List<House> findHouseByUsers(Users user,int pageIndex){ List<House> houseList = null; int pageSize = 3; int count = 0; @SuppressWarnings("unused") int totalPage = 0; try{ super.session = super.getSession(); Query query = super.session.createQuery("from House h inner join " + "fetch h.user where h.user.username=? "); query.setString(0, user.getUsername()); houseList = query.list(); count = houseList.size(); totalPage = (count%pageSize == 0)?(count/pageSize):(count/pageSize+1); query.setFirstResult((pageIndex-1)*pageSize); query.setMaxResults(pageSize); houseList = query.list(); }catch(Exception e){ e.printStackTrace(); }finally{ super.closeSession(); } return houseList; } @SuppressWarnings({ "static-access", "unchecked" }) public List<House> page(int pageIndex){ List<House> houseList = null; int count = 0; @SuppressWarnings("unused") int totalPage = 0; try{ super.session = super.getSession(); Query query = super.session.createQuery("from House"); houseList = query.list(); count = houseList.size(); totalPage = (count% PAGESIZE == 0)?(count/ PAGESIZE):(count/ PAGESIZE+1); query.setFirstResult((pageIndex-1)* PAGESIZE); query.setMaxResults( PAGESIZE); houseList = query.list(); }catch(Exception e){ e.printStackTrace(); }finally{ super.closeSession(); } return houseList; } @SuppressWarnings({ "static-access" }) public int getTotalPage()throws NullPointerException{ super.session = super.getSession(); Query query = super.session.createQuery("from House"); int count = query.list().size(); int totalPage = (count% PAGESIZE == 0)?(count/ PAGESIZE):(count/PAGESIZE+1); System.out.println(totalPage); return totalPage; } @SuppressWarnings({ "static-access", "unchecked" }) public List<House> queryByLike(House house){ List<House> houseList = null; try{ super.session = super.getSession(); Query query = super.session.createQuery("from House h where h.title like ?"); query.setString(0, "%"+house.getTitle()+"%"); houseList = query.list(); for(House h:houseList){ System.out.println(h.getDescription()+h.getPrice()); } }catch(Exception e){ e.printStackTrace(); }finally{ super.closeSession(); } return houseList; } @SuppressWarnings("static-access") public Serializable houseComment(Comment comment){ Serializable flag = null; try{ super.session = super.getSession(); super.tran = super.session.beginTransaction(); flag = super.session.save(comment); super.tran.commit(); }catch(Exception e){ super.tran.rollback(); e.printStackTrace(); }finally{ System.out.println(flag); super.closeSession(); } return flag; } @SuppressWarnings("unchecked") public List<Comment> displayAllComment(int id){ List<Comment> list = null; try{ Query query = super.getSession().createQuery("from Comment c inner join " + "fetch c.house where c.house.id=?"); list = query.setInteger(0, id).list(); for(Comment c:list){ System.out.println(c.getContent()+"\t"+c.getTime()+"\t"+c.getId()+"\t" +c.getHouse().getId()); } }catch(Exception e){ e.printStackTrace(); }finally{ super.closeSession(); } return list; } public int getCommentCount(int id){ int count = 0; try{ Query query = super.getSession().createQuery("from Comment c inner join " + "fetch c.house where c.house.id=?"); count = query.setInteger(0, id).list().size(); }catch(Exception e){ e.printStackTrace(); }finally{ System.out.println(count); super.closeSession(); } return count; } }