直接用form 表单
servlet或者下一个Jsp
for(int i=0;i
response.getWriter().print(userIds2[i]+"---------------") ;
}
%>
这样就可以把选中的全部带过来了
2.用js链接实现
function rowsDelete(){
var userIds =document.getElementsByName("userIds");
//alert(userIds.length);
var struids="";
for(var i=0;i
if(userIds[i].checked==true){
struids=struids+userIds[i].value+","
//alert(struids);
}
}
var a = document.getElementById("dela");
a.href = "deleteUserRows.jsp?struids="+struids;
}
下一个页面接收一个串串
String userIds=request.getParameter("struids");
再来分解
下面如图
在最后把我的list页面的整版内容贴出来供大家参考:
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
My JSP 'login.jsp' starting pagefunction rowsDelete(){
var userIds =document.getElementsByName("userIds");
//alert(userIds.length);
var struids="";
for(var i=0;i
if(userIds[i].checked==true){
struids=struids+userIds[i].value+","
//alert(struids);
}
}
var a = document.getElementById("dela");
a.href = "deleteUserRows.jsp?struids="+struids;
}
批量删除
String url="jdbc:sqlserver://localhost:1433;DataBaseName=testDB";
String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String username1="sa";
String password1="123456";
//连接数据库
Class.forName(driver);
Connection con =DriverManager.getConnection(url,username1,password1);
String sql = "select * from user_info";
PreparedStatement pst =con.prepareStatement(sql);
ResultSet rst =pst.executeQuery();
ArrayList userList = new ArrayList();
while(rst.next()){
UserInfo ui = new UserInfo();
ui.setUserID(rst.getString(1));
ui.setUsername(rst.getString(2));
ui.setPassword(rst.getString(3));
ui.setAddress(rst.getString(4));
ui.setPhoto(rst.getString(5));
ui.setQQ(rst.getString(6));
ui.setSex(rst.getString(7));
ui.setRules(rst.getString(8));
userList.add(ui);
}
%>
for(int i=0;i
UserInfo userI=(UserInfo)userList.get(i);
%>
dfdfdfdf管理员列表df
![9e73c072d670fdcb3c986de0660c2aae.png](https://i-blog.csdnimg.cn/blog_migrate/75ba4b0d51de24b7117a8dc8c1768026.png)
![e652e2faa3da0f824b2377a0fb6244da.png](https://i-blog.csdnimg.cn/blog_migrate/5ea312907daeffad1518a96aafdc6264.jpeg)
![9e73c072d670fdcb3c986de0660c2aae.png](https://i-blog.csdnimg.cn/blog_migrate/75ba4b0d51de24b7117a8dc8c1768026.png)
扫码关注我们
微信号 : gongth830