?? userts.jsp
字號:
<%@ page contentType="text/html;charset=GBK" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="top.jsp"%>
<link href="css.css" rel="stylesheet" type="text/css">
<div align="center">
<center>
<table border="0" width="600" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td width="380" height="25">
<%
String errmsg="";
String user_name="";
String sub_number="";
boolean founderr=false;
if(request.getParameter("user_name").equals("")){
founderr=true;
errmsg=errmsg+"<br>"+"<li>使用投訴功能要提供用戶賬號";
}
else
user_name=request.getParameter("user_name");
if(request.getParameter("sub_number").equals("")){
founderr=true;
errmsg=errmsg+"<br>"+"<li>使用投訴功能要提供訂單號";
}
else
sub_number=request.getParameter("sub_number");
if(founderr==false){
sql="select * from sub where sub_number='"+sub_number+"' and user_name='"+user_name+"'";
rs=mdb.executeQuery(sql);
if(!rs.next()){
founderr=true;
errmsg=errmsg+"<br>"+"<li>用戶沒有此訂單信息";
}
else{
sql="select * from ts where sub_number='"+sub_number+"'";
rs=mdb.executeQuery(sql);
if(!rs.next()){
sql="insert into ts(user_name,sub_number) values('"+user_name+"','"+sub_number+"')";
mdb.executeInsert(sql);
}
else{
founderr=true;
errmsg=errmsg+"<BR>"+"<li>請不要重復提交投訴信息!";
}
}
}
%>
<div align="center"><font color="#FFFFFF"><b>
<%if(founderr==true)
out.print("請確認你的投訴信息");
else
out.print(" 您的投訴信息已經確認!");
%>
</b></font></div></td>
</tr>
<tr>
<td width="100%" height="25">
<%
if(founderr==true)
out.print(errmsg);
else{%>您的投訴訂單為:<font color=red><%=sub_number%></font><br>我們會盡快的處理給您一個滿意的答復</td>
<%}%>
</tr>
</table>
</center>
</div>
<%@ include file="copy.jsp"%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -