【JSP开源代码栏目提醒】:网学会员鉴于大家对JSP开源代码十分关注,论文会员在此为大家搜集整理了“checkoutDealwith.jsp”一文,供大家参考学习
<%@page contentType="text/html; charset=GBK" language="java" import="java.sql.*" errorPage=""%>
<%@page import="com.dao.BuyList"%>
<%@page import="java.util.*"%>
<jsp:useBean id="connection" scope="request" class="com.tool.JDBConnection"/>
<%
request.setCharacterEncoding("GBK");
String orderNumber = request.getParameter("orderNumber");
String name = request.getParameter("name");
String realName = request.getParameter("realName");
String email = request.getParameter("email");
String address = request.getParameter("address");
String tel = request.getParameter("tel");
String post = request.getParameter("post");
String sqlOrderMan = "insert into tb_shop_orderMan values('" + orderNumber + "','" + name + "','" + realName + "','" + email + "','" + post + "','" + tel + "','" + address + "')";
connection.executeUpdate(sqlOrderMan);
List list = (List) session.getAttribute("shop");
for (int i = 0; i < list.size(); i++) {
BuyList buy = (BuyList) list.get(i);
String sqlOrderPr = "insert into tb_shop_orderProduction values ('" + orderNumber + "','" + buy.warename + "','" + buy.id + "','" + buy.photo + "','" + buy.price + "','" + buy.number + "')";
connection.executeUpdate(sqlOrderPr);
}
session.invalidate();
connection.closeDBConnection();
response.sendRedirect("index.jsp");
%>