📄 5-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">
<!--
.STYLE2 {font-size: larger; color: #FF00FF;}
.STYLE3 {
font-size: x-large;
font-weight: bold;
}
-->
</style>
</head>
<body>
<p>
<%! String dn[];
String tn[];
%>
<%
String pid=request.getParameter("pid").toString();
String name=request.getParameter("name").toString();
String xianyou=request.getParameter("xianyou").toString();
String security=request.getParameter("security").toString();
String product=request.getParameter("product").toString();
String add=request.getParameter("add").toString();
String tn1=request.getParameter("tn1").toString();
String tn2=request.getParameter("tn2").toString();
String tn3=request.getParameter("tn3").toString();
String tn4=request.getParameter("tn4").toString();
String tn5=request.getParameter("tn5").toString();
String tn6=request.getParameter("tn6").toString();
String tn7=request.getParameter("tn7").toString();
String tn8=request.getParameter("tn8").toString();
String tn9=request.getParameter("tn9").toString();
String tn10=request.getParameter("tn10").toString();
String dn1=request.getParameter("dn1").toString();
String dn2=request.getParameter("dn2").toString();
String dn3=request.getParameter("dn3").toString();
String dn4=request.getParameter("dn4").toString();
String dn5=request.getParameter("dn5").toString();
String dn6=request.getParameter("dn6").toString();
String dn7=request.getParameter("dn7").toString();
String dn8=request.getParameter("dn8").toString();
String dn9=request.getParameter("dn9").toString();
String dn10=request.getParameter("dn10").toString();
String dn[]={dn1,dn2,dn3,dn4,dn5,dn6,dn7,dn8,dn9,dn10};
String tn[]={tn1,tn2,tn3,tn4,tn5,tn6,tn7,tn8,tn9,tn10};
Connection conn=null;
Statement stmt=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn =DriverManager.getConnection("jdbc:odbc:MPS_Data","","");
stmt=conn.createStatement();%>
</p>
<p>计算结果：
<%
String t[]=new String[]{"t1","t2","t3","t4","t5","t6","t7","t8","t9","t10"};
float a[];
a=new float[10];
float b[]=new float[10];
float c[]=new float[10];
float d[]=new float[11];
float e[]=new float[10];
float g[]=new float[10];
int i=0;
for(i=0;i<10;i++){
if(i<=1)
{a[i]=Float.parseFloat(dn[i]);}
else if(i>=2&&i<=5)
{if (Integer.parseInt(tn[i])>Integer.parseInt(dn[i]))
{a[i]=Float.parseFloat(tn[i]);}
else
{a[i]=Float.parseFloat(dn[i]);}}
else if(i>=4&&i<=9)
{a[i]=Float.parseFloat(tn[i]);}
if(i==0)
{b[i]=Float.parseFloat(xianyou)-a[i];}
else
{b[i]=e[i-1]-a[i];}
if(b[i]>=Float.parseFloat(security))
{c[i]=0;d[i]=0;e[i]=b[i];
}
else
{c[i]=Float.parseFloat(security)-b[i];
d[i]=1*Float.parseFloat(product);e[i]=e[i-1]+d[i]-a[i];
}
if(i==0){g[i]=e[i];}
else{if(d[i]>0){g[i]=d[i]-Float.parseFloat(dn[i]);}
else{g[i]=0;}}
}%>
<% for(i=0;i<10;i++){
String sql1="insert into mps2(a,b,c,d,e,f,g,pid,dn,tn,t) values('"+a[i]+"','"+b[i]+"','"+c[i]+"','"+d[i]+"','"+e[i]+"','"+d[i+1]+"','"+g[i]+"','"+pid+"','"+dn[i]+"','"+tn[i]+"','"+t[i]+"')";stmt.executeUpdate(sql1);
}
%>
</p>
<table width="582" height="389" border="1">
<tr>
<td width="89"><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><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="17"><div align="center">10</div></td>
</tr>
<tr>
<td><div align="center">预测量</div></td>
<td> </td>
<td><%= tn1 %></td>
<td><%= tn2 %></td>
<td><%= tn3 %></td>
<td><%= tn4 %></td>
<td><%= tn5 %></td>
<td><%= tn6 %></td>
<td><%= tn7 %></td>
<td><%= tn8 %></td>
<td><%= tn9 %></td>
<td><%= tn10 %></td>
</tr>
<tr>
<td><div align="center">订单量</div></td>
<td> </td>
<td><%= dn1 %></td>
<td><%= dn2 %></td>
<td><%= dn3 %></td>
<td><%= dn4 %></td>
<td><%= dn5 %></td>
<td><%= dn6 %></td>
<td><%= dn7 %></td>
<td><%= dn8 %></td>
<td><%= dn9 %></td>
<td><%= dn10 %></td>
</tr>
<tr>
<td><div align="center">毛需求量</div></td>
<td> </td>
<td><%= a[0] %></td>
<td><%= a[1] %></td>
<td><%= a[2] %></td>
<td><%= a[3] %></td>
<td><%= a[4] %></td>
<td><%= a[5] %></td>
<td><%= a[6] %></td>
<td><%= a[7] %></td>
<td><%= a[8] %></td>
<td><%= a[9] %></td>
</tr>
<tr>
<td><div align="center">PAB初值</div></td>
<td><%= xianyou %></td>
<td><%= b[0] %>;</td>
<td><%= b[1] %></td>
<td><%= b[2] %></td>
<td><%= b[3] %></td>
<td><%= b[4] %></td>
<td><%= b[5] %></td>
<td><%= b[6] %></td>
<td><%= b[7] %></td>
<td><%= b[8] %></td>
<td><%= b[9] %></td>
</tr>
<tr>
<td><div align="center">净需求量</div></td>
<td> </td>
<td><%= c[0] %></td>
<td><%= c[1] %></td>
<td><%= c[2] %></td>
<td><%= c[3] %></td>
<td><%= c[4] %></td>
<td><%= c[5] %></td>
<td><%= c[6] %></td>
<td><%= c[7] %></td>
<td><%= c[8] %></td>
<td><%= c[9] %></td>
</tr>
<tr>
<td><div align="center">计划产出量</div></td>
<td> </td>
<td><%= d[0] %></td>
<td><%= d[1] %></td>
<td><%= d[2] %></td>
<td><%= d[3] %></td>
<td><%= d[4] %></td>
<td><%= d[5] %></td>
<td><%= d[6] %></td>
<td><%= d[7] %></td>
<td><%= d[8] %></td>
<td><%= d[9] %></td>
</tr>
<tr>
<td><div align="center">PAB</div></td>
<td> </td>
<td><%= e[0] %></td>
<td><%= e[1] %></td>
<td><%= e[2] %></td>
<td><%= e[3] %></td>
<td><%= e[4] %></td>
<td><%= e[5] %></td>
<td><%= e[6] %></td>
<td><%= e[7] %></td>
<td><%= e[8] %></td>
<td><%= e[9] %></td>
</tr>
<tr>
<td><div align="center">计划投入量</div></td>
<td> </td>
<td><%= d[1] %></td>
<td><%= d[2] %></td>
<td><%= d[3] %></td>
<td><%= d[4] %></td>
<td><%= d[5] %></td>
<td><%= d[6] %></td>
<td><%= d[7] %></td>
<td><%= d[8] %></td>
<td><%= d[9] %></td>
<td><%= d[10] %></td>
</tr>
<tr>
<td><div align="center">ATP</div></td>
<td> </td>
<td><%= g[0] %></td>
<td><%= g[1] %></td>
<td><%= g[2] %></td>
<td><%= g[3] %></td>
<td><%= g[4] %></td>
<td><%= g[5] %></td>
<td><%= g[6] %></td>
<td><%= g[7] %></td>
<td><%= g[8] %></td>
<td><%= g[9] %></td>
</tr>
</table>
<p class="STYLE2">您可以进行<span class="STYLE3"><a href="6.jsp">查询</a></span>产品！！</p>
<form id="form1" name="form1" method="post" action="0.jsp">
<label>
<input type="submit" name="Submit" value="返回首页" />
</label>
</form>
</body>
<%
stmt.close();
conn.close();
%>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -