?? 4-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>無標(biāo)題文檔</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 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 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};
Connection conn=null;
Statement stmt=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn =DriverManager.getConnection("jdbc:odbc:MPS_Data","","");
stmt=conn.createStatement();%>
</p>
<p>計算結(jié)果：
<%
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++){
a[i]=Float.parseFloat(dn[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 sql2="insert into mps2(a,b,c,d,e,f,g,pid,dn,t) values('"+a[i]+"','"+b[i]+"','"+c[i]+"','"+d[i]+"','"+e[i]+"','"+d[i+1]+"','"+g[i]+"','"+pid+"','"+dn[i]+"','"+t[i]+"')";stmt.executeUpdate(sql2);}
%>
<table width="605" height="389" border="1">
<tr>
<td width="89"><div align="center">時區(qū)</div></td>
<td width="40"><div align="center">當(dāng)前</div></td>
<td colspan="2"><div align="center">需求時區(qū)</div></td>
<td colspan="4"><div align="center">計劃時區(qū)</div></td>
<td colspan="4"><div align="center">預(yù)測時區(qū)</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="40"><div align="center">10</div></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">計劃產(chǎn)出量</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>
<p><span class="STYLE2">您可以進行<span class="STYLE3"><a href="6.jsp">查詢</a></span>！！</span></p>
<form id="form1" name="form1" method="post" action="0.jsp">
<label>
<input type="submit" name="Submit" value="返回首頁" />
</label>
</form>
<%
stmt.close();
conn.close();
%>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -