写了一段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;
+ "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;你替换一下少了什么?明显少了括号