初学者提问
zwliu 2004-09-14 03:01:51 <%!
int pagesize=16;
int ShowPage=4;
int rowcount=0;
int pagecount=0;
Connection con=null;
java.sql.Statement stmt=null;
ResultSet rs=null;
public void jspInit(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:userctms","","");
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
}
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 getowner=request.getParameter("owner");
String getguest=request.getParameter("guestcode");
String getcont=request.getParameter("contno");
rs=stmt.executeQuery("select containerno,isocode,guestcode,containerowner,intime from containeronyard where containerowner='"+getowner+"'");
rs.last();
rowcount=rs.getRow();
pagecount=((rowcount%pagesize)==0?
(rowcount/pagesize):(rowcount/pagesize)+1);
%>
<CENTER>
<%
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);
%>
<H3>目前在第<FONT SIZE=4 COLOR=red>
<%=ShowPage%></FONT>页,共有
<FONT SIZE=4 COLOR=red>
<%=pagecount%></FONT>页</H3>
<TABLE bgcolor=LightBlue>
<TR bgcolor=SkyBlue>
<TD><FONT SIZE=2><B>箱号</b></FONT></TD>
<TD><FONT SIZE=2><B>ISO代码</b></FONT></TD>
<TD><FONT SIZE=2><B>船公司</b></FONT></TD>
<TD><FONT SIZE=2><B>箱主</b></FONT></TD>
<TD><FONT SIZE=2><B>进场时间</B></FONT></TD></TR>
<%
for(int i=1;i<=pagesize;i++)
{
%>
<TR bgcolor=SkyBlue>
<TD><FONT SIZE=2><B><%=rs.getString(1)%></B></FONT></TD>
<TD><FONT SIZE=2><B><%=rs.getString(2)%></B></FONT></TD>
<TD><FONT SIZE=2><B><%=rs.getString(3)%></B></FONT></TD>
<TD><FONT SIZE=2><B><%=rs.getString(4)%></B></FONT></TD>
<TD><FONT SIZE=2><B><%=rs.getString(5)%></B></FONT></TD>
</TR>
<%
if(!rs.next())
break;
}
%>
</TABLE>
<TABLE>
<TR valign=baseline align=center>
<%
if(ShowPage!=1)
{
%>
<TD width=150>
<A Href=Mypage.jsp?ToPage=<%=1%>>ToFirst</A>
</TD>
<TD width=150>
<A Href=Mypage.jsp?ToPage=<%=ShowPage-1%>>ToPrior</A>
</TD>
<%
}
if(ShowPage!=pagecount)
{
%>
<TD width=150>
<A Href=Mypage.jsp?ToPage=<%=ShowPage+1%>>ToNext</A>
</TD>
<TD width=150>
<A Href=Mypage.jsp?ToPage=<%=pagecount%>>ToLast</A>
</TD>
<%
}
%>
<TD Width=1>
<FORM action=Mypage.jsp method=post>
To<INPUT type="text" name=ToPage style="HEIGHT:25px;WIDTH:40px" value=<%=ShowPage%>>Page
</FORM>
</TD></TR>
</TABLE>
</CENTER>
</BODY>
</HTML>
运行后,显示错误:
Error: 500
Location: /myjsp/Mypage.jsp
Internal Servlet Error:
javax.servlet.ServletException: [Microsoft][ODBC 驱动程序 管理器] 无效的光标状态
怎么解决啊?