bookStore第三篇【用户模块、购买模块、订单模块】

小鱼儿 2021-09-17 05:52 380阅读 0赞

# 用户模块 #

要登陆后才能购买，因此我们先写购买模块

## 设计实体 ##

private String id;
        private String username;
        private String password;
        private String email;
        private String cellphone;
        private String address;
    
        //各种setter、getter

## 设计数据库表 ##

CREATE TABLE user ( id VARCHAR(40) PRIMARY KEY, username VARCHAR(20) NOT NULL, cellphone VARCHAR(20) NOT NULL, address VARCHAR(40) NOT NULL, email VARCHAR(30), password VARCHAR(30) NOT NULL );

## 编写DAO ##

/** * 用户的登录注册模块 * 1：登陆 * 2：注册 * 3：根据id查找具体的用户 */
    public class UserDaoImpl { 
    
    
    
        public void register(User user) {
    
            QueryRunner queryRunner = new QueryRunner(Utils2DB.getDataSource());
    
            String sql = "INSERT INTO user (id,username,cellphone,address,email,password) VALUES(?,?,?,?,?,?)";
            try {
    
                queryRunner.update(sql, new Object[]{user.getId(),user.getUsername(), user.getCellphone(), user.getAddress(), user.getEmail(), user.getPassword()});
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        }
    
        public User login(String username, String password) {
    
            QueryRunner queryRunner = new QueryRunner(Utils2DB.getDataSource());
    
            String sql = "SELECT * FROM user WHERE username = ? AND password=?";
            try {
    
                return (User) queryRunner.query(sql, new Object[]{username, password}, new BeanHandler(User.class));
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        }
    
        public User find(String id) {
    
            QueryRunner queryRunner = new QueryRunner(Utils2DB.getDataSource());
    
            String sql = "SELECT * FROM user WHERE id=?";
            try {
    
                return (User) queryRunner.query(sql, id, new BeanHandler(User.class));
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        }
    
    }

## 测试DAO ##

public class UserDemo {
        UserDaoImpl userDao = new UserDaoImpl();
    
        @Test
        public void add() {
    
            User user = new User();
            user.setId("1");
            user.setUsername("zhong");
            user.setPassword("123");
            user.setCellphone("10085");
            user.setAddress("广州萝岗");
            user.setEmail("40368324234234@QQ.com");
    
            userDao.register(user);
        }
    
        @Test
        public void find() {
    
            String id = "1";
            User user = userDao.find(id);
    
            System.out.println(user.getEmail());
        }
    
        @Test
        public void login() {
            String username = "zhong";
            String password = "123";
            User user = userDao.login(username, password);
    
            System.out.println(user.getAddress());
        }
    }

## 抽取DAO ##

public interface UserDao {
        void register(User user);
    
        User login(String username, String password);
    
        User find(String id);
    }

## 编写Service ##

private UserDao userDao = DaoFactory.getInstance().createDao("zhongfucheng.dao.impl.UserDaoImpl", UserDao.class);
    
        public void registerUser(User user) {
            userDao.register(user);
        }
    
        public User loginUser(String username,String password) {
            return userDao.login(username, password);
        }
    
        public User findUser(String id) {
            return userDao.find(id);
        }

## 前台样式 ##

*  head.jsp

*  head.css

#body { position: relative; }
    #user { position: absolute; margin-top: 130px; margin-left: 1364px; }

*  效果：

![这里写图片描述][SouthEast]

--------------------

## 实现登陆注册功能 ##

**当点击登陆按钮的时候，把数据带过去给Servlet，让Servlet调用BusinessService方法，实现登陆**。注册同理…..因此，我们需要用到JavaScript代码

*  head.jsp

<c:if test="${user==null}" >
    <div id="User">
        用户名：<input type="text" id="username">
        密码：<input type="password" id="password">
        <button name="login" onclick="login()">登陆</button>
        <button name="register" onclick="register()">注册</button>
    </div>
    </c:if>
    
    <c:if test="${user!=null}" >
        <div id="User">
                  欢迎您：${user.username}    <a href="${pageContext.request.contextPath}/UserServlet?method=Logout">注销</a>
        </div>
    </c:if>

*  javaScript代码

*  UserServlet

String method = request.getParameter("method");
    
            BussinessServiceImpl service = new BussinessServiceImpl();
            if (method.equals("login")) {
    
                try {
                    //得到页面传递过来的数据
                    String username = request.getParameter("username");
                    String password = request.getParameter("password");
                    User user = service.loginUser(username, password);
    
                    request.getSession().setAttribute("user",user);
                    request.getRequestDispatcher("/client/head.jsp").forward(request, response);
    
                } catch (Exception e) {
                    request.setAttribute("message", "登陆失败了！");
                    request.getRequestDispatcher("/message.jsp").forward(request, response);
                }
    
            } else if (method.equals("register")) {
    
                try {
                    //得到JSP传递过来的数据，封装成Bean对象
                    User user = WebUtils.request2Bean(request, User.class);
                    user.setId(WebUtils.makeId());
    
                    service.registerUser(user);
    
                    request.setAttribute("message", "注册成功了！");
    
                } catch (Exception e) {
                    e.printStackTrace();
                    request.setAttribute("message", "注册失败了！");
                }
                request.getRequestDispatcher("/message.jsp").forward(request, response);
            } else if (method.equals("Logout")) {
    
                //销毁session
                request.getSession().invalidate();
    
                //回到首页
                request.getRequestDispatcher("/client/head.jsp").forward(request, response);
    
            }

# 购买模块 #

在显示图书的时候，顺便添加购买的超链接

## 设计购物车实体 ##

如果不清楚为什么这样设计，可参考我之前的博文：[http://blog.csdn.net/hon\_3y/article/details/56481439\#t5][http_blog.csdn.net_hon_3y_article_details_56481439_t5]

*  Cart实体

public class Cart {
    
        private Map<String, CartItem> map = new HashMap<>();
        private double price;
    
    
        //提供把商品添加到购物的功能
        public void addBook2Cart(Book book) {
    
            //得到对应的购物项
            CartItem cartItem = map.get(book.getId());
    
            //如果是null，说明购物车还没有该购物项
            if (cartItem == null) {
                cartItem = new CartItem();
                cartItem.setQuantity(1);
                cartItem.setBook(book);
                cartItem.setPrice(book.getPrice());
    
                //把购物项加到购物车中
                map.put(book.getId(), cartItem);
            } else {
    
                //如果购物车有该购物项了，那么将购物项的数量+1
                cartItem.setQuantity(cartItem.getQuantity() + 1);
            }
        }
    
    
        //购物车的价钱是购物项价钱的总和
        public double getPrice() {
    
            double totalPrice = 0;
            for (Map.Entry<String, CartItem> me : map.entrySet()) {
                CartItem cartItem = me.getValue();
                totalPrice += cartItem.getPrice();
            }
    
            return totalPrice;
        }
    
        public Map<String, CartItem> getMap() {
            return map;
        }
    
        public void setMap(Map<String, CartItem> map) {
            this.map = map;
        }
    
    
        public void setPrice(double price) {
            this.price = price;
        }
    }

## 设计购物项实体 ##

public class CartItem {
    
        private Book book;
        private double price;
        private int quantity;
    
        public double getPrice() {
            return this.book.getPrice() * this.quantity;
        }
    
        public void setPrice(double price) {
            this.price = price;
        }
    
        public Book getBook() {
            return book;
        }
    
        public void setBook(Book book) {
            this.book = book;
        }
        public int getQuantity() {
            return quantity;
        }
    
        public void setQuantity(int quantity) {
            this.quantity = quantity;
        }
    }

## 处理用户想要买的书籍Servlet ##

*  BuyServlet

BussinessServiceImpl service = new BussinessServiceImpl();
    
            //先检查该用户是否登陆了。
            User user = (User) request.getSession().getAttribute("user");
            if (user == null) {
                request.setAttribute("message", "您还没登陆，请登陆了再来购买");
                request.getRequestDispatcher("/message.jsp").forward(request, response);
                return ;
            }
    
            //如果登陆了...
    
            //得到该用户的购物车
            Cart cart = (Cart) request.getSession().getAttribute("cart");
            if (cart == null) {
                cart = new Cart();
                request.getSession().setAttribute("cart", cart);
            }
    
            //得到用户想买的书籍
            String book_id = request.getParameter("book_id");
            Book book = service.findBook(book_id);
    
            //把书籍添加到购物车中
            service.buyBook(cart, book);
            request.setAttribute("message", "该商品已添加到购物车中");
            request.getRequestDispatcher("/message.jsp").forward(request,response);

## 提供显示购物车商品的Servlet ##

//先判断该用户是否登陆了
            User user = (User) request.getSession().getAttribute("user");
            if (user == null) {
                request.setAttribute("message", "您还没有登陆呢！");
                request.getRequestDispatcher("/message.jsp").forward(request, response);
                return;
            }
    
            //如果登陆了.....
            Cart cart = (Cart) request.getSession().getAttribute("cart");
    
            //把该用户的购物车给JSP页面显示
            request.setAttribute("cart", cart);
            request.getRequestDispatcher("/client/listCart.jsp").forward(request, response);

## 显示购物车的JSP页面 ##

<c:if test="${empty(cart.map)}">
    
        您还没有购买过任何商品哦！！！
    </c:if>
    
    
    <table border="1px">
        <c:if test="${!empty(cart.map)}">
            <h1>您购物车下有如下的商品：</h1><br>
    
            <tr>
                <td>书名：</td>
                <td>作者：</td>
                <td>数量：</td>
                <td>价钱：</td>
            </tr>
            <c:forEach items="${cart.map}" var="cartItme">
    
    
                <tr>
                    <td>${cartItme.value.book.name}</td>
                    <td>${cartItme.value.book.author}</td>
                    <td>${cartItme.value.quantity}</td>
                    <td>${cartItme.value.price}</td>
                </tr>
            </c:forEach>
    
        </c:if>
    </table>

### **效果：** ###

![这里写图片描述][SouthEast 1]

--------------------

# 订单模块 #

在前台用户界面中，当用户要把购物车付款时，应该提供生成订单的超链接….

![这里写图片描述][SouthEast 2]

--------------------

## 设计订单实体 ##

订单应该包含id,收货人信息,下单的时间，订单的总价,订单的状态【有无发货】..而不应该包含商品的信息的。商品的信息用一个专门的”订单项“来表示

一个订单对应多个订单项，这是一对多的关系！

private String id;
    
        //下单的时间、日期、状态
        private Date date;
        private double price;
        private boolean state;
    
        //一个用户可以有多个订单，把用户记住
        private String user_id;
    
        //一个订单中有多个订单项
        private Set<OrderItem> items = new HashSet<>();
    
        //各种的setter和getter

## 设计订单项实体 ##

private String id;
    
    
        //一本书对应多个订单项，订单项一定是由书组成，记住书
        private String book_id;
    
        private double price;
        private int quantity;
    
        //各种的setter和getter

## 设计数据库表 ##

*  订单表

**mysql不能创建名为”order”的表，后边加个s就可以**

CREATE TABLE orders ( id VARCHAR(40) PRIMARY KEY, date DATE NOT NULL, user_id VARCHAR(40) NOT NULL, state BOOLEAN, price DOUBLE, CONSTRAINT user_id_FK FOREIGN KEY (user_id) REFERENCES user (id) );

*  订单项表：

CREATE TABLE orderItem ( id VARCHAR(40) PRIMARY KEY, price DOUBLE, quantity INT, order_id VARCHAR(40) , book_id VARCHAR(40) , CONSTRAINT order_id_FK FOREIGN KEY (order_id) REFERENCES orders (id), CONSTRAINT book_id_FK FOREIGN KEY (book_id) REFERENCES book (id) );

*  表之间的结构：

![这里写图片描述][SouthEast 3]

--------------------

## 设计Dao ##

public class OrderDaoImpl implements zhongfucheng.dao.OrderDao { 
    
        @Override
        public void addOrder(Order order) {
            QueryRunner queryRunner = new QueryRunner(Utils2DB.getDataSource());
            String sql1 = "INSERT INTO orders(id,ordertime,user_id,state,price) VALUES(?,?,?,?,?)";
            try {
                //订单的基本信息
                queryRunner.update(sql1, new Object[]{
        order.getId(), order.getOrdertime(), order.getUser_id(), order.isState(), order.getPrice()});
    
                //订单项的信息
                String sql2 = "INSERT INTO orderItem(id,price,quantity,order_id,book_id) VALUES(?,?,?,?,?)";
    
                Set<OrderItem> items = order.getItems();
    
                for (OrderItem item : items) {
                    queryRunner.update(sql2, new Object[]{item.getId(), item.getPrice(), item.getQuantity(), item.getOrder_id(), item.getBook_id()});
                }
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        }
    
        @Override
        public Order findOrder(String id) {
            QueryRunner queryRunner = new QueryRunner(Utils2DB.getDataSource());
    
            Order order;
            try {
                //找出订单的基本信息
                String sql = "SELECT * FROM orders WHERE id=?";
                order = (Order) queryRunner.query(sql, new BeanHandler(Order.class), new Object[]{id});
    
                //找出订单的所有订单项
                String sql2 = "SELECT * FROM orderItem WHERE order_id=?";
                List<OrderItem> list = (List<OrderItem>) queryRunner.query(sql2, new BeanListHandler(OrderItem.class), new Object[]{
        order.getId()});
    
                System.out.println("这是数据库拿到的list集合："+list.size());
    
    
                //将所有订单项装到订单里边
                order.getItems().addAll(list);
                System.out.println("这是数据库拿到的"+order.getItems().size());
    
    
                //找出该订单是属于哪一个用户的
                String sql3 = "SELECT * FROM orders o,user u WHERE o.user_id=u.id AND o.id=? ";
                User user = (User) queryRunner.query(sql3, new BeanHandler(User.class), new Object[]{
        order.getId()});
    
                order.setUser_id(user.getId());
                return order;
    
    
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        }
    
    
        //更新订单的状态
        public void updateState(String id) {
    
            QueryRunner queryRunner = new QueryRunner(Utils2DB.getDataSource());
    
            String sql = "UPDATE orders SET state=? WHERE id=?";
    
            try {
                queryRunner.update(sql, new Object[]{
        true, id});
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        }
    
        //查看已经发货或没发货的订单信息
        public List<Order> getAllOrder(boolean state) {
            QueryRunner queryRunner = new QueryRunner(Utils2DB.getDataSource());
    
            String sql = "SELECT * FROM orders WHERE state=? ";
            try {
                return (List<Order>) queryRunner.query(sql, new BeanListHandler(Order.class), new Object[]{state});
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        }
    
        //通过用户的id查找用户的订单，可能不止一个
        public List<Order> findUserOrder(String user_id) {
            QueryRunner queryRunner = new QueryRunner(Utils2DB.getDataSource());
    
            String sql = "SELECT * FROM orders WHERE user_id=? ";
    
            try {
                return List<Order> queryRunner.query(sql, new BeanHandler(Order.class), new Object[]{user_id});
    
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
    
        }
    }

## 抽取成DAO接口 ##

public interface OrderDao {
        void addOrder(Order order);
    
        Order findOrder(String user_id);
    
        List<Order> getAllOrder(boolean state);
    
        void updateState(String user_id);
    
        List<Order> findUserOrder(String user_id);
    }

## BussinessService ##

private OrderDao orderDao = DaoFactory.getInstance().createDao("zhongfucheng.dao.impl.OrderDaoImpl", OrderDao.class);
        public void createOrder(Cart cart, User user) {
    
            //订单的基本信息
            String order_id = WebUtils.makeId();
            Order order = new Order();
            order.setId(order_id);
            order.setPrice(cart.getPrice());
            order.setOrdertime(new Date());
            order.setState(false);
            order.setUser_id(user.getId());
    
    
            //订单项的基本信息
            //得到每个购物项，购物项就作为订单项
            for (Map.Entry<String, CartItem> me : cart.getMap().entrySet()) {
    
                OrderItem orderItem = new OrderItem();
                CartItem cartItem = me.getValue();
    
                orderItem.setId(WebUtils.makeId());
                orderItem.setPrice(cartItem.getPrice());
                orderItem.setBook_id(cartItem.getBook().getId());
                orderItem.setQuantity(cartItem.getQuantity());
                orderItem.setOrder_id(order_id);
                order.getItems().add(orderItem);
            }
    
            orderDao.addOrder(order);
    
        }
    
        public Order findOrder(String user_id) {
    
            return orderDao.findOrder(user_id);
        }
    
        public List<Order> getAllOrder(boolean state) {
            return orderDao.getAllOrder(state);
        }
    
        public void sendOutOrder(String id) {
    
            orderDao.updateState(id);
        }
    
        public List<Order> findUserOrder(String user_id) {
            return orderDao.findUserOrder(user_id);
        }

## 生成订单的Servlet ##

BussinessServiceImpl service = new BussinessServiceImpl(); //检查该用户的购物车是否有商品 Cart cart = (Cart) request.getSession().getAttribute("cart"); if (cart == null) { request.setAttribute("message", "您购物车没有商品，无法生成订单"); request.getRequestDispatcher("/message.jsp").forward(request, response); return; } //如果有商品，得到当前用户 User user = (User) request.getSession().getAttribute("user"); service.createOrder(cart, user); request.setAttribute("message", "订单已经生成了，准备好钱来收货把"); request.getRequestDispatcher("/message.jsp").forward(request, response); return;

## 用户查询自己的订单Servlet ##

BussinessServiceImpl service = new BussinessServiceImpl();
    
            //检查该用户是否登陆了
            User user = (User) request.getSession().getAttribute("user");
            if (user == null) {
                request.setAttribute("message", "您还没登陆，等您登陆了再来看把");
                request.getRequestDispatcher("/message.jsp").forward(request, response);
                return;
            }
    
            //用户登陆了！
            Order order = service.findUserOrder(user.getId());
    
            //交给相对应的JSP 显示
            request.setAttribute("order", order);
            request.setAttribute("user",user);
            request.getRequestDispatcher("/client/listOrder.jsp").forward(request, response);
            return ;

## 显示订单数据的JSP ##

<c:if test="${order==null}">
        您还没有下过任何订单！！
    
    </c:if>
    
    <c:if test="${order!=null}">
    
        <table border="1px">
    
            <tr>
                <td>下单人：</td>
                <td>订单时间</td>
                <td>订单状态</td>
                <td>订单价钱</td>
            </tr>
            <tr>
                <td>${user.username}</td>
                <td>${order.ordertime}</td>
                <td>${order.state==false?"未发货":"已发货"}</td>
                <td>${order.price}</td>
            </tr>
    
        </table>
    
    </c:if>

### **效果：** ###

![这里写图片描述][SouthEast 4]

--------------------

## 后台查询订单的状况Servlet ##

<a href="${pageContext.request.contextPath}/OrderServlet?state=false" target="body">待处理订单</a><br>
    <a href="${pageContext.request.contextPath}/OrderServlet?state=true" target="body">已发货订单</a><br>

BussinessServiceImpl service = new BussinessServiceImpl();
            String state = request.getParameter("state");
    
            if (state.equals("true")) {
                List<Order> list = service.getAllOrder(true);
                request.setAttribute("list",list);
    
            } else if (state.equals("false")) {
                List<Order> list = service.getAllOrder(false);
                request.setAttribute("list", list);
            }
    
    
            request.getRequestDispatcher("/background/listOrder.jsp").forward(request, response);

## 显示订单状况的JSP ##

<c:if test="${empty(list)}">
    
        还没有任何订单哦！
    
    </c:if>
    
    <c:if test="${!empty(list)}">
    
        <table border="1px">
    
            <tr>
                <td>下单人：</td>
                <td>订单时间</td>
                <td>订单状态</td>
                <td>订单价钱</td>
                <td>操作</td>
            </tr>
    
            <c:forEach items="${list}" var="order">
                <tr>
                    <td>${order.user_id}</td>
                    <td>${order.ordertime}</td>
                    <td>${order.state==false?"未发货":"已发货"}</td>
                    <td>${order.price}</td>
                    <td>
                        <a href="${pageContext.request.contextPath}/orderItemServlet?order_id=${order.id}">查看详细信息</a>
                        <a href="#">删除</a>
    
                    </td>
                </tr>
            </c:forEach>
    
    
        </table>
    
    
    </c:if>

## 查看具体订单的详细信息Servlet ##

BussinessServiceImpl service = new BussinessServiceImpl();
    
            //得到用户想要查看详细信息的表单
            String order_id = request.getParameter("order_id");
    
            Order order = service.findOrder(order_id);
    
            //将该order对象给相对应的JSP显示
            request.setAttribute("order", order);
            request.getRequestDispatcher("/background/listDetail.jsp").forward(request, response);

## 查看具体订单的详细信息JSP ##

<table border="1px">
    
       <tr>
           <td>书籍的编号</td>
           <td>价钱</td>
           <td>数量</td>
           <td>操作</td>
       </tr>
        <c:forEach items="${order.items}" var="item">
            <tr>
                <td>${item.book_id}</td>
                <td>${item.price}</td>
                <td>${item.quantity}</td>
                <td><a href="${pageContext.request.contextPath}/SendOutServlet?id=${order.id}">发货</a></td>
            </tr>
        </c:forEach>
    </table>

## 处理发货的Servlet ##

BussinessServiceImpl service = new BussinessServiceImpl(); String id = request.getParameter("id"); service.sendOutOrder(id); request.setAttribute("message", "已发货！"); request.getRequestDispatcher("/message.jsp").forward(request, response); return;

### **效果:** ###

![这里写图片描述][SouthEast 5]

--------------------

[SouthEast]: /images/20210827/41658783b79f4e3cbc60dd6d98f092bf.png
[http_blog.csdn.net_hon_3y_article_details_56481439_t5]: http://blog.csdn.net/hon_3y/article/details/56481439#t5
[SouthEast 1]: /images/20210827/e6a69f1721f74b268cda805469ee574d.png
[SouthEast 2]: /images/20210827/b4c636ce1f0b4d0fa37558bf44d8ce0f.png
[SouthEast 3]: /images/20210827/6b8b1731e245492ea066ecf70f77714d.png
[SouthEast 4]: /images/20210827/b5ececbeeff04e569f2d1cdda9d39ceb.png
[SouthEast 5]: /images/20210827/e61d9e38efdf4b80a044eb8aeaea0fbf.png