基于javaweb+mysql的jsp+servlet简单购物车(java+jsp+servlet+mysql)

最新推荐文章于 2024-04-30 13:29:47 发布
最新推荐文章于 2024-04-30 13:29:47 发布
阅读量147 收藏 1
点赞数
文章标签： mysql java servlet
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_71016350/article/details/131839045
版权

基于javaweb+mysql的jsp+servlet简单购物车(java+jsp+servlet+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

注册、登录、注销

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

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

技术框架

JSP Servlet MySQL JDBC Tomcat

基于javaweb+mysql的JSP+Servlet简单购物车(java+jsp+servlet+mysql)

		String username=u.getUsername();
		DataBase db=new DataBase();
		ResultSet rs = db.getData("SELECT * FROM t_cart where un='"+username+"'");
		
		try {
			while(rs.next()) {
				Cart c=new Cart();
				c.setGoodsname(rs.getString(1));
				c.setNumber(rs.getInt(2));
				c.setPrice(rs.getDouble(3));
				c.setUsername(username);
				cart.add(c);
				
			}
			
			
		} 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("cart", cart);
		req.getRequestDispatcher("order.jsp").forward(req, resp);
		//备份 cart
		cart_.clear();
		cart_.addAll(cart);
		//清空
		cart.clear();
		db.close();
	}

}
package servlet;



public class CartServlet extends HttpServlet {
	public static List<Cart> cart=new ArrayList<Cart>();
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		String path = req.getServletPath();
		resp.setContentType("text/html;charset=utf-8");
		req.setCharacterEncoding("utf-8");
		resp.setCharacterEncoding("utf-8");
		if("/add.cart".equals(path)){
			add(req,resp);
		}
		if("/show.cart".equals(path)){
			show(req,resp);
		}
		if("/delete.cart".equals(path)){
			delete(req,resp);
		}
	}
	
	protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		String index=req.getParameter("index");
		User u=(User)req.getSession().getAttribute("user");
		String username=u.getUsername();
		DataBase db=new DataBase();
		ResultSet rs = db.getData("SELECT * FROM t_goods where goodsid="+index);
		String goodsname = "";
		Double price = 0.0;
		try {
			if(rs.next()) {
				goodsname=rs.getString(2);
				price=rs.getDouble(3);
			}
			else {
				System.out.println("获取出错！！！");
			}
			
		} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
		}


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);
			
		}
		return newDate+result;
	}
		
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		String path = req.getServletPath();
		resp.setContentType("text/html;charset=utf-8");
		req.setCharacterEncoding("utf-8");
		resp.setCharacterEncoding("utf-8");
		if("/confirm.order".equals(path)){
			confirm(req,resp);
		}
		if("/generate.order".equals(path)){
			generate(req,resp);
		}
		if("/showOrders.order".equals(path)){
			showOrders(req,resp);
		}
		if("/detail.order".equals(path)){
			detail(req,resp);

		
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		String path = req.getServletPath();
		resp.setContentType("text/html;charset=utf-8");
		req.setCharacterEncoding("utf-8");
		resp.setCharacterEncoding("utf-8");
		if("/confirm.order".equals(path)){
			confirm(req,resp);
		}
		if("/generate.order".equals(path)){
			generate(req,resp);
		}
		if("/showOrders.order".equals(path)){
			showOrders(req,resp);
		}
		if("/detail.order".equals(path)){
			detail(req,resp);
		}
		
	}
	//订单详情
	protected void detail(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		String OrderId=req.getParameter("id");
		DataBase db=new DataBase();
		ResultSet rs = db.getData("SELECT * FROM t_order where id='"+OrderId+"'");
		try {
			while(rs.next()) {
				Order o=new Order();
				o.setUsername(rs.getString("un"));
				o.setGoodsname(rs.getString("goodsname"));
				o.setNumber(rs.getInt("number"));
				o.setPrice(rs.getDouble("price"));
				o.setId(OrderId);
				order.add(o);
			}
			
			
		} 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();

			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
		}
		String sql="insert into t_user(un,pwd,phone,addr) values('"+username+"','"+password+"','"+phone+"','"+address+"')";
		db.setData(sql);
		resp.sendRedirect(req.getContextPath()+"/login.jsp");
		db.close();
	}
	protected void login(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		String username=req.getParameter("username");
		String password=req.getParameter("password");
		HttpSession session=req.getSession();
		DataBase db=new DataBase();
		ResultSet rs = db.getData("SELECT * FROM t_user where un='"+username+"' and pwd='"+password+"'");
		try {
			if(rs.next()) {
				User u=new User();
				u.setUsername(rs.getString(1));
				u.setPassword(rs.getString(2));
				u.setPhone(rs.getString(3));
				u.setAddress(rs.getString(4));
				session.setAttribute("user", u);
				resp.sendRedirect(req.getContextPath()+"/show.goods");
				return;
			}
			req.setAttribute("msg", "用户名或密码错误！！！");
			req.getRequestDispatcher("/login.jsp").forward(req, resp);
		} 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();
			}
		}
	}
		db.close();


		}
		req.setAttribute("order", order);
		req.getRequestDispatcher("orderDetail.jsp").forward(req, resp);
		order.clear();
		db.close();
		
	}
	//查询历史订单
	protected void showOrders(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		DataBase db=new DataBase();
		User u=(User)req.getSession().getAttribute("user");
		ResultSet rs = db.getData("SELECT distinct id FROM t_order where un='"+u.getUsername()+"' ");
		try {
			while(rs.next()) {
				String id=rs.getString("id");
				OrderId.add(id);
			}
			
			
		} 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("OrderId", OrderId);
		req.getRequestDispatcher("historyOrders.jsp").forward(req, resp);
		OrderId.clear();
		db.close();
	}
	//生成订单
	protected void generate(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		String id=getOrderIdByTime();
		User u=(User)req.getSession().getAttribute("user");
		String username=u.getUsername();
		DataBase db=new DataBase();
		for(Cart c:cart_) {
			String sql="insert into t_order(id,un,goodsname,number,price) values('"+id+"','"+username+"','"+c.getGoodsname()+"',"+c.getNumber()+","+c.getPrice()+")";
			db.setData(sql);
		}
		db.setData("DELETE FROM t_cart");
		req.setAttribute("id", id);
		req.getRequestDispatcher("success.jsp").forward(req, resp);

		} 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("cart", cart);
		req.getRequestDispatcher("cart.jsp").forward(req, resp);
		cart.clear();
		db.close();
	}

	protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		DataBase db=new DataBase();
		String type=req.getParameter("type");
		//清空
		if("All".equals(type)) {
			String sql="DELETE FROM t_cart";
			db.setData(sql);
			resp.sendRedirect(req.getContextPath()+"/show.cart");
		}
		//删除某个
		else {
			String goodsname=req.getParameter("goodsname");
//			byte[] b=goodsname.getBytes("ISO8859-1");
//			goodsname=new String(b,"utf-8");
//			这里取得的编码是utf-8不做处理，tomcat版本不同返回的值编码可能不一样，如果中文乱码，则对编码进行处理
			String sql="DELETE FROM t_cart WHERE goodsname = '"+goodsname+"' ";
			db.setData(sql);
			resp.sendRedirect(req.getContextPath()+"/show.cart");
		}
		db.close();
	}

}
package servlet;


}
package servlet;

public class CartServlet extends HttpServlet {
	public static List<Cart> cart=new ArrayList<Cart>();
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		String path = req.getServletPath();
		resp.setContentType("text/html;charset=utf-8");
		req.setCharacterEncoding("utf-8");
		resp.setCharacterEncoding("utf-8");
		if("/add.cart".equals(path)){
			add(req,resp);
		}
		if("/show.cart".equals(path)){
			show(req,resp);
		}
		if("/delete.cart".equals(path)){
			delete(req,resp);
		}
	}
	
	protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		String index=req.getParameter("index");
		User u=(User)req.getSession().getAttribute("user");
		String username=u.getUsername();
		DataBase db=new DataBase();
		ResultSet rs = db.getData("SELECT * FROM t_goods where goodsid="+index);
		String goodsname = "";
		Double price = 0.0;
		try {
			if(rs.next()) {
				goodsname=rs.getString(2);
				price=rs.getDouble(3);
			}
			else {


public class UserServlet extends HttpServlet {
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		String path = req.getServletPath();
		resp.setContentType("text/html;charset=utf-8");
		req.setCharacterEncoding("utf-8");
		resp.setCharacterEncoding("utf-8");
		if("/login.user".equals(path)){
			login(req,resp);
		}
		if("/register.user".equals(path)){
			register(req,resp);
		}
		
	}
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		String path = req.getServletPath();
		resp.setContentType("text/html;charset=utf-8");
		req.setCharacterEncoding("utf-8");
		resp.setCharacterEncoding("utf-8");
		if("/logout.user".equals(path)){
			logout(req,resp);
		}
		if("/check.user".equals(path)){
			check(req,resp);

			
		} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
		}
		rs = db.getData("SELECT * FROM t_cart  where goodsname='"+goodsname+"' and un='"+username+"'");
		try {
			if(rs.next()) {
				String sql="UPDATE t_cart SET number="+(rs.getInt("number")+1)+",price="+(price*(rs.getInt("number")+1))+" where goodsname='"+goodsname+"' and un='"+username+"'";
				db.setData(sql);
				req.setAttribute("msg", "商品"+goodsname+"加入购物成成功！");
				req.getRequestDispatcher("/show.goods").forward(req, resp);
			}
			else {
				String sql="insert into t_cart(goodsname,number,price,un) values('"+goodsname+"',1,'"+price+"','"+username+"')";
				System.out.print(sql);
				db.setData(sql);
				req.setAttribute("msg", "商品"+goodsname+"加入购物成成功！");
				req.getRequestDispatcher("/show.goods").forward(req, resp);
			}
			
		} 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();
				}
			}
		}
		db.close();
		
	}
	
	protected void show(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		User u=(User)req.getSession().getAttribute("user");
		String username=u.getUsername();
		DataBase db=new DataBase();
		ResultSet rs = db.getData("SELECT * FROM t_cart where un='"+username+"'");
		
		try {
			while(rs.next()) {
				Cart c=new Cart();
				c.setGoodsname(rs.getString(1));

					rs.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		req.setAttribute("order", order);
		req.getRequestDispatcher("orderDetail.jsp").forward(req, resp);
		order.clear();
		db.close();
		
	}
	//查询历史订单
	protected void showOrders(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		DataBase db=new DataBase();
		User u=(User)req.getSession().getAttribute("user");
		ResultSet rs = db.getData("SELECT distinct id FROM t_order where un='"+u.getUsername()+"' ");
		try {
			while(rs.next()) {
				String id=rs.getString("id");
				OrderId.add(id);
			}
			
			
		} 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("OrderId", OrderId);
		req.getRequestDispatcher("historyOrders.jsp").forward(req, resp);
		OrderId.clear();
		db.close();
	}
	//生成订单
	protected void generate(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		String id=getOrderIdByTime();
		User u=(User)req.getSession().getAttribute("user");
		String username=u.getUsername();
		DataBase db=new DataBase();

		db.close();
		
	}
	
	protected void show(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		User u=(User)req.getSession().getAttribute("user");
		String username=u.getUsername();
		DataBase db=new DataBase();
		ResultSet rs = db.getData("SELECT * FROM t_cart where un='"+username+"'");
		
		try {
			while(rs.next()) {
				Cart c=new Cart();
				c.setGoodsname(rs.getString(1));
				c.setNumber(rs.getInt(2));
				c.setPrice(rs.getDouble(3));
				c.setUsername(username);
				cart.add(c);
				
			}
			
			
		} 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("cart", cart);
		req.getRequestDispatcher("cart.jsp").forward(req, resp);
		cart.clear();
		db.close();
	}

	protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		DataBase db=new DataBase();

	}
	protected void login(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		String username=req.getParameter("username");
		String password=req.getParameter("password");
		HttpSession session=req.getSession();
		DataBase db=new DataBase();
		ResultSet rs = db.getData("SELECT * FROM t_user where un='"+username+"' and pwd='"+password+"'");
		try {
			if(rs.next()) {
				User u=new User();
				u.setUsername(rs.getString(1));
				u.setPassword(rs.getString(2));
				u.setPhone(rs.getString(3));
				u.setAddress(rs.getString(4));
				session.setAttribute("user", u);
				resp.sendRedirect(req.getContextPath()+"/show.goods");
				return;
			}
			req.setAttribute("msg", "用户名或密码错误！！！");
			req.getRequestDispatcher("/login.jsp").forward(req, resp);
		} 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();
			}
		}
	}
		db.close();

	}
	
	protected void logout(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		HttpSession session=req.getSession();
		session.invalidate();
		resp.sendRedirect(req.getContextPath()+"/show.goods");
	}
	protected void check(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		User u=(User)req.getSession().getAttribute("user");
		if(u==null) {
			resp.sendRedirect(req.getContextPath()+"/login.jsp");
			return;

				req.setAttribute("msg", "商品"+goodsname+"加入购物成成功！");
				req.getRequestDispatcher("/show.goods").forward(req, resp);
			}
			
		} 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();
				}
			}
		}
		db.close();
		
	}
	
	protected void show(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		User u=(User)req.getSession().getAttribute("user");
		String username=u.getUsername();
		DataBase db=new DataBase();
		ResultSet rs = db.getData("SELECT * FROM t_cart where un='"+username+"'");
		
		try {
			while(rs.next()) {
				Cart c=new Cart();
				c.setGoodsname(rs.getString(1));
				c.setNumber(rs.getInt(2));
				c.setPrice(rs.getDouble(3));
				c.setUsername(username);
				cart.add(c);
				
			}
			
			
		} 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();
		}finally {
			if(rs!=null) {
				try {
					rs.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		db.close();
		
	}
	
	protected void show(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		User u=(User)req.getSession().getAttribute("user");
		String username=u.getUsername();
		DataBase db=new DataBase();
		ResultSet rs = db.getData("SELECT * FROM t_cart where un='"+username+"'");
		
		try {
			while(rs.next()) {
				Cart c=new Cart();
				c.setGoodsname(rs.getString(1));
				c.setNumber(rs.getInt(2));
				c.setPrice(rs.getDouble(3));
				c.setUsername(username);
				cart.add(c);
				
			}
			
			
		} 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

				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		db.close();
		
	}
	
	protected void show(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		User u=(User)req.getSession().getAttribute("user");
		String username=u.getUsername();
		DataBase db=new DataBase();
		ResultSet rs = db.getData("SELECT * FROM t_cart where un='"+username+"'");
		
		try {
			while(rs.next()) {
				Cart c=new Cart();
				c.setGoodsname(rs.getString(1));
				c.setNumber(rs.getInt(2));
				c.setPrice(rs.getDouble(3));
				c.setUsername(username);
				cart.add(c);
				
			}
			
			
		} 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("cart", cart);
		req.getRequestDispatcher("cart.jsp").forward(req, resp);
		cart.clear();
		db.close();
	}

	protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		DataBase db=new DataBase();
		String type=req.getParameter("type");
		//清空
		if("All".equals(type)) {
			String sql="DELETE FROM t_cart";
			db.setData(sql);


public class GoodsServlet extends HttpServlet {
	public static List<Goods> goods=new ArrayList<Goods>();
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		String path = req.getServletPath();
		resp.setContentType("text/html;charset=utf-8");
		req.setCharacterEncoding("utf-8");
		resp.setCharacterEncoding("utf-8");
		if("/show.goods".equals(path)){
			show(req,resp);
		}
		
	}
	protected void show(HttpServletRequest req, HttpServletResponse resp)
	throws ServletException, IOException {
		DataBase db=new DataBase();
		ResultSet rs = db.getData("SELECT * FROM t_goods");
		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 {
					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();

		HttpSession session=req.getSession();
		DataBase db=new DataBase();
		ResultSet rs = db.getData("SELECT * FROM t_user where un='"+username+"' and pwd='"+password+"'");
		try {
			if(rs.next()) {
				User u=new User();
				u.setUsername(rs.getString(1));
				u.setPassword(rs.getString(2));
				u.setPhone(rs.getString(3));
				u.setAddress(rs.getString(4));
				session.setAttribute("user", u);
				resp.sendRedirect(req.getContextPath()+"/show.goods");
				return;
			}
			req.setAttribute("msg", "用户名或密码错误！！！");
			req.getRequestDispatcher("/login.jsp").forward(req, resp);
		} 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();
			}
		}
	}
		db.close();

	}
	
	protected void logout(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		HttpSession session=req.getSession();
		session.invalidate();
		resp.sendRedirect(req.getContextPath()+"/show.goods");
	}
	protected void check(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		User u=(User)req.getSession().getAttribute("user");
		if(u==null) {
			resp.sendRedirect(req.getContextPath()+"/login.jsp");
			return;
		}
		String tag = req.getParameter("tag");
		if("AddCart".equals(tag)) {
			String index=req.getParameter("index");
			resp.sendRedirect(req.getContextPath()+"/add.cart?index="+index);
		}
		else{
			resp.sendRedirect(req.getContextPath()+"/show.cart");
		}
	}
}


	}
	
	protected void logout(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		HttpSession session=req.getSession();
		session.invalidate();
		resp.sendRedirect(req.getContextPath()+"/show.goods");
	}
	protected void check(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		User u=(User)req.getSession().getAttribute("user");
		if(u==null) {
			resp.sendRedirect(req.getContextPath()+"/login.jsp");
			return;
		}
		String tag = req.getParameter("tag");
		if("AddCart".equals(tag)) {
			String index=req.getParameter("index");
			resp.sendRedirect(req.getContextPath()+"/add.cart?index="+index);
		}
		else{
			resp.sendRedirect(req.getContextPath()+"/show.cart");
		}
	}
}
package servlet;


				// TODO Auto-generated catch block
				e.printStackTrace();
	}finally {
		if(rs!=null) {
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
		db.close();

	}
	
	protected void logout(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		HttpSession session=req.getSession();
		session.invalidate();
		resp.sendRedirect(req.getContextPath()+"/show.goods");
	}
	protected void check(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		User u=(User)req.getSession().getAttribute("user");
		if(u==null) {
			resp.sendRedirect(req.getContextPath()+"/login.jsp");
			return;
		}
		String tag = req.getParameter("tag");
		if("AddCart".equals(tag)) {
			String index=req.getParameter("index");
			resp.sendRedirect(req.getContextPath()+"/add.cart?index="+index);
		}
		else{
			resp.sendRedirect(req.getContextPath()+"/show.cart");
		}
	}
}
package servlet;


			}
			
		} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
		}
		rs = db.getData("SELECT * FROM t_cart  where goodsname='"+goodsname+"' and un='"+username+"'");
		try {
			if(rs.next()) {
				String sql="UPDATE t_cart SET number="+(rs.getInt("number")+1)+",price="+(price*(rs.getInt("number")+1))+" where goodsname='"+goodsname+"' and un='"+username+"'";
				db.setData(sql);
				req.setAttribute("msg", "商品"+goodsname+"加入购物成成功！");
				req.getRequestDispatcher("/show.goods").forward(req, resp);
			}
			else {
				String sql="insert into t_cart(goodsname,number,price,un) values('"+goodsname+"',1,'"+price+"','"+username+"')";
				System.out.print(sql);
				db.setData(sql);
				req.setAttribute("msg", "商品"+goodsname+"加入购物成成功！");
				req.getRequestDispatcher("/show.goods").forward(req, resp);
			}
			
		} 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();
				}
			}
		}
		db.close();
		
	}
	
	protected void show(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		User u=(User)req.getSession().getAttribute("user");
		String username=u.getUsername();
		DataBase db=new DataBase();

				cart.add(c);
				
			}
			
			
		} 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("cart", cart);
		req.getRequestDispatcher("order.jsp").forward(req, resp);
		//备份 cart
		cart_.clear();
		cart_.addAll(cart);
		//清空
		cart.clear();
		db.close();
	}

}
package servlet;

public class CartServlet extends HttpServlet {
	public static List<Cart> cart=new ArrayList<Cart>();
	@Override

		order.clear();
		db.close();
		
	}
	//查询历史订单
	protected void showOrders(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		DataBase db=new DataBase();
		User u=(User)req.getSession().getAttribute("user");
		ResultSet rs = db.getData("SELECT distinct id FROM t_order where un='"+u.getUsername()+"' ");
		try {
			while(rs.next()) {
				String id=rs.getString("id");
				OrderId.add(id);
			}
			
			
		} 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("OrderId", OrderId);
		req.getRequestDispatcher("historyOrders.jsp").forward(req, resp);
		OrderId.clear();
		db.close();
	}
	//生成订单
	protected void generate(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		String id=getOrderIdByTime();
		User u=(User)req.getSession().getAttribute("user");
		String username=u.getUsername();
		DataBase db=new DataBase();
		for(Cart c:cart_) {
			String sql="insert into t_order(id,un,goodsname,number,price) values('"+id+"','"+username+"','"+c.getGoodsname()+"',"+c.getNumber()+","+c.getPrice()+")";
			db.setData(sql);
		}
		db.setData("DELETE FROM t_cart");
		req.setAttribute("id", id);
		req.getRequestDispatcher("success.jsp").forward(req, resp);
		cart_.clear();
		db.close();
	}
	//确认订单
	protected void confirm(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		User u=(User)req.getSession().getAttribute("user");

		try {
			while(rs.next()) {
				Order o=new Order();
				o.setUsername(rs.getString("un"));
				o.setGoodsname(rs.getString("goodsname"));
				o.setNumber(rs.getInt("number"));
				o.setPrice(rs.getDouble("price"));
				o.setId(OrderId);
				order.add(o);
			}
			
			
		} 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("order", order);
		req.getRequestDispatcher("orderDetail.jsp").forward(req, resp);
		order.clear();
		db.close();
		
	}
	//查询历史订单
	protected void showOrders(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		DataBase db=new DataBase();
		User u=(User)req.getSession().getAttribute("user");
		ResultSet rs = db.getData("SELECT distinct id FROM t_order where un='"+u.getUsername()+"' ");
		try {
			while(rs.next()) {
				String id=rs.getString("id");
				OrderId.add(id);
			}
			
			
		} 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();
				}


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);
			
		}
		return newDate+result;
	}
		
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		String path = req.getServletPath();
		resp.setContentType("text/html;charset=utf-8");
		req.setCharacterEncoding("utf-8");
		resp.setCharacterEncoding("utf-8");
		if("/confirm.order".equals(path)){
			confirm(req,resp);
		}
		if("/generate.order".equals(path)){
			generate(req,resp);
		}
		if("/showOrders.order".equals(path)){

请添加图片描述

请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述

请添加图片描述

m0_71016350
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
jsp实现的购物车编写工具myeclipse+server2005
12-29
主要是利用jsp中的内置对象session来实现购物车的功能！myeclipse+sql server2005开发！
myEclipse实现购物车
12-06
使用JDBC数据库驱动及操作数据及使用JSP内置对象的使用 开发一个简易购物车程序
jsp+servlet实现商城购物车功能
想吃一口西多
05-29 1万+
&lt;a href="AddCart?id=${b.id}"&gt;&lt;button class="btn btn-default"&gt;加入购物车&lt;span class="glyphicon glyphicon-shopping-cart"&gt;&lt;/span&gt;&lt;/button&gt;&lt;/a&gt; 商品详情页
servlet+jsp实现小小购物车功能
热门推荐
freshbin000的博客
08-28 3万+
使用jsp以及servlet实现购物车功能
JavaWeb实现模拟数据库实现购物车功能
最新发布
2301_79501633的博客
04-30 372
Product类 ，是一共父类后续物品都继承它。4.1 增加到购物车的业务逻辑。4.2 删除购物车的业务逻辑。
servlet版购物车项目（上）
weixin_67235801的博客
04-29 3012
servlet购物车项目（上）
【JAVAWEB开发】基于Java+Servlet+Ajax+jsp网上购物系统设计实现
程序猿追的博客
09-01 1万+
在传统电商时代，用户是先有需求再购买，用户对平台较为依赖，商家对消费者很难有直接的影响力，而如今社交 + 电商解决了产品质量的信息不对称问题，电商已经成为当今经济发展的一个重要领域。...
简单实现将商品加入购物车（初级）
m0_71293166的博客
02-07 565
【代码】简单实现将商品加入购物车（初级）
javaWeb网上购物系统的设计与实现
m0_58065010的博客
10-07 1万+
(1) 用户实体拥有的属性有用户ID、用户名、用户密码、性别、姓名、电话、邮寄地址和电子邮箱这八个属性。用户实体属性如图5-1所示。图5-1 用户实体属性图(2) 商品实体拥有的属性有商品ID、商品名称、商品种类、商品图片、商品描述、商品厂商、商城价格、商品原价、总数量和剩余数量这十个属性。商品实体属性如图5-2所示。图5-2 商品实体属性图(3) 商品种类实体拥有的属性有商品种类和商品种类名称这两个属性。商品种类实体属性如图5-3所示。图5-3 商品种类实体属性图。
JavaWeb实现简单购物车案例
hssjsh的博客
10-17 3115
JavaWeb实现简单购物车案例
Java项目:电影院售票管理系统(java+Servlet+JSP+JDBC+Mysql)
07-09
这个项目是一个基于Servlet+JSP的电影院售票系统，分为管理员和会员两种角色。 管理员权限包括： 修改登录密码 电影类别管理 电影信息管理 会员信息管理 订单信息管理 留言信息管理 会员权限包括： 会员注册 ...
Java项目:在线奶茶店系统(java+JSP+JavaScript+servlet+Mysql)
06-24
JSP+CSS+JavaScript+java+servlet+mysql 使用说明 1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导
基于jsp+element+mysql+servlet实现的图书商城的前后端项目（含报告）
06-30
适用于简单的javaweb期末课程设计。包含功能如下所示。 1）前端功能 图书的分类展示; 图书详情 图书搜索 订单详情(购物车) 登录与注册 注意：注册用户可以购买商品，非注册用户仅可以浏览、查询商品 2）后端功能 ...
Java web 购物车myeclipse工程
03-01
Java web 购物车myeclipse maven工程ServletCartDemo Java web 购物车myeclipse maven工程ServletCartDemo
jsp购物车代码Myeclipse
11-17
Myeclipse编写的简易购物车代码，界面进行了简单的美化，实现了将物品添加至购物车，清空购物车，删除商品等功能，供初学者参考
jsp开发的一个简单的购物车程序源码
05-16
开发工具myeclipse，数据库mysql,服务器tomcat
Java项目:网上书城+后台管理系统(java+jsp+servlert+mysql+ajax)
04-07
功能： 前台： * 用户模块 * 分类模块 * 图书模块 * 购物车模块 * 订单模块 后台： * 管理员模块 * 分类管理模块 * 图书管理模块 * 订单模块 二、项目运行 环境配置： Jdk1.8 + Tomcat8.5 + mysql + Eclispe ...
Java项目:仿天猫网上商城项目(java+jsp+servlet+mysql+ajax)
02-14
环境配置： Jdk1.8 + Tomcat8.5 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持) 项目技术： JSP + C3P0+ Servlert + html+ css + JavaScript + JQuery + Ajax + Fileupload等等。
javaweb实现购物车功能
m0_65525347的博客
11-11 1万+
JavaWeb实现购物车功能(javaweb练手小项目)欢迎阅读
给我一个完整的基于Javaweb的Spring+jsp+Servlet+MySql的超市订单管理系统
06-10
好的，我可以给你简单介绍一下一个基于Javaweb的Spring+jsp+Servlet+MySql的超市订单管理系统的大致架构和功能模块。 该系统主要分为前台和后台两个部分，前台是顾客使用的界面，可以进行商品浏览、购物车管理、...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值