當前位置：首頁 > 编程资源 > 综合教程 >内容正文

综合教程

Java Web之网上购物系统（提交订单、查看我的订单）

發(fā)布時間：2023/12/29 综合教程 27 生活家

生活随笔收集整理的這篇文章主要介紹了 Java Web之网上购物系统（提交订单、查看我的订单）小編覺得挺不錯的,現(xiàn)在分享給大家,幫大家做個參考.

作業(yè)終于做完了，好開心。。。。。。雖然這一周經(jīng)歷不是那么順利，但是覺得還是收獲了不少，有過想哭的沖動，代碼不會寫，事情辦不好，各種發(fā)愁?？臻g里發(fā)小發(fā)了帶父母出去游玩的照片，瞬間能量值不知道是被擊退的多還是回返的多。不過今天終于補滿能量值。下面我來分享一下我的運行結(jié)果。

下面我把我管理后臺的代碼粘貼一下

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
    <head>
        <title>top.jsp</title>
        <style type="text/css">
body {
    text-align: center;
    font-size: 38px;
}

* {
    font-family: 華文楷體;
    font-size: 18px;
    color: #F0F ";
}

h1 {
    text-align: center;
    font-size: 38px;
}
</style>
    </head>

    <body>
        <h1>
            歡迎登錄網(wǎng)上購物后臺
        </h1>

        <form action="<c:url value='/AdminServlet'/>" method="post">
            <input type="hidden" name="method" value="1">
            用戶名:
            <input type="text" name="username" />
            <br />
            密 &nbsp; 碼:
            <input type="password" name="password" />
            <br />
            <input type="submit" value="登錄">
        </form>
    </body>
</html>

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
    <head>
        <title>list.jsp</title>
        <style type="text/css">
body {
    text-align: center;
    font-size: 38px;
}

* {
    font-family: 華文楷體;
    font-size: 18px;
    color: #F0F ";
}
img{
    width: 50px;
    height: 30px;


}
h1 {
    text-align: center;
    font-size: 38px;
}

a:link {
    color: #999;
    text-decoration: none;
}

a:VISITED {
    text-decoration: none;
    color: #c60;
}

a:HOVER {
    text-decoration: none;
    color: #00F;
}
</style>

    </head>

    <body>
        <h1>
            歡迎登錄到網(wǎng)上購物后臺系統(tǒng)
        </h1>
        <a
            href="<c:url value='/AdminServlet?method=2'/>">查看商品</a>
        <a href="<c:url value='/admin/add.jsp'/>">添加商品</a>
        <a
            href="<c:url value='/AdminServlet?method=7'/>">查看訂單</a>
        <a href="<c:url value='/admin/login.jsp'/>">退出系統(tǒng)</a>

        <table border="1" align="center" width="60%">
            <tr>
                <th>
                    商品名
                </th>
                <th>
                    價格
                </th>
                <th>
                    類型
                </th>
                <th>
                    數(shù)量
                </th>
                <th>
                    圖片
                </th>
                <th>
                    描述
                </th>
                <th>
                    操作
                </th>

            </tr>
            <c:forEach items="${pb.datas }" var="c">
                <tr>
                    <td>
                        ${c.name }
                    </td>
                    <td>
                        ${c.price }
                    </td>
                    <td>
                        ${c.category }
                    </td>
                    <td>
                        ${c.pnum}
                    </td>
                    <td>
                        <a href="<c:url value='/AdminServlet?method=9&id=${c.id }'/>"><img  src="${c.imgurl }"/> </a>
                    </td>
                    <td>
                        ${c.description }
                    </td>

                    <td>
                        <a href="<c:url value='/AdminServlet?method=4&id=${c.id }'/>">編輯</a>
                        <a href="<c:url value='/OrderServlet?method=4&id=${c.id }'/>">刪除</a>
                    </td>
                </tr>
            </c:forEach>
        </table>
        <br>
        第${pb.pageCode }頁/共${pb.totalPage }頁
        <a href="<c:url value='/AdminServlet?method=2'/>">首頁</a>
        <c:if test="${pb.pageCode > 1}">
            <a
                href="<c:url value='/AdminServlet?method=2&pageCode=${pb.pageCode-1}'/>">上一頁</a>
        </c:if>
        <%--頁碼列表 --%>
        <c:set var="begin" value="1" />
        <c:set var="end" value="10" />

        <!-- 定位begin和end -->
        <c:choose>
            <c:when test="${pb.totalPage <= 10}">
                <c:set var="begin" value="1" />
                <c:set var="end" value="${pb.totalPage}" />
            </c:when>
            <c:otherwise>
                <c:choose>
                    <c:when test="${pb.pageCode-4 <= 1 }">
                        <c:set var="begin" value="1" />
                        <c:set var="end" value="10" />
                    </c:when>
                    <c:when test="${pb.pageCode+5 > pb.totalPage}">
                        <c:set var="begin" value="${pb.totalPage-9}" />
                        <c:set var="end" value="${pb.totalPage}" />
                    </c:when>
                    <c:otherwise>
                        <c:set var="begin" value="${pb.pageCode-4}" />
                        <c:set var="end" value="${pb.pageCode+5}" />
                    </c:otherwise>
                </c:choose>
            </c:otherwise>
        </c:choose>
        <c:forEach begin="${begin}" end="${end}" var="i">
            <c:choose>
                <c:when test="${pb.pageCode == i}">${i}</c:when>
                <c:otherwise>
                    <a href="<c:url value='/AdminServlet?method=2&pageCode=${i}'/>">${i
                        }</a>
                </c:otherwise>
            </c:choose>
        </c:forEach>

        <c:if test="${pb.pageCode < pb.totalPage}">
            <a
                href="<c:url value='/AdminServlet?method=2&pageCode=${pb.pageCode+1}'/>">下一頁</a>
        </c:if>
        <a
            href="<c:url value='/AdminServlet?method=2&pageCode=${pb.totalPage }'/>">尾頁</a>

    </body>
</html>

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
    <head>
        <title>add.jsp</title>
        <style type="text/css">
body {
    text-align: center;
    font-size: 38px;
}

* {
    font-family: 華文楷體;
    font-size: 18px;
    color: #F0F ";
}

h1 {
    text-align: center;
    font-size: 38px;
}
</style>

    </head>

    <body>

        <h1>
            添加商品
        </h1>

        <form action="<c:url value='/AdminServlet'/>" method="post">
            <input type="hidden" name="method" value="3">
            <table border="1" width="50%" align="center">
                <tr>
                    <td>
                        商品名
                    </td>
                    <td>
                        <input type="text" name="name" id="name" onfocus="nameFocus()"
                            onblur="nameBlur()" />
                        <div id="nameId"></div>
                    </td>
                </tr>
                <tr>
                    <td>
                        價格
                    </td>
                    <td>
                        <input type="text" name="price" id="tel" onfocus="telFocus()"
                            onblur="telBlur()" />
                        <div id="telId"></div>
                    </td>
                </tr>
                <tr>
                    <td>
                        類型
                    </td>
                    <td>
                        <input type="text" name="category" id="address" />
                    </td>
                </tr>
                <tr>
                    <td>
                        數(shù)量
                    </td>
                    <td>
                        <input type="text" name="pnum" />
                    </td>
                </tr>
            
                <tr>
                    <td>
                        描述
                    </td>
                    <td>
                        <input type="text" name="description" />
                    </td>
                </tr>


            </table>
            <input type="submit" value="添加" />

        </form>
    </body>
</html>

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
    <head>
        <title>edit.jsp</title>
    </head>

    <body>
        <h3>
            修改商品信息
        </h3>
        <form action="<c:url value='/AdminServlet'/>" method="post">
            <input type="hidden" name="method" value="5">
            <input type="hidden" name="id" value="${product.id }">
            <table border="1" width="50%" align="center">
                <tr>
                    <td>
                        商品名
                    </td>
                    <td>
                        <input type="text" name="name" value="${product.name }" />
                    </td>
                </tr>
                <tr>
                    <td>
                        價格
                    </td>
                    <td>
                        <input type="text" name="price" value="${product.price }" />
                    </td>
                </tr>
                <tr>
                    <td>
                        類型
                    </td>
                    <td>
                        <input type="text" id="birthday" name="category"
                            value="${product.category }" />
                    </td>
                </tr>
                <tr>
                    <td>
                        數(shù)量
                    </td>
                    <td>
                        <input type="text" name="pnum" value="${product.pnum }" />
                    </td>
                </tr>

                <tr>
                    <td>
                        描述
                    </td>
                    <td>
                        <input type="text" name="description"
                            value="${product.description }" />
                    </td>
                </tr>

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
    <head>
        <title>list.jsp</title>
    </head>

    <body>
        <center>
            <h1>
                查看所有訂單
            </h1>
            <table border="2" width="80%">
                <tr align="left">
                    <th>
                        序號
                    </th>
                    <th>
                        訂單號
                    </th>
                    <th>
                        訂單金額
                    </th>
                    <th>
                        時間
                    </th>
                    <th>
                        狀態(tài)
                    </th>
                    <th>
                        買家詳情
                    </th>
                    <th>
                        物流信息
                    </th>
                    <th>
                        交易狀態(tài)
                    </th>
                    <th>
                        操作
                    </th>
                </tr>
                <c:forEach items="${allorderList}" var="order" varStatus="status">
                    <tr>
                        <td>
                            ${status.count}
                        </td>
                        <td>
                            ${order.id }
                        </td>
                        <td>
                            ${order.totalMoney }
                        </td>
                        <td>
                            ${order.ordertime}
                        </td>
                        <td>
                            <c:if test="${order.paysate == 0 }">
                            未支付
                        </c:if>
                            <c:if test="${order.paysate == 1 }">
                            已支付
                        </c:if>
                        </td>
                        <td>
                            ${order.receiverName }
                        </td>
                        <td>
                            <c:if test="${order.paysate == 0 }">
                            未發(fā)貨
                        </c:if>
                            <c:if test="${order.paysate == 1 }">
                            已發(fā)貨
                        </c:if>
                        </td>
                        <td>
                            交易中
                        </td>
                        <td>
                            <a href="<c:url value='/OrderServlet?method=4&id=${order.id }'/>">刪除</a>
                        </td>
                    </tr>
                    <c:set value="${total + entry.key.price*entry.value}" var="total" />
                </c:forEach>
            </table>
        </center>
    </body>
</html>

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
    <head>
        <title>updateorder.jsp</title>
    </head>

    <body>
        <h3>
            修改訂單信息
        </h3>
        <form action="<c:url value='/AdminServlet'/>" method="post">
            <input type="hidden" name="method" value="5">
            <input type="hidden" name="id" value="${product.id }">
            <table border="1" width="50%" align="center">
                <tr>
                    <td>
                        訂單號
                    </td>
                    <td>
                        ${order.id }
                    </td>
                </tr>
                <tr>
                    <td>
                        買家姓名
                    </td>
                    <td>
                        <input type="text" name="receiverName"
                            value="${order.receiverName }" />
                    </td>
                </tr>
                <tr>
                    <td>
                        收貨地址
                    </td>
                    <td>
                        <input type="text" id="birthday" name="receiverAddress"
                            value="${order.receiverAddress }" />
                    </td>
                </tr>
                <tr>
                    <td>
                        收獲電話
                    </td>
                    <td>
                        <input type="text" name="receiverPhone"
                            value="${order.receiverPhone }" />
                    </td>
                </tr>
                <tr>
                    <td>
                        物流信息
                    </td>
                    <td>
                        在路上
                    </td>
                </tr>
                <tr>
                    <td>
                        交易狀態(tài)
                    </td>
                    <td>
                        交易中
                    </td>
                </tr>
                <tr>
                    <td colspan="2" align="center">
                        <input type="submit" value="更改" />
                    </td>
                </tr>
            </table>
        </form>
    </body>
</html>

<%@ page language="java"  import="java.util.*" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>upload.jsp</title>
    </head>
    <body>
        
        <form method="post" action="/shopping/AdminServlet?method=8&id=${product.id }"
            enctype="multipart/form-data">
            選擇一個文件:
            <input type="file" name="imgurl"/>
            <br />
            <br />
            <input type="submit" value="上傳" />
        </form>
    </body>
</html>

                <tr>
                    <td colspan="2" align="center">
                        <input type="submit" value="更改" />
                    </td>
                </tr>
            </table>
        </form>
    </body>
</html>

package cn.edu.aynu.rjxy.servlet;

import java.io.File;
import java.io.IOException;
import java.io.PrintWriter;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

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 org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;

import cn.edu.aynu.rjxy.bean.Admin;
import cn.edu.aynu.rjxy.bean.Order;
import cn.edu.aynu.rjxy.bean.Page;
import cn.edu.aynu.rjxy.bean.Product;
import cn.edu.aynu.rjxy.service.AdminService;
import cn.edu.aynu.rjxy.service.OrderService;
import cn.edu.aynu.rjxy.service.ProductService;
import cn.edu.aynu.rjxy.utils.CommonsUtils;

public class AdminServlet extends HttpServlet {
    private AdminService aService = new AdminService();
    private ProductService ps = new ProductService();
    private OrderService os = new OrderService();
    private static final long serialVersionUID = 1L;
    // 上傳文件存儲目錄
    private static final String UPLOAD_DIRECTORY = "img";
    // 上傳配置
    private static final int MEMORY_THRESHOLD = 1024 * 1024 * 3; // 3MB
    private static final int MAX_FILE_SIZE = 1024 * 1024 * 40; // 40MB
    private static final int MAX_REQUEST_SIZE = 1024 * 1024 * 50; // 50MB

    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        this.doPost(request, response);
    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        // 處理中文亂碼
        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=UTF-8");
        // 獲取隱藏字段method的值，并把它轉(zhuǎn)換為int型
        int method = Integer.parseInt(request.getParameter("method"));

        switch (method) {

        case 1:
            this.login(request, response);
            break;
        case 2:
            this.query(request, response);
            break;
        case 3:
            this.add(request, response);
            break;
        case 4:
            this.loadForUpdate(request, response);
            break;
        case 5:
            this.edit(request, response);
            break;
        case 6:
            this.delete(request, response);
            break;
        case 7:
            this.order(request, response);
            break;
        case 8:
            this.uploadpicture(request, response);
            break;
        case 9:
            this.uploadForpicture(request, response);
            break;

        }

    }

    // 管理員登錄
    public void login(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        // 從請求中解析用戶名和密碼
        String username = request.getParameter("username");
        String password = request.getParameter("password");
        // 執(zhí)行加載業(yè)務
        Admin a = aService.login(username, password);
        if (a != null) {
            HttpSession session = request.getSession();
            session.setAttribute("userId", a.getId());
            response.getWriter().print("登錄成功" + a.getId());
            // 通過請求轉(zhuǎn)發(fā)將pb帶到list.jsp上去
            request.getRequestDispatcher("/admin/list.jsp").forward(request,
                    response);
        } else {
            response.getWriter().print("登錄失敗，即將跳轉(zhuǎn)到登錄頁面，請重新登錄......");
            response.setHeader("Refresh", "3;url=/shopping/admin/login.jsp");

        }

    }

    // 管理員查看商品
    public void query(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        // 當前頁有一個默認值為1
        int pageCode = 1;
        String s = request.getParameter("pageCode");
        // 如果請求中存在pageCode參數(shù)
        if (s != null && !s.trim().isEmpty()) {
            pageCode = Integer.parseInt(s);
        }
        // 查詢當前頁的記錄
        Page pb = ps.queryByPage(pageCode);
        // 將pb保存在request域中
        request.setAttribute("pb", pb);
        // 通過請求轉(zhuǎn)發(fā)將pb帶到list.jsp上去
        request.getRequestDispatcher("/admin/list.jsp").forward(request,
                response);
    }

    // 管理員添加商品
    public void add(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        // 使用CommonUtils工具類將請求數(shù)據(jù)封裝到bean中
        Product p = CommonsUtils.toBean(request.getParameterMap(),
                Product.class);
        // 使用UUID作為id屬性的值
        p.setId(CommonsUtils.uuid());
        // p.setImgurl(uploadPath);
        // 執(zhí)行添加
        ps.add(p);
        // 輸出添加成功提示
        response.getWriter().print("添加成功");
    }

    // 加載商品為修改做準備
    public void loadForUpdate(HttpServletRequest request,
            HttpServletResponse response) throws ServletException, IOException {
        // 從請求中獲取客戶的id
        String id = request.getParameter("id");
        // 執(zhí)行加載業(yè)務
        Product p = ps.findById(id);
        // 將Customer對象c保存在request域中
        request.setAttribute("product", p);
        // t=通過請求轉(zhuǎn)發(fā)將customer對象顯示在list.jsp頁面上
        request.getRequestDispatcher("/admin/edit.jsp").forward(request,
                response);

    }

    // 管理員修改商品信息
    public void edit(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        // 使用CommonUtils工具類將請求數(shù)據(jù)封裝到bean中
        Product p = CommonsUtils.toBean(request.getParameterMap(),
                Product.class);
        // 執(zhí)行更改業(yè)務
        ps.edit(p);
        // 給客戶端發(fā)送更改成功提示
        response.getWriter().print("更改成功");

    }

    // 管理員刪除商品
    public void delete(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        // 從請求中獲取id
        String id = request.getParameter("id");
        // 執(zhí)行刪除
        ps.delete(id);
        // 給客戶端發(fā)送刪除成功提示
        response.getWriter().print("刪除成功");

    }

    // 管理員查看所有訂單
    public void order(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        List<Order> list = os.findAllOrder();
        request.setAttribute("allorderList", list);
        request.getRequestDispatcher("/admin/orderproduct.jsp").forward(
                request, response);
    }

    // 為上傳照片做準備
    public void uploadForpicture(HttpServletRequest request,
            HttpServletResponse response) throws ServletException, IOException {
        String id = request.getParameter("id");
        Product p = ps.findById(id);
        System.out.println(id + "id");
        ps.upload(p, id);
        // 將Customer對象c保存在request域中
        request.setAttribute("product", p);
        // t=通過請求轉(zhuǎn)發(fā)將customer對象顯示在list.jsp頁面上
        request.getRequestDispatcher("/admin/upload.jsp").forward(request,
                response);
    }

    // 管理員上傳照片
    public void uploadpicture(HttpServletRequest request,
            HttpServletResponse response) throws ServletException, IOException {
        // 檢測是否為多媒體上傳
        if (!ServletFileUpload.isMultipartContent(request)) {
            // 如果不是則停止
            PrintWriter writer = response.getWriter();
            writer.println("Error: 表單必須包含 enctype=multipart/form-data");
            writer.flush();
            return;
        }

        // 配置上傳參數(shù)
        DiskFileItemFactory factory = new DiskFileItemFactory();
        // 設置內(nèi)存臨界值 - 超過后將產(chǎn)生臨時文件并存儲于臨時目錄中
        factory.setSizeThreshold(MEMORY_THRESHOLD);
        // 設置臨時存儲目錄
        factory.setRepository(new File(System.getProperty("java.io.tmpdir")));

        ServletFileUpload upload = new ServletFileUpload(factory);

        // 設置最大文件上傳值
        upload.setFileSizeMax(MAX_FILE_SIZE);

        // 設置最大請求值 (包含文件和表單數(shù)據(jù))
        upload.setSizeMax(MAX_REQUEST_SIZE);

        // 構(gòu)造臨時路徑來存儲上傳的文件
        // 這個路徑相對當前應用的目錄
        String uploadPath = getServletContext().getRealPath("")
                + File.separator + UPLOAD_DIRECTORY;
        // 如果目錄不存在則創(chuàng)建
        File uploadDir = new File(uploadPath);
        if (!uploadDir.exists()) {
            uploadDir.mkdir();
        }

        try {
            // 解析請求的內(nèi)容提取文件數(shù)據(jù)
            @SuppressWarnings("unchecked")
            List<FileItem> formItems = upload.parseRequest(request);

            if (formItems != null && formItems.size() > 0) {
                // 迭代表單數(shù)據(jù)
                for (FileItem item : formItems) {
                    // 處理不在表單中的字段
                    if (!item.isFormField()) {

                        Date date = new Date();
                        DateFormat format = new SimpleDateFormat(
                                "yyyy-MM-dd-HH-mm-ss");
                        String time = format.format(date);
                        String filePath = uploadPath + File.separator + time
                                + ".jpg";
                        File storeFile = new File(filePath);
                        // 使用CommonUtils工具類將請求數(shù)據(jù)封裝到bean中
                        Product p = CommonsUtils.toBean(request
                                .getParameterMap(), Product.class);
                        String url = "/" + "shopping" + "/" + UPLOAD_DIRECTORY
                                + "/" + time + ".jpg";
                        p.setImgurl(url);
                        // 執(zhí)行更改業(yè)務
                        ps.upload(p, p.getId());

                        // 在控制臺輸出文件的上傳路徑
                         System.out.println(filePath);
                        System.out.println("/" + "shopping" + "/"
                                + UPLOAD_DIRECTORY + "/" + time + ".jpg");
                        // 保存文件到硬盤
                        item.write(storeFile);
                        request.setAttribute("message", "文件上傳成功!");
                    }
                }
            }
        } catch (Exception ex) {
            request.setAttribute("message", "錯誤信息: " + ex.getMessage());
        }
        response.getWriter().print("上傳成功,三秒后跳轉(zhuǎn)到功能界面......");
        response.setHeader("Refresh", "3;url=/shopping/admin/list.jsp");
    }

}

package cn.edu.aynu.rjxy.servlet;

import java.io.IOException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import cn.edu.aynu.rjxy.bean.Order;
import cn.edu.aynu.rjxy.bean.OrderItem;
import cn.edu.aynu.rjxy.bean.Product;
import cn.edu.aynu.rjxy.bean.User;
import cn.edu.aynu.rjxy.service.OrderService;
import cn.edu.aynu.rjxy.utils.CommonsUtils;

public class OrderServlet extends HttpServlet {
    private OrderService orderService = new OrderService();

    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        this.doPost(request, response);

    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        // 處理中文亂碼
        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=UTF-8");
        // 獲取隱藏字段method的值，并把它轉(zhuǎn)換為int型
        int method = Integer.parseInt(request.getParameter("method"));

        switch (method) {
        case 1:
            this.addOrder(request, response);
            break;
        case 2:
            this.findMyOrder(request, response);
            break;
        case 3:
            this.findOrderItem(request, response);
            break;
        case 4:
            this.delete(request, response);
            break;

        }

    }

    // 添加訂單和訂單項
    public void addOrder(HttpServletRequest request,
            HttpServletResponse response) throws ServletException, IOException {
        /**
         * 1、判斷用戶是否登錄，如果未登錄就重定向到login.jsp 2、使用工具類將訂單表中的信息封裝成order對象，補全剩余的字段
         * 3、從session中獲取購物車，遍歷購物車，創(chuàng)建訂單項，把它們加入list集合 4、添加訂單和訂單項
         */
        User user = (User) request.getSession().getAttribute("user");
        if (user == null) {
            response.sendRedirect("jsp/login.jsp");
            return;
        }
        Order order = CommonsUtils.toBean(request.getParameterMap(),
                Order.class);
        // 補全字段
        order.setId(CommonsUtils.uuid());
        order.setOrdertime(new Date());
        order.setPaysate(0);
        order.setUser_id(user.getId());
        Map<Product, Integer> cart = (Map<Product, Integer>) request
                .getSession().getAttribute("cart");
        List<OrderItem> list = new ArrayList<OrderItem>();
        for (Product p : cart.keySet()) {
            OrderItem orderItem = new OrderItem();
            orderItem.setId(CommonsUtils.uuid());
            orderItem.setOrder_id(order.getId());
            orderItem.setProduct_id(p.getId());
            orderItem.setBuynum(cart.get(p));
            orderItem.setSubtotal(p.getPrice() * orderItem.getBuynum());
            // 訂單項加入list集合
            list.add(orderItem);
        }
        order.setList(list);
        // 添加訂單和訂單項
        String result = orderService.addOrder(order);
        request.setAttribute("orderResult", result);
        response.getWriter().print("購買成功,三秒后跳轉(zhuǎn)到商品界面......");
        response.setHeader("Refresh", "3;url=/shopping/index.jsp");
    }

    // 查看我的訂單
    public void findMyOrder(HttpServletRequest request,
            HttpServletResponse response) throws ServletException, IOException {
        /**
         * 1、用戶已經(jīng)登錄，從session中獲取用戶信息，從用戶信息中得到user_id 2、調(diào)用方法得到用戶的訂單的集合
         * 3、通過請求轉(zhuǎn)發(fā)將訂單集合顯示在myorder.jsp頁面上
         */
        User user = (User) request.getSession().getAttribute("user");
        String user_id = user.getId();
        List<Order> list = orderService.findMyOrder(user_id);
        request.setAttribute("myorderList", list);
        request.getRequestDispatcher("/jsp/myorder.jsp").forward(request,
                response);

    }

    // 查看我的訂單的詳情
    public void findOrderItem(HttpServletRequest request,
            HttpServletResponse response) throws ServletException, IOException {
        /**
         * 1、從請求轉(zhuǎn)發(fā)中獲取訂單的id 2、調(diào)用方法得到訂單詳情的集合 3、通過請求轉(zhuǎn)發(fā)將訂單詳情在orderItem.jsp頁面上顯示
         */
        String order_id = request.getParameter("order_id");
        System.out.println(order_id + "ssssss");
        List<OrderItem> list = orderService.findOrderItem(order_id);
        request.setAttribute("orderItemList", list);
        request.getRequestDispatcher("/jsp/orderitem.jsp").forward(request,
                response);

    }

    public void delete(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        // 從請求中獲取id
        String id = request.getParameter("id");
        // 執(zhí)行刪除客戶業(yè)務
        orderService.delete(id);
        // 給客戶端發(fā)送刪除成功提示
        response.getWriter().print("刪除成功,三秒后跳轉(zhuǎn)到功能界面......");
        response.setHeader("Refresh", "3;url=/shopping/admin/list.jsp");

    }
}

package cn.edu.aynu.rjxy.servlet;

import java.io.IOException;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

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 cn.edu.aynu.rjxy.bean.Product;
import cn.edu.aynu.rjxy.service.ProductService;

/**
 * 調(diào)用ProductService的方法
 * 
 * @author Administrator
 * 
 */
public class ProductServlet extends HttpServlet {
    private ProductService ps = new ProductService();

    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        this.doPost(request, response);
    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        // 處理中文亂碼
        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=UTF-8");
        // 獲取隱藏字段method的值，并把它轉(zhuǎn)換為int型
        int method = Integer.parseInt(request.getParameter("method"));

        switch (method) {
        case 1:
            this.findAll(request, response);
            break;
        case 2:
            this.addCart(request, response);
            break;
        }

    }

    // 處理查詢所有商品的請求
    public void findAll(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        List<Product> list = ps.findAll();
        request.setAttribute("listProduct", list);
        // 通過請求轉(zhuǎn)發(fā)將商品信息顯示在product.jsp頁面上
        request.getRequestDispatcher("/jsp/product.jsp").forward(request,
                response);
    }

    // 處理添加購物車的請求
    public void addCart(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        // 獲取商品的id
        String id = request.getParameter("id");
        // 得到商品
        Product p = ps.findById(id);
        // 購物車是保存在session中
        HttpSession session = request.getSession();
        // 從session中拿到購物車
        Map<Product, Integer> cart = (Map<Product, Integer>) session
                .getAttribute("cart");
        // 如果cart不存在，就創(chuàng)建購物車
        if (cart == null) {
            cart = new HashMap<Product, Integer>();
        }
        /**
         * 遍歷Map中的所有key也就是商品對象，如果發(fā)現(xiàn)有的商品的id和 即將加入購物車的id相同，就在原來的數(shù)量上＋1
         */
        Iterator<Product> it = cart.keySet().iterator();
        boolean f = true;
        while (it.hasNext()) {
            Product pp = (Product) it.next();
            if (pp.getId().equals(p.getId())) {
                cart.put(pp, cart.get(pp) + 1);
                f = false;
            }
        }
        // 如果沒有發(fā)現(xiàn)購物車原來相同的商品，就直接加入
        if (f) {
            cart.put(p, 1);
        }
        // 將cart放入session
        session.setAttribute("cart", cart);
        // 重定向
        response.sendRedirect("jsp/cart.jsp");

    }

}

package cn.edu.aynu.rjxy.servlet;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import cn.edu.aynu.rjxy.bean.User;
import cn.edu.aynu.rjxy.exception.UserException;
import cn.edu.aynu.rjxy.service.UserService;
import cn.edu.aynu.rjxy.utils.CommonsUtils;

/**
 * 調(diào)用UserService里面的方法
 * 
 * @author Administrator
 * 
 */
public class UserServlet extends HttpServlet {

    private UserService userService = new UserService();

    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        this.doPost(request, response);

    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        // 處理中文亂碼
        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=UTF-8");
        // 獲取隱藏字段method的值，并把它轉(zhuǎn)換為int型
        int method = Integer.parseInt(request.getParameter("method"));

        switch (method) {
        case 1:
            this.register(request, response);
            break;
        case 2:
            this.login(request, response);
            break;

        }
    }

    public void register(HttpServletRequest request,
            HttpServletResponse response) throws ServletException, IOException {
        /**
         * 1、將注冊表單中的用戶信息封裝到user對象中 2、將獲取的ＵＵＩＤ值作為ｕｓｅｒ?qū)ο蟮模椋?         * ３、注冊，如果發(fā)生異常，就到register.jsp頁面上顯示：用戶已存在 如果成功，顯示注冊成功，3秒后就跳轉(zhuǎn)到index.jsp頁面。
         */
        User user = CommonsUtils.toBean(request.getParameterMap(), User.class);
        user.setId(CommonsUtils.uuid());
        try {
            userService.register(user);
            request.setAttribute("msg", "注冊成功");
            request.getRequestDispatcher("/jsp/index.jsp").forward(request,
                    response);
        } catch (UserException e) {
            request.setAttribute("msg", e.getMessage());
            // 將用戶在注冊表單中輸入的信息保存在request域中，請求轉(zhuǎn)發(fā)的register.jsp，目的回顯
            request.setAttribute("user", user);
            request.getRequestDispatcher("/jsp/register.jsp").forward(request,
                    response);
        }
    }

    public void login(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        /**
         * 1、將用戶登錄表單中的信息封裝成User對象 2、登錄，如果發(fā)生異常，就轉(zhuǎn)發(fā)到login.jsp頁面，顯示：異常信息
         * 如果成功，就將查詢到的user對象u，存放到session域中 然后轉(zhuǎn)發(fā)到shopping.jsp頁面，顯示：歡迎用戶登錄
         */
        User user = CommonsUtils.toBean(request.getParameterMap(), User.class);
        System.out.println(user + "-------->");
        try {
            User u = userService.login(user);
            System.out.println(u + ">>>>");
            // 將u存放到session域中
            request.getSession().setAttribute("user", u);
            request.getRequestDispatcher("/jsp/index.jsp").forward(request,
                    response);
        } catch (UserException e) {
            request.setAttribute("msg", e.getMessage());
            request.setAttribute("user", user); // 回顯
            request.getRequestDispatcher("/jsp/login.jsp").forward(request,
                    response);
        }
    }
}

package cn.edu.aynu.rjxy.service;

import java.sql.SQLException;

import cn.edu.aynu.rjxy.bean.Admin;
import cn.edu.aynu.rjxy.dao.AdminDao;

public class AdminService {
    private AdminDao aDao = new AdminDao();

    /**
     * 根據(jù)用戶名和密碼查詢用戶
     * 
     * @param cid
     */
    public Admin login(String username, String password) {
        try {
            return aDao.findByCid(username, password);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }
}

package cn.edu.aynu.rjxy.service;

import java.sql.SQLException;
import java.util.List;

import cn.edu.aynu.rjxy.bean.Order;
import cn.edu.aynu.rjxy.bean.OrderItem;
import cn.edu.aynu.rjxy.dao.OrderDao;
import cn.edu.aynu.rjxy.dao.OrderItemDao;
import cn.edu.aynu.rjxy.utils.JDBCUtils;

/**
 * 調(diào)用dao里面的方法
 * 
 * @author Administrator
 * 
 */
public class OrderService {
    private OrderDao orderDao = new OrderDao();
    private OrderItemDao orderItemDao = new OrderItemDao();

    // 添加訂單和訂單項
    public String addOrder(Order order) {
        try {
            // 開啟事物
            JDBCUtils.startTransaction();
            // 添加訂單
            orderDao.add(order);
            // 獲取訂單項的集合
            List<OrderItem> list = order.getList();
            // 遍歷訂單項目，依次將它們插入orderitem表中
            for (OrderItem orderItem : list) {
                // 添加訂單項
                orderItemDao.addItem(orderItem);
            }
            // 提交事務
            JDBCUtils.commit();
            return "success";
        } catch (Exception e) {
            // 回滾事務
            JDBCUtils.rollback();
            e.printStackTrace();
            return "fail";
        }
    }

    // 查看所有的訂單
    public List<Order> findAllOrder() {
        try {
            return orderDao.findAllOrder();
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

    // 查看我的訂單
    public List<Order> findMyOrder(String user_id) {
        try {
            return orderDao.findOrderByUser_id(user_id);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

    // 查看某個訂單
    public List<OrderItem> findOrderItem(String order_id) {
        try {
            return orderItemDao.findOrderItem(order_id);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

    // 刪除某個訂單
    public void delete(String id) {
        try {
            orderDao.deleteById(id);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }
}

package cn.edu.aynu.rjxy.service;

import java.sql.SQLException;
import java.util.List;

import cn.edu.aynu.rjxy.bean.Page;
import cn.edu.aynu.rjxy.bean.Product;
import cn.edu.aynu.rjxy.dao.ProductDao;

/**
 * 調(diào)用ProductDao的方法
 * 
 * @author Administrator
 * 
 */
public class ProductService {
    private ProductDao pDao = new ProductDao();

    /**
     * 添加商品
     * 
     * @param c
     */
    public void add(Product p) {
        try {
            pDao.insert(p);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }
    //上傳照片
    public  void upload(Product p,String id){
        try {
            pDao.insertURL(p, id);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }
    /**
     * 刪除客戶業(yè)務
     */
    public void delete(String cid) {
        try {
            pDao.delete(cid);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

    /**
     * 編輯修改商品
     * 
     * @param c
     */
    public void edit(Product p) {
        try {
            pDao.update(p);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

    // 查詢所有商品
    public List<Product> findAll() {
        try {
            return pDao.findAll();
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

    // 查看某一商品
    public Product findById(String id) {
        try {
            return pDao.findProductById(id);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

    /**
     * 分頁查詢
     * 
     * @param pageCode
     * @return
     */
    public Page queryByPage(int pageCode) {
        try {
            // 獲取總記錄數(shù)
            int totalRecord = pDao.queryTotalRecord();
            // 創(chuàng)建Page
            Page pb = new Page(pageCode, totalRecord);
            // 查詢當前頁的記錄
            List<Product> datas = pDao.queryByPage((pageCode - 1)
                    * pb.getPageSize(), pb.getPageSize());
            // 將datas封裝到pb
            pb.setDatas(datas);
            return pb;
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }
}

package cn.edu.aynu.rjxy.service;

import java.sql.SQLException;

import cn.edu.aynu.rjxy.bean.User;
import cn.edu.aynu.rjxy.dao.UserDao;
import cn.edu.aynu.rjxy.exception.UserException;

/**
 * 調(diào)用dao層的方法
 * 
 * @author Administrator
 * 
 */
public class UserService {
    private UserDao userDao = new UserDao();

    /**
     * 用戶注冊 1、檢測輸入的用戶名是否存在，如果存在拋出異常“用戶已存在” 2、把輸入的用戶添加到數(shù)據(jù)庫中的user表
     * 
     * @throws UserException
     */
    public void register(User user) throws UserException {
        try {
            // 檢測用戶是否存在
            User u = userDao.findByUsername(user.getUsername());
            // 如果存在拋出異常否則添加用戶到user表
            if (u != null) {
                throw new UserException("用戶已經(jīng)存在");
            } else {
                userDao.add(user);
            }
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

    /**
     * 用戶登錄
     * 
     * @throws UserException
     */
    public User login(User user) throws UserException {
        try {
            // 根據(jù)用戶名查詢user表得到user對象u
            User u = userDao.findByUsername(user.getUsername());
            /**
             * 如果u為null，說明用戶不存在，拋出異常，顯示用戶不存在 否則說明用戶存在，檢測u對象中的密碼和用戶輸入的面貌是否一致
             * 如果一致，返回查詢到的u否則拋出異常，顯示密碼錯誤
             */
            if (u == null) {
                throw new UserException("用戶名不存在");
            }
            // 查詢到的用戶密碼和用戶名輸入的密碼不一致
            if (!u.getPassword().equals(user.getPassword())) {
                throw new UserException("密碼錯誤");
            }
            return u;
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }

    }
}

package cn.edu.aynu.rjxy.dao;

import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;

import cn.edu.aynu.rjxy.bean.Admin;
import cn.edu.aynu.rjxy.utils.JDBCUtils;

/**
 * 對管理員表的操作
 * 
 * @author Administrator
 * 
 */
public class AdminDao {
    QueryRunner qr = new QueryRunner(JDBCUtils.getDataSource());

    /**
     * 根據(jù)用戶名和用戶密碼查詢
     * 
     * @return
     * @throws SQLException
     */
    public Admin findByCid(String username, String password)
            throws SQLException {
        String sql = "select * from admin where username=?&&password=?";
        Admin admin = qr.query(sql, new BeanHandler<Admin>(Admin.class),
                username, password);
        return admin;
    }
}

package cn.edu.aynu.rjxy.dao;

import java.sql.Connection;
import java.sql.Date;
import java.sql.SQLException;
import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import cn.edu.aynu.rjxy.bean.Order;
import cn.edu.aynu.rjxy.utils.JDBCUtils;

/**
 * 對order1表的操作
 * 
 * @author Administrator
 * 
 */
public class OrderDao {
    private QueryRunner qr = new QueryRunner(JDBCUtils.getDataSource());

    // 添加訂單到數(shù)據(jù)庫表order1中
    public void add(Order order) throws Exception {
        Connection conn = JDBCUtils.getConnection();
        String sql = "insert into order1 values(?,?,?,?,?,?,?,?)";
        // 訂單生成時間，由java.util.Date----->java.sql.Date
        Date date = new Date(order.getOrdertime().getTime());
        qr.update(conn, sql, order.getId(), order.getTotalMoney(), order
                .getReceiverAddress(), order.getReceiverName(), order
                .getReceiverPhone(), order.getPaysate(), date, order
                .getUser_id());

    }

    // 查看所有用戶的訂單
    public List<Order> findAllOrder() throws SQLException {
        String sql = "select * from order1";
        return qr.query(sql, new BeanListHandler<Order>(Order.class));
    }

    // 根據(jù)user_id查看用戶的訂單
    public List<Order> findOrderByUser_id(String user_id) throws SQLException {
        String sql = "select * from order1 where user_id = ?";
        return qr.query(sql, new BeanListHandler<Order>(Order.class), user_id);
    }

    // 根據(jù)user_id刪除用戶的訂單
    public void deleteById(String id) throws SQLException {
        String sql = "delete from order1 where id=?";
        qr.update(sql, id);
    }
}

package cn.edu.aynu.rjxy.dao;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import cn.edu.aynu.rjxy.bean.OrderItem;
import cn.edu.aynu.rjxy.bean.Product;
import cn.edu.aynu.rjxy.utils.JDBCUtils;

/**
 * 對orderItem表的操作
 * 
 * @author Administrator
 * 
 */
public class OrderItemDao {
    private QueryRunner qr = new QueryRunner(JDBCUtils.getDataSource());

    // 添加訂單項到數(shù)據(jù)庫表orderitem中
    public void addItem(OrderItem orderItem) throws Exception {
        Connection conn = JDBCUtils.getConnection();
        String sql = "insert into orderitem values(?,?,?,?,?)";
        qr.update(conn, sql, orderItem.getId(), orderItem.getOrder_id(),
                orderItem.getProduct_id(), orderItem.getBuynum(), orderItem
                        .getSubtotal());
    }

    // 查詢某一個訂單的所有訂單項
    public List<OrderItem> findOrderItem(String order_id) throws SQLException {
        // 查詢某一訂單所包含的訂單項
        String sql = "select * from orderitem where order_id = ?";
        List<OrderItem> orderItemList = qr.query(sql,
                new BeanListHandler<OrderItem>(OrderItem.class), order_id);
        // 查詢某一訂單所包含的訂單項對應的商品信息
        sql = "select p.id,p.name,p.price from product p,orderitem oi where p.id = oi.product_id  and  order_id = ?";
        List<Product> productList = qr.query(sql, new BeanListHandler<Product>(
                Product.class), order_id);
        // 將查詢出來的商品作為訂單項的屬性進行添加
        for (OrderItem oi : orderItemList) {
            for (Product p : productList) {
                if (oi.getProduct_id().equals(p.getId())) {
                    oi.setProduct(p);
                }
            }
        }
        return orderItemList;
    }
}

package cn.edu.aynu.rjxy.dao;

import java.sql.SQLException;
import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.apache.commons.dbutils.handlers.ScalarHandler;

import cn.edu.aynu.rjxy.bean.Product;
import cn.edu.aynu.rjxy.utils.JDBCUtils;

/**
 * 對product表進行增刪改查
 * 
 * @author Administrator
 * 
 */
public class ProductDao {
    QueryRunner qr = new QueryRunner(JDBCUtils.getDataSource());

    /**
     * 添加商品
     * 
     * @param c
     * @throws SQLException
     */
    public void insert(Product p) throws SQLException {
        String sql = "insert into product(id,name,price,category,pnum,description) values(?,?,?,?,?,?)";
        qr.update(sql, p.getId(), p.getName(), p.getPrice(), p.getCategory(), p
                .getPnum(),  p.getDescription());
    }
    
    public void insertURL(Product p,String id) throws SQLException {
        String sql = "update product set imgurl = ? where id =?";
        qr.update(sql, p.getImgurl(),id);
    }

    // 查詢所有商品
    public List<Product> findAll() throws SQLException {
        String sql = "select * from product";
        List<Product> list = qr.query(sql, new BeanListHandler<Product>(
                Product.class));
        return list;
    }

    // 根據(jù)id查找商品
    public Product findProductById(String id) throws SQLException {
        String sql = "select * from product where id=?";
        return qr.query(sql, new BeanHandler<Product>(Product.class), id);
    }

    /**
     * 根據(jù)傳過來的id，刪除商品
     * 
     * @throws SQLException
     * 
     */
    public void delete(String id) throws SQLException {
        String sql = "delete from product where id=?";
        qr.update(sql, id);
    }

    /**
     * 修改商品屬性
     * 
     * @throws SQLException
     */
    public void update(Product p) throws SQLException {
        String sql = "update product set name=?,price=?,category=?,pnum=?,imgurl=?,description=? where id=?";
        qr.update(sql, p.getName(), p.getPrice(), p.getCategory(), p.getPnum(),
                p.getImgurl(), p.getDescription(), p.getId());
    }

    /**
     * 查詢總記錄數(shù)
     * 
     * @throws SQLException
     * 
     */
    public int queryTotalRecord() throws SQLException {
        String sql = "select count(*) from product";
        Long num = qr.query(sql, new ScalarHandler<Long>());
        return num.intValue();
    }

    /**
     * 分頁查詢
     * 
     * @throws SQLException
     * 
     */
    public List<Product> queryByPage(int recordStartIndex, int pageSize)
            throws SQLException {
        String sql = "select * from product limit ?,?";
        List<Product> datas = qr.query(sql, new BeanListHandler<Product>(
                Product.class), recordStartIndex, pageSize);
        return datas;
    }
}

package cn.edu.aynu.rjxy.dao;

import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;

import cn.edu.aynu.rjxy.bean.User;
import cn.edu.aynu.rjxy.utils.JDBCUtils;

/**
 * 對User表的操作
 * 
 * @author Administrator
 * 
 */
public class UserDao {
    QueryRunner qr = new QueryRunner(JDBCUtils.getDataSource());

    /**
     * 添加用戶到user表
     * 
     * @throws SQLException
     */
    public void add(User user) throws SQLException {
        String sql = "insert into user(id,username,password) values(?,?,?)";
        qr.update(sql, user.getId(), user.getUsername(), user.getPassword());
    }

    /**
     * 通過用戶名查找用戶
     * 
     * @throws SQLException
     */
    public User findByUsername(String username) throws SQLException {
        String sql = "select * from user where username = ?";
        User user = qr.query(sql, new BeanHandler<User>(User.class), username);
        return user;
    }
}

http://lijun0349-163-com.iteye.com/blog/2008680

http://blog.sina.com.cn/s/blog_ae96abfd0101p9bf.html

總結(jié)

以上是生活随笔為你收集整理的Java Web之网上购物系统（提交订单、查看我的订单）的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。

上一篇： HTML5 localStorageXS
下一篇：御宝羊奶粉怎么样(御宝羊奶粉最新事件)