WebRoot/pages/buySave.jsp

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@page import="java.util.List"%>
<%@ page language="java" pageEncoding="UTF-8"%>
<%@page import="com.inloam.common.QueryAssistant"%>
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="org.apache.commons.lang.StringUtils"%>
<%@page import="com.inloam.domain.Order"%>
<%@page import="com.inloam.service.OrderService"%>
<%@page import="com.inloam.service.impl.OrderServiceImpl"%>
<%@page import="org.springframework.beans.factory.BeanFactory"%>
<%@page import="java.util.Map"%>
<html>
<head>
<title><%=com.inloam.common.Constant.SYS_NAME %></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="sg803.css" rel="stylesheet" type="text/css">
</head>
<body>
<%
	String productId = request.getParameter("productId");
	String money = request.getParameter("money");
	String productNum = request.getParameter("productNum");
	//String address = request.getParameter("address");
	//String qq = request.getParameter("qq");
	String remark = request.getParameter("remark");
	String username = (String)request.getSession().getAttribute("username");
	//String yyTime = (String)request.getParameter("yyTime");
	
	java.util.Date dd = new java.util.Date();
	java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyyMMddHHmmss");
	String idd = sdf.format(dd);
	System.out.println("idd:"+idd);
	String sql = "insert into or_order(id,productId, productNum,money,username,createtime,remark,status) values('"+idd+"','"+productId+"','"+productNum+"','"+money+"','"+username+"',sysdatetime(),'"+remark+"','已预约');";
	System.out.println("sql:"+sql);
	QueryAssistant.getInstance().execute(sql);
	
%>
<script type="text/javascript">
	alert("预订成功！");
	window.location.href="<%=request.getContextPath()%>";
</script>
</body>
</html>