java.sql.SQLException: Result set type is TYPE_FORWARD_ONLY
我已经在数据库连接时设置了
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=java.sql.DriverManager.getConnection("jdbc:odbc:OA","sa","123456789");
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
程序里是这样的:
ResultSet rst=dm.stmt.executeQuery("select * from OA_admin where username='"+username+"' and pwd='"+password+"'");
rst.last();
int rows =rst.getRow();
rst.first();
String str="";
if(rows==1)
{
session.setAttribute("username",username);
session.setAttribute("password",password);
str=response.encodeRedirectURL("main.jsp");
}
但是在执行的时候就出现java.sql.SQLException: Result set type is TYPE_FORWARD_ONLY的错误
大家帮帮忙看看吧~
我才接触JSP10天,好多原理还浑浑噩噩的呢:(