dell.jsp

留言管理系统 用户网络版块的增加

<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage="" import="java.lang.*"%>
<%@ include file="conn.jsp"%>
<%
 password="admin";//管理员密码
String mm=null;mm=(String)session.getAttribute("pass");
if(password.equals(mm)){


String sql;

int showrow,p,no;
String rw=(String)request.getParameter("showrow");
String pages=(String)request.getParameter("pages");
if(rw==null){showrow=1;}else{showrow=Integer.parseInt(rw);}
if(pages==null){p=1;}else{p=Integer.parseInt(pages);}


for(int i=1;i<=showrow;i++){
no=i+(p-1)*showrow;
String del=request.getParameter("del"+no);
if(del!=null){

sql="delete from scott.lyb where id="+del;
stmt.executeUpdate(sql);
}
}

stmt.close();

response.sendRedirect("index.jsp");
}else{
response.sendRedirect("log.jsp");
}
%>