有可能是rs不支持absolute
如果是那样的话,就要用别的方法了
如果是那样的话,就要用别的方法了
解决方案 »
- ResourceBundle能否使用绝对路径?
- 乱码问题
- tomcat下的webapps目录中的文件哪些是可以删除的?
- 出手相救!!!!!!
- struts2一个错误,求高手解决
- 新手跪问:text类型怎么取?
- ~~~~~~~~~~~~~~~~~~关于freemarker的简单问题~~~~~~~~~~~~~~~~~~
- js验证问题请教,不是单纯的验证
- 请教我的主页只想让用IE浏览器的人使用,使用其他浏览器不能显示我的主页
- 有没有用eclipse开发java的兄弟,我想问几个问题
- 调了两天,不知为何出错!!请大虾帮忙!!我做的一个登陆系统,注册与登陆做好了,但是在修改用户信息是出错,不知为何??
- 有用过JRun Studio3.0的高手吗?怎样使它和Tomcat4连结?而不用JRun当Server。
500 Servlet Exception
java.lang.NullPointerException
at _feedback._feedback__jsp._jspService(/feedback/feedback.jsp:287)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:485)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:312)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:221)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163)
at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
at java.lang.Thread.run(Thread.java:479)
--------------------------------------------------------------------------------
Resin 2.1.5 (built Fri Oct 4 12:10:31 PDT 2002) 请问如果不支持哪用什么方法呢。
int PageSize=5;
int ShowPage=1;
int RowCount=0;
int PageCount=0;
Connection con=null;
Statement stmt=null;
ResultSet rs=null;public void jspInit()
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:feedback");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);rs=stmt.executeQuery("SELECT*FROM Feedback");
rs.last();
RowCount=rs.getRow();
PageCount=((RowCount%PageSize)==0?
(RowCount/PageSize):(RowCount/PageSize)+1);
}
catch(Exception ex)
{
System.out.println(ex.toString());
}
}public void jspDestroy()
{
try{
rs.close();
stmt.close();
con.close();
}
catch(Exception ex)
{
System.out.println(ex.toString());
}
}
%>
<%
String ToPage=request.getParameter("ToPage");
if (ToPage!=null)
{
ShowPage=Integer.parseInt(ToPage);
if(ShowPage>PageCount)
{
ShowPage=PageCount;
}
else if(ShowPage<=0)
{
ShowPage=1;
}
}
jspInit();//缺这一句
rs.absolute((ShowPage-1)*PageSize+1);
%>
<%=ShowPage%>
<%=PageCount%>
<%
for(int i = 1; i <= PageSize; i++)
{
%>
hhh
<%
if(!rs.next())
break;
}
jspDestroy();//缺
%>
500 Servlet Exception
java.lang.NullPointerException
at _feedback._feedback__jsp._jspService(/feedback/feedback.jsp:66)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:485)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:312)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:221)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163)
at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
at java.lang.Thread.run(Thread.java:479)
--------------------------------------------------------------------------------
Resin 2.1.5 (built Fri Oct 4 12:10:31 PDT 2002)
我只要将下面的代码删除就没事了。
rs.absolute((ShowPage-1)*PageSize+1);
%>
<%=ShowPage%>
<%=PageCount%>
<%
for(int i = 1; i <= PageSize; i++)
{
%>
hhh
<%
if(!rs.next())
break;
}
jspDestroy();//缺
%>
数据源也是feedback 但改过来就是有误了。<%@ page contentType="text/html; charset=GB2312"
import="java.sql.*"%>
<%!
int PageSize = 2; //设置每张网页显示两笔记录
int ShowPage = 1; //设置欲显示的页数
int RowCount = 0; //ResultSet的记录笔数
int PageCount = 0; //ResultSet分页后的总页数
Connection con = null;
Statement stmt = null;
ResultSet rs = null;public void jspInit() //执行数据库与相关数据的初始化
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:BookDB");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery("SELECT * FROM Book"); rs.last(); //将指标移至最后一笔记录 RowCount = rs.getRow(); //取得ResultSet中记录的笔数
PageCount = ((RowCount % PageSize) == 0 ?
(RowCount/PageSize) : (RowCount/PageSize)+1);
//计算显示的页数
}
catch(Exception ex)
{
System.out.println(ex.toString());
}
}public void jspDestroy() //执行关闭各种对象的操作
{
try{
rs.close(); //关闭ResultSet对象
stmt.close(); //关闭Statement对象
con.close(); //关闭数据库链接对象
}
catch(Exception ex)
{
System.out.println(ex.toString());
}
}
%>
<%
String ToPage = request.getParameter("ToPage");
if(ToPage != null)
{
ShowPage = Integer.parseInt(ToPage); if(ShowPage > PageCount)
{ ShowPage = PageCount;
}
else if(ShowPage <= 0)
{
ShowPage = 1;
}
}
rs.absolute((ShowPage - 1) * PageSize + 1);
%>
{
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433","sa","sa");
DatabaseMetaData conMD = con.getMetaData();
con.setCatalog("库名");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433","sa","sa");
DatabaseMetaData conMD = con.getMetaData();
con.setCatalog("feedback");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery("SELECT * FROM feedback");
rs.last();
RowCount = rs.getRow();
PageCount = ((RowCount % PageSize) == 0 ?
(RowCount/PageSize) : (RowCount/PageSize)+1);
}
catch(Exception ex)
{
System.out.println(ex.toString());
}
}这样有误了
/feedback/feedback.jsp:31: Type expected.
catch(Exception ex)
^
1 error
这是为什么?