📄 handle_addpart.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.lang.*,java.io.*" %>
<%@include file="/db/dbPool.inc"%>
<HTML><HEAD><TITLE>提交信息</TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<link href="/lib/main.css" rel="stylesheet" type="text/css">
</head>
<script src="/lib/jsFunc.js"></script>
<jsp:useBean id="queryBean" scope="page" class="Query.Query"/>
<jsp:useBean id="pageList" scope="session" class="myLib.PageList" />
<BODY>
<%
int isSuc=0;
String[] bInfo=(String[])session.getValue("bInfo");
String bID=bInfo[0];
String wID=bInfo[1];
String sID=bInfo[2];
String wName=bInfo[3];
String tmp_busyNum=bInfo[4];
String oInstr=bInfo[5];
String picName=bInfo[6];
String com_pID=bInfo[7];
String selInfoID[]=request.getParameterValues("gid");
queryBean.initialize(conn1);//数据库连接初始化
Statement stmt=conn1.createStatement();
try{
for(int i=0;i<selInfoID.length;i++)
stmt.executeUpdate("exec p_updatewBOM '"+sID+"','"+wID+"','"+wName+"','"+selInfoID[i]+"'");
}
catch(Exception e)
{
System.out.println("SQL语句执行出错");
System.out.println("Error Code is:"+e.getMessage());
}
finally
{
if(stmt!=null)
try{
stmt.close();
}
catch(SQLException e){
System.out.println("SQL出错，ERROR CODE IS:" + e.getErrorCode());
}
}
%>
<script language="javascript">
window.opener.location.href='modwInfo.jsp?bID=<%=bID%>&&wID=<%=wID%>&&sID=<%=sID%>&&wName=<%=wName%>&&tmp_busyNum=<%=tmp_busyNum%>&&oInstr=<%=oInstr%>&&picName=<%=picName%>&&pID=<%=com_pID%>';
window.close();
</script>
</BODY>
</HTML>
<script src="/lib/jsFooter.js"></script>
<%@ include file="/db/dbpoolEnd.inc" %>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -