演示视频:

购物网站

代码: https://github.com/wu1369955/shopping

购物网站首页

首先说明:这个是花几天搭建出来玩的,从github上拉到找好看的框架组合的,效果还不错,主要是学习作用.源码之类的也会分享出来,希望一起进步,最好动手实践,可以参照逻辑做的更好,

简易购物商城设计

 实验要求:1.编写注册和登录页面,（要注意检查注册信息是否已经被其他用户使用）。2.编写采购页面,页面显示不同的商品，（可以按分类来展示，如有能力者可增加商品管理页面，对展示的商品进行管理）3.用户可以选择商品并加入购物车，4.用户在购物车可以进行结算产生订单（结算可以不进行实际的支付）。5.自行设计页面的展示和跳转方式，要求必须登录后才能进入下单页面,不登录只能浏览商品页面。6.可以查询订单情况（订单样式自行设计）

一、数据库设计

(1)用户数据表

User表用于存储用户信息

CREATE TABLE IF NOT EXISTS `user`(  `user_id` INT UNSIGNED AUTO_INCREMENT,  `user_name` VARCHAR(100) NOT NULL,  `user_password` VARCHAR(40) NOT NULL,  PRIMARY KEY ( `user_id` ))ENGINE=InnoDB DEFAULT CHARSET=utf8;INSERT INTO user (user_id, user_name, user_password) VALUES  ('1', 'user_1', '123456'),  ('2', 'user_2', '123456'),  ('3', 'user_3', '123456');insert into user(user_name, user_password) VALUES  ('admin@qq.com', '123');select * from user;

(2)商品数据表

Mall_cloth 表用于存储衣物商品信息
Mall_food 表用于存储食物商品信息
Mall_fruit 表用于存储水果商品信息
Mall_mobile 表用于存储手机商品信息

drop table if exists `mall_food`;drop table if exists `mall_cloth`;drop table if exists `mall_mobile`;drop table if exists  `mall_fruit`;create table if not exists `mall_cloth`(`id` int not null ,`name` char(20) not null ,`price`  int not null ,`number` int not null,`describe` char(100) not null ,PRIMARY KEY (`id`))ENGINE =InnoDB default charset=utf8;create table if not exists `mall_fruit` (  `id` int not null ,  `name` char(20) not null ,  `price`  int not null ,  `number` int not null,  `describe` char(100) not null ,  PRIMARY KEY (`id`))ENGINE =InnoDB default charset=utf8;create table if not exists `mall_mobile` (  `id` int not null ,  `name` char(20) not null ,  `price`  int not null ,  `number` int not null,  `describe` char(100) not null ,  PRIMARY KEY (`id`))ENGINE =InnoDB default charset=utf8;create table if not exists `mall_food` (  `id` int not null ,  `name` char(20) not null ,  `price`  int not null ,  `number` int not null,  `describe` char(100) not null ,  PRIMARY KEY (`id`))ENGINE =InnoDB default charset=utf8;insert into mall_cloth (id, name, price, number, `describe`) VALUES('0','短袖','300','4000','黑色'),('1','长袖','700','2000','黑色'),('2','短裤','800','12000','黑色'),('3','长裤','1000','8000','黑色');insert into mall_fruit (id, name, price, number, `describe`)values ('4','苹果','23','2000','江西'),('5','香蕉','7','2050','九江'),('6','荔枝','20','15400','江西'),('7','橙子','5','8080','赣南');insert into mall_mobile (id, name, price, number, `describe`) VALUES('8','手机','1780','5000','华为'),('9','手表','700','3000','三星'),('10','平板','800','12400','苹果'),('11','电脑','5000','6000','苹果');insert into mall_food (id, name, price, number, `describe`) VALUES('12','三只松鼠','40','785','内地'),('13','老干妈','20','4545','内地'),('14','泡椒鸡爪','10','545','内地'),('15','肥宅快乐水','5','854','内地');

(3)购物表单数据表

Cart 表用于存储购物车商品信息

Order表用于存储历史订单商品信息

(4) java 数据设置

java 数据类型

做一个数据库连接接口,使得数据库表和java类数据可以有机连接

(4) 数据接口连接 Database.java

package mysql;import java.sql.*;public class DataBase {private Connection con=null;public DataBase(){String url="jdbc:mysql://127.0.0.1:3306/shopping?useUnicode=true&characterEncoding=utf-8";String un="root";String pwd="123456";try{Class.forName("com.mysql.jdbc.Driver");con=DriverManager.getConnection(url, un, pwd);}catch(ClassNotFoundException e){System.out.println("ClassCastException!!!");e.printStackTrace();}catch(SQLException e){System.out.println("SQLException");e.printStackTrace();}}public ResultSet getData(String sql){Statement stm=null;try{stm = con.createStatement();ResultSet result = stm.executeQuery(sql);System.out.println("getData！！！");return result;}catch(SQLException e){System.out.println("SQLException!!!");e.printStackTrace();return null;}}public void setData(String sql){Statement stm = null;try{stm = con.createStatement();stm.executeUpdate(sql);System.out.println("setData！！！");}catch(SQLException e){System.out.println("SQLException!!!");e.printStackTrace();}finally {if(stm!=null) {try {stm.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}public void close() {try {     con.close();     System.out.println("con.close"); } catch (SQLException e) {     // TODO Auto-generated catch block     e.printStackTrace(); }}}

总结:

1.用户表单存储用户信息,验证用户是否登陆,注册.
2.在登陆后,用户拥有选购商品信息的权限,选购的商品将存储在购物车中,
3.同时商品分开显示选购衣物,水果,食品,手机信息,
4.最后,用户可以通过结算生成订单存储在数据库中,用户可以查看历史订单的成交信息

二、前端页面设计

(1)登陆界面设计

1.登陆表单整体布局为登陆头像,提交表单,还有底部显示信息

2.用户通过选择登陆和注册进行用户表的操作

3.注销,用户退出登陆.

4.注册界面设计

(2)表格设计

表格对齐,表格头部进行渲染(css),和各个表格的居中渲染,表单借鉴开源css设计网站的例程,通过一些修改,做成本次得表单由数据库获取的信息来组成表格的内容,整个表格的演示分为商品表格(衣物,食品,水果,手机),和购物车表单,历史记录表单,这些表单都是动态表单.

(3)导航栏设计()

1.导航栏点击主页(主页还有轮播图的效果)

2.单击商品栏水果

3.单击我的 (商品表格) 展示这个商城所有区的商品

4.单击我的(历史记录) ,可以查看历史订单信息

三、后端设计

嗯到这里描述一下主要的逻辑思路:

1. 这个是你当前的网页: http://localhost:8082/main.jsp

2. 这个是你页面的超链接你点击服装一下这个超链接,链接会变为http://localhost:8082/mall_cloth.goods
   

3. 这个时候web.xml 起作用了,这个*.goods 匹配上了咱们的servlet.GoodsServlet.java 文件,这个时候咱们这个java文件extends HttpServlet ,可以继承doget ,和dopost 方法

4. 咱们java类做完相应的处理后,这个时候肯定要退出java了,转到html,或者jsp 页面了,比如resp.sendRedirect(req.getContextPath()+“/login.jsp”),中间的话一些传参,取参数,用到相应的函数.

基本逻辑流程就这样了

(1)Userservlet .java 实现登陆,注册,注销,确认用户是否登陆功能

1.doget 方法实现登陆,注册和确认用户是否登陆的转发

package servlet;import entity.User;import mysql.DataBase;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import java.io.IOException;import java.sql.ResultSet;import java.sql.SQLException;public class UserServlet extends HttpServlet {@Overrideprotected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String path = req.getServletPath();resp.setContentType("text/html;charset=utf-8");req.setCharacterEncoding("utf-8");resp.setCharacterEncoding("utf-8");if("/login.user".equals(path)){login(req,resp);}if("/register.user".equals(path)){register(req,resp);}}@Overrideprotected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String path = req.getServletPath();resp.setContentType("text/html;charset=utf-8");req.setCharacterEncoding("utf-8");resp.setCharacterEncoding("utf-8");if("/logout.user".equals(path)){logout(req,resp);}if("/check_food.user".equals(path)){check_food(req,resp);}if("/check_fruit.user".equals(path)){check_fruit(req,resp);}if("/check_mobile.user".equals(path)){check_mobile(req,resp);}if("/check_cloth.user".equals(path)){check_cloth(req,resp);}if("/check_mall.user".equals(path)){check_mall(req,resp);}}protected void register(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String username=req.getParameter("username");String password=req.getParameter("password");//String phone=req.getParameter("phone");//String address=req.getParameter("address");DataBase db=new DataBase();ResultSet rs = db.getData("SELECT * FROM user where user_name='"+username+"'");try {if(rs.next()) {req.setAttribute("msg", "用户名已注册，请重新注册！！！");req.getRequestDispatcher("/register.jsp").forward(req, resp);rs.close();db.close();return;}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}String sql="insert into user(user_name,user_password) values('"+username+"','"+password+"')";db.setData(sql);resp.sendRedirect(req.getContextPath()+"/login.jsp");db.close();}protected void login(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String username=req.getParameter("username");String password=req.getParameter("password");HttpSession session=req.getSession();DataBase db=new DataBase();ResultSet rs = db.getData("SELECT * FROM user where user_name='"+username+"' and user_password='"+password+"'");System.out.println("调试3");try {if(rs.next()) {User u=new User();u.setUsername(rs.getString("user_name"));u.setPassword(rs.getString("user_password"));//u.setPhone(rs.getString(3));//u.setAddress(rs.getString(4));session.setAttribute("user", u);System.out.println("调试2");resp.sendRedirect(req.getContextPath()+"/show.goods");System.out.println("调试1");return;}req.setAttribute("msg", "用户名或密码错误！！！");req.getRequestDispatcher("/login.jsp").forward(req, resp);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally {if(rs!=null) {try {rs.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}db.close();}protected void logout(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {HttpSession session=req.getSession();session.invalidate();resp.sendRedirect(req.getContextPath()+"/show.goods");}protected void check_food(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {User u=(User)req.getSession().getAttribute("user");if(u==null) {resp.sendRedirect(req.getContextPath()+"/login.jsp");return;}String tag = req.getParameter("tag");if("AddCart".equals(tag)) {String index=req.getParameter("index");resp.sendRedirect(req.getContextPath()+"/add_food.cart?index="+index);}else{resp.sendRedirect(req.getContextPath()+"/show.cart");}}protected void check_fruit(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {User u=(User)req.getSession().getAttribute("user");if(u==null) {resp.sendRedirect(req.getContextPath()+"/login.jsp");return;}String tag = req.getParameter("tag");if("AddCart".equals(tag)) {String index=req.getParameter("index");resp.sendRedirect(req.getContextPath()+"/add_fruit.cart?index="+index);}else{resp.sendRedirect(req.getContextPath()+"/show.cart");}}protected void check_mobile(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {User u=(User)req.getSession().getAttribute("user");if(u==null) {resp.sendRedirect(req.getContextPath()+"/login.jsp");return;}String tag = req.getParameter("tag");if("AddCart".equals(tag)) {String index=req.getParameter("index");resp.sendRedirect(req.getContextPath()+"/add_mobile.cart?index="+index);}else{resp.sendRedirect(req.getContextPath()+"/show.cart");}}protected void check_cloth(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {User u=(User)req.getSession().getAttribute("user");if(u==null) {resp.sendRedirect(req.getContextPath()+"/login.jsp");return;}String tag = req.getParameter("tag");if("AddCart".equals(tag)) {String index=req.getParameter("index");resp.sendRedirect(req.getContextPath()+"/add_cloth.cart?index="+index);}else{resp.sendRedirect(req.getContextPath()+"/show.cart");}}protected void check_mall(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {User u=(User)req.getSession().getAttribute("user");if(u==null) {resp.sendRedirect(req.getContextPath()+"/login.jsp");return;}String tag = req.getParameter("tag");if("Del".equals(tag)) {String mall_name=req.getParameter("mall_name");String id=req.getParameter("id");resp.sendRedirect(req.getContextPath()+"/del.mall?mall_name="+mall_name+"&id="+id);}if("Update".equals(tag)){String mall_name=req.getParameter("mall_name");String id=req.getParameter("id");resp.sendRedirect(req.getContextPath()+"/update.mall?mall_name="+mall_name+"&id="+id);}}}

(2)Cartservlet.java实现购物功能

1.通过.user来跳转确认用户是否登陆,在通过转发来跳转,被Cartservlet 捕获.

Mall_cloth.jsp

Web.xml

单击加入购物车,显示添加成功;

购物车显示如下,可以选择继续购物或者清空购物车

(3)CardServlet实现商品显示功能

package servlet;import entity.Cart;import entity.User;import mysql.DataBase;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import java.io.IOException;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;public class CartServlet extends HttpServlet {public static List<Cart> cart=new ArrayList<Cart>();@Overrideprotected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String path = req.getServletPath();resp.setContentType("text/html;charset=utf-8");req.setCharacterEncoding("utf-8");resp.setCharacterEncoding("utf-8");if("/add_food.cart".equals(path)){add_food(req,resp);}if("/add_fruit.cart".equals(path)){add_fruit(req,resp);}if("/add_mobile.cart".equals(path)){add_mobile(req,resp);}if("/add_cloth.cart".equals(path)){add_cloth(req,resp);}if("/show.cart".equals(path)){show(req,resp);}if("/delete.cart".equals(path)){delete(req,resp);}}protected void add_food(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String index=req.getParameter("index");User u=(User)req.getSession().getAttribute("user");String username=u.getUsername();DataBase db=new DataBase();ResultSet rs = db.getData("SELECT * FROM mall_food where id="+index);String goodsname = "";Double price = 0.0;try {if(rs.next()) {goodsname=rs.getString("name");price=rs.getDouble("price");}else {System.out.println("获取出错！！！");}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}rs = db.getData("SELECT * FROM cart  where name='"+goodsname+"' and un='"+username+"'");try {if(rs.next()) {String sql="UPDATE cart SET number="+(rs.getInt("number")+1)+",price="+(price*(rs.getInt("number")+1))+" where name='"+goodsname+"' and un='"+username+"'";db.setData(sql);req.setAttribute("msg", "商品"+goodsname+"加入购物成成功！");req.getRequestDispatcher("/show.goods").forward(req, resp);}else {String sql="insert into cart(name,number,price,un) values('"+goodsname+"',1,'"+price+"','"+username+"')";System.out.print(sql);db.setData(sql);req.setAttribute("msg", "商品"+goodsname+"加入购物成成功！");req.getRequestDispatcher("/show_food.goods").forward(req, resp);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally {if(rs!=null) {try {rs.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}db.close();}protected void add_fruit(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String index=req.getParameter("index");User u=(User)req.getSession().getAttribute("user");String username=u.getUsername();DataBase db=new DataBase();ResultSet rs = db.getData("SELECT * FROM mall_fruit where id="+index);String goodsname = "";Double price = 0.0;try {if(rs.next()) {goodsname=rs.getString("name");price=rs.getDouble("price");System.out.println("水果调试1"+goodsname);}else {System.out.println("获取出错！！！");}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}rs = db.getData("SELECT * FROM cart  where name='"+goodsname+"' and un='"+username+"'");try {if(rs.next()) {System.out.println("水果调试2");String sql="UPDATE cart SET number="+(rs.getInt("number")+1)+",price="+(price*(rs.getInt("number")+1))+" where name='"+goodsname+"' and un='"+username+"'";db.setData(sql);req.setAttribute("msg", "商品"+goodsname+"加入购物成成功！");req.getRequestDispatcher("/show_fruit.goods").forward(req, resp);}else {String sql="insert into cart(name,number,price,un) values('"+goodsname+"',1,'"+price+"','"+username+"')";System.out.print(sql);db.setData(sql);req.setAttribute("msg", "商品"+goodsname+"加入购物成成功！");req.getRequestDispatcher("/show_fruit.goods").forward(req, resp);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally {if(rs!=null) {try {rs.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}db.close();}protected void add_mobile(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String index=req.getParameter("index");User u=(User)req.getSession().getAttribute("user");String username=u.getUsername();DataBase db=new DataBase();ResultSet rs = db.getData("SELECT * FROM mall_mobile where id="+index);String goodsname = "";Double price = 0.0;try {if(rs.next()) {goodsname=rs.getString("name");price=rs.getDouble("price");}else {System.out.println("获取出错！！！");}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}rs = db.getData("SELECT * FROM cart  where name='"+goodsname+"' and un='"+username+"'");try {if(rs.next()) {String sql="UPDATE cart SET number="+(rs.getInt("number")+1)+",price="+(price*(rs.getInt("number")+1))+" where name='"+goodsname+"' and un='"+username+"'";db.setData(sql);req.setAttribute("msg", "商品"+goodsname+"加入购物成成功！");req.getRequestDispatcher("/show_mobile.goods").forward(req, resp);}else {String sql="insert into cart(name,number,price,un) values('"+goodsname+"',1,'"+price+"','"+username+"')";System.out.print(sql);db.setData(sql);req.setAttribute("msg", "商品"+goodsname+"加入购物成成功！");req.getRequestDispatcher("/show_mobile.goods").forward(req, resp);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally {if(rs!=null) {try {rs.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}db.close();}protected void add_cloth(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String index=req.getParameter("index");User u=(User)req.getSession().getAttribute("user");String username=u.getUsername();DataBase db=new DataBase();ResultSet rs = db.getData("SELECT * FROM mall_cloth where id="+index);String goodsname = "";Double price = 0.0;try {if(rs.next()) {goodsname=rs.getString("name");price=rs.getDouble("price");}else {System.out.println("获取出错！！！");}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}rs = db.getData("SELECT * FROM cart  where name='"+goodsname+"' and un='"+username+"'");try {if(rs.next()) {String sql="UPDATE cart SET number="+(rs.getInt("number")+1)+",price="+(price*(rs.getInt("number")+1))+" where name='"+goodsname+"' and un='"+username+"'";db.setData(sql);req.setAttribute("msg", "商品"+goodsname+"加入购物成成功！");req.getRequestDispatcher("/show_cloth.goods").forward(req, resp);}else {String sql="insert into cart(name,number,price,un) values('"+goodsname+"',1,'"+price+"','"+username+"')";System.out.print(sql);db.setData(sql);req.setAttribute("msg", "商品"+goodsname+"加入购物成成功！");req.getRequestDispatcher("/show_cloth.goods").forward(req, resp);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally {if(rs!=null) {try {rs.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}db.close();}protected void show(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {User u=(User)req.getSession().getAttribute("user");String username=u.getUsername();DataBase db=new DataBase();ResultSet rs = db.getData("SELECT * FROM cart where un='"+username+"'");try {while(rs.next()) {Cart c=new Cart();c.setGoodsname(rs.getString("name"));c.setNumber(rs.getInt("number"));c.setPrice(rs.getDouble("price"));c.setUsername(username);cart.add(c);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally {if(rs!=null) {try {rs.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}req.setAttribute("cart", cart);System.out.println("添加购物车调试接口4");req.getRequestDispatcher("/cart1.jsp").forward(req, resp);System.out.println("添加购物车调试接口5");cart.clear();db.close();}protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {DataBase db=new DataBase();String type=req.getParameter("type");//清空if("All".equals(type)) {String sql="DELETE FROM cart";db.setData(sql);resp.sendRedirect(req.getContextPath()+"/show.cart");}//删除某个else {String goodsname=req.getParameter("goodsname");byte[] b=goodsname.getBytes("ISO8859-1");goodsname=new String(b,"utf-8");//这里取得的编码是utf-8不做处理，tomcat版本不同返回的值编码可能不一样，如果中文乱码，则对编码进行处理String sql="DELETE FROM cart WHERE name='"+goodsname+"'";db.setData(sql);resp.sendRedirect(req.getContextPath()+"/show.cart");}db.close();}}

1.导航栏超链接如下

2.Web.xml 做一个映射,捕捉.goods 的请求

3.对.good 请求进行一个转化,并在主类中声明主类的数据存储

4.对不同的请求转发进行数据处理数(数据库请求)

5.请求数据库,并将数据进行转发给对应的jsp页面

6.Jsp 页面捕获这些数据进行显示
<%
List goods=(List)request.getAttribute(“goods”);
User u=(User)session.getAttribute(“user”);
%>

(4)OrderServlet.java 订单生成,历史订单查询

购物车页面订单生成,在确认区生成订单,订单数据会存储在数据库中.

查看历史订单:

查看订单信息

同样是路由转发,执行数据库操作,显示数据

package servlet;import entity.Cart;import entity.Order;import entity.User;import mysql.DataBase;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import java.io.IOException;import java.sql.ResultSet;import java.sql.SQLException;import java.text.SimpleDateFormat;import java.util.ArrayList;import java.util.Date;import java.util.List;import java.util.Random;public class OrderServlet extends HttpServlet {public static List<Cart> cart=new ArrayList<Cart>();//备份cart 生成订单时用public static List<Cart> cart_=new ArrayList<Cart>();//订单号 listpublic static List<String> OrderId = new ArrayList<String>();//订单详情 Listpublic static List<Order> order = new ArrayList<Order>();//时间+随机数public static String getOrderIdByTime() {SimpleDateFormat sdf=new SimpleDateFormat("yyyyMMddHHmmss");String newDate=sdf.format(new Date()); String result="";Random random=new Random();for(int i=0;i<3;i++) {result+=random.nextInt(10);}return newDate+result;}@Overrideprotected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String path = req.getServletPath();resp.setContentType("text/html;charset=utf-8");req.setCharacterEncoding("utf-8");resp.setCharacterEncoding("utf-8");if("/confirm.order".equals(path)){confirm(req,resp);}if("/generate.order".equals(path)){generate(req,resp);}if("/showOrders.order".equals(path)){showOrders(req,resp);}if("/detail.order".equals(path)){detail(req,resp);}}//订单详情protected void detail(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String OrderId=req.getParameter("id");DataBase db=new DataBase();ResultSet rs = db.getData("SELECT * FROM order_ where id='"+OrderId+"'");try {while(rs.next()) {Order o=new Order();o.setUsername(rs.getString("un"));o.setGoodsname(rs.getString("goodsname"));o.setNumber(rs.getInt("number"));o.setPrice(rs.getDouble("price"));o.setId(OrderId);order.add(o);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally {if(rs!=null) {try {rs.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}req.setAttribute("order", order);req.getRequestDispatcher("orderDetail.jsp").forward(req, resp);order.clear();db.close();}//查询历史订单protected void showOrders(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {DataBase db=new DataBase();User u=(User)req.getSession().getAttribute("user");ResultSet rs = db.getData("SELECT distinct id FROM order_ where un='"+u.getUsername()+"' ");try {while(rs.next()) {String id=rs.getString("id");OrderId.add(id);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally {if(rs!=null) {try {rs.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}req.setAttribute("OrderId", OrderId);req.getRequestDispatcher("historyOrders.jsp").forward(req, resp);OrderId.clear();db.close();}//生成订单protected void generate(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {String id=getOrderIdByTime();User u=(User)req.getSession().getAttribute("user");String username=u.getUsername();DataBase db=new DataBase();for(Cart c:cart_) {String sql="insert into order_(id,un,goodsname,number,price) values('"+id+"','"+username+"','"+c.getGoodsname()+"',"+c.getNumber()+","+c.getPrice()+")";db.setData(sql);}db.setData("DELETE FROM cart");req.setAttribute("id", id);req.getRequestDispatcher("success.jsp").forward(req, resp);cart_.clear();db.close();}//确认订单protected void confirm(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {User u=(User)req.getSession().getAttribute("user");String username=u.getUsername();DataBase db=new DataBase();ResultSet rs = db.getData("SELECT * FROM cart where un='"+username+"'");try {while(rs.next()) {Cart c=new Cart();c.setGoodsname(rs.getString(1));c.setNumber(rs.getInt(2));c.setPrice(rs.getDouble(3));c.setUsername(username);cart.add(c);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}finally {if(rs!=null) {try {rs.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}req.setAttribute("cart", cart);req.getRequestDispatcher("order.jsp").forward(req, resp);//备份 cartcart_.clear();cart_.addAll(cart);//清空cart.clear();db.close();}}

​

​
​