<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" import="java.lang.*"%>
<%
String password="arthemis";//管理員密碼
String mm=null;mm=(String)session.getAttribute("pass");
if(password.equals(mm)){

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:numb1","","");
Statement st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
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++){ //該循環(huán)游歷該頁（pages）首頁留言
no=i+(p-1)*showrow;

String del=request.getParameter("del"+no);
if(del!=null){ //判斷該留言是否被選為刪除之列，如果是即執(zhí)行下列刪除語句
sql="delete from lyb where id="+del;
st.executeUpdate(sql);
}
}
st.close();
con.close();
response.sendRedirect("index.jsp");
}else{
response.sendRedirect("log.jsp");
}
%>