解决方案 »
- 求助 在el表达式里读取一组 checkbox ???
- Spring + hibernate 问题
- struts标签<html:text>没有ID和NAME属性,如何定位到这个控件?
- JAVA 图片二进流转成PDF文件
- 关于Tomcat5.0的问题,希望高手能给解答!
- 请问如何写socket客户端程序来实现文件的上传
- JBoss问题
- 各位大侠,求助struts的问题,费解中
- struts为什么不推荐使用GenericDataSource?高分酬谢
- PetStore1.3.1.01的安装问题
- 一个javaee项目里异常一般怎么处理呢
- 开发购买笔记本,个人四分之一,有工作年限合同,否则按比例补上,想买款合适的,请各位懂行的推荐,谢谢
id as id,
appserialnumber as appserialnumber,
who as who,
createtime as createtime,
operatedtype as operatedtype,
operate as operate,
operatedobject as operatedobject,
description as description,
result as result,
ROWNUM AS row_num
FROM server_log and ROWNUM < (#{startRecord}+#{total}))
你试试sum(#{startRecord},#{total})测试下
或者把这句干掉试试
最好的是这个加法算法不要在xml里面做 , 后台加好再传进来
这句是不是有问题? 少where?
id as id,
appserialnumber as appserialnumber,
who as who,
createtime as createtime,
operatedtype as operatedtype,
operate as operate,
operatedobject as operatedobject,
description as description,
result as result,
ROWNUM AS row_num
FROM server_log where ROWNUM < (#{startRecord}+#{total}))
照着你说的改了,但是还是报缺失右括号!
控制台输出:10:26:42,536 DEBUG Connection:27 - ooo Connection Opened
10:26:42,853 DEBUG PreparedStatement:27 - ==> Executing: select count(*) from server_log
10:26:42,853 DEBUG PreparedStatement:27 - ==> Executing: select count(*) from server_log
10:26:42,854 DEBUG PreparedStatement:27 - ==> Parameters:
10:26:42,854 DEBUG PreparedStatement:27 - ==> Parameters:
10:26:43,050 DEBUG Connection:27 - ooo Connection Opened
10:26:43,060 DEBUG PreparedStatement:27 - ==> Executing: SELECT * FROM (SELECT id as id, appserialnumber as appserialnumber, who as who, createtime as createtime, operatedtype as operatedtype, operate as operate, operatedobject as operatedobject, description as description, result as result, ROWNUM AS row_num FROM server_log and ROWNUM < (?+?)) t_temp WHERE t_temp.row_num >= ?
10:26:43,060 DEBUG PreparedStatement:27 - ==> Executing: SELECT * FROM (SELECT id as id, appserialnumber as appserialnumber, who as who, createtime as createtime, operatedtype as operatedtype, operate as operate, operatedobject as operatedobject, description as description, result as result, ROWNUM AS row_num FROM server_log and ROWNUM < (?+?)) t_temp WHERE t_temp.row_num >= ?
10:26:43,061 DEBUG PreparedStatement:27 - ==> Parameters: 0(Integer), 10(Integer), 0(Integer)
10:26:43,061 DEBUG PreparedStatement:27 - ==> Parameters: 0(Integer), 10(Integer), 0(Integer)
2014-8-1 10:26:43 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet SearchServlet threw exception
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.sql.SQLException: ORA-00907: 缺失右括号
正解!!!!恩,就是这样,改为where就正确了!!谢谢!!
恩,原来你在下面又重新回复了一次,添加where就对了!!谢谢!