forked from maxliaops/Java_Web_Examples
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathSparePart_Add.jsp
More file actions
86 lines (86 loc) · 3.51 KB
/
SparePart_Add.jsp
File metadata and controls
86 lines (86 loc) · 3.51 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
<%@ page contentType="text/html; charset=gb2312" import="java.sql.*"%>
<html>
<% request.setCharacterEncoding("gb2312");%>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<head>
<title>备件数据添加</title>
</head>
<jsp:useBean id="data" scope="session" class="cars.Bean1"></jsp:useBean>
<link rel="stylesheet" href="Css/style.css">
<body topmargin="0" leftmargin="0">
<%!
String sql;
int i;
String type;
String name,price,number;
%>
<% if(request.getParameter("action")!=null){
type=request.getParameter("type");
number=request.getParameter("number");
price=request.getParameter("price");
name=request.getParameter("name");
sql="insert into tb_SparePart values('"+number+"','"+name+"','"+price+"','"+type+"')";
i=data.getint(sql);
if(i>0){
%>
<script language="javascript">
alert("备件数据添加成功");
window.close();
opener.location.reload();
</script>
<%
}
}
data.close();
%>
<table width="380" height="210" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#A7B5CE" class="table">
<tr>
<td valign="top"><table width="360" height="210" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="40" align="center"><div align="center" class="bottm" style="font-size: 16px;color: #FF0000;font-weight: bold;width:160;"> 备 件 数 据 添 加</div></td>
</tr>
<form name="orderform" method="post" action="SparePart_Add.jsp?action=add">
<tr>
<td valign="top">
<table width="360" height="163" border="0" cellpadding="0" cellspacing="0">
<tr valign="bottom">
<td height="30"><div align="right">备 件 标 号：</div></td>
<td width="236" height="30"><input name="number" type="text" class="wenbenkuang" size="20"></td>
</tr>
<tr valign="bottom">
<td width="124" height="30"><div align="right">备 件 名 称：</div></td>
<td height="30">
<input name="name" type="text" class="wenbenkuang" size="20">
</td>
</tr>
<tr valign="bottom">
<td width="124" height="30"><div align="right">匹 配 车 型：</div>
<div align="right"></div></td>
<td height="23"><div align="left">
<input name="type" type="text" class="wenbenkuang" id="type" size="20">
</div> </td>
</tr>
<tr valign="bottom">
<td height="30"><div align="right">销 售 价 格：</div></td>
<td height="30"><input name="price" type="text" class="wenbenkuang" size="15">
（ 元 ）</td>
</tr>
<tr valign="bottom">
<td height="30" colspan="2">
<div align="center">
<input name="Submit2" type="submit" class="buttons" value=" 添 加 ">
<input name="Submit" type="reset" class="buttons" value=" 重 置 ">
<input name="Submit3" type="button" class="buttons" value=" 返 回 " onClick="javascript:window.close()">
</div></td>
</tr>
<tr valign="bottom">
<td height="13" colspan="2"> </td>
</tr>
</table></td>
</tr>
</form>
</table></td>
</tr>
</table>
</body>
</html>