JavaWeb项目，实现了登陆注册、商店购物、购物车.zip

package impl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import util.DBUtil; import entity.Shopcart; public class shopcart_impl { // 添加购物车订单 public static void insert_shopcart(int id, String name, float price, String color, String size, int num, String img,String usertel) throws SQLException { Connection conn = DBUtil.getConnection(); String sql = "insert into shopcart values(?,?,?,?,?,?,?,?)"; PreparedStatement ps = conn.prepareStatement(sql); ps.setInt(1, id); ps.setString(2, name); ps.setFloat(3, price); ps.setString(4, color); ps.setString(5, size); ps.setInt(6, num); ps.setString(7, img); ps.setString(8, usertel); int rs = ps.executeUpdate(); if (rs == 1) { System.out.println("购物车添加成功"); } else { System.out.println("购物车添加失败"); } conn.close(); } // 查询订单是否存在并返回数量 public static int find_shopcart(int id, String color, String size,String usertel) throws SQLException { Connection conn = DBUtil.getConnection(); String sql = "select * from shopcart where id = ? and color = ? and size = ? and usertel = ?"; PreparedStatement ps = conn.prepareStatement(sql); ps.setInt(1, id); ps.setString(2, color); ps.setString(3, size); ps.setString(4, usertel); ResultSet rs = ps.executeQuery(); if (rs.next()) { int res = rs.getInt("num"); System.out.println("查询已存在该订单"); conn.close(); // 返回数量 return res; } // 查询不存在用户 System.out.println("查询不存在该订单"); conn.close(); return 0; } // 订单删除 public static void delete_shopcart(int id, String color, String size,String usertel) throws SQLException { Connection conn = DBUtil.getConnection(); String sql = "delete from `shopcart` where id=? and color= ? and size = ? and usertel = ?"; PreparedStatement ps = conn.prepareStatement(sql); ps.setInt(1, id); ps.setString(2,color); ps.setString(3,size); ps.setString(4, usertel); int rs = ps.executeUpdate(); if (rs == 1) { System.out.println("删除购物车订单成功"); } else { System.out.println("删除购物车订单失败"); } conn.close(); } // 订单更新为num个 public static void update_shopcart(int id, String color, String size, int num,String usertel) throws SQLException { Connection conn = DBUtil.getConnection(); String sql = "update shopcart set num=? where id=? and color = ? and size = ? and usertel = ?"; PreparedStatement ps = conn.prepareStatement(sql); ps.setInt(1, num); ps.setInt(2, id); ps.setString(3,color); ps.setString(4,size); ps.setString(5, usertel); int rs = ps.executeUpdate(); if (rs == 1) { System.out.println("更新购物车订单成功"); } else { System.out.println("更新购物车订单失败"); } conn.close(); } // 查询用户的所有订单 public static ArrayList<Shopcart> find_allshopcart(String usertel) throws SQLException { Connection conn = DBUtil.getConnection(); ArrayList<Shopcart> list = new ArrayList<Shopcart>(); String sql = "select * from shopcart where usertel = ?"; PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, usertel); ResultSet rs = ps.executeQuery(); Shopcart sc; while (rs.next()) { sc = new Shopcart(rs.getInt("id"), rs.getString("name"), rs.getFloat("price"), rs.getString("color"), rs.getString("size"), rs.getInt("num"), rs.getString("img"),rs.getString("usertel")); list.add(sc); } conn.close(); return list; } }