Java源码社

基于javaweb的JSP+Servlet家居购物商城系统(java+jsp+jdbc+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

070023542402

080023542402

090023542402

100023542402

110023542402

120023542402

基于javaweb的JSP+Servlet家居购物商城系统(java+jsp+jdbc+mysql)

一、项目简述

功能： Java Web精品项目源码，家居商城分类展示，商品展示， 商品下单，购物车，个人中心，后台管理，用户管理，商品管理，分类管理等等。

二、项目运行

环境配置： Jdk1.8 + Tomcat8.5 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持)

项目技术： Jdbc+ Servlert + html+ css + JavaScript + JQuery + Ajax + Fileupload

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
        if (user != null) {

            SmartUpload su = new SmartUpload();
            su.initialize(this.getServletConfig(), request, response);// 初始化
            String fileName = "";
            int userId = user.getUser_id();

            try {

                su.setAllowedFilesList("jpg,gif,jpeg,png");
                su.upload();

                Files uploadFiles = su.getFiles();
                fileName = uploadFiles.getFile(0).getFileExt();
                fileName = userId + "." + fileName;

                File f = new File(this.getServletContext().getRealPath("/upload/user"));
                if (!f.exists() && !f.isDirectory()) {
                    f.mkdir();
                }
                uploadFiles.getFile(0).saveAs("/upload/user/" + fileName);

            } catch (SmartUploadException e) {
                e.printStackTrace();
            }

            UserService service = new UserServiceImpl();
            service.updatePhotoById(userId,fileName);

            PrintWriter out = response.getWriter();
            out.write("<script>");
            out.write("alert('更新成功！');");
            out.write("location.href='toMyInfoServlet'");
            out.write("</script>");
            out.close();
        }else {
            response.sendRedirect("login.jsp");
        }
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request,response);
    }
}
package servlet.verifycode;


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35


@WebServlet("/selectProductList")
public class SelectProductList extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        //查询购物车数量
        HttpSession session = request.getSession();
        User user = (User) session.getAttribute("name");

        String cartCount = "0";
        CartService service1 = new CartServiceImpl();
        if (user != null) {
            cartCount = String.valueOf(service1.findCartCountByUserId(user.getUser_id()));
        }else {
            cartCount = "?";
        }
        request.setAttribute("cartCount",cartCount);


        String cid = request.getParameter("cid");
        if (cid != null && !cid.trim().equals("")) {
            ProductService service = new ProductServiceImpl();
            List<Product> list = service.findProductByCategoryCid(Integer.valueOf(cid));

            request.setAttribute("productList",list);

            CategoryService service2 = new CategoryServiceImpl();
            Category c = service2.findCategoryByCid(Integer.valueOf(cid));
            System.out.println(c.getCategory_name());
            request.setAttribute("childC",c);
            Category f = service2.findCategoryByCid(c.getCategory_parentid());
            System.out.println(f.getCategory_name());
            request.setAttribute("fatherC",f);

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
            cartCount = String.valueOf(service1.findCartCountByUserId(user.getUser_id()));
        }else {
            cartCount = "?";
        }

        request.setAttribute("cartCount",cartCount);

        //查询评论
        int productId = Integer.valueOf(id);

        CommentService service3 = new CommentServiceImpl();
        List<Comment> comments= service3.findCommentByProductId(productId);
        request.setAttribute("comments",comments);

        System.out.println(comments);

        request.getRequestDispatcher("productview.jsp").forward(request, response);




/*
        //获取最近访问

        HttpSession session = request.getSession();

        //从SSESSIOn获取一下 ids

        List<Integer> ids = (List<Integer>)session.getAttribute("ids");

        if(ids == null){
            ids = new List<Integer>();
        }

        //最多放5， 如果多出5个将第一个删除
        if(ids.size() >= 5) {
            ids.remove(0);
        }

        // 添加列表里， 但只要一份
        if(id!=null && (!ids.contains(Integer.parseInt(id)))) {
            ids.add(Integer.parseInt(id));
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
        System.out.println(comments);

        request.getRequestDispatcher("productview.jsp").forward(request, response);




/*
        //获取最近访问

        HttpSession session = request.getSession();

        //从SSESSIOn获取一下 ids

        List<Integer> ids = (List<Integer>)session.getAttribute("ids");

        if(ids == null){
            ids = new List<Integer>();
        }

        //最多放5， 如果多出5个将第一个删除
        if(ids.size() >= 5) {
            ids.remove(0);
        }

        // 添加列表里， 但只要一份
        if(id!=null && (!ids.contains(Integer.parseInt(id)))) {
            ids.add(Integer.parseInt(id));

        }

        session.setAttribute("ids", ids);

        ids= (List<Integer>)session.getAttribute("ids");

        if(ids!=null) {

            List<LMONKEY_PRODUCT> lastlylist = LMONKEY_PRODUCTDao.selectAllById(ids);
            request.setAttribute("lastlylist", lastlylist);
        }


        LMONKEY_PRODUCT p = null;

        if(id !=null) {
            p = LMONKEY_PRODUCTDao.selectById(Integer.parseInt(id));
            request.setAttribute("p", p);
        }


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29


@WebServlet("/updateUserListServlet")
public class UpdateUserListServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");

        SmartUpload su = new SmartUpload();
        su.initialize(this.getServletConfig(), request, response);// 初始化
        String fileName = "";

        try {

            su.setAllowedFilesList("jpg,gif,jpeg,png");
            su.upload();
            int UserId = Integer.valueOf(request.getParameter("userId"));
            Files uploadFiles = su.getFiles();
            fileName = uploadFiles.getFile(0).getFileExt();
            String fileNameExt = uploadFiles.getFile(0).getFileExt();
            if("".equals(fileName)) {
                System.out.println("1kong");
                UserService service = new UserServiceImpl();
                User u = service.findUserByUserId(UserId);
                fileName = u.getUser_photo();
            }else {
                System.out.println("no kong");
                fileName =  UserId+"."+fileNameExt;
                File f = new File(this.getServletContext().getRealPath("/upload/user"));
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51

    AddressService service = new AddressServiceImpl();
    List<Address> addresses = service.findAddressByUserId(user.getUser_id());
    request.setAttribute("address",addresses);

    //计算商品价格
    String pid = request.getParameter("pid");
    String oid = request.getParameter("oid");
    String count = request.getParameter("count");

    ProductService service2 = new ProductServiceImpl();
    Product p = service2.findProductById(Integer.valueOf(pid));
    int price = p.getProduct_price();
    int totalPrice = price*Integer.valueOf(count);

    request.setAttribute("price",price);
    request.setAttribute("count",count);
    request.setAttribute("product",p);
    request.setAttribute("totalPrice",totalPrice);

    //查询购物车数量
    String cartCount = "0";
    CartService service3 = new CartServiceImpl();
    if (user != null) {
        cartCount = String.valueOf(service3.findCartCountByUserId(user.getUser_id()));
    }else {
        cartCount = "?";
    }
    request.setAttribute("cartCount",cartCount);
    OrderService service4 = new OrderServiceImpl();
    Order o = service4.findOrderById(oid);

    request.setAttribute("order",o);


}else {
    CategoryService service1 = new CategoryServiceImpl();
    List<Category> flist = service1.findCategoryListByName("father");
    List<Category> clist = service1.findCategoryListByName("child");
    request.setAttribute("flist",flist);
    request.setAttribute("clist",clist);

    AddressService service = new AddressServiceImpl();
    List<Address> addresses = service.findAddressByUserId(user.getUser_id());
    request.setAttribute("address",addresses);

    //计算商品价格
    String pid = request.getParameter("pid");
    String count = request.getParameter("count");

    ProductService service2 = new ProductServiceImpl();

项目链接：
https://javayms.github.io?id=311422312105200ik
https://javayms.pages.dev?id=311422312105200ik