📄 delconsign.jsp
字号:
<%@ page language="java" contentType="text/html; charset=gb2312" pageEncoding="gb2312"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><%@page import="TeaWeb.OracleHepler"%>
<%@page import="java.sql.Connection" %>
<%@page import="java.sql.PreparedStatement" %>
<html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>Insert title here</title></head><body> <%
request.setCharacterEncoding("gb2312");
String Code = request.getParameter("Code");
if (Code != null)
{
try
{
OracleHepler db = new OracleHepler();
Connection cn = db.getconnection();
cn.setAutoCommit(false);
//删除的是一张单据
//先删除明细表中的所有记录，外键
PreparedStatement pstmts = cn.prepareStatement("Delete From PurchaseItem Where PURCHASECODE = ?");
pstmts.setString(1,Code);
pstmts.execute();
pstmts.close();
//再删除进货记录
PreparedStatement pstmt = cn.prepareStatement("Delete From Purchase Where Code = ?");
pstmt.setString(1,Code);
pstmt.execute();
pstmt.close();
cn.setAutoCommit(true);
cn.close();
}
catch(Exception ex)
{
out.print(ex.getMessage());
}
}
out.print("<script language='javascript'>");
out.print("document.location = 'PurchaseList.jsp';");
out.print("</script>");
%></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -