drop.jsp

一个用JSP+ACCESS做的留言板页面,简单实用

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
String password="arthemis";//管理员密码
String mm=null;mm=(String)session.getAttribute("pass");
if(password.equals(mm)){
String id=request.getParameter("id");
if(id==null){out.print("<h3><font color=#FF0000>ERROR!</font></h3>");}else{

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="delete from lyb where id="+id;
st.executeUpdate(sql);
st.close();
con.close();
response.sendRedirect("index.jsp");
}
}else{
response.sendRedirect("log.jsp");
}
%>