?? 5.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>無標題文檔</title>
</head>
<body>
<%
String pid=request.getParameter("pid");
String name=request.getParameter("name");
String start=request.getParameter("start");
String end=request.getParameter("end");
String xianyou=request.getParameter("xianyou");
String security=request.getParameter("security");
String product=request.getParameter("product");
String add=request.getParameter("add");
String tn1=request.getParameter("tn1");
String tn2=request.getParameter("tn2");
String tn3=request.getParameter("tn3");
String tn4=request.getParameter("tn4");
String tn5=request.getParameter("tn5");
String tn6=request.getParameter("tn6");
String tn7=request.getParameter("tn7");
String tn8=request.getParameter("tn8");
String tn9=request.getParameter("tn9");
String tn10=request.getParameter("tn10");
String dn1=request.getParameter("dn1");
String dn2=request.getParameter("dn2");
String dn3=request.getParameter("dn3");
String dn4=request.getParameter("dn4");
String dn5=request.getParameter("dn5");
String dn6=request.getParameter("dn6");
String dn7=request.getParameter("dn7");
String dn8=request.getParameter("dn8");
String dn9=request.getParameter("dn9");
String dn10=request.getParameter("dn10");
Connection conn=null;
Statement stmt=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn =DriverManager.getConnection("jdbc:odbc:MPS_Data","","");
stmt=conn.createStatement();
String sql="insert into mps1(pid,name,start,end,xianyou,security,product,add,tn1,tn2,tn3,tn4,tn5,tn6,tn7,tn8,tn9,tn10,dn1,dn2,dn3,dn4,dn5,dn6,dn7,dn8,dn9,dn10) values ('"+pid+"','"+name+"','"+start+"','"+end+"','"+xianyou+"','"+security+"','"+product+"','"+add+"','"+dn1+"','"+dn2+"','"+dn3+"','"+dn4+"','"+dn5+"','"+dn6+"','"+dn7+"','"+dn8+"','"+dn9+"','"+dn10+"','"+tn1+"','"+tn2+"','"+tn3+"','"+tn4+"','"+tn5+"','"+tn6+"','"+tn7+"','"+tn8+"','"+tn9+"','"+tn10+"')";
stmt.executeUpdate(sql);
out.print("恭喜您成功保存到數(shù)據(jù)庫！");
%>
<form name="form4" method="post" action="5-1.jsp">
<p>第三步：點擊進入計算</p>
<p>
<input type="hidden" name="pid" value="<%= pid %>" />
<input type="hidden" name="name" value="<%= name %>" />
<input type="hidden" name="xianyou" value="<%= xianyou %>" />
<input type="hidden" name="security" value="<%= security %>" />
<input type="hidden" name="product" value="<%= product %>" />
<input type="hidden" name="add" value="<%= add %>" />
<input type="hidden" name="tn1" value="<%= tn1 %>" />
<input type="hidden" name="tn2" value="<%= tn2 %>" />
<input type="hidden" name="tn3" value="<%= tn3 %>" />
<input type="hidden" name="tn4" value="<%= tn4 %>" />
<input type="hidden" name="tn5" value="<%= tn5 %>" />
<input type="hidden" name="tn6" value="<%= tn6 %>" />
<input type="hidden" name="tn7" value="<%= tn7 %>" />
<input type="hidden" name="tn8" value="<%= tn8 %>" />
<input type="hidden" name="tn9" value="<%= tn9 %>" />
<input type="hidden" name="tn10" value="<%= tn10 %>" />
<input type="hidden" name="dn1" value="<%= dn1 %>" />
<input type="hidden" name="dn2" value="<%= dn2 %>" />
<input type="hidden" name="dn3" value="<%= dn3 %>" />
<input type="hidden" name="dn4" value="<%= dn4 %>" />
<input type="hidden" name="dn5" value="<%= dn5 %>" />
<input type="hidden" name="dn6" value="<%= dn6 %>" />
<input type="hidden" name="dn7" value="<%= dn7 %>" />
<input type="hidden" name="dn8" value="<%= dn8 %>" />
<input type="hidden" name="dn9" value="<%= dn9 %>" />
<input type="hidden" name="dn10" value="<%= dn10 %>" />
</p>
<p>
<input type="submit" name="Submit" value="確認">
</p>
</form>
</body>
<%
stmt.close();
conn.close();
%>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -