📄 bconfirm.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.lang.*,java.text.*,java.util.*,java.io.*" %>
<%@include file="/db/dbPool.inc"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="/lib/main.css" rel="stylesheet" type="text/css">
<title>确认生产计划</title>
</head>
<script src="/lib/jsFunc.js"></script>
<jsp:useBean id="queryBean" scope="page" class="Query.Query"/>
<body>
<%
String[] Info=(request.getParameter("Info")).split(":");
String bID=Info[0];
String sID=Info[3];
session.putValue("Info",Info);
//String bID=(String)session.getValue("bID");
//String sID=(String)session.getValue("sID");
Statement stmt=conn1.createStatement();
String sql="select pID from wBOM where sID='"+sID+"' and wID=''";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
%>
<jsp:forward page="restPart.jsp" />
<%
}
else{
int isSuc=0;
isSuc=stmt.executeUpdate("update pTab set cFlags='2' where bID='"+bID+"'");
if(isSuc>0){
%>
<script language="javascript">
successTips("恭喜，该批次生产计划确认成功！",false,true,"bList.jsp");
</script>
<%}else{%>
<script language="javascript">
failTips("抱歉，操作失败，请重试！",false,true);
</script>
<%}}%>
</body>
</html>
<%@ include file="/db/dbpoolEnd.inc" %>
<script src="/lib/jsFooter.js"></script>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -