JavaWeb15(购物车项目02)

xiongᥫᩣ

已于 2022-11-28 17:00:26 修改

阅读量1.7k

点赞数 12

分类专栏： JavaWeb 文章标签：开发语言 java 前端 eclipse web

于 2022-04-16 22:37:44 首次发布

版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文链接：https://blog.csdn.net/weixin_65474399/article/details/124221266

版权

JavaWeb 专栏收录该内容

13 篇文章 2 订阅

订阅专栏

上次给大家简单介绍了一下web的购物车项目，今天来给大家接着介绍项目的后续优化。

目录

一，功能优化点：

1.登陆约束：

2.用户显示功能：

3.购物车界面：

4.购物车操作：

5.退出登录功能：

6.结算功能：

二，代码：

com.zking.biz包：

com.zking.biz.impl

GoodsBizImpl.java

UserBizImpl.java

com.zking.dao.impl

GoodsDaoImpl.java

UserDaoImpl.java

一，功能优化点：

1.登陆约束：

在主界面和购物车界面都增加了约束，必须要在登陆的情况下才可以访问主页面，如果没有登陆直接访问主页面，则会返回到登陆界面，在登录过后才可以访问主页面。

2.用户显示功能：

在主界面做了用户显示功能，可以查看当前登录的用户

3.购物车界面：

增加了专门的购物车界面：点击主页的购物车按钮就可以进入

4.购物车操作：

在购物车界面可以对商品进行数量的操作，点击删除按钮可以直接删除该商品，做了商品数量限制，当数量<0时默认数量为1。

5.退出登录功能：

做了退出登陆的设置，点击退出登录按钮过后，就会失去访问主页面和购物车界面的权限，返回至登陆界面。

6.结算功能：

点击结算按钮，就会清空购物车里的所有商品。

二，代码：

com.zking.biz包：

IGoodsBiz.java

package com.zking.biz;

import com.zking.pojo.Goods;

import java.util.List;

public interface IGoodsBiz {

    List<Goods> getAll();

    Goods getOne(Integer id);

}

IUserBiz.java

package com.zking.biz;

import com.zking.pojo.User;

public interface IUserBiz {

    User login(User user);

}

com.zking.biz.impl

GoodsBizImpl.java

package com.zking.biz.impl;

import com.zking.biz.IGoodsBiz;
import com.zking.dao.IGoodsDao;
import com.zking.dao.impl.GoodsDaoImpl;
import com.zking.pojo.Goods;

import java.util.List;


public class GoodsBizImpl implements IGoodsBiz {

    private IGoodsDao goodsDao=new GoodsDaoImpl();

    @Override
    public List<Goods> getAll() {
        return goodsDao.getAll();
    }

    @Override
    public Goods getOne(Integer id) {
        return goodsDao.getOne(id);
    }

}

UserBizImpl.java

package com.zking.biz.impl;

import com.zking.biz.IUserBiz;
import com.zking.dao.IUserDao;
import com.zking.dao.impl.UserDaoImpl;
import com.zking.pojo.User;
import org.apache.commons.codec.binary.StringUtils;
import org.apache.commons.codec.digest.DigestUtils;


public class UserBizImpl implements IUserBiz {

    private IUserDao userDao=new UserDaoImpl();

    @Override
    public User login(User user) {
        User u = userDao.login(user);
        if(u!=null){
            if (u.getPassword().equals(user.getPassword())) {
                return u;
            }
        }
        return null;
    }

    public static void main(String[] args) {
        System.out.println(DigestUtils.md5Hex("123456"));
    }

}

com.zking.dao

IGoodsDao.java

package com.zking.dao;

import com.zking.pojo.Goods;

import java.util.List;


public interface IGoodsDao {

    List<Goods> getAll();


    Goods getOne(Integer id);

}

IUserDao.java

package com.zking.dao;

import com.zking.pojo.User;


public interface IUserDao {

    User login(User user);

}

com.zking.dao.impl

GoodsDaoImpl.java

package com.zking.dao.impl;

import com.zking.dao.IGoodsDao;
import com.zking.pojo.Goods;
import com.zking.util.DBHelper;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;


public class GoodsDaoImpl implements IGoodsDao {

    private Connection con;
    private PreparedStatement ps;
    private ResultSet rs;

    @Override
    public List<Goods> getAll() {
        List<Goods> list = new ArrayList<Goods>();
        try {
            con = DBHelper.getCon();
            ps = con.prepareStatement("select * from shop_goods");
            rs = ps.executeQuery();
            while (rs.next()) {
                Goods goods = new Goods();
                goods.setId(rs.getInt(1));
                goods.setName(rs.getString(2));
                goods.setPrice(rs.getInt(3));
                goods.setInfo(rs.getString(4));
                list.add(goods);
            }
            return list;
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            DBHelper.close(con, ps, rs);
        }
        return list;
    }

    @Override
    public Goods getOne(Integer id) {
        try {
            con = DBHelper.getCon();
            ps = con.prepareStatement("select * from shop_goods where id=?");
            ps.setInt(1, id);
            rs = ps.executeQuery();
            if (rs.next()) {
                Goods goods = new Goods();
                goods.setId(rs.getInt(1));
                goods.setName(rs.getString(2));
                goods.setPrice(rs.getInt(3));
                goods.setInfo(rs.getString(4));
                return goods;
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            DBHelper.close(con, ps, rs);
        }
        return null;
    }

}

UserDaoImpl.java

package com.zking.dao.impl;

import com.zking.dao.IUserDao;
import com.zking.pojo.User;
import com.zking.util.DBHelper;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


public class UserDaoImpl implements IUserDao {

    private Connection con;
    private PreparedStatement ps;
    private ResultSet rs;

    @Override
    public User login(User user) {
        System.out.println(user.getAccount());
        try {
            con=DBHelper.getCon();
            ps=con.prepareStatement("select * from shop_user where account=?");
            ps.setString(1,user.getAccount());
            rs=ps.executeQuery();
            if(rs.next()){
                User u=new User();
                u.setId(rs.getInt(1));
                u.setAccount(rs.getString(2));
                u.setPassword(rs.getString(3));
                return u;
            }
        }catch (Exception e) {
            e.printStackTrace();
        }finally {
            DBHelper.close(con,ps,rs);
        }
        return null;
    }

com.zking.pojo

Goods.java

package com.zking.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.experimental.Accessors;
import org.apache.commons.codec.digest.DigestUtils;

import java.math.BigDecimal;
import java.math.BigInteger;


public class Goods {

    private Integer id;
    private String name;
    private Integer price;
    private String info;
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public Integer getPrice() {
		return price;
	}
	public void setPrice(Integer price) {
		this.price = price;
	}
	public String getInfo() {
		return info;
	}
	public void setInfo(String info) {
		this.info = info;
	}
    public Goods() {
		// TODO Auto-generated constructor stub
	}
	public Goods(Integer id, String name, Integer price, String info) {
		super();
		this.id = id;
		this.name = name;
		this.price = price;
		this.info = info;
	}
    

}

User.java

package com.zking.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.experimental.Accessors;


public class User {

    private Integer id;
    private String account;
    private String password;
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getAccount() {
		return account;
	}
	public void setAccount(String account) {
		this.account = account;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}

    public User() {
		// TODO Auto-generated constructor stub
	}
	public User(Integer id, String account, String password) {
		super();
		this.id = id;
		this.account = account;
		this.password = password;
	}
    
}

com.zking.util

DBHelper.java

package com.zking.util;

import oracle.jdbc.driver.OracleDriver;

import java.sql.*;


public class DBHelper {

    //加载驱动
    static{
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    //定义链接字符串
    private static final String URL="jdbc:oracle:thin:@localhost:1521:orcl";

    //获得链接
    public static Connection getCon() {
        try {
            return DriverManager.getConnection(URL,"scott","tiger");
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }

    //关闭资源
    public static void close(Connection con,PreparedStatement ps, ResultSet rs) {
        try {
            if (con!=null&&!con.isClosed()) {
                con.close();
            }
            if(ps!=null){
                ps.close();
            }
            if(rs!=null){
                rs.close();
            }
        }catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static void main(String[] args) {
        System.out.println(DBHelper.getCon());
    }

}

com.zking.vo

CarItem.java

package com.zking.vo;

import com.zking.pojo.Goods;

import lombok.Data;


public class CarItem {

    private Integer count;
    private Integer sum;
    private Goods goods;
	public Integer getCount() {
		return count;
	}
	public void setCount(Integer count) {
		this.count = count;
	}
	public Integer getSum() {
		return sum;
	}
	public void setSum(Integer sum) {
		this.sum = sum;
	}
	public Goods getGoods() {
		return goods;
	}
	public void setGoods(Goods goods) {
		this.goods = goods;
	}
    
    public CarItem() {
		// TODO Auto-generated constructor stub
	}
	public CarItem(Integer count, Integer sum, Goods goods) {
		super();
		this.count = count;
		this.sum = sum;
		this.goods = goods;
	}
    

}

car.jsp

<%@ page import="java.util.List" %>
<%@ page import="com.zking.vo.CarItem" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>

<!DOCTYPE html>
<html lang="zh">

<head>
    <meta charset="UTF-8">
    <title>Document</title>
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="stylesheet" href="bootstrap-3.3.7-dist/css/bootstrap.css">
    <script src="bootstrap-3.3.7-dist/js/jquery-3.5.1.js"></script>
    <script src="bootstrap-3.3.7-dist/js/bootstrap.js"></script>
    <style>
        td:nth-child(4)::before,
        small {
            content: "$";
        }

        * {
            outline: none !important;
        }

        td,
        th {
            text-align: center;
        }

        input {
            text-align: center;
        }
    </style>
</head>

<body>
<div class="jumbotron">
    <div class="container">
        <h1>欢迎光临🍬🍬购物车🛒</h1>
        <p>尊贵的xxx</p>
        <p>
            <a href="doExit.jsp" class="btn btn-warning">退出登录</a>
        </p>
    </div>
</div>

<table class="table">
    <tr>
        <th>商品序号</th>
        <th>商品名称</th>
        <th>商品个数</th>
        <th>商品总价</th>
        <th>操作</th>
    </tr>
    <%
        int sum=0;
        List<CarItem> car = (List<CarItem>) session.getAttribute("car");
        for (CarItem carItem : car) {
            //每个购物条目都有自己的价格
            sum+= carItem.getSum();
    %>
    <tr>
        <td style="line-height: 30.5px;"><%=carItem.getGoods().getId()%>
        </td>
        <td style="line-height: 30.5px;"><%=carItem.getGoods().getName()%>
        </td>
        <td>
            <div class="input-group" style="width: 120px;margin: auto;">
                    <span class="input-group-btn">
                        <a href="doUpdCar.jsp?id=<%=carItem.getGoods().getId()%>&type=0" class="btn btn-default" type="button">-</a>
                    </span>
                <input type="number" onblur="location.href='doUpdCar.jsp?id=<%=carItem.getGoods().getId()%>&count='+this.value" value="<%=carItem.getCount()%>" class="form-control">
                <span class="input-group-btn">
                        <a href="doUpdCar.jsp?id=<%=carItem.getGoods().getId()%>&type=1" class="btn btn-default" type="button">+</a>
                    </span>
            </div>
        </td>
        <td style="line-height: 30.5px;"><%=carItem.getSum()%></td>
        <td style="line-height: 30.5px;">
            <a href="doDelCar.jsp?id=<%=carItem.getGoods().getId()%>" class="btn btn-primary">删除</a>
        </td>
    </tr>
    <%
        }
    %>
</table>

<h1 class="alert alert-info">
    当前购物车总价
    <small><%=sum%></small>
    <a href="doClear.jsp" class="btn btn-danger">点我结算</a>
</h1>
</body>
</html>

doAddCar.jsp

<%@ page import="com.zking.vo.CarItem" %>
<%@ page import="com.zking.biz.IGoodsBiz" %>
<%@ page import="com.zking.biz.impl.GoodsBizImpl" %>
<%@ page import="java.util.List" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
    //拿购物车
    List<CarItem> car=(List<CarItem>)session.getAttribute("car");

    IGoodsBiz goodsBiz=new GoodsBizImpl();

    //添加购物车的页面

    //1.得知道是那件商品吧
    String str = request.getParameter("id");
    int id = -1;
    if (str != null) {
        id = Integer.parseInt(str);
    }

    //2-1.判断该商品是否存在
    boolean f=true;
    for (CarItem item : car) {
        // item.getGoods().getId() 条目的商品id
        if(id==item.getGoods().getId()){
            //商品应该是已经被添加购物车了 [购物车中某个条目的商品id和你需要添加的商品id相同了]
            item.setCount(item.getCount()+1);//数量+1
            item.setSum(item.getCount()*item.getGoods().getPrice());
            f=false;
            break;
        }
    }

    //只要判断f是否发生了改变
    if(f){
        //2-2.生成一个CarItem [如果购物车没有该商品]
        CarItem carItem=new CarItem();
        //设置对应的商品数据
        carItem.setGoods(goodsBiz.getOne(id));
        //商品加车的数量
        carItem.setCount(1);
        //carItem.getCount() 商品加车的数量
        //carItem.getGoods().getPrice() 商品的单价
        //加车数量*商品单价
        carItem.setSum(carItem.getCount()*carItem.getGoods().getPrice());
        //将 购物条目[carItem] 绑定到 购物车[car] 中
        car.add(carItem);
    }

    //更新购物车
    session.setAttribute("car", car);
    //跳回首页
    response.sendRedirect("index.jsp");
%>

doClear.jsp

<%@ page import="java.util.ArrayList" %>
<%@ page import="com.zking.vo.CarItem" %>
<%@ page import="java.util.List" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
    // session.setAttribute("car",new ArrayList<CarItem>());

    List<CarItem> car = (List<CarItem>) session.getAttribute("car");
    car.clear();
    //更新购物车
    session.setAttribute("car", car);
    //跳回首页
    response.sendRedirect("car.jsp");
%>

doDelCar.jsp

<%@ page import="com.zking.vo.CarItem" %>
<%@ page import="java.util.List" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
    List<CarItem> car = (List<CarItem>) session.getAttribute("car");
    //商品的id
    Integer id = Integer.parseInt(request.getParameter("id"));
    //去删除购物车中对应的选项
    for (CarItem item : car) {
        if(item.getGoods().getId()==id){
            car.remove(item);
            break;
        }
    }
    /**
    for (int i = 0; i < car.size(); i++) {
        if(car.get(i).getGoods().getId()==id){
            car.remove(car.get(i));
            break;
        }
    }
     **/

    //更新购物车
    session.setAttribute("car", car);
    //跳回首页
    response.sendRedirect("car.jsp");
%>

doExit.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
    session.invalidate();//让session失效
    response.sendRedirect("login.jsp");
%>

doLogin.jsp

<%@ page import="com.zking.biz.IUserBiz" %>
<%@ page import="com.zking.biz.impl.UserBizImpl" %>
<%@ page import="com.zking.pojo.User" %>
<%@ page import="java.util.List" %>
<%@ page import="com.zking.vo.CarItem" %>
<%@ page import="java.util.ArrayList" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
    request.setCharacterEncoding("utf-8");
    String account = request.getParameter("account");
    String password = request.getParameter("password");

    IUserBiz userBiz = new UserBizImpl();
    User user = userBiz.login(new User(0, account, password));

    System.out.println(user + "---jsp");

    if (user == null) {
        response.sendRedirect("/login.jsp");
    } else {
        //首页需要登录数据
        session.setAttribute("user", user);
        //找来一个购物车
        List<CarItem> car = new ArrayList<>();
        //放到session中(把购物车给我)
        session.setAttribute("car", car);
        response.sendRedirect("index.jsp");
    }

%>

doUpdCar.jsp

<%@ page import="com.zking.vo.CarItem" %>
<%@ page import="java.util.List" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%
    List<CarItem> car = (List<CarItem>) session.getAttribute("car");
    //商品的id
    Integer id = Integer.parseInt(request.getParameter("id"));
    //类型
    String type = request.getParameter("type");

    //查询对应的条目
    CarItem i=null;
    for (CarItem item : car) {
        if (item.getGoods().getId() == id) {
            i=item;
            break;
        }
    }

    if(type!=null){
        //去修改购物车中对应的选项
        i.setCount(i.getCount() + (type.equals("0") ? -1 : 1));
    }
    else{
        i.setCount((int)Double.parseDouble(request.getParameter("count").equals("")?"1":request.getParameter("count")));
    }
    i.setCount(i.getCount() > 0 ? i.getCount() : 1);
    i.setSum(i.getCount() * i.getGoods().getPrice());

    //更新购物车
    session.setAttribute("car", car);
    //跳回首页
    response.sendRedirect("car.jsp");
%>

index.jsp


<%@page import="com.zking.pojo.Goods"%>
<%@page import="com.zking.biz.impl.GoodsBizImpl"%>
<%@page import="com.zking.biz.IGoodsBiz"%>
<%@page import="com.zking.pojo.User"%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>

<!DOCTYPE html>
<html lang="zh">
<head>
  <meta charset="UTF-8">
  <title>Document</title>
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="${pageContext.request.contextPath}/bootstrap-3.3.7-dist/css/bootstrap.css">
  <script src="${pageContext.request.contextPath}/bootstrap-3.3.7-dist/js/jquery-3.5.1.js"></script>
  <script src="${pageContext.request.contextPath}/bootstrap-3.3.7-dist/js/bootstrap.js"></script>
  <style>

    td:nth-child(3)::before{
      content: "$";
    }

  </style>
</head>

<body>
<%
  Object obj = session.getAttribute("user");
  if(obj==null){
    response.sendRedirect("login.jsp");
    return;
  }
%>
<div class="jumbotron">
  <div class="container">
    <h1>欢迎光临🍬🍬SuperMarket</h1>
    <p>尊贵的<%=((User)obj).getAccount()%></p>
    <p>
      <a href="car.jsp" class="btn btn-primary">🛒</a></p>
  </div>
</div>

<div class="container">
  <table class="table">
    <tr>
      <th>商品序号</th>
      <th>商品名称</th>
      <th>商品单价</th>
      <th>商品描述</th>
      <th>操作</th>
    </tr>
    <%
      IGoodsBiz goodsBiz=new GoodsBizImpl();
      for (Goods goods : goodsBiz.getAll()) {
    %>
    <tr>
      <td><%=goods.getId()%></td>
      <td><%=goods.getName()%></td>
      <td><%=goods.getPrice()%></td>
      <td><%=goods.getInfo()%></td>
      <td>
        <div class="btn-group btn-group-xs">
          <a href="doAddCar.jsp?id=<%=goods.getId()%>" class="btn btn-primary">添加购物车</a>
        </div>
      </td>
    </tr>
    <%}%>
  </table>
</div>
</body></html>

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html lang="zh">
<head>
    <meta charset="UTF-8">
    <title>Document</title>
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="stylesheet" href="${pageContext.request.contextPath}/bootstrap-3.3.7-dist/css/bootstrap.css">
    <script src="${pageContext.request.contextPath}/bootstrap-3.3.7-dist/js/jquery-3.5.1.js"></script>
    <script src="${pageContext.request.contextPath}/bootstrap-3.3.7-dist/js/bootstrap.js"></script>
    <style>
        * {
            outline: none !important;
        }

        html,
        body {
            background: #1abe9c;
        }

        form {
            width: 300px;
            background: #ebeff2;
            box-shadow: 0px 0px 50px rgba(0, 0, 0, .5);
            border-radius: 5px;
            padding: 20px;
            position: absolute;
            left: 50%;
            top: 50%;
            transform: translate(-50%, -50%);
        }

        .btn-group {
            width: 100%;
        }

        .btn-group button {
            width: 50%;
        }
    </style>
</head>

<body>
<form action="doLogin.jsp" method="post">
    <h3 class="text-center" style="text-shadow: 2px 2px 1px #ed3f3f;">欢迎光临🍬🍬超市</h3>
    <div class="form-group">
        <input name="account" type="text" class="form-control" placeholder="请输入您的用户名">
    </div>
    <div class="form-group">
        <input name="password" type="password" class="form-control" placeholder="请输入您的密码">
    </div>
    <div class="btn-group">
        <button type="submit" class="btn btn-primary">登录</button>
        <button type="button" class="btn btn-danger">没有账号?</button>
    </div>
</form>
</body></html>

今天的分享就到此为止啦，下期精彩继续哦。

关注

12
点赞
踩
44

收藏

觉得还不错? 一键收藏
7
评论
JavaWeb15(购物车项目02)

上次给大家简单介绍了一下web的购物车项目，今天来给大家接着介绍项目的后续优化。一，
复制链接

扫一扫

专栏目录

评论 7

被折叠的条评论为什么被折叠?

到【灌水乐园】发言

查看更多评论

添加红包

成就一亿技术人!

hope_wisdom

发出的红包

实付元

使用余额支付

点击重新获取

扫码支付

钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。