dell.jsp

可以自由留言,采用mysql数据库,jsp编程,界面美观

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" import="java.lang.*"%>
<%
String host="localhost";
String user="root";
String pw="";
String db="numb1";

String pass=null;pass=(String)session.getAttribute("pass");
if("y".equals(pass)){

Class.forName("com.mysql.jdbc.Driver").newInstance();
String url="jdbc:mysql://"+host+"/"+db;
Connection con=DriverManager.getConnection(url,user,pw);
Statement st=con.createStatement();
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 lyb where id="+del;
st.executeUpdate(sql);
}
}

st.close();
con.close();
response.sendRedirect("index.jsp");
}else{
response.sendRedirect("login.jsp");
}
%>