实在不知道哪里出现了问题Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY.

Question

这是源代码：

package handle.data;
import save.data.Record_Bean;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.sql.DataSource;
import javax.naming.Context;
import javax.naming.InitialContext;
public class SearchByCondition extends HttpServlet{
   public void init(ServletConfig config) throws ServletException{
      super.init(config);
   }
   public void service(HttpServletRequest request,
               HttpServletResponse response) throws ServletException,IOException{
      request.setCharacterEncoding("utf-8");
      HttpSession session=request.getSession(true); 
      String searchMess= request.getParameter("searchMess");
      String radioMess= request.getParameter("radio");
      if(searchMess==null||searchMess.length()==0) {
         response.getWriter().print("没有查询信息，无法查询");
         return;
      }
      Connection con=null; 
      String queryCondition="";
      float max=0,min=0;
      if(radioMess.contains("shoes_version")){
        queryCondition =
        "SELECT shoes_version,shoes_name,shoes_made,shoes_price "+
        "FROM shoesForm where shoes_version='"+searchMess+"'";  
      }
      else if(radioMess.contains("shoes_name")) {
         queryCondition =
        "SELECT shoes_version,shoes_name,shoes_made,shoes_price "+
        "FROM shoesForm where shoes_name like '%"+searchMess+"%'";
      }
      else if(radioMess.contains("shoes_price")) {
         String priceMess[] = searchMess.split("[-]+");
         try{
           min = Float.parseFloat(priceMess[0]);
           max = Float.parseFloat(priceMess[1]);
         }
         catch(NumberFormatException exp){
            min = 0;
            max = 0;
         }
         queryCondition =
        "SELECT shoes_version,shoes_name,shoes_made,shoes_price "+
        "FROM shoesForm where shoes_price<="+max+" and shoes_price>="+min;  
      }
      Record_Bean dataBean=null;
      try{ 
         dataBean=(Record_Bean)session.getAttribute("dataBean");
         if(dataBean==null){
            dataBean=new Record_Bean();  //创建bean。
            session.setAttribute("dataBean",dataBean);//是session bean。
         }
      }
      catch(Exception exp){} 
      try{ 
          Context  context = new InitialContext();
          Context  contextNeeded=(Context)context.lookup("java:comp/env");
          DataSource ds=
          (DataSource)contextNeeded.lookup("shoesConn");//获得连接池。
           con= ds.getConnection();//使用连接池中的连接。
         Statement sql=con.createStatement();
          ResultSet rs=sql.executeQuery(queryCondition);
          ResultSetMetaData metaData = rs.getMetaData();
          int columnCount = metaData.getColumnCount(); //得到结果集的列数。
          rs.last();
          int rows=rs.getRow();  //得到记录数。
          String [][] tableRecord=dataBean.getTableRecord();
          tableRecord = new String[rows][columnCount];
          rs.beforeFirst();
          int i=0;
          while(rs.next()){
            for(int k=0;k<columnCount;k++) 
              tableRecord[i][k] = rs.getString(k+1);
              i++; 
          }
          dataBean.setTableRecord(tableRecord); //更新bean。
          con.close(); //连接返回连接池。
          response.sendRedirect("byPageShow.jsp"); //重定向。
     }
     catch(Exception e){
         response.getWriter().print(""+e);
     } 
     finally{
        try{
          con.close();
        }
        catch(Exception ee){}
     } 
   }
}  

Answer 1

Operation not allowed for a result set of type ResultSet.TYPE_FORWORWARD_ONLY._wwr12138333的博客-CSDN博客 5月14日前几天学了用jsp完成分页操作.老是报一个错误代码看了自己的和别人的也上网查了，始终不知道哪错了。今天问了老师，老师说是我的Mysql配置的有问题导致游标不能按要求动。PreparedStatement pst = conn.prepareStatement("select * from wwrnews1");主要是这里的问题改成PreparedStatement pst = conn.prepareStatement("select * from wwrnews1",Result https://blog.csdn.net/wwr12138333/article/details/116805247

加上第二个参数。