del_choose_msgbin.jsp

采用j2ee架构做的bbs

<%@page pageEncoding="gb2312"%>
<%@page contentType="text/html;charset=gb2312" %>
<%@include file="conn.jsp" %>
<%
	request.setCharacterEncoding("gb2312");
	String msg_id=request.getParameter("msg_id");
	
	String sql1="select * from icefish_msg where msg_id="+msg_id;
	Statement stmt1=conn.createStatement();
	ResultSet rs1=stmt1.executeQuery(sql1);

		while(rs1.next()){
	int msgdel=rs1.getInt("msg_del");

    if(msgdel==0){
	String sql2="update icefish_msg set msg_del='1',msg_del_msgbin='0' where msg_id="+msg_id;
    Statement stmt2=conn.createStatement();
    stmt2.executeUpdate(sql2);
        stmt2.close();
		
     }
	 else
	 {
	 
	String sql3="delete from icefish_msg where msg_id="+msg_id;
	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>");
	%>