自己写的一个项目中实现的购物车功能！购物车页面以及实现购物车相应的dao包！

最新推荐文章于 2024-04-18 15:45:37 发布

annabell

最新推荐文章于 2024-04-18 15:45:37 发布

阅读量1.9k

点赞数 1

本文链接：https://blog.csdn.net/annabelljie/article/details/8267972

版权

java 编程专栏收录该内容

2 篇文章 0 订阅

订阅专栏

cart.jsp 页面的实现

<%@ page language="java" import="java.util.*,com.yuxuan.db.*" pageEncoding="gb2312"%>
<%@page import="com.yuxuan.entity.*" %>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <base href="<%=basePath%>">

    <title>网上书店系统</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

实现该功能的相应dao 包

package com.yuxuan.db;

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

import com.yuxuan.entity.*;
import com.yuxuan.db.DBUtil;

public class GoodsDao {
private Connection conn;
private Statement stmt;
private PreparedStatement pStmt;
private ResultSet rs;
int num=10;
public List<Goods> getAllGoods(int page){
  List<Goods> goodsList=new ArrayList<Goods>();
  String sql="select top " + num
     + " * from Goods where isbn not in (select top "
     + (page - 1) * num
     + " isbn from Goods order by isbn)";
  conn=DBUtil.getConnection();
  try {
    stmt = conn.createStatement();
    rs = stmt.executeQuery(sql);
   while (rs.next()) {

    Goods goods=new Goods();
    goods.setIsbn(rs.getString("isbn"));
    goods.setGoodsName(rs.getString("goodsName"));
    goods.setPrice(rs.getFloat("price"));
    goods.setCount(rs.getInt("count"));
    goods.setPic(rs.getString("pic"));
    goods.setDescription(rs.getString("description"));
    goodsList.add(goods);
   }
   return goodsList;
  }catch(SQLException e){
   e.printStackTrace();
  }
   finally{
    try {
     if(rs != null){
     rs.close();
     }

     if(stmt != null){
     stmt.close();
     }

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

  }
   DBUtil.close();
   return null;
}

public List<Goods> getAllGoods(){
  List<Goods> goodsList=new ArrayList<Goods>();
  String sql="select * from Goods";
  conn=DBUtil.getConnection();
  try {
    stmt = conn.createStatement();
    rs = stmt.executeQuery(sql);
   while (rs.next()) {

    Goods goods=new Goods();
    goods.setIsbn(rs.getString("isbn"));
    goods.setGoodsName(rs.getString("goodsName"));
    goods.setPrice(rs.getFloat("price"));
    goods.setCount(rs.getInt("count"));
    goods.setPic(rs.getString("pic"));
    goods.setDescription(rs.getString("description"));
    goodsList.add(goods);
   }
   return goodsList;
  }catch(SQLException e){
   e.printStackTrace();
  }
   finally{
    try {
     if(rs != null){
     rs.close();
     }

     if(stmt != null){
     stmt.close();
     }

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

  }
   DBUtil.close();
   return null;
}

public Goods getGoodsByIsbn(String isbn){

  String sql="select * from Goods where isbn='" + isbn + "'";
  Goods goods=new Goods();
  conn=DBUtil.getConnection();
  try{
    stmt = conn.createStatement();
    rs = stmt.executeQuery(sql);
   while(rs.next()){

    goods.setIsbn(rs.getString("isbn"));
    goods.setGoodsName(rs.getString("goodsName"));

    goods.setPrice(rs.getFloat("price"));
    goods.setCount(rs.getInt("count"));
    goods.setPic(rs.getString("pic"));
    goods.setDescription(rs.getString("description"));
   }
   return goods;
  }catch(SQLException e){
   e.printStackTrace();
  }
  finally{
   try {
    if(rs != null){
    rs.close();
    }

    if(stmt != null){
    stmt.close();
    }

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

}
  DBUtil.close();
  return null;
}
public List<Goods> getGoodsByName(String name){
  List<Goods> goodsList=new ArrayList<Goods>();
  String sql="select * from Goods where goodsName like'%"+name+"%'";
  conn=DBUtil.getConnection();
  try{
    stmt = conn.createStatement();
    rs = stmt.executeQuery(sql);
   while(rs.next()){
    Goods goods=new Goods();
    goods.setIsbn(rs.getString("isbn"));
    goods.setGoodsName(rs.getString("goodsName"));
    goods.setPrice(rs.getFloat("price"));
    goods.setCount(rs.getInt("count"));
    goods.setPic(rs.getString("pic"));
    goods.setDescription(rs.getString("description"));
    goodsList.add(goods);

   }
   return goodsList;
  }catch(SQLException e){
   e.printStackTrace();
  }
  finally{
   try {
    if(rs != null){
    rs.close();
    }

    if(stmt != null){
    stmt.close();
    }

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

}
  DBUtil.close();
  return null;
}

public int addGoods(Goods goods){
  int result=0;
  conn=DBUtil.getConnection();
  String sql="insert into Goods(isbn,goodsName,price,count,pic,description) values(?,?,?,?,?,?)";
  /*
     1获取得到要添加的图书的相关字段值
    2形成SQL语句
    3利用命令官执行SQL语句
    4根据命令官执行的结果返回值
  */
  //String isbn=book.getIsbn();
  //Strin sql="";
  //pstmt=con.prrepareStatement(sql);


  //if(pstmt!=null) conn
   //pstmt.close();
  boolean r=false;
  try{



   r = conn.getAutoCommit();
   DBUtil.setAutoCommit(conn, false);
   pStmt = conn.prepareStatement(sql);
   pStmt.setString(1, goods.getIsbn());
   pStmt.setString(2, goods.getGoodsName());
   pStmt.setFloat(3, (float) goods.getPrice());
   pStmt.setInt(4, goods.getCount());
   pStmt.setString(5, goods.getPic());
   pStmt.setString(6, goods.getDescription());

   result = pStmt.executeUpdate();
   conn.commit();

   DBUtil.setAutoCommit(conn, r);

  }catch(Exception e){
   e.printStackTrace();
  }
  finally{
   try {
    if(rs != null){
    rs.close();
    }

    if(stmt != null){
    stmt.close();
    }

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

}
  DBUtil.close();
  return result;

}

public int update(Goods goods) {
  int result = 0;
  String sql = "update Goods set isbn=?,goodsName=?,price=?,count=?,pic=?,description=? where isbn=?";

  conn = DBUtil.getConnection();
  boolean autoCommit = false;

  try {
   autoCommit = conn.getAutoCommit();
   DBUtil.setAutoCommit(conn, false);

   pStmt = conn.prepareStatement(sql);

   pStmt.setString(1, goods.getIsbn());
   pStmt.setString(2, goods.getGoodsName());
   pStmt.setFloat(3, (float) goods.getPrice());
   pStmt.setInt(4, goods.getCount());
   pStmt.setString(5, goods.getPic());
   pStmt.setString(6,goods.getDescription());
   pStmt.setString(7, goods.getIsbn());

   result = pStmt.executeUpdate();

   conn.commit();
   DBUtil.setAutoCommit(conn, autoCommit);

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

  finally{
   try {
    if(rs != null){
     rs.close();
    }

    if(stmt != null){
     stmt.close();
    }

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

  DBUtil.close();

  return result;
}

public int delGoodsByIsbn(String isbn){
  int result=0;
  String sql="delete from Goods where isbn=?";
  conn = DBUtil.getConnection();
  boolean autoCommit = false;
  try{

   autoCommit = conn.getAutoCommit();
   DBUtil.setAutoCommit(conn, false);

   pStmt = conn.prepareStatement(sql);

   pStmt.setString(1, isbn);

   result = pStmt.executeUpdate();
   conn.commit();

   DBUtil.setAutoCommit(conn, autoCommit);
  }catch(Exception e){
   e.printStackTrace();
  }
  finally{
   try {
    if(rs != null){
     rs.close();
    }

    if(stmt != null){
     stmt.close();
    }

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

  DBUtil.close();
  return result;
}

}

annabell

关注

1
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
自己写的一个项目中实现的购物车功能！购物车页面以及实现购物车相应的dao包！

cart.jsp 页面的实现%@page import="com.yuxuan.entity.*" %>%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>String path = request.getContextPath();String basePath = request.getScheme
复制链接

扫一扫