数据库连接是这样写的:
synchronized(con){
try{
sql=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("SELECT * FROM mytable");
rs.last();
lastrow=rs.getRow();
pagecount=(lastrow%pagesize==0)?(lastrow/pagesize):(lastrow/pagesize)+1;
showpage=1;
}catch(SQLException e){
}
}
我跟了一下:程序是在这边出错的
int posion=(showpage-1)*pagesize+1;
posion = 1;
rs.absolute(posion); //?????下面是异常:
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause java.lang.NullPointerException
org.apache.jsp.Example5_005f2_jsp._jspService(Example5_005f2_jsp.java:155)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
synchronized(con){
try{
sql=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("SELECT * FROM mytable");
rs.last();
lastrow=rs.getRow();
pagecount=(lastrow%pagesize==0)?(lastrow/pagesize):(lastrow/pagesize)+1;
showpage=1;
}catch(SQLException e){
}
}
我跟了一下:程序是在这边出错的
int posion=(showpage-1)*pagesize+1;
posion = 1;
rs.absolute(posion); //?????下面是异常:
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause java.lang.NullPointerException
org.apache.jsp.Example5_005f2_jsp._jspService(Example5_005f2_jsp.java:155)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
解决方案 »
- 再次求助,将编写好的java程序放置在web中如何实现……
- java.lang.IllegalStateException: Session invalidation is in progress with differ
- web页面,多窗口同时进行 服务器对比 问题
- JSP打印问题
- 为什么我的JSP请求一进入ActionServlet就不动了?而且还显示ActionServlet无法解析类
- 关于STRUTS的DISPACHACTION的一个疑问
- 请热心人不吝赐教,如何在发送http请求之前,定制头部。
- spring mvc如果插件化问题
- 关于ssh框架搭建。tomcat启动报错的问题
- 购物车功能如何实现根据当前登录用户来查找购物车
- 寻求帮助~!excel问题
- 求url问题
103: int posion=(showpage-1)*pagesize+1;
104: posion = 1;
105: rs.absolute(posion);
106: //for(int ii=0;ii<pagesize;ii++)
107: //{
108: // out.print("<TR>");我封掉了显示部分,现在提示是absolute这个有问题,我都是硬赋值的
resultset是依赖于connection和statement的,如果这两个中有一个关闭了,rs就无效了,如果放在session中,就意味着数据库连接不能关闭,这肯定是不行的.session中的数据会常驻系统内存,用户越多,系统开销越大。