求大佬帮帮忙异常没找到

xiaoxiao2023-11-24 156

Hibernate: select leaseroom0_.id as id6_, leaseroom0_.uid as uid6_, leaseroom0_.aid as aid6_, leaseroom0_.hid as hid6_, leaseroom0_.address as address6_, leaseroom0_.time as time6_, leaseroom0_.acreage as acreage6_, leaseroom0_.title as title6_, leaseroom0_.img as img6_, leaseroom0_.pirce as pirce6_, leaseroom0_.esthment as esthment6_, leaseroom0_.remark as remark6_, leaseroom0_.state as state6_, leaseroom0_.chamber as chamber6_, leaseroom0_.hall as hall6_, leaseroom0_.toilet as toilet6_ from house.dbo.leaseRoom leaseroom0_ where 1=1 and leaseroom0_.state>=3 order by leaseroom0_.time desc limit ? org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2148) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) at org.hibernate.loader.Loader.list(Loader.java:2024) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at dao.impl.ProjectDaoimpl.getByPage(ProjectDaoimpl.java:194) at server.impl.LeaseRoomServerImpl.getByPage(LeaseRoomServerImpl.java:113) at struts.action.LeaseRoomAction.show(LeaseRoomAction.java:281) at struts.action.LeaseRoomAction.showRoomIndex(LeaseRoomAction.java:313) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270) at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292) at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:694) at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:665) at org.apache.jsp.index_jsp.jspx_meth_logic_005fempty_005f0(index_jsp.java:1135) at org.apache.jsp.index_jsp.jspService(index_jsp.java:185) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at struts.filter.CodingFilter.doFilter(CodingFilter.java:32) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol $H t t p 11 C o n n e c t i o n H a n d l e r . p r o c e s s (H t t p 11 P r o t o c o l . j a v a : 581) a t o r g . a p a c h e . t o m c a t . u t i l . n e t . J I o E n d p o i n t$ Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:662) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.leaseRoom leaseroom0 where 1=1 and leaseroom0.state>=3 order by leaseroom0_.t’ at line 1 at sun.reflect.GeneratedConstructorAccessor8.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:389) at com.mysql.jdbc.Util.getInstance(Util.java:372) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2535) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1911) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2034) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2145) … 54 more Hibernate: select count(leaseroom0_.id) as col_0_0_ from house.dbo.leaseRoom leaseroom0_ where 1=1 and leaseroom0_.state>=3 org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2148) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) at org.hibernate.loader.Loader.list(Loader.java:2024) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:749) at dao.impl.ProjectDaoimpl.uniqueSelect(ProjectDaoimpl.java:169) at server.impl.LeaseRoomServerImpl.getByPage(LeaseRoomServerImpl.java:117) at struts.action.LeaseRoomAction.show(LeaseRoomAction.java:281) at struts.action.LeaseRoomAction.showRoomIndex(LeaseRoomAction.java:313) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270) at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292) at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:694) at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:665) at org.apache.jsp.index_jsp.jspx_meth_logic_005fempty_005f0(index_jsp.java:1135) at org.apache.jsp.index_jsp.jspService(index_jsp.java:185) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at struts.filter.CodingFilter.doFilter(CodingFilter.java:32) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol $H t t p 11 C o n n e c t i o n H a n d l e r . p r o c e s s (H t t p 11 P r o t o c o l . j a v a : 581) a t o r g . a p a c h e . t o m c a t . u t i l . n e t . J I o E n d p o i n t$ Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:662) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.leaseRoom leaseroom0 where 1=1 and leaseroom0.state>=3’ at line 1 at sun.reflect.GeneratedConstructorAccessor8.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:389) at com.mysql.jdbc.Util.getInstance(Util.java:372) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2535) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1911) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2034) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2145) … 55 more 2019-5-25 22:23:47 org.apache.catalina.core.ApplicationDispatcher invoke 严重: Servlet.service() for servlet action threw exception java.lang.NullPointerException at server.impl.LeaseRoomServerImpl.getByPage(LeaseRoomServerImpl.java:117) at struts.action.LeaseRoomAction.show(LeaseRoomAction.java:281) at struts.action.LeaseRoomAction.showRoomIndex(LeaseRoomAction.java:313) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270) at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292) at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:694) at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:665) at org.apache.jsp.index_jsp._jspx_meth_logic_005fempty_005f0(index_jsp.java:1135) at org.apache.jsp.index_jsp._jspService(index_jsp.java:185) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at struts.filter.CodingFilter.doFilter(CodingFilter.java:32) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol $H t t p 11 C o n n e c t i o n H a n d l e r . p r o c e s s (H t t p 11 P r o t o c o l . j a v a : 581) a t o r g . a p a c h e . t o m c a t . u t i l . n e t . J I o E n d p o i n t$ Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:662) 2019-5-25 22:23:47 org.apache.catalina.core.StandardWrapperValve invoke 严重: Servlet.service() for servlet jsp threw exception java.lang.NullPointerException at server.impl.LeaseRoomServerImpl.getByPage(LeaseRoomServerImpl.java:117) at struts.action.LeaseRoomAction.show(LeaseRoomAction.java:281) at struts.action.LeaseRoomAction.showRoomIndex(LeaseRoomAction.java:313) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270) at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292) at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:694) at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:665) at org.apache.jsp.index_jsp._jspx_meth_logic_005fempty_005f0(index_jsp.java:1135) at org.apache.jsp.index_jsp._jspService(index_jsp.java:185) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at struts.filter.CodingFilter.doFilter(CodingFilter.java:32) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol $H t t p 11 C o n n e c t i o n H a n d l e r . p r o c e s s (H t t p 11 P r o t o c o l . j a v a : 581) a t o r g . a p a c h e . t o m c a t . u t i l . n e t . J I o E n d p o i n t$ Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:662)

package server.impl;

import java.util.ArrayList; import java.util.List;

import server.LeaseRoomServer; import bean.LeaseRoomBean; import bean.PublicBean; import dao.ProjectDao; import dao.impl.ProjectDaoimpl; import entity.LeaseRoom;

public class LeaseRoomServerImpl implements LeaseRoomServer {

private ProjectDao dao = new ProjectDaoimpl(); public boolean addRoom(LeaseRoom room) { // TODO Auto-generated method stub return dao.add(room); } public boolean delRoom(int id) { // TODO Auto-generated method stub LeaseRoom room=getRoom(id); return dao.delete(room); } // 分页查询 public PublicBean getByPage(int page,int row, LeaseRoomBean bean) { String hql = "select room from LeaseRoom room where 1=1 "; String count_hql = "select count(room) from LeaseRoom room where 1=1 "; List args = new ArrayList(); /** * 判断是否有以下条件,对查询语句进行拼接 ** */ if (bean.getState()==0) { //前台用户管理 hql += " and room.state>0"; count_hql+= " and room.state>0"; }if (bean.getState()==3) { //前台首页显示 hql += " and room.state>=3"; count_hql+= " and room.state>=3"; } if (bean.getUid()!=0) { hql += " and room.users.uid=?"; count_hql+= " and room.users.uid=?"; args.add(bean.getUid()); } if (bean.getAreaName() != null && !bean.getAreaName().equals("")) { hql += " and room.areaType.area=?"; count_hql+= " and room.areaType.area=?"; args.add(bean.getAreaName()); } if (bean.getTitle() != null && !bean.getTitle().equals("")) { hql += " and room.title like ?"; count_hql+= " and room.title like ?"; args.add("%"+bean.getTitle()+"%"); } if (bean.getChamber()!=null&&bean.getChamber()!=0) { hql += " and room.chamber=?"; count_hql += " and room.chamber=?"; args.add(bean.getChamber()); } if (bean.getHouseType() != null && !bean.getHouseType().equals("")) { hql += " and room.houseType.type=?"; count_hql += " and room.houseType.type=?"; args.add(bean.getHouseType()); } if (bean.getStartPrice()!=null && bean.getStartPrice()!=0) { hql += " and room.pirce>=?"; count_hql += " and room.pirce>=?"; args.add(bean.getStartPrice()); } if (bean.getEndPrice()!=null && bean.getEndPrice()!=0) { hql += " and room.pirce<=?"; count_hql += " and room.pirce<=?"; args.add(bean.getEndPrice()); } //始终按时间倒序排序 if(bean.getOrderBy() != null && bean.getOrderBy().equals("time")){//按时间升序 hql+=" order by room.time "; }else{ hql+=" order by room.time desc"; //按时间降序，默认 } //-----------------------判断排序------------------------// if (bean.getOrderBy() != null && !bean.getOrderBy().equals("")) { if(bean.getOrderBy().equals("acreageDESC")){//面积从大到小 hql+=",room.acreage desc"; } if(bean.getOrderBy().equals("acreage")){//面积从小到大 hql+=",room.acreage "; } if(bean.getOrderBy().equals("priceDESC")){//租金从高到低 hql+=",room.pirce desc"; } if(bean.getOrderBy().equals("price")){//租金从低到高 hql+=",room.pirce"; } } /*** 返回值JavaBean ***/ PublicBean pbean=new PublicBean(); if(bean.getIslist()==null){ List<LeaseRoom> list=dao.getByPage(hql, page, args, row); //获得每页所要显示的数据集合 pbean.setList(list); } int allCount=(Integer)dao.uniqueSelect(count_hql, args); //获得数据库所有数据条数 int allPage=0; //共有页码数 if(allCount%row!=0){ allPage=(allCount/row)+1; }else{ allPage=allCount/row; } pbean.setAllCount(allCount); pbean.setAllPage(allPage); pbean.setShowPage(page); return pbean; } public LeaseRoom getRoom(int id) { // 加载 // TODO Auto-generated method stub return (LeaseRoom) dao.getPojo(LeaseRoom.class, id); } public List<LeaseRoom> selectInfo(LeaseRoomBean bean) { // 一般查询 // TODO Auto-generated method stub String hql = "select room from LeaseRoom room where room.state>0 "; List args = new ArrayList(); /* 判断所带有的条件 */ if (bean.getAreaName() != null && !bean.getAreaName().equals("")) { hql += " and room.areaType.area=?"; args.add(bean.getAreaName()); } List<LeaseRoom> rlist = dao.select(hql, args); return rlist; } public boolean update(LeaseRoom room) { // TODO Auto-generated method stub return dao.update(room); }

//带TOP的查询 public List topRoom(LeaseRoomBean bean,int count) { String hql=“select room from LeaseRoom room where room.state>2 “; List args=new ArrayList(); if(bean.getUid()!=0){ hql+=” and room.users.uid=?”; args.add(bean.getUid()); } if(bean.getId()!=0){ hql+=" and room.id <>?"; args.add(bean.getId()); } hql+=" order by time desc";//排序 List list=dao.getByTop(hql, args, count); return list; }

public boolean delBySQL(int uid) { // TODO Auto-generated method stub String sql ="delete LeaseRoom l where l.users.uid= "+uid; return dao.deleteBySQL(sql); } public List<LeaseRoom> topRoom(LeaseRoomBean bean, int count, String key) { String hql="select room from LeaseRoom room where room.state>2 "; List args=new ArrayList(); if(bean.getUid()!=0){ hql+=" and room.users.uid=?"; args.add(bean.getUid()); } if(bean.getId()!=0){ hql+=" and room.id <>?"; args.add(bean.getId()); } hql+=" and room.address like '%"+key+"%'" + " or room.title like '%"+key+"%'"; hql+=" order by time desc";//排序 List<LeaseRoom> list=dao.getByTop(hql, args, count); return list; }

}

最新回复(0)