基于javaweb+mysql的简单购物车

基于javaweb+mysql的简单购物车

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

注册、登录、注销

商品加入购物车，查看购物车，删除购物车中的商品和清空购物车

生成订单，查看历史订单及订单详情等

技术框架

JSP Servlet MySQL JDBC Tomcat

---

				Goods g=new Goods();
				g.setGoodsname(rs.getString(2));
				g.setPrice(rs.getDouble(3));
				goods.add(g);
				
			}
		} catch (SQLException e) {
   
				// TODO Auto-generated catch block
				e.printStackTrace();
		}finally {
   
			if(rs!=null) {
   
				try {
   
					rs.close();
				} catch (SQLException e) {
   
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		req.setAttribute("goods", goods);
		req.getRequestDispatcher("list.jsp").forward(req, resp);
		goods.clear();
		db.close();
	}
}
package entity;

		try {
   
			while(rs.next()) {
   
				Goods g=new Goods();
				g.setGoodsname(rs.getString(2));
				g.setPrice(rs.getDouble(3));
				goods.add(g);
				
			}
		} catch (SQLException e) {
   
				// TODO Auto-generated catch block
				e.printStackTrace();
		}finally {
   
			if(rs!=null) {
   
				try {
   

import entity.User;
import mysql.DataBase;


public class OrderServlet extends HttpServlet {
   
	public static List<Cart> cart=new ArrayList<Cart>();
	//备份cart 生成订单时用
	public static List<Cart> cart_=new ArrayList<Cart>();
	//订单号 list
	public static List<String> OrderId = new ArrayList<String>();
	//订单详情 List
	public static List<Order> order = new ArrayList<Order>();
	//时间+随机数
	public static String getOrderIdByTime() {
   
		SimpleDateFormat sdf=new SimpleDateFormat("yyyyMMddHHmmss");
		String newDate=sdf.format(new Date()); 
		String result="";
		Random random=new Random();
		for(int i=0;i<3;i++) {
   
			result+=random.nextInt(10);
			
		}