📄 6-1.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
.STYLE1 {color: #FF00FF}
.STYLE2 {
color: #FF00FF;
font-weight: bold;
font-size: xx-large;
}
-->
</style>
</head>
<body>
<div align="center">
<%
String pid=request.getParameter("pid");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con =DriverManager.getConnection("jdbc:odbc:MPS_Data","","");
Statement stmt=con.createStatement();
String sql="select * from mps1 where pid='"+pid+"'";
ResultSet rs =stmt.executeQuery(sql);
if(rs.next()){
%>
</div>
<p align="center" class="style5">输出MPS报表 ：</p>
<p align="center" class="style5">产品编号：<%= rs.getString("pid") %> </p>
<p align="center" class="style5"> 产品名称：<%= rs.getString("name") %></p>
<p align="center" class="style5"> 现有库存量：<%= rs.getString("xianyou") %> 安全库存量：<%= rs.getString("security") %></p>
<p align="center" class="style5"> 生产批量：<%= rs.getString("product") %>批量增量：<%= rs.getString("add") %></p>
<div align="center">
<table width="605" height="139" border="1">
<tr>
<td width="89" height="29"><div align="center">时区</div></td>
<td width="40"><div align="center">当前</div></td>
<td colspan="2"><div align="center">需求时区</div></td>
<td colspan="4"><div align="center">计划时区</div></td>
<td colspan="4"><div align="center">预测时区</div></td>
</tr>
<tr>
<td height="29"><div align="center">时段</div></td>
<td> </td>
<td width="40"><div align="center">1</div></td>
<td width="40"><div align="center">2</div></td>
<td width="40"><div align="center">3</div></td>
<td width="40"><div align="center">4</div></td>
<td width="40"><div align="center">5</div></td>
<td width="40"><div align="center">6</div></td>
<td width="40"><div align="center">7</div></td>
<td width="40"><div align="center">8</div></td>
<td width="40"><div align="center">9</div></td>
<td width="40"><div align="center">10</div></td>
</tr>
<tr>
<td height="34"><div align="center">预测量</div></td>
<td> </td>
<td><%= rs.getString("tn1") %></td>
<td><%= rs.getString("tn2") %></td>
<td><%= rs.getString("tn3") %></td>
<td><%= rs.getString("tn4") %></td>
<td><%= rs.getString("tn5") %></td>
<td><%= rs.getString("tn6") %></td>
<td><%= rs.getString("tn7") %></td>
<td><%= rs.getString("tn8") %></td>
<td><%= rs.getString("tn9") %></td>
<td><%= rs.getString("tn10") %></td>
</tr>
<tr>
<td height="35"><div align="center">订单量</div></td>
<td> </td>
<td><%= rs.getString("dn1") %></td>
<td><%= rs.getString("dn2") %></td>
<td><%= rs.getString("dn3") %></td>
<td><%= rs.getString("dn4") %></td>
<td><%= rs.getString("dn5") %></td>
<td><%= rs.getString("dn6") %></td>
<td><%= rs.getString("dn7") %></td>
<td><%= rs.getString("dn8") %></td>
<td><%= rs.getString("dn9") %></td>
<td><%= rs.getString("dn10") %></td>
</tr>
</table>
<% }else {out.print("该编号不存在");}
rs.close();
%>
<%
Statement stmt1=con.createStatement();
String sql1="select * from mps2 where pid='"+pid+"'";
ResultSet rst =stmt1.executeQuery(sql1);
while(rst.next()){
out.print("<table border=1>");
out.print("时段"+rst.getString(3)+"<br>"+"产品编号:"+rst.getString(2)+"<br>");
out.print("<tr><th>毛需求量</th><th>PAB初值</th><th>净需求量</th><th>计划产出量</th><th>PAB</th><th>计划投入量</th><th>ATP</th></tr>");
out.print("<tr><td>"+rst.getString(6)+"</td></td>"+"</td><td>"+rst.getString(7)+"</td><td>"+rst.getString(8)+"</td><td>"+rst.getString(9)+"</td><td>"+rst.getString(10)+"</td><td>"+rst.getString(11)+"</td><td>"+rst.getString(12)+"</td></tr>");}
%>
<%
con.close();
%>
</table>
</div>
<p align="center"><a href=6.jsp class="STYLE2">返回</a><span class="STYLE1">继续查询</span></p>
<form id="form1" name="form1" method="post" action="0.jsp">
<label>
<div align="center">
<input type="submit" name="Submit" value="返回首页" />
</div>
</label>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -