notesdelete.jsp

来自「用jsp技术开发的网络书店 用户注册登录 浏览购书 购物车 下订单 留」· JSP 代码 · 共 20 行

<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.util.*,java.sql.*"%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:bookshoplk","sa","");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=null;
%>
<%
String s_admin=(String)session.getAttribute("admin");
if(s_admin==null){
response.sendRedirect("checklogin.jsp");
}
%>
<%
String s_currentpage=request.getParameter("currentpage");
String s_id = request.getParameter("id");
stmt.executeUpdate("delete from notes where id='"+s_id+"'");
response.sendRedirect("noteslist.jsp?op=show&currentpage="+s_currentpage);
%>