2,JSP调用部分(code为小组代码,ruYield为产量)
   <%@ page language="java" import="java.sql.*,java.util.*"%>
<%@ page contentType="text/HTML;charset=GB2312"%>
<jsp:useBean id="dbBean" scope="page" class="test.dbConn"/>

<% request.setCharacterEncoding("GBK");%>

<% 
//--以下是清空表的操作，不必判断
dbBean.executeUpdate("DELETE FROM peasant_info$Temp");
//dbBean.executeUpdate("DELETE FROM delID");

//-----------------------------------------
 Vector v_id=new Vector();//存入被选的ID
//-----------------------------------------
 double cl=0.0,sum=0.0;
 String []tt={"A1","A2","A3","A4","A5","A6","A7","A8","A9","A10","A11","A12","A13","A14","A15","A16","A17","A18","A19","A20","A21","A22","A23"};
 
 aa:for(int k=0;k<=22;k++)
   {
    if(request.getParameter(tt[k]).equals(""))
       continue aa;
 //***************************************
    else
      {
       cl=Double.parseDouble(request.getParameter(tt[k]));
       String sql="SELECT * FROM peasant_info$ WHERE code='"+tt[k]+"'";
       ResultSet rs=dbBean.executeQuery(sql);

       rs.beforeFirst();
      while(rs.next())
         {
            String s=rs.getString("id");
            sum +=rs.getInt("ruYield");
            if(sum >(cl+0))
                break;//此处要减去的值可用表中的最小值
            v_id.add(s);//保存现在提取的id
         }
       }
     }
//----------------------------------------
String []s=new String[v_id.size()];
v_id.copyInto(s);
for(int i=0;i<=s.length-1;i++)
  {
   String sql="INSERT INTO peasant_info$Temp SELECT * FROM peasant_info$ WHERE id="+s[i];
   dbBean.executeUpdate(sql);  
  }
dbBean.clean();
response.sendRedirect("pageView.jsp");//处理完后返回到显示页面。
%>
3,返回页面部分(pageView.jsp)在从临时表(peasant_info$Temp )中读取(可完成).
 在运行时也能运行,可结果老有问题,不知如何是好?望各位高手赐招,帮帮我,有什么好办法!谢谢!!!!!!!!!!!