求大佬帮帮忙 异常没找到

最新推荐文章于 2023-07-20 01:46:02 发布
最新推荐文章于 2023-07-20 01:46:02 发布
阅读量155 收藏
点赞数 2
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/liu_bao_liang/article/details/90552708
版权

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 Http11ConnectionHandler.process(Http11Protocol.java:581) at org.apache.tomcat.util.net.JIoEndpoint Http11ConnectionHandler.process(Http11Protocol.java:581)atorg.apache.tomcat.util.net.JIoEndpointWorker.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 Http11ConnectionHandler.process(Http11Protocol.java:581) at org.apache.tomcat.util.net.JIoEndpoint Http11ConnectionHandler.process(Http11Protocol.java:581)atorg.apache.tomcat.util.net.JIoEndpointWorker.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 Http11ConnectionHandler.process(Http11Protocol.java:581) at org.apache.tomcat.util.net.JIoEndpoint Http11ConnectionHandler.process(Http11Protocol.java:581)atorg.apache.tomcat.util.net.JIoEndpointWorker.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 Http11ConnectionHandler.process(Http11Protocol.java:581) at org.apache.tomcat.util.net.JIoEndpoint Http11ConnectionHandler.process(Http11Protocol.java:581)atorg.apache.tomcat.util.net.JIoEndpointWorker.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;
}

}

Triste 旧约*�
关注
  • 2
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
各位大佬哥哥可以帮我看一下吗
05-04
各位大佬哥哥可以帮我看一下吗
supervisor
CentOS
01-10 817
supervisor 重启 启动 命令 sudo supervisorctl reload 首次重起 sudo supervisorctl start all首次重起 systemctl restart supervisord重启 supervisorctl reload重启 可能是由于supervisord进程停止了，建议重新运行 sudo supervisord...
拾壹博客的启动及一些注意事项
qq3892997的博客
02-26 2516
拾壹博客的启动及一些注意事项
jeecg-boot 空指针异常
ly1316221439的博客
12-25 1837
jeecg boot空指针异常
如何修复NullPointerException异常
山山的学习笔记
07-23 5803
java.lang.NullPointerException 是JAVA中最容易出现的异常，也是非常困扰编程新手的问题。本文对空指针异常的发生原因进行说明，并对如何解决空指针异常给出了快捷方法。 什么是空指针异常 NullPointerExceptions 是当您尝试使用未指向任何对象的引用时，发生的异常。对空引用调用方法或尝试访问空引用的字段将触发NullPointerException。比如如下代码： public class Dm2box { public...
出现java.lang.NullPointerException的可能原因及解决方案
热门推荐
IT学习小镇
03-23 6万+
综上所述，最常见的原因是对象未被正确初始化或者有 null 值的参数、数组或集合。因此，开发人员需要避免这些情况并进行适当的错误处理。
跪求各位大佬大神这题怎么写
01-06
平面直角坐标系中： 1、编写一个点类，将横、纵坐标作为其私有常数据成员；编写带两个参数（横、纵坐标）的构造函数，用成员初始化列表形式进行横、纵坐标的初始化赋值。 2、编写一个线段类，包含两个点类对象（端点...
哪位大佬可以帮一下这个文件的时间限制取消吗
最新发布
06-11
哪位大佬可以帮一下这个文件的时间限制取消吗
谷歌大佬刷题笔记.zip
04-25
谷歌大佬刷题笔记
青戈大佬沙箱支付系统资料
06-02
青戈大佬沙箱支付系统资料是一份专注于支付系统开发与测试的专业资源，主要涉及的是支付宝的沙箱环境应用。在IT行业中，沙箱支付系统是一个重要的概念，它为开发者提供了一个安全、隔离的测试环境，使得他们可以在不...
空指针异常：java.lang.NullPointerException: Cannot invoke “Object.getClass()“ because “obj“ is null
m0_63064861的博客
07-20 4855
空指针异常：java.lang.NullPointerException: Cannot invoke "Object.getClass()" because "obj" is null该问题是在一个空对象上调用方法而导致的，所以增加一个。
java.lang.NullPointerException错误的解决方案
越努力越幸运~~ Java领域从业者；CSDN新兴创新博主；Java领域优质创作者；书写奋斗者故事;欢迎交流学习进步；
08-24 3万+
java.lang.NullPointerException空指针异常是像我一样新手很容易出现的问题，这个问题一般情况都是不细心的时候出现的，开始正文如下： 1、业务层面的错误： 　　a、没有写非空验证：if(list.size()>0 && !"".equal(list)); 　　b、service方法引用注解的，有可能没有写注解（这个问题以前没有用代码模板工具经常出现）； 2、sql方法层面的错误： 　　a、mapper文件的dao路径引用路径写错，如下图（仅供参考） 　　b、sq
空指针错误 java.lang.NullPointerException 浅谈
weixin_30271335的博客
09-02 228
使用基本的JAVA数据类型，变量的值要么已经是默认值，如果没有对其正常赋值，程序便不能通过编译，因此使用基本的JAVA数据类型(double,float,boolean,char,int,long)一般不会引起空指针异常。由此可见，空指针异常主要跟与对象的操作相关。 下面先列出了可能发生空指针异常的几种情况及相应解决方案： 不管对象是否为空就直接开始使用。 (JSP)代码段1： out.p...
java.lang.NullPointerException
qq_58291701的博客
07-16 1374
java.lang.NullPointerException:无法调用“java.sql.Statement.executeQuery(String)”，因为“”为null
check …MySQL server…… use near '?' at line 1?(这些问题，你看后绝对会收藏)
qiukui111的博客
03-05 9018
文章目录一、常见错误二、吐血经历三、错误原因四、分享交流 一、常见错误 废话不多逼逼，先看java操作数据库常见错误： ：表名用了MySQL关键字 如下可知用了dec关键字(但表里的列名用关键字不影响，不信自己试哈） ：SQL语句有错（自己不扎实，怪谁呢！！哈哈哈） 这里的常常犯的错误又有： from写成form (我上面的错误就是这个错误) where前面好端端加个逗号 (反...
c语言循环重新输入Y,大佬们帮帮忙 帮我改改 怎样能在输入Y后 再次进行for循环...
06-10
你可以使用一个 `do-while` 循环来实现这个功能，具体代码如下： ```c #include int main() { char choice; do { // 在这里编写需要重复执行的代码 printf("Do you want to continue?... // 注意空格，避免缓冲...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值