goods_del_deal.jsp

来自「解压在c盘」· JSP 代码 · 共 29 行

<%@ page contentType="text/html;charset=gb2312"%> 
<%@ page import="java.sql.*"%> 

<% 
String spath="wangye/ec.mdb";   
String dbpath = application.getRealPath(spath);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); 
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)}; DBQ="+dbpath;
Connection conn= DriverManager.getConnection(url,"",""); 
Statement stmt=conn.createStatement();


 %>
 <%
   int ID=Integer.parseInt(request.getParameter("ID")); 
ResultSet rs=stmt.executeQuery("select * from goods where key="+ID);
if (!rs.next()){
	out.println("<script language='javascript'>alert('您的操作有误！');window.location.href='goodsContral.jsp';</script>");
}else{
	 String sql="Delete from goods where key="+ID;
      stmt.executeUpdate(sql);
      out.println("<script language='javascript'>alert('商品信息删除成功！'); window.location.href='goodsContral.jsp';</script>");
       
}
rs.close(); 
stmt.close(); 
conn.close();
%>