使用jstl标签编写购物车系统

筱☆

已于 2022-12-03 18:10:32 修改

阅读量843

点赞数 4

分类专栏： JavaWeb 文章标签： web java 后端 html

于 2022-04-21 16:50:48 首次发布

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

本文链接：https://blog.csdn.net/weixin_67235801/article/details/124325944

版权

JavaWeb 专栏收录该内容

21 篇文章 2 订阅

订阅专栏

目录

商品的数据库访问层：IGoodsDao.java

数据库访问层的实现类：GoodsDaoImpl.java

购物车的业务逻辑层：IGoodsBiz.java

业务逻辑层的实现：GoodsBizImpl.java

修改后的主界面：index.jsp

主界面中java代码的处理：doIndex.jsp

修改后的购物车界面：car.jsp

这次分享的全部都是基于之前的博客中有讲述到的购物车系统，这里只是基于购物车系统做了稍稍的更改。还有分页的制作

商品的数据库访问层：IGoodsDao.java

package com.xyz.dao;

import java.util.List;

import com.xyz.pojo.Goods;

public interface IGoodsDao {

	//查询所有
	List<Goods> getAll(int page);
	
	//根据id查询
	Goods getOne(Integer id);
	
	//查询所有数量
	int getRowCount();
}

数据库访问层的实现类：GoodsDaoImpl.java

package com.xyz.dao.impl;

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

import com.xyz.dao.IGoodsDao;
import com.xyz.pojo.Goods;
import com.xyz.pojo.User;
import com.xyz.util.DBHelper;

public class GoodsDaoImpl implements IGoodsDao{
	
	private Connection con;
	private PreparedStatement ps;
	private ResultSet rs;

	//查询所有的数量
	@Override
	public int getRowCount() {
		try {
			con=DBHelper.getCon();
			ps=con.prepareStatement("select count(1) from shop_goods");
			rs=ps.executeQuery();
			if(rs.next()) {
				return rs.getInt(1);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			DBHelper.close(con, ps, rs);
		}
		return 0;
	}
	
	//查询所有
	@Override
	public List<Goods> getAll(int page) {
		int size=4;
		int begin=(page-1)*size+1;
		int end=page*size;
		List<Goods> list=new ArrayList<Goods>();
		try {
			con=DBHelper.getCon();
			String sql="select * from (select a.*,rownum myr from shop_goods a) b where myr between ? and ?";
			ps=con.prepareStatement(sql);
			ps.setInt(1, begin);
			ps.setInt(2, end);
			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;
	}
	
	//根据id查询
	@Override
	public Goods getOne(Integer id) {
		try {
			con=DBHelper.getCon();
			ps=con.prepareStatement("select * from shop_goods where g_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;
	}
	

}

购物车的业务逻辑层：IGoodsBiz.java

package com.xyz.biz;

import java.util.List;

import com.xyz.pojo.Goods;

public interface IGoodsBiz {
	
	//查询全部
	List<Goods> getAll(int page);
	
	//根据id查询
	Goods getOne(Integer id);
	
	//查询所有数量
	int getRowCount();

}

业务逻辑层的实现：GoodsBizImpl.java

package com.xyz.biz.impl;

import java.util.List;

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

public class GoodsBizImpl implements IGoodsBiz{
	
	private IGoodsDao goodsDao=new GoodsDaoImpl();
	
	@Override
	public List<Goods> getAll(int page) {
		return goodsDao.getAll(page);
	}

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

修改后的主界面：index.jsp

<%@page import="com.xyz.pojo.Goods"%>
<%@page import="com.xyz.biz.impl.GoodsBizImpl"%>
<%@page import="com.xyz.biz.IGoodsBiz"%>
<%@page import="com.xyz.pojo.User"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    
<!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>

<c:if test="${user==null}">
	<c:redirect url="login.jsp"></c:redirect>
</c:if>
<c:if test="${empty goods}">
	<c:redirect url="doIndex.jsp"></c:redirect>
</c:if>
    <div class="jumbotron">
        <div class="container">
            <h1>欢迎光临串串遇SuperMarket</h1>
            <p>尊贵的${user.account}</p>
            <a href="car.jsp" class="btn btn-primary">🛒</a>
            <a href="doExit.jsp" class="btn btn-warning">退出登录</a>
        </div>
    </div>
    
    <div class="container">
    	<table class="table">
        <tr>
            <th>商品序号</th>
            <th>商品名称</th>
            <th>商品单价</th>
            <th>商品描述</th>
            <th>操作</th>
        </tr>

<c:forEach items="${goods}" var="g">
        <tr>
            <td>${g.id}</td>
            <td>${g.name}</td>
            <td>${g.price}</td>
            <td>${g.info}</td>
            <td>
                <div class="btn-group btn-group-xs">
                    <a href="doAddCar.jsp?id=${g.id}" class="btn btn-primary">添加购物车</a>
                </div>
            </td>
        </tr>
</c:forEach>
    </table>
    </div>
    
    <div class="container text-center">
    <ul class="pagination" style="margin: 20px auto;">
        <li>
            <a href="doIndex.jsp?ipage=${Math.max(ipage-1,1)}"><span>&laquo;</span></a>
        </li>
        <c:forEach begin="1" end="${maxPage}" var="i">
        	<li class="${ipage==i?"active":""}">
        		<a href="doIndex.jsp?ipage=${i}">${i}</a>
        	</li>
        </c:forEach>
        <li>
            <a href="doIndex.jsp?ipage=${ipage+1}"><span>&raquo;</span></a>
        </li>
    </ul>
	</div>
</body>
</html>

主界面中java代码的处理：doIndex.jsp

<%@page import="com.xyz.biz.impl.GoodsBizImpl"%>
<%@page import="com.xyz.biz.IGoodsBiz"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%
	String pageCount=request.getParameter("ipage");
	int ipage=1;
	if(pageCount!=null){
		ipage=Integer.parseInt(pageCount);
	}
	
	//得到商品的biz
	IGoodsBiz goodsBiz=new GoodsBizImpl();
	//将商品查询出来 并且放入请求域中
	request.setAttribute("goods", goodsBiz.getAll(ipage));
	
	//算出最大页数 带到index.jsp
	int row=goodsBiz.getRowCount();
	request.setAttribute("maxPage", (int)Math.ceil(row*1.0/4));
	//当前页数
	request.setAttribute("ipage", ipage);
	
	//将数据转发到index.jsp
	request.getRequestDispatcher("index.jsp").forward(request, response);
%>

修改后的购物车界面：car.jsp

<%@page import="com.xyz.pojo.User"%>
<%@page import="com.xyz.vo.CarItem"%>
<%@page import="java.util.List"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    
<!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,
     
        * {
            outline: none !important;
        }

        td,
        th {
            text-align: center;
        }

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

<body>

    <div class="jumbotron">
        <div class="container">
            <h1>欢迎光临串串遇购物车🛒</h1>
            <p>尊贵的${user.account}</p>
            <a href="doIndex.jsp" class="btn btn-primary">返回主界面</a>
        </div>
    </div>

    <table class="table">
        <tr>
            <th>商品序号</th>
            <th>商品名称</th>
            <th>商品单价</th>
            <th>商品个数</th>
            <th>商品总价</th>
            <th>操作</th>
        </tr>
        
        <c:forEach items="${car}" var="c">
        <tr>
            <td style="line-height: 30.5px;">${c.goods.id}</td>
            <td style="line-height: 30.5px;">${c.goods.name}</td>
            <td style="line-height: 30.5px;">${c.goods.price}</td>
            <td>
                <div class="input-group" style="width: 120px;margin: auto;">
                    <span class="input-group-btn">
                        <a href="doUpdCar.jsp?id=${c.goods.id}&type=0" class="btn btn-default" type="button">-</a>
                    </span>
                    <input onblur="location.href='doUpdCar.jsp?id=${c.goods.id}&count='+this.value" value="${c.count}" type="number" class="form-control">
                    <span class="input-group-btn">
                        <a href="doUpdCar.jsp?id=${c.goods.id}&type=1" class="btn btn-default" type="button">+</a>
                    </span>
                </div>
            </td>
            <td style="line-height: 30.5px;">${c.sum}</td>
            <td style="line-height: 30.5px;">
                <a href="doDelCar.jsp?id=${c.goods.id}" class="btn btn-primary">删除</a>
            </td>
        </tr>
    	</c:forEach>
    </table>

    <h1 class="alert alert-info">
        <a href="doClear.jsp" class="btn btn-danger">点我结算</a>
    </h1>
</body>
</html>

注：记得将所有跳转到index界面的改成doIndex，否则主界面会没有数据

界面并没有发生什么改变，只是代码改变了，可以看到显示的界面中已经没有java代码了。

关注

4
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
使用jstl标签编写购物车系统

使用jstl标签完成购物车系统，分页的制作
复制链接

扫一扫

专栏目录

评论

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

到【灌水乐园】发言

查看更多评论

添加红包

成就一亿技术人!

hope_wisdom

发出的红包

实付元

使用余额支付

点击重新获取

扫码支付

钱包余额 0

抵扣说明：

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