delall_choose_forebin.jsp

来自「采用j2ee架构做的bbs」· JSP 代码 · 共 43 行

<%@page pageEncoding="gb2312"%>
<%@page contentType="text/html;charset=gb2312" %>
<%@include file="conn.jsp" %>
<%
request.setCharacterEncoding("gb2312");
String ids="";
String[] msg_id=request.getParameterValues("checkbox");

for(int i=0;i<msg_id.length;i++){
ids= "'"+msg_id[i]+"'";
	System.out.print(ids+"===");
	
		String sql1="select * from icefish_msg where msg_id in("+ids+")";
	Statement stmt1=conn.createStatement();
	ResultSet rs1=stmt1.executeQuery(sql1);
	
		while(rs1.next()){
	int msgdel=rs1.getInt("msg_del");
	System.out.print(msgdel+"===");
	
	
	if(msgdel==0){
	String sql2="update icefish_msg set msg_del='1',msg_del_forebin='0' where msg_id in("+ids+")";
    Statement stmt2=conn.createStatement();
    stmt2.executeUpdate(sql2);
        stmt2.close();
		
     }
	 else
	 {
	 
	String sql3="delete from icefish_msg where msg_id in("+ids+")";
	Statement stmt3=conn.createStatement();
    stmt3.executeUpdate(sql3);
	    stmt3.close();
			}
  
   }
		rs1.close();
			stmt1.close();}
			conn.close();
	out.println("<script language=javascript> alert('       删除成功!'); location.href='message.jsp';</script>");
%>