使用EL与JSTL优化购物车项目

最新推荐文章于 2023-03-30 11:56:44 发布

王真教掌门

最新推荐文章于 2023-03-30 11:56:44 发布

阅读量163

点赞数 4

文章标签： java html

本文链接：https://blog.csdn.net/WZJ278/article/details/124264406

版权

index.jsp：主界面（增加了一个分页）

doIndex.jsp：存放index中java代码的地方

car.jsp：购物车界面

IGoodsBiz：业务逻辑层的商品接口

GoodsBizImpl：业务逻辑层的商品接口的实现类

IGoodsDao：数据库访问层的商品接口

GoodsDaoImpl：数据库访问层的商品接口的实现类

index.jsp：主界面（增加了一个分页）

<%@page import="com.test.pojo.Goods"%>
<%@page import="com.test.biz.impl.GoodsBizImpl"%>
<%@page import="com.test.biz.IGoodsBiz"%>
<%@page import="com.test.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>SuperMarket</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(3)::before{
            content: "$";
        }

    </style>
</head>
	<c:if test="${user == null}">
		<jsp:forward page="login.jsp"/>
	</c:if>
	<c:if test="${empty goods}">
		<jsp:forward page="login.jsp"/>
	</c:if>
<body>
    <div class="jumbotron">
        <div class="container">
            <h1>欢迎光临胡阿玛SuperMarket</h1>
            <p>尊贵的${user.userAccount}</p>
            <p>
      			<a href="car.jsp" class="btn btn-primary">🛒</a>
      		</p>
        </div>
    </div>
    <table class="table">
        <tr>
            <th>商品序号</th>
            <th>商品名称</th>
            <th>商品单价</th>
            <th>商品描述</th>
            <th>操作</th>
        </tr>
	<c:forEach items="${goods}" var="g">
        <tr>
            <td>${g.goodsId}</td>
            <td>${g.goodsName}</td>
            <td>${g.goodsPrice}</td>
            <td>${g.goodsInfo}</td>
            <td>
                <div class="btn-group btn-group-xs">
                    <a href="doAddCar.jsp?goodsId=${g.goodsId}" class="btn btn-primary">添加购物车</a>
                </div>
            </td>
        </tr>
    </c:forEach>
    </table>
   	<div style="text-align: center">
	   	<ul class="pagination">
	    <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>maxPage?maxPage:ipage+1}">
	        <span>&raquo;</span>
	      </a>
	    </li>
	  	</ul>
   	</div>
</body>
</html>

doIndex.jsp：存放index中java代码的地方

<%@page import="com.test.biz.impl.GoodsBizImpl"%>
<%@page import="com.test.biz.IGoodsBiz"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%
	String parameter = request.getParameter("ipage");
	int ipage=1;
	if(parameter!=null){
		ipage = Integer.parseInt(parameter);
	}
	//得到商品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/2));
	//将当前页码带过去
	request.setAttribute("ipage", ipage);
	//将数据携带到index.jsp界面去
	request.getRequestDispatcher("index.jsp").forward(request, response);
%>

car.jsp：购物车界面

<%@page import="java.util.List"%>
<%@page import="com.test.vo.CarItem"%>
<%@page import="com.test.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>购物车</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>
	<c:if test="${user == null}">
		<jsp:forward page="login.jsp"/>
	</c:if>
<body>
    <div class="jumbotron">
        <div class="container">
            <h1>欢迎光临胡阿玛购物车🛒</h1>
            <p>尊贵的${user.userAccount}</p>
            <p>
            <a href="doExit.jsp" class="btn btn-warning">退出登录</a>
            <a href="doIndex.jsp" class="btn btn-warning">返回</a>
        	</p>
        </div>
    </div>

    <table class="table">
        <tr>
            <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.goodsId}</td>
            <td style="line-height: 30.5px;">${c.goods.goodsName}</td>
            <td>
                <div class="input-group" style="width: 120px;margin: auto;">
                    <span class="input-group-btn">
                        <a href="doUpdCar.jsp?goodsId=${c.goods.goodsId}&type=0" class="btn btn-default" type="button">-</a>
                    </span>
                    <input οnblur="location.href='doUpdCar.jsp?goodsId=${c.goods.goodsId}&count='+this.value" value="${c.count}" type="text" class="form-control">
                    <span class="input-group-btn">
                        <a href="doUpdCar.jsp?goodsId=${c.goods.goodsId}&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?goodsId=${c.goods.goodsId}" class="btn btn-primary">删除</a>
            </td>
        </tr>
        </c:forEach>
    </table>

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

IGoodsBiz：业务逻辑层的商品接口

package com.test.biz;

import java.util.List;

import com.test.pojo.Goods;

public interface IGoodsBiz {
	
	//查询所有
	List<Goods> getAll(Integer page);
	
	//查询单个
	Goods getOne(Integer goodsId);
	
	//查询所有的数量
	Integer getRowCount();

}

GoodsBizImpl：业务逻辑层的商品接口的实现类

package com.test.biz.impl;

import java.util.List;

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

public class GoodsBizImpl implements IGoodsBiz{
	private IGoodsDao goodsDao=new GoodsDaoImpl();

	/**
	 * 查询所有的实现方法
	 */
	public List<Goods> getAll(Integer page) {
		return goodsDao.getAll(page);
	}
	
	/**
	 * 查询单个的实现方法
	 */
	public Goods getOne(Integer goodsId) {
		return goodsDao.getOne(goodsId);
	}
	
	/**
	 * 查询所有数量的实现方法
	 */
	public Integer getRowCount() {
		return goodsDao.getRowCount();
	}
}

IGoodsDao：数据库访问层的商品接口

package com.test.dao;

import java.util.List;

import com.test.pojo.Goods;

public interface IGoodsDao {

	//查询所有
	List<Goods> getAll(Integer page);
	
	//查询单个
	Goods getOne(Integer goodsId);
	
	//查询所有的数量
	Integer getRowCount();
	
}

GoodsDaoImpl：数据库访问层的商品接口的实现类

package com.test.dao.impl;

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

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

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

	/**
	 * 查询所有的实现方法
	 */
	public List<Goods> getAll(Integer page) {
		int size=2;
		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.setGoodsId(rs.getInt(1));
				goods.setGoodsName(rs.getString(2));
				goods.setGoodsPrice(rs.getDouble(3));
				goods.setGoodsInfo(rs.getString(4));
				list.add(goods);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			DBHelper.close(con, ps, rs);
		}
		return list;
	}
	
	/**
	 * 查询单个的实现方法
	 */
	public Goods getOne(Integer goodsId) {
		try {
			con = DBHelper.getCon();
			ps = con.prepareStatement("SELECT * FROM SHOP_GOODS WHERE GOODS_ID=?");
			ps.setInt(1, goodsId);
			rs = ps.executeQuery();
			if(rs.next()) {
				Goods goods=new Goods();
				goods.setGoodsId(rs.getInt(1));
				goods.setGoodsName(rs.getString(2));
				goods.setGoodsPrice(rs.getDouble(3));
				goods.setGoodsInfo(rs.getString(4));
				return goods;
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally {
			DBHelper.close(con, ps, rs);
		}
		return null;
	}
	
	/**
	 * 查询所有数量的实现方法
	 */
	public Integer 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;
	}
}

王真教掌门

关注

4
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
使用EL与JSTL优化购物车项目

目录index.jsp：主界面（增加了一个分页）doIndex.jsp：存放index中java代码的地方car.jsp：购物车界面IGoodsBiz：业务逻辑层的商品接口GoodsBizImpl：业务逻辑层的商品接口的实现类IGoodsDao：数据库访问层的商品接口GoodsDaoImpl：数据库访问层的商品接口的实现类index.jsp：主界面（增加了一个分页）<%@page import="com.test.pojo.Goods"%>...
复制链接

扫一扫