我要疯了，还是复选框的问题 最后一次在发复选框的帖子 谢谢大家
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN "
"http://www.w3.org/TR/html4/loose.dtd ">
<html>
<head>
<%@ page language= "java " contentType= "text/html; charset=UTF-8 " pageEncoding= "UTF-8 "%>
<%@page import= "com.gsi.role.db.ConnDB2Imp " %>
<%@page import= "com.gsi.role.util.HandlePage " %>
<%@page import= "java.sql.ResultSet " %>
<%@page import= "com.gsi.role.po.Sys_Roles " %>
<META http-equiv= "Content-Type " content= "text/html; charset=UTF-8 ">
<META name= "GENERATOR " content= "IBM Software Development Platform ">
<META http-equiv= "Content-Style-Type " content= "text/css ">
<TITLE> OA系统 </TITLE>
</head>
<%
ConnDB2Imp conndb = new ConnDB2Imp();
HandlePage handlePage = new HandlePage();
String UsrName=request.getParameter( "Name ");
String UsrID=request.getParameter( "ID ");
Sys_Roles te= new Sys_Roles();
int size = 12;
int pageCount = 0;
String sql= "select * From sys_roles ";
ResultSet rs = conndb.returnSelectRs(sql);
rs.last();
int recordCount = rs.getRow();
handlePage.calcuePage(recordCount,size);
pageCount = handlePage.getPageCount();
rs.beforeFirst();
%>
<style type= "text/css ">
<!--
body,td,th {
font-size: 12px;
font-family: 宋体;
}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
color: #999999;
}
a:active {
text-decoration: none;
}
-->
</style>
<style type= "text/css ">
<!--
table.a tr {background-color:expression((this.sectionRowIndex%2==0)? "#D9FFFF ": "#FDFFFF ")}
body {
margin-left: 6px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
.style44 {
font-weight: bold;
color: #0000CC;
font-size: 16px;
font-family: "宋体 ";
}
-->
</style>
<body>
<table width= "741 " border= "0 " cellspacing= "0 " cellpadding= "0 ">
<tr>
<td height= "38 " >
<table width= "709 " border= "0 " cellspacing= "0 " cellpadding= "0 ">
<tr>
<td width= "198 "> <a href= "# "> <font color= "#0000FF "> 当前为 <%=UsrID%> 用户分配角色 </font> </a> </td>
</tr>
</table> </td>
</tr>
<form name= "form " method= "post " action= "RoleFPJg.jsp?&ID= <%=UsrID%> ">
<tr>
<td width= "741 " bgcolor= "#CCCCCC "> <table width= "741 " border= "0 " align= "left " cellpadding= "0 " cellspacing= "1 ">
<tr bgcolor= "C8E2FB ">
<td width= "80 " bgcolor= "#F2F4F6 "> <div align= "center ">
</div> </td>
<td width= "146 " height= "29 " bgcolor= "#F2F4F6 "> <div align= "center "> 角色编号 </div> </td>
<td width= "234 " bgcolor= "#F2F4F6 "> <div align= "center "> 角色名称 </div> </td>
<td width= "276 " bgcolor= "#F2F4F6 " > <div align= "center "> 说明 </div> </td>
</tr>
<%
int gopage = 0;
String temp=request.getParameter( "gogo ");
if(temp==null||temp.trim().equals( " ")){
gopage=1;
}else{
gopage=Integer.parseInt(temp);
if(gopage < 1) {
gopage = 1;
}
if (gopage > pageCount) {
gopage = pageCount;
}
}
for(int k=0;k <(gopage-1)*size;k++)
rs.next();
int i=0;
while(rs.next()){
i++;
if(i> size)break;
%>
<tr align= "center " bgcolor= "#FFFFFF " onMouseOver= "this.style.background= '#ECFFFF ' " onMouseOut= "this.style.background= '#FFFFFF ' ">
<td > <div align= "center ">
<input type= "checkbox " name= "C_fRoles_ID " value= <%= rs.getString( "C_Roles_ID ")%> >
</div> </td>
<td height= "24 " > <div align= "center "> <%=rs.getString( "C_Roles_ID ")%> </div> </td>
<td > <div align= "center "> <%=rs.getString( "C_Roles_Name ")%> </td>
<td > <div align= "center "> <%=rs.getString( "C_Comment ")%> </div> </td>
</tr>
<% }
if(rs!=null) {
rs.close();
}
conndb.closeRs();
conndb.closeStmt();
conndb.closeConn();
%>
</table> </td> </tr>
<tr>
<td height= "38 " >
<table width= "709 " border= "0 " cellspacing= "0 " cellpadding= "0 ">
<tr>
<td width= "511 "> <input type= "submit " name= "Submit32 " value= "保 存 "> </td>
</tr>
</table> </td>
</tr>
<tr>
<td height= "34 " bgcolor= "#CCE0F5 "> <table width= "740 " border= "0 " cellspacing= "0 " cellpadding= "0 ">
<tr> <TD width= "8 " height=23 bgcolor= "f5f5f5 "> </TD>
<TD class=forum_oran align= "center " width= "70 " bgcolor= "f5f5f5 "> <a
href= "RoleFP1.jsp?gogo(1)&Name= <%= UsrName %> &ID= <%= UsrID %> "> 首页 </a> </TD>
<TD class=forum_oran align= "center " width= "81 " bgcolor= "f5f5f5 "> <a
href= "RoleFP1.jsp?gogo= <%= gopage-1 %> &Name= <%= UsrName %> &ID= <%= UsrID %> "> 上一页 </a> </TD>
<TD class=forum_oran align= "center " width= "72 " bgcolor= "f5f5f5 "> <a
href= "RoleFP1.jsp?gogo= <%= gopage+1 %> &Name= <%= UsrName %> &ID= <%= UsrID %> "> 下一页 </a> </TD>
<TD class=forum_oran align= "center " width= "83 " bgcolor= "f5f5f5 "> <a
href= "RoleFP1.jsp?gogo= <%=pageCount%> &Name= <%= UsrName %> &ID= <%= UsrID %> "> 尾页 </a> </TD>
<TD vAlign=top width= "160 " bgcolor= "f5f5f5 ">
<form name= "form1 " method= "post " action= "RoleFP1.jsp&Name= <%= UsrName %> &ID= <%= UsrID %> ">
跳到第 <select name= "gogo " OnChange= "document.forms[0].submit() ">
<script language= "JavaScript ">
for(i=1; i <= <%=pageCount%> ; i++)
document.write( " <option value= "+i+ "> "+i+ " </option> ")
document.forms[0].gogo.options[ <%= gopage-1 %> ].selected = true;
</script>
</select> 页 </form> </TD>
<td width= "9 " bgcolor= "f5f5f5 "> </td>
<TD width= "188 " bgcolor= "f5f5f5 "> 共 <%= pageCount %> 页,当前为第 <%= gopage %> 页 </TD>
<TD width= "59 " bgcolor= "f5f5f5 "> </TD>
</tr>
</table> </td>
</tr>
</table>
</body>
</html>
这个页面是选择复选框的JSP页面，然后他提交给下面的JSP
<%
String C_Roles_ID[] =request.getParameterValues( "C_fRoles_ID ");
//String cc=request.getParameter( "C_fRoles_ID ");
String id=request.getParameter( "ID ");
String userIdAll = " ";
String deleteResult = " ";
SJUsr sr = new SJUsr();
if(C_Roles_ID!=null)
{
for(int i=0;i <C_Roles_ID.length;i++)
{ userIdAll=userIdAll + C_Roles_ID[i] + ", "; }
userIdAll = userIdAll.substring(0, userIdAll.length()-1);
deleteResult = sr.insertRU(userIdAll,id);
}
%>
[解决办法]
insertRU（）方法放到for里
[解决办法]
for(int i=0;i <C_Roles_ID.length;i++)
{ userIdAll=userIdAll + C_Roles_ID[i] + ", "; }
userIdAll = userIdAll.substring(0, userIdAll.length()-1);
deleteResult = sr.insertRU(userIdAll,id);
改为
for(int i=0;i <C_Roles_ID.length;i++)
{ userIdAll=userIdAll + C_Roles_ID[i] + ", ";
userIdAll = userIdAll.substring(0, userIdAll.length()-1);
deleteResult = sr.insertRU(userIdAll,id);
}
