求助!!请高手指点!(有时提示“无效的游标错误!”)
/*
*下边是jsp页面文件
*/
<%@ page contentType= "text/html; charset=gb2312 " language= "java " import= "java.sql.*,bean.DBClass "
errorPage= " " %>
<table width= "75% " align= "right " border= "0 ">
<%
String query= "SELECT * FORM message ";
String userId= " ";
String message= " ";
String date= " ";
DBClass db=new DBClass();
db.connect();
ResultSet rt=db.executeQuery(query);
while(rt.next()){
userId=rt.getString( "userId ");
message=rt.getString( "message ");
date=rt.getString( "date ");
%>
<tr> <td>
留言者: <%=userId %> <%=date %> </td> </tr>
<tr> <%=message %> </tr>
<%
}
db.closeConnection();
%>
<tr> <td>
<form name= "form3 " method= "post " action= "/MsgBoard/UserComment ">
<div align= "center "> 我要发言:(不超过50字) <font color= "#FF0000 " size= "-1 "> <% if (request.getAttribute( "errInf2 ")!=null){ %>
<%=(String)request.getAttribute( "errInf2 ") %> <% } %> </font>
<p align= "center ">
<textarea name= "comment " cols= "30 " rows= "9 " > </textarea> </p>
<p align= "center ">
<input name= "submit " type= "submit " value= "发布 "/>
<input name= "reset " type= "reset " value= "重写 "/> </p>
</div>
</form> </td> </tr>
</table>
/* DBClass 原代码,编译过 没有错误
* Designed by *****
*/
package bean;
import java.io.*;
import java.util.*;
import java.sql.*;
public class DBClass
{
private String driver;
private String url;
private String username;
private String password;
private Connection connection;
private Statement statement;
private String message= " ";
public DBClass(){
driver= "sun.jdbc.odbc.JdbcOdbcDriver ";
url= "jdbc:odbc:msgboard ";
username= " ";
password= " ";
connection=null;
statement=null;
message= " ";
}
public DBClass(String driver,String url,String username,String password){
this.driver=driver;
this.url=url;
this.username=username;
this.password=password;