写了一段sql,但一直报缺失 右括号.请朋友们帮我看看,谢谢了
sql="select q.* from (select rowNum n,t.* from (" +
"select * from book_lend c where " +
" c.bookName like'%"+query+"%' " +
" or c.author like'%"+query+"%' " +
"or c.press like'%"+query+"%' or to_char(c.appearYear,'yyyy-mm-dd') like '%"+query+"%' ) t "
+currentYear+"' order by auto_id ) q "
+"where q.n>" + Snt + " and q.n<=" + Cnt;
sql="select q.* from (select rowNum n,t.* from (" +
"select * from book_lend c where " +
" c.bookName like'%"+query+"%' " +
" or c.author like'%"+query+"%' " +
"or c.press like'%"+query+"%' or to_char(c.appearYear,'yyyy-mm-dd') like '%"+query+"%' ) t "
+currentYear+"' order by auto_id ) q "
+"where q.n>" + Snt + " and q.n<=" + Cnt;
解决方案 »
- getHibernateTemplate.find(hql)
- 在cmd命令行里用什么java命令可以查询java的安装目录
- 怎么让别人通过IP给自己发送数据?(本地IP是随机分配的)
- hibernate懒加载代理问题
- 请求对象与JS脚本
- 请问关于spring roo项目中<form:select的用法
- 请问用struts如何把数据库的信息读出来,并用<table>显示?实在没分了,抱歉
- 有誰能告訴我用struts訪問數據庫是怎么實現的???
- 向数据库里插入一条新数据后,如何获取该数据得id(id字段为auto_increment属性)???
- 从数据库读出的数据输出到控制台乱码
- SSH框架用log4j怎么把数据存入SQL数据库
- 关于64位开发环境
+ "select * from book_lend c where "
+ " c.bookName like '%"+ query + "%'"
+ " or c.author like '%" + query + "%'"
+ " or c.press like '%" + query+ "%'"
+ " or to_char(c.appearYear,'yyyy-mm-dd') like '%" + query+ "%' ) t " + currentYear + "' order by auto_id ) q"
+ " where q.n>" + Snt + " and q.n<=" + Cnt;
select q.* from (select rowNum n,t.* from ( select * from book_lend c where
c.bookName like '% query %' or c.author like'% query %' or c.press like
'%query%' or to_char(c.appearYear,'yyyy-mm-dd') like '%query%' ) t
currentYear' order by auto_id ) q where q.n> Snt and q.n<= Cnt;你替换一下少了什么?明显少了括号