SQL语法异常,求教求帮助

_Dust_小德 2014-03-19 09:40:53
Dao层


	@Override

	public Page findOrdersByUser(String username, Date date, Integer page) {



		String hql = "select * from order where userid = (select id from user where username = "

				+ username + ")";

		

//		if (date != null) {

//			hql += " and date = '" + date + "'";

//		}



		return this.findBySQL(hql, page);

	}

Dao里面的私有方法


/**

	 * 分页

	 */

	private Page findBySQL(String hql, int pageNum) {



		int totalPage = 1;// 总页数

		Page page = new Page();

		// 总条数

		int countNum = this.getSession().createSQLQuery(hql).addEntity(Order.class).list().size();



		// 总页数

		if (countNum % Constants.PAGE_NUMBER == 0) {

			totalPage = countNum / Constants.PAGE_NUMBER;

		} else {

			totalPage = countNum / Constants.PAGE_NUMBER + 1;

		}

		page.setTotalPage(totalPage);



		List<Order> result = this.getSession().createSQLQuery(hql).addEntity(Order.class)

				.setFirstResult((pageNum - 1) * Constants.PAGE_NUMBER)

				.setMaxResults(Constants.PAGE_NUMBER).list();

		page.setResult(result);

		page.setCurrPage(pageNum);

		return page;

	}

异常信息


Hibernate: 

    select

        * 

    from

        

    order where

        userid = (

            select

                id 

            from

                user 

            where

                username = 1

        )

2014-3-19 9:30:46 org.apache.catalina.core.StandardWrapperValve invoke

严重: Servlet.service() for servlet [action] in context with path [/Dentist] threw exception [org.hibernate.exception.SQLGrammarException: could not execute query] with root cause

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 'order where userid = (select id from user where username = 1)' at line 1

	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

	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:406)

	at com.mysql.jdbc.Util.getInstance(Util.java:381)

	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)

	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)

	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)

	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)

	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)

	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)

	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)

	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)

	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2228)

	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)

	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)

	at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)

	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:2211)

	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)

	at org.hibernate.loader.Loader.list(Loader.java:2090)

	at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)

	at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)

	at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)

	at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:150)

	at com.dentist.dao.impl.OrderDaoImpl.findBySQL(OrderDaoImpl.java:55)

	at com.dentist.dao.impl.OrderDaoImpl.findOrdersByUser(OrderDaoImpl.java:24)

	at com.dentist.service.impl.OrderServiceImpl.findOrdersByUser(OrderServiceImpl.java:28)

	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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)

	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)

	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)

	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)

	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)

	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)

	at $Proxy10.findOrdersByUser(Unknown Source)

	at com.dentist.action.OrderAction.findByDoctor(OrderAction.java:42)

	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.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)

	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.doPost(ActionServlet.java:432)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

	at com.dentist.filter.LoginFilter.doFilter(LoginFilter.java:48)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:78)

	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)

	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)

	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)

	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)

	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)

	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)

	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

	at java.lang.Thread.run(Thread.java:662)
...全文
81 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
花谢尊前不敢香 2014-03-19
  • 打赏
  • 举报
 回复
首先order是mysql的关键字，加上单引号或者加上数据库名和点 再有就是传参的时候你要传varchar才行，也就是要加上单引号。
比特灵 2014-03-19
  • 打赏
  • 举报
 回复
select * from order a,user b where a.userid =b.userid and b. username ='" + username + "'"
tony4geek 2014-03-19
  • 打赏
  • 举报
 回复
select * from order where userid = ( select id from user where username = ‘1’ ) 如果子查询 id 是个集合怎么办
【SQL刷题】Day2----SQL语法基础查询
MySql的增删改查，刷题篇
求教sql的with as出错的问题
在这里插入图片描述](https://img-blog.csdnimg.cn/2019030610074327.?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzMTExODA4,size_16,color_FFFFFF,t_70) ...
【SQL刷题】DAY19----SQL联结表专项练习
-SQL联结表专项练习
php+mysql数据库语法错误_求教：PHP+MYSQL制作用户登录系统问题，总是提示数据库查询语句语法不对。$sql=mysql_query（。。。）这行...
html页面部分代码如下：html页面部分代码如下：用户名：密 码：php代码如下：session_start(); //初始化SESSION变量$A_name=$_POST[user];//接收表单提交的用户名$A_paw=$_POST[password];//接收表单提交的密码class chkinput{//定义类var $user;var $password;function ...
请教大神！SQL创建表时候，提示不能使用列名！!求解决！
请教大神！SQL创建表时候，提示不能使用列名！!求教！ 在这里插入图片描述 你好！ 这是你第一次使用 Markdown编辑器 所展示的欢迎页。如果你想学习如何使用Markdown编辑器, 可以仔细阅读这篇文章，了解一下Markdown的基本语法知识。 新的改变 我们对Markdown编辑器进行了一些功能拓展与语法支持，除了标准的Markdown编辑器功能，我们增加了如下几点新功能，帮助你用它写博客...
Java EE

67,513

社区成员

225,879

社区内容

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器，保护我们的业务核心组件（中间件），以延续它的生命力，而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章