forked from maxliaops/Java_Web_Examples
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathPermute_Particular.jsp
More file actions
127 lines (127 loc) · 4.83 KB
/
Permute_Particular.jsp
File metadata and controls
127 lines (127 loc) · 4.83 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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
<%@ page contentType="text/html; charset=gb2312" import="java.sql.*"%>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<% request.setCharacterEncoding("gb2312");%>
<html>
<head>
<title>华奥汽车销售集团网站在线订单</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<jsp:useBean id="data" scope="page" class="cars.Bean1" />
<link rel="stylesheet" href="Css/style.css">
<%!
String sql;
ResultSet rs;
int i;
%>
<%
if(request.getParameter("Submit2")!=null){
sql="delete tb_Permute where ID="+request.getParameter("id");
int j=data.getint(sql);
data.close();
%>
<script language="javascript">
alert("置换申请删除成功");
opener.location.reload();
window.close();
</script>
<%
}
%>
<%
if(request.getParameter("Submit")!=null){
sql="update tb_Permute set Whether='受理' where ID="+request.getParameter("id");
int j=data.getint(sql);
data.close();
%>
<script language="javascript">
alert("置换申请受理成功");
opener.location.reload();
window.close();
</script>
<%
}
%>
<%
sql="select * from tb_Permute where ID="+request.getParameter("id");
rs=data.getrs(sql);
rs.beforeFirst();
if(rs!=null&&rs.next()){
%>
<body leftmargin="0" topmargin="0">
<table width="500" height="460" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#efefef" class="table">
<tr>
<td valign="middle"><table width="480" height="370" 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:130;">置 换 申 请</div></td>
</tr>
<tr>
<td height="25" align="center"> </td>
</tr>
<form name="order" method="post" action="Permute_Particular.jsp">
<tr>
<td valign="top">
<table width="480" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="152" height="28"><div align="right">真实姓名:</div></td>
<td width="328" height="28"><%=rs.getString("Name")%>
<input name="id" type="hidden" id="id" value="<%=request.getParameter("id")%>"></td>
</tr>
<tr valign="bottom">
<td height="28"><div align="right">联系电话:</div></td>
<td height="28"><%=rs.getString("Phone")%></td>
</tr>
<tr valign="bottom">
<td height="28"><div align="right">手机号码:</div></td>
<td height="28"><div align="left">
<%=rs.getString("Hander")%>
</div></td>
</tr>
<tr valign="bottom">
<td height="28"><div align="right">E-mail:</div></td>
<td height="28"><%=rs.getString("Email")%></td>
</tr>
<tr valign="bottom">
<td height="28"><div align="right">联系地址:</div></td>
<td height="28">
<div align="left">
<%=rs.getString("Address")%>
</div></td>
</tr>
<tr valign="bottom">
<td height="28"><div align="right">持有车辆名称:</div></td>
<td height="28"><%=rs.getString("CarName")%></td>
</tr>
<tr valign="bottom">
<td height="28"><div align="right">购买时间:</div></td>
<td height="28"><%=rs.getString("Times")%></td>
</tr>
<tr valign="bottom">
<td height="28"><div align="right">是否有损:</div></td>
<td height="28"><%=rs.getString("Bad")%></td>
</tr>
<tr valign="bottom">
<td height="28"><div align="right">是否已经过车检:</div></td>
<td height="28"><%=rs.getString("YearCheck")%></td>
</tr>
<tr valign="bottom">
<td height="28"><div align="right">欲置换车辆名称:</div></td>
<td height="28"> <%=rs.getString("ChangeCar")%></td>
</tr>
<tr valign="bottom">
<td height="28" colspan="2">
<div align="center">
<input name="Submit" type="submit" class="buttons" value=" 受 理 ">
<input name="Submit2" type="submit" class="buttons" value=" 删 除 ">
<input name="Submit22" type="button" class="buttons" value=" 返 回 " onClick="javascript:window.close()">
</div></td>
</tr>
</table></td>
</tr>
</form>
</table></td>
</tr>
</table>
<%}%>
</body>
</html>