经验首页 前端设计 程序设计 Java相关 移动开发 数据库/运维 软件/图像 大数据/云计算 其他经验
当前位置：技术经验 » 数据库/运维 » MySQL » 查看文章
大项目之网上书城（九）——订单Demo
来源：cnblogs　　作者：return_false　　时间：2019/6/24 8:47:01　　对本文有异议

目录

大项目之网上书城（九）——订单Demo

主要改动

加了创建订单，为订单付款，删除订单。

1.OrderServiceImpl

代码

有添加、删除、付款、根据是否付款查找。还加了添加收货信息登记。

  1. package cn.edu.bdu.mc.services.impls;
  3. import java.sql.SQLException;
  4. import java.util.ArrayList;
  5. import java.util.List;
  6. import java.util.UUID;
  8. import cn.edu.bdu.mc.beans.Book;
  9. import cn.edu.bdu.mc.beans.Order;
  10. import cn.edu.bdu.mc.beans.Orderitem;
  11. import cn.edu.bdu.mc.daos.BookDao;
  12. import cn.edu.bdu.mc.daos.OrderDao;
  13. import cn.edu.bdu.mc.daos.OrderitemDao;
  14. import cn.edu.bdu.mc.daos.impls.BookDaoImpl;
  15. import cn.edu.bdu.mc.daos.impls.OrderDaoImpl;
  16. import cn.edu.bdu.mc.daos.impls.OrderitemDaoImpl;
  17. import cn.edu.bdu.mc.services.OrderService;
  19. public class OrderServiceImpl implements OrderService {
  20.     
  21.     private OrderDao orderDao = new OrderDaoImpl();
  22.     private OrderitemDao orderitemDao  = new OrderitemDaoImpl();
  23.     private BookDao bookDao = new BookDaoImpl();
  24.     
  25.     @Override
  26.     public boolean addOrder(String order_id, int user_id, String name, String address, String phone, String[] book_ids) throws SQLException {
  27.         // TODO Auto-generated method stub
  28.         List<Book>books = new ArrayList<Book>();
  29.         for (String book_id : book_ids) {   
  30.             Book book = bookDao.findBookById(Integer.parseInt(book_id));
  31.             books.add(book);
  32.             //如果数量不够了就本次购买失败
  33.             if(book.getCount()==0) {
  34.                 return false;
  35.             }
  36.         }
  37.         Order order = new Order();
  38.         order.setUser_id(user_id);
  39.         order.setReciver_name(name);
  40.         order.setReciver_phone(phone);
  41.         order.setReciver_address(address);
  42.         order.setOrder_id(order_id);
  43.         orderDao.addOrder(order);
  44.         for (Book book : books) {           
  45.             Orderitem orderitem = new Orderitem();
  46.             orderitem.setBook_id(book.getBook_id());
  47.             orderitem.setOrder_id(order_id);
  48.             orderitem.setCount(1);
  49.             orderitem.setPrice(book.getPrice());
  50.             book.setCount(book.getCount()-1);
  51.             bookDao.update(book);
  52.             orderitemDao.addOrderitem(orderitem);
  53.         }
  54.         return true;
  55.     }
  56.     
  57.     @Override
  58.     public void AfterPay(String order_id) throws SQLException {
  59.         Order order = orderDao.findOrderById(order_id);
  60.         order.setPaystate(1);
  61.         orderDao.update(order);
  62.     }
  64.     @Override
  65.     public Order delById(String order_id) throws SQLException {
  66.         // TODO Auto-generated method stub
  67.         Order order = orderDao.delById(order_id);
  68.         orderitemDao.delById(order_id);
  69.         return order;
  70.     }
  72.     @Override
  73.     public List<Order> findNotPayByUser_id(int user_id) throws SQLException {
  74.         // TODO Auto-generated method stub
  75.         return orderDao.findOrderByUser_id(user_id, 0);
  76.     }
  78.     @Override
  79.     public List<Order> findAreadyPayByUser_id(int user_id) throws SQLException {
  80.         // TODO Auto-generated method stub
  81.         return orderDao.findOrderByUser_id(user_id, 1);
  82.     }
  84.     
  85. }

2.OrderDaoImpl

代码

目前有添加、删除、根据order_id查找和根据user_id查找

  1. package cn.edu.bdu.mc.daos.impls;
  3. import java.sql.SQLException;
  4. import java.text.SimpleDateFormat;
  5. import java.util.Date;
  6. import java.util.List;
  8. import javax.sql.DataSource;
  10. import org.apache.commons.dbutils.QueryRunner;
  11. import org.apache.commons.dbutils.handlers.BeanHandler;
  12. import org.apache.commons.dbutils.handlers.BeanListHandler;
  14. import cn.edu.bdu.mc.beans.Order;
  15. import cn.edu.bdu.mc.daos.OrderDao;
  16. import cn.edu.bdu.mc.utils.JDBCUtil;
  18. public class OrderDaoImpl implements OrderDao {
  20.     private DataSource dataSource = JDBCUtil.getDataSource();
  21.     private QueryRunner queryRunner = new QueryRunner(dataSource);      
  22.     
  23.     @Override
  24.     public void addOrder(Order order) throws SQLException {
  25.         // TODO Auto-generated method stub
  26.         String sql = "insert into `order`(user_id,order_id,reciver_name,reciver_phone,reciver_address,paystate,money,order_time) values(?,?,?,?,?,0,0,?)";
  27.         Date date = new Date();
  28.         SimpleDateFormat dateFormat = new SimpleDateFormat("YYYY-MM-dd HH:mm:ss");
  29.         String date1 = dateFormat.format(date);
  30.         queryRunner.update(sql,order.getUser_id(),order.getOrder_id(),order.getReciver_name(),order.getReciver_phone(),order.getReciver_address(),date1);
  31.     }
  32.     
  33.     @Override
  34.     public void update(Order order) throws SQLException {
  35.         // TODO Auto-generated method stub
  36.         String sql = "update `order` set user_id = ?,reciver_name = ?,reciver_phone = ?,reciver_address = ?,paystate = ?,money = ?,order_time = ?";
  37.         queryRunner.update(sql,order.getUser_id(),order.getReciver_name(),order.getReciver_phone(),order.getReciver_address(),order.getPaystate(),order.getMoney(),order.getOrder_time());
  38.     }
  40.     @Override
  41.     public Order findOrderById(String order_id) throws SQLException {
  42.         // TODO Auto-generated method stub
  43.         String sql = "select * from `order` where order_id = ?";
  44.         return queryRunner.query(sql, new BeanHandler<Order>(Order.class), order_id);
  45.     }
  47.     @Override
  48.     public Order delById(String order_id) throws SQLException {
  49.         Order order = findOrderById(order_id);
  50.         String sql = "delete from `order` where order_id = ?";
  51.         queryRunner.update(sql, order_id);
  52.         return order;
  53.     }
  55.     @Override
  56.     public List<Order> findOrderByUser_id(int user_id, int paystate) throws SQLException {
  57.         // TODO Auto-generated method stub
  58.         String sql = "select * from `order` where user_id = ? and paystate = ?";
  59.         return queryRunner.query(sql, new BeanListHandler<Order>(Order.class), user_id, paystate);
  60.     }
  61.     
  62.     
  64. }

3.OrderitemDaoImpl

代码

目前有添加和删除

  1. package cn.edu.bdu.mc.daos.impls;
  3. import java.sql.SQLException;
  5. import javax.sql.DataSource;
  7. import org.apache.commons.dbutils.QueryRunner;
  9. import cn.edu.bdu.mc.beans.Orderitem;
  10. import cn.edu.bdu.mc.daos.OrderitemDao;
  11. import cn.edu.bdu.mc.utils.JDBCUtil;
  13. public class OrderitemDaoImpl implements OrderitemDao {
  15.     private DataSource dataSource = JDBCUtil.getDataSource();
  16.     private QueryRunner queryRunner = new QueryRunner(dataSource);      
  18.     @Override
  19.     public void addOrderitem(Orderitem orderitem) throws SQLException {
  20.         // TODO Auto-generated method stub
  21.         String sql = "insert into orderitem values (?,?,?,?)";
  22.         queryRunner.update(sql,orderitem.getOrder_id(),orderitem.getBook_id(),orderitem.getCount(),orderitem.getPrice());
  23.     }
  25.     @Override
  26.     public void delById(String order_id) throws SQLException {
  27.         // TODO Auto-generated method stub
  28.         String sql = "delete from `order` where order_id = ?";
  29.         queryRunner.update(sql, order_id);
  30.     }
  32. }

4.orderitem_insert触发器

代码

orderitem中每增加一项，将他对应的order_id的订单的钱增加上他的书的价格乘以数量。

  1. DROP TRIGGER IF EXISTS `orderitem_insert`;
  2. DELIMITER ;;
  3. CREATE TRIGGER `orderitem_insert` AFTER INSERT ON `orderitem` FOR EACH ROW begin
  4.     update `order` set money = money + new.price * new.count where order_id = new.order_id;
  5. end
  6. ;;
  7. DELIMITER ;

5.DelOrderServlet

代码

  1. package cn.edu.bdu.mc.servlets;
  3. import java.io.IOException;
  4. import java.sql.SQLException;
  5. import java.util.List;
  7. import javax.servlet.ServletException;
  8. import javax.servlet.annotation.WebServlet;
  9. import javax.servlet.http.HttpServlet;
  10. import javax.servlet.http.HttpServletRequest;
  11. import javax.servlet.http.HttpServletResponse;
  13. import cn.edu.bdu.mc.beans.Order;
  14. import cn.edu.bdu.mc.services.OrderService;
  15. import cn.edu.bdu.mc.services.impls.OrderServiceImpl;
  17. /**
  18.  * Servlet implementation class DelOrderServlet
  19.  */
  20. @WebServlet("/DelOrder")
  21. public class DelOrderServlet extends HttpServlet {
  22.     private static final long serialVersionUID = 1L;
  23.        
  24.     /**
  25.      * @see HttpServlet#HttpServlet()
  26.      */
  27.     public DelOrderServlet() {
  28.         super();
  29.         // TODO Auto-generated constructor stub
  30.     }
  32.     /**
  33.      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
  34.      */
  35.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  36.         try {
  37.             String order_id = request.getParameter("order_id");
  38.             OrderService orderService = new OrderServiceImpl();
  39.             Order order = orderService.delById(order_id);
  40.             response.sendRedirect(request.getContextPath()+"/client/order.jsp");
  41.         } catch (SQLException e) {
  42.             // TODO Auto-generated catch block
  43.             e.printStackTrace();
  44.         }
  45.     }
  47.     /**
  48.      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
  49.      */
  50.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  51.         // TODO Auto-generated method stub
  52.         doGet(request, response);
  53.     }
  55. }

6.NewOrderServlet

代码

  1. package cn.edu.bdu.mc.servlets;
  3. import java.io.IOException;
  4. import java.sql.SQLException;
  5. import java.util.ArrayList;
  6. import java.util.List;
  7. import java.util.Map;
  8. import java.util.UUID;
  10. import javax.servlet.ServletException;
  11. import javax.servlet.annotation.WebServlet;
  12. import javax.servlet.http.HttpServlet;
  13. import javax.servlet.http.HttpServletRequest;
  14. import javax.servlet.http.HttpServletResponse;
  15. import javax.servlet.http.HttpSession;
  17. import cn.edu.bdu.mc.beans.Order;
  18. import cn.edu.bdu.mc.beans.User;
  19. import cn.edu.bdu.mc.services.OrderService;
  20. import cn.edu.bdu.mc.services.impls.OrderServiceImpl;
  22. /**
  23.  * Servlet implementation class NewOrderServlet
  24.  */
  25. @WebServlet("/NewOrder")
  26. public class NewOrderServlet extends HttpServlet {
  27.     private static final long serialVersionUID = 1L;
  28.        
  29.     /**
  30.      * @see HttpServlet#HttpServlet()
  31.      */
  32.     public NewOrderServlet() {
  33.         super();
  34.         // TODO Auto-generated constructor stub
  35.     }
  37.     /**
  38.      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
  39.      */
  40.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  41.         if(request.getSession().getAttribute("shouhuo")==null) {
  42.             response.sendRedirect(request.getContextPath()+"/client/shouhuo.jsp");
  43.         }else {
  44.             try {
  45.                 String[] book_ids = request.getParameter("book_id_list").split("#");
  46.                 User user = (User) request.getSession().getAttribute("user");
  47.                 int user_id = user.getUser_id();
  48.                 Map<String, String>shouhuo = (Map<String, String>) request.getSession().getAttribute("shouhuo");
  49.                 String name = shouhuo.get("name");
  50.                 String phone = shouhuo.get("phone");
  51.                 String address = shouhuo.get("address");
  52.                 OrderService orderService = new OrderServiceImpl();
  53.                 String order_id = UUID.randomUUID().toString();
  54.                 boolean create_order = orderService.addOrder(order_id, user_id, name, address, phone, book_ids);
  55.                 if(create_order) {
  56.                     String htmlCode="<!DOCTYPE html>\n" + 
  57.                             "<html>"
  58.                             + "<head>"
  59.                             + "<link rel=\"stylesheet\" href=\""+request.getContextPath()+"/bootstrap-3.3.7-dist/css/bootstrap.min.css\">"
  60.                             + "</head>"
  61.                             + "<body>"
  62.                             + "<div style=\"position:absolute;left:44%;top:42%;height:140px;width:240px;background-color:rgba(145, 162, 196, 0.9);border:1px;text-align:center;\"id=\"quit1\">\r\n" + 
  63.                             "   <h3>订单创建成功！请尽快付款！</h3><a class=\"btn btn-info\" href=\""+request.getContextPath()+"/client/order.jsp\">查看订单</a>&nbsp;&nbsp;&nbsp;&nbsp;"
  64.                             +"<a class=\"btn btn-info\" href=\""+request.getContextPath()+"/PayFor?order_id=\""+order_id+">立即付款</a>\n" + 
  65.                             "</div>"
  66.                             + "</body>"
  67.                             + "</html>";
  68.                     response.getWriter().write(htmlCode);
  69.                 }else {
  70.                     String htmlCode="<!DOCTYPE html>\n" + 
  71.                             "<html>"
  72.                             + "<head>"
  73.                             + "<link rel=\"stylesheet\" href=\""+request.getContextPath()+"/bootstrap-3.3.7-dist/css/bootstrap.min.css\">"
  74.                             + "</head>"
  75.                             + "<body>"
  76.                             + "<div style=\"position:absolute;left:44%;top:46%;height:100px;width:240px;background-color:rgba(145, 162, 196, 0.9);border:1px;text-align:center;\"id=\"quit1\">\r\n" + 
  77.                             "   <h3>订单创建失败！请检查订单！</h3><a class=\"btn btn-info\" href=\""+request.getContextPath()+"/client/order.jsp\">查看订单</a>&nbsp;&nbsp;&nbsp;&nbsp;"
  78.                             +"<a class=\"btn btn-info\" href=\""+request.getContextPath()+"/client/index.jsp\">再逛逛</a>\n" + 
  79.                             "</div>"
  80.                             + "</body>"
  81.                             + "</html>";
  82.                     response.getWriter().write(htmlCode);
  83.                 }
  84.             } catch (SQLException e) {
  85.                 // TODO Auto-generated catch block
  86.                 e.printStackTrace();
  87.             }
  88.         }
  89.     }
  91.     /**
  92.      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
  93.      */
  94.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  95.         // TODO Auto-generated method stub
  96.         doGet(request, response);
  97.     }
  99. }

7.PayForServlet

代码

  1. package cn.edu.bdu.mc.servlets;
  3. import java.io.IOException;
  4. import java.sql.SQLException;
  5. import java.util.ArrayList;
  6. import java.util.List;
  8. import javax.servlet.ServletException;
  9. import javax.servlet.annotation.WebServlet;
  10. import javax.servlet.http.HttpServlet;
  11. import javax.servlet.http.HttpServletRequest;
  12. import javax.servlet.http.HttpServletResponse;
  13. import javax.servlet.http.HttpSession;
  15. import cn.edu.bdu.mc.beans.Order;
  16. import cn.edu.bdu.mc.beans.User;
  17. import cn.edu.bdu.mc.daos.OrderDao;
  18. import cn.edu.bdu.mc.daos.impls.OrderDaoImpl;
  19. import cn.edu.bdu.mc.services.OrderService;
  20. import cn.edu.bdu.mc.services.impls.OrderServiceImpl;
  22. /**
  23.  * Servlet implementation class PayForServlet
  24.  */
  25. @WebServlet("/PayFor")
  26. public class PayForServlet extends HttpServlet {
  27.     private static final long serialVersionUID = 1L;
  28.        
  29.     /**
  30.      * @see HttpServlet#HttpServlet()
  31.      */
  32.     public PayForServlet() {
  33.         super();
  34.         // TODO Auto-generated constructor stub
  35.     }
  37.     /**
  38.      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
  39.      */
  40.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  41.         
  42.         try {
  43.             String order_id = request.getParameter("order_id");
  44.             OrderService orderService = new OrderServiceImpl();
  45.             orderService.AfterPay(order_id);
  46.             String htmlCode="<!DOCTYPE html>\n" + 
  47.                     "<html>"
  48.                     + "<head>"
  49.                     + "<link rel=\"stylesheet\" href=\""+request.getContextPath()+"/bootstrap-3.3.7-dist/css/bootstrap.min.css\">"
  50.                     + "</head>"
  51.                     + "<body>"
  52.                     + "<div style=\"position:absolute;left:44%;top:46%;height:100px;width:240px;background-color:rgba(145, 162, 196, 0.9);border:1px;text-align:center;\"id=\"quit1\">\r\n" + 
  53.                     "   <h3>购买成功！</h3><a class=\"btn btn-info\" href=\""+request.getContextPath()+"/client/index.jsp\">继续购买</a>&nbsp;&nbsp;&nbsp;&nbsp;"
  54.                             +"<a class=\"btn btn-info\" href=\""+request.getContextPath()+"/client/order.jsp\">查看订单</a>\n" + 
  55.                     "</div>"
  56.                     + "</body>"
  57.                     + "</html>";
  58.             response.getWriter().write(htmlCode);
  59.         } catch (SQLException e) {
  60.             // TODO Auto-generated catch block
  61.             e.printStackTrace();
  62.         }
  63.         
  64.     }
  66.     /**
  67.      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
  68.      */
  69.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  70.         // TODO Auto-generated method stub
  71.         doGet(request, response);
  72.     }
  74. }

8.shouhuo.jsp

代码

  1. <%@ page language="java" contentType="text/html; charset=utf-8"
  2.     pageEncoding="utf-8"%>
  3. <!DOCTYPE html>
  4. <html>
  5. <head>
  6. <title>收货地址</title>
  7. </head>
  8. <body style="background-color:#bbb;width:1400px;margin:0 auto">
  9. <!-- 调用头部页面 -->
  10. <div style="width:100%;height:100px;float:left">
  11. <jsp:include page="/client/head.jsp"></jsp:include>
  12. </div>
  13. <!-- 通用内容体大小 -->
  14. <div style="width:70%;height:720px;float:left;margin-left:15%;">
  15.     <!-- 好看的图 -->
  16.     <div style="width:55%;height:100%;float:left;margin-top:10%;">
  17.         <img alt="快递员" src="${pageContext.request.contextPath }/client/img/kuaidi.jpg" style="width:90%;">
  18.     </div>
  19.     <!-- 登录界面 -->
  20.     <div style="width:45%;height:80%;float:left;margin-top:7%">
  21.         <h1 style="color:#8b6914;text-align:center">收货信息</h1>
  22.         <hr style="height:2px;border:none;border-top:5px ridge green;" />
  23.         <form action="${pageContext.request.contextPath }/ShouHuo" method="post" class="form-horizontal" role="form">
  24.             <div class="form-group">
  25.                 <label for="lastname" class="col-sm-3 control-label input-lg">姓名</label>
  26.                 <div class="col-sm-9">
  27.                     <input type="text" name="name" class="form-control input-lg"
  28.                            placeholder="收货人姓名" style="float:left"/>
  29.                 </div>
  30.             </div>
  31.             <div class="form-group">
  32.                 <label for="firstname" class="col-sm-3 control-label input-lg">手机号</label>
  33.                 <div class="col-sm-9">
  34.                     <input type="text" name="phone" 
  35.                     class="form-control input-lg" placeholder="收货人手机号" style="float:left"/>
  36.                 </div>
  37.             </div>
  38.             
  39.             <div class="form-group">
  40.                 <label for="firstname" class="col-sm-3 control-label input-lg">地址</label>
  41.                 <div class="col-sm-9">
  42.                     <input type="text" name="address"
  43.                     class="form-control input-lg" placeholder="收货人地址" style="float:left"/>
  44.                 </div>
  45.             </div>
  46.             <div class="form-group">
  47.                 <label for="firstname" class="col-sm-1 control-label input-lg"></label>
  48.                 <div class="col-sm-5">
  49.                     <input type="submit" name="submit" value="提交"
  50.                     class="form-control input-lg btn btn-primary"style="width:100%;float:left"/>
  51.                 </div>
  52.                 <div class="col-sm-5">
  53.                     <input type="reset" name="reset" value="重置" id="re"
  54.                     class="form-control input-lg btn btn-warning"style="width:100%;float:left"/>
  55.                 </div>
  56.             </div>
  57.         </form>
  58.     </div>
  59. </div>
  60. <!-- 调用底部页面 -->
  61. <div style="width:100%;height:60px;float:left">
  62. <jsp:include page="/client/foot.jsp"></jsp:include>
  63. </div>
  64. </body>
  65. </html>

效果图

9.order.jsp

代码

  1. <%@page import="cn.edu.bdu.mc.beans.User"%>
  2. <%@page import="cn.edu.bdu.mc.services.impls.OrderServiceImpl"%>
  3. <%@page import="cn.edu.bdu.mc.services.OrderService"%>
  4. <%@page import="cn.edu.bdu.mc.beans.Order"%>
  5. <%@page import="java.util.List"%>
  6. <%@ page language="java" contentType="text/html; charset=utf-8"
  7.     pageEncoding="utf-8"%>
  8. <!DOCTYPE html>
  9. <html>
  10. <head>
  11. <title>订单</title>
  12. </head>
  13. <%
  14.     User user = (User)request.getSession().getAttribute("user");
  15.     OrderService orderService = new OrderServiceImpl();
  16.     List<Order>notPay = orderService.findNotPayByUser_id(user.getUser_id());
  17.     List<Order>areadyPay = orderService.findAreadyPayByUser_id(user.getUser_id());
  18.     
  19. %>
  20. <body style="background-color:#bbb;width:1400px;margin:0 auto">
  21. <!-- 调用头部页面 -->
  22. <div style="width:100%;height:100px;float:left">
  23. <jsp:include page="/client/head.jsp"></jsp:include>
  24. </div>
  25. <!-- 通用内容体大小 -->
  26. <div style="width:70%;height:720px;float:left;margin-left:15%;">
  27.     未付款：<br>
  28.     <% if(notPay==null){ %>
  29.         无<br>
  30.     <% }else{ %>
  31.         <% for(Order order : notPay){%>
  32.             id=<font><%=order.getOrder_id() %></font>&nbsp;&nbsp;money=<font><%=order.getMoney() %></font>&nbsp;&nbsp;
  33.             <a href="${pageContext.request.contextPath }/PayFor?order_id=<%=order.getOrder_id() %>">付款</a>&nbsp;&nbsp;
  34.             <a href="${pageContext.request.contextPath }/DelOrder?order_id=<%=order.getOrder_id() %>">删除</a>&nbsp;&nbsp;
  35.             <br>
  36.         <% } %>
  37.     <% } %>
  38.     已付款：<br>
  39.     <% if(areadyPay==null){ %>
  40.         无<br>
  41.     <% }else{ %>
  42.         <% for(Order order : areadyPay){%>
  43.             id=<font><%=order.getOrder_id() %></font>&nbsp;&nbsp;money=<font><%=order.getMoney() %></font>&nbsp;&nbsp;
  44.             <br>
  45.         <% } %>
  46.     <% } %>
  47. </div>
  48. <!-- 调用底部页面 -->
  49. <div style="width:100%;height:60px;float:left">
  50. <jsp:include page="/client/foot.jsp"></jsp:include>
  51. </div>
  52. </body>
  53. </html>

效果图

点击付款后，还删除了一个，忘截图了

总结

今天弄得不是很多，又是各种报错。再加上开始的晚，于是拖到了现在才更。

原文链接：http://www.cnblogs.com/zhangA/p/11071231.html

 友情链接：直通硅谷 　点职佳 　北美留学生论坛

MySQL热门文章

  • 大项目之网上书城（九）——订单Demo
  • CentOS7下MySQL服务启动失败原因及解决方法
  • MySQL从删库到跑路_高级（六）——索引
  • 55 道MySQL基础题
  • MySQL与PHP的基础与应用专题之自连接
  • 树形结构的菜单表设计与查询
  • MYSQL语句
  • 《高性能MySQL（第3版）》PDF免费下载
  • 《MySQL必知必会》知识汇总二
  • 【必知必会的MySQL知识】④DCL语言

    • MySQL推荐文章

  • 如何让SQL Server像MySQL一样拥有慢查询日志（Slow Query Log慢日志）
  • MySQL中为什么要使用索引合并(Index Merge)？
  • MySQL派生表合并优化的原理和实现
  • 使用EF 连接 数据库 SQLserver、MySql 实现 CodeFirst
  • 升级到 MySQL 8.4，MySQL 启动报错：io_setup() failed with EAGAIN
  • TiKV 源码分析之 PointGet
  • 异构数据源同步之数据同步 → DataX 使用细节
  • 一文搞懂 MySQL 日志
  • 浅析MySQL 8.0直方图原理
  • 分布式任务调度内的 MySQL 分页查询优化

    • 本站QQ群：前端 618073944 | Java 606181507 | Python 626812652 | C/C++ 612253063 | 微信 634508462 | 苹果 692586424 | C#/.net 182808419 | PHP 305140648 | 运维 608723728

    W3xue 的所有内容仅供测试，对任何法律问题及风险不承担任何责任。通过使用本站内容随之而来的风险与本站无关。
    关于我们  |  意见建议  |  捐助我们  |  报错有奖  |  广告合作、友情链接（目前9元/月）请联系QQ：27243702 沸活量
    皖ICP备17017327号-2　皖公网安备34020702000426号