结果集的问题

try:<%
String[] aId = String[]{"aId1","aId2","aId3","aId4","aId5"} ; //这里是你的记录集中的数据。
%>
<form name=f method=post action=test.jsp>
<%for (int i=0;i<aId.length;i++){%>
<input type=checkbox checked name=aid value=<%aId[i]%>>
<%}%>
<input type=submit name=b value=submit>
</form>在test.jsp中
<%
String[] aId = request.getParameterValues("aid") ;
if (aId!=null){
for(int i =0;i<aId.length;i++)
out.print(aId[i]+"<br>") ;
}
%>

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

try:<%
String[] aId = String[]{"aId1","aId2","aId3","aId4","aId5"} ; //这里是你的记录集中的数据。
%>
<form name=f method=post action=test.jsp>
<%for (int i=0;i<aId.length;i++){%>
<input type=checkbox checked name=aid value=<%aId[i]%>>
<%}%>
<input type=submit name=b value=submit>
</form>在test.jsp中
<%
String[] aId = request.getParameterValues("aid") ;
if (aId!=null){
for(int i =0;i<aId.length;i++)
out.print(aId[i]+"<br>") ;
}
%>
sorry:<input type=checkbox checked name=aid value=<%=aId[i]%>>
显示页：
<input type=checkbox name="chk" value="<%=rs.getInt("id")%>">
处理页：
<%
String[] chk = request.getParameterValues("chk");
if (chk==null){
    //没选
}else{
    //构造sql语句如： ids = "0,2,5,9"：
    String ids = chk[0];
    for (int i=1;i<chk.length;i++){
        ids += ","+chk[i] ;
    }
    String sql = "delete from tblName where id in("+ids+")";
}
%>
try:ResultSet rs = stmt.createStatement(sYourSql) ;
java.util.Vector vId = new java.util.Vector() ;
String[] aId = null ;
while(rs.next()){
vId.add(rs.getString("id")) ;
}aId = new String[vId.size()] ;
vId.copyInto(aId) ;希望你能明白!
产生复选框的页面<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import='java.sql.*,com.zsoft.sqlserver.*'%>
<%@ include file="..\connection\user_check.jsf" %><html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head><body bgcolor="#CCCCCC" text="#000000">
<% //Á¬½Ó¹¦ÄÜ±ífunction Ñ¡³ö¹¦ÄÜÁÐ±í


  Connection conn = MyDB.getConnection();
  String[][] data1 = MyDB.fetchStrData(conn,"select count(*) from functions");
  int count = Integer.parseInt(data1[0][0] ) ;  String partner_no=(String)session.getAttribute("THE_PARTNERNO");
  String partner_no_data[][]=MyDB.fetchStrData(conn,"select PARTER_type from partner where partner_no="+partner_no);  String data[][] = MyDB.fetchStrData(conn,"select funcNo,sname_c,lname_c,funcArea from functions where funcArea='"+ partner_no_data[0][0] + "' order by funcNo");
String checkboxnumber=String.valueOf((data == null) ? 0 : data.length) ;%>
<br>
<form name="form1" method="post" action="rights_insert_s.jsp?checkboxname=<%=checkboxnumber%>" target=commfrm>
  <%//Á¬½Ó¹«Ë¾Ãûoperator£¬ÁÐ³öÓÃ»§Ãû
  Connection connoperator = MyDB.getConnection();
  String[][] dataoperator2 = MyDB.fetchStrData(connoperator,"select count(*) from users");
  int count2 = Integer.parseInt(dataoperator2[0][0] ) ;  String[][] dataoperator=MyDB.fetchStrData(connoperator,"select userNo,partner_no,loginName,lname_c,lname_e from users where partner_no="+partner_no+" and loginName<>'guest'");
%>
  <br>
  <a href="rights_vend.jsp">Ö÷Ò³Ãæ</a>>>Ìí¼ÓÓÃ»§¹¦ÄÜÐÅÏ¢<br>
  <table width="75%" border="1">
    <tr bgcolor="#006666">
      <td width="41%"><font color="#FFFFFF">ÓÃ»§Ãû</font></td>
      <td width="59%">
        <select name="select">
          <%
     int rows2 = (dataoperator == null) ? 0 : dataoperator.length ;
     for ( int i = 0 ; i < rows2 ; i ++ )
       {
       %>
          <option value="<%=dataoperator[i][0]%>"><%=dataoperator[i][2]%> <%=dataoperator[i][3]%></option>
          <%
        }
      %>
    <option value="guest">guest</option>
        </select>
      </td>
    </tr>
    <tr>
      <td colspan="2" bgcolor="#FFFFFF">¹¦ÄÜÈ¨ÏÞÁÐ±í<br>
      </td>
    </tr>
    <tr>
      <td colspan="2">
        <table width="100%" border="1" cellspacing="0" cellpadding="0">
          <%
       int rows = (data == null) ? 0 : data.length ;
   for ( int i = 0 ; i < rows ; i ++ )
      {
      %>
          <tr>
            <td width="41%">
              <input type="checkbox" name="checkbox<%=i%>" value="">
              <%=data[i++][1]%> </td>
            <td width="59%">
              <input type="checkbox" name="checkbox<%=i%>" value="">
              <%=i<rows?data[i][1]:""%></td>
          </tr>
          <%
         }
      %>
        </table>
      </td>
    </tr>
  </table>
  <input type="submit" name="Submit" value="È·¶¨">
  <input type="reset" name="Submit2" value="È¡Ïû">
</form>
</body>
<iframe name=commfrm width=0 height=400></iframe>
</html>
处理页面
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import='java.sql.*,com.zsoft.sqlserver.*'%>
<%@page import="java.util.*" %>
<%int function[]=new int[300];%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head><body bgcolor="#FFFFFF" text="#000000">
<%
  Connection conn = MyDB.getConnection();
  String partner_no=(String)session.getAttribute("THE_PARTNERNO");
  String partner_no_data[][]=MyDB.fetchStrData(conn,"select PARTER_type from partner where partner_no="+partner_no);
  String data[][] = MyDB.fetchStrData(conn,"select * from functions where funcArea='"+partner_no_data[0][0]+"' order by funcNo"); %>
<%
  //String partnerNo=request.getParameter("select2");
  String userNo=request.getParameter("select");
//String checkboxnumber=request.getParameter("checkboxname");

  int checkboxnumber=Integer.parseInt((String)request.getParameter("checkboxname"));//×÷ÎªÑ»·µÄ´ÎÊý  for(int i=0;i<checkboxnumber;++i)
  {
    if(request.getParameter("checkbox"+String.valueOf(i))!=null)
          function[i]=Integer.parseInt(data[i][0]);
     else
  function[i]=0;
//temp+=request.getParameter("checkbox"+String.valueOf(i))+"<br>";
  }  Connection conn1 = MyDB.getConnection();
  for(int i=0;i<checkboxnumber;++i)
  {
      if(function[i]!=0)
  {
  Connection connr=MyDB.getConnection();
           if(userNo.equals("guest"))//Ð´ÈëÓÃ»§ºÅÎª1£¬´ú±íguest
           {
              String insertString="insert into rights(funcNo,userNo) values("+function[i]+",1)";
          out.println(insertString+"<br>");
              int data1 = MyDB.transProcess(conn1,insertString);
  continue;
           }

   String[][] DataRepeat=MyDB.fetchStrData(connr,"select funcNo,userNo from rights where funcNo="+function[i]+" and userNo="+userNo);
   if(DataRepeat==null)
      {
      String insertString="insert into rights(funcNo,userNo) values("+function[i]+","+userNo+")";
          out.println(insertString+"<br>");
              int data1 = MyDB.transProcess(conn1,insertString);
        }
   else
      {
  out.println("<script>alert(\"¸Ã¼ÍÂ¼ÒÑ¾´æÔÚ£¬ÇëÖØÐÂÊäÈë\");</script>");
  return;
      }

  }
    }
     out.println("<script>alert(\"Ìí¼ÓÐÅÏ¢³É¹¦\");</script>");

%>
</body>
</html>