基于javaweb+mysql的jsp+servlet在线商城购物商城服装商城(前台、后台)(java+jsp+servlet+mysql)

基于javaweb+mysql的jsp+servlet在线商城购物商城服装商城(前台、后台)(java+jsp+servlet+mysql)

私信源码获取及调试交流

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

在线商城，实现了商城的基本功能

如分类展示商品信息、搜索商品信息、用户注册登录、添加商品到购物车、提交订单、个人中心查看订单、留言板留言等

管理员登录后台后可以查看管理用户信息、商品分类信息、商品信息、新闻信息、留言信息、订单信息等。

商城模板通用，可修改为任意商城，如手机商城、鲜花商城等等

后台管理员

前台用户

技术框架

CSS JavaScript JSP Servlet JDBC MySQL

基于javaweb+mysql的JSP+Servlet在线商城购物商城服装商城(前台、后台)(java+jsp+servlet+mysql)

		
		Files fs = su.getFiles();//获得所有文件
		File f = fs.getFile(0);//获得上传的文件
		String fname = f.getFileName();//获得文件名
		try {
			su.save("images/product");//保存图片到指定位置
		} catch (SmartUploadException e) {
			e.printStackTrace();
		}
		Request req1 = su.getRequest();
		String pname = req1.getParameter("productName");
		String id = req1.getParameter("parentId");
		String price = req1.getParameter("productPrice");
		String desc = req1.getParameter("productDesc");
		String stock = req1.getParameter("productStock");
		EASYBUY_PRODUCT p = null;
		if(price!=null && stock!=null && id!=null){
			p = new EASYBUY_PRODUCT(0, pname, desc, 
													Integer.parseInt(price), 
													Integer.parseInt(stock), 
													Integer.parseInt(id.split("-")[0]), 
													Integer.parseInt(id.split("-")[1]), 
													fname);
		}
		int count = 0;
		if(p!=null){
			count = EASYBUY_PRODUCTDao.insert(p);
		}
		
		req.getRequestDispatcher("productSelect").forward(req, resp);
		
	}
}

public class SelectProductViewServlet extends HttpServlet {
	@SuppressWarnings("unchecked")

}
}

public class RegisterInServlet extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
	req.setCharacterEncoding("UTF-8");
	String username=req.getParameter("userName");
	String name=req.getParameter("name");
	String rePassWord=req.getParameter("rePassWord");
	String sex=req.getParameter("sex");
	String year=req.getParameter("birthday");
	String email=req.getParameter("email");
	String mobile=req.getParameter("mobile");
	String address=req.getParameter("address");
	String veryCode=req.getParameter("veryCode");
	
	HttpSession session = req.getSession();
	//获得系统生成的验证码
	String sysCode = (String)session.getAttribute("syscode");
	EASYBUY_USER u=new EASYBUY_USER(username, name, rePassWord, sex, year, null, email, mobile, address, 1);
	int count=EASYBUY_USERDao.insert(u);
	PrintWriter out=resp.getWriter();
	if(sysCode.equals(veryCode)){
		if(count>0){
			resp.sendRedirect("reg-result.jsp");
		}else{
			out.write("<script>");
			out.write("alert('register error');");
			out.write("location.href='register.jsp'");
			out.write("</script>");
			out.close();
		}
	}
	
	
	}
}

//	String birthday=request.getParameter("birthday");
	
//	String year=birthyear+"-"+birthmonth+"-"+birthday;
	String year=req.getParameter("birthday");
	String email=req.getParameter("email");
	String mobile=req.getParameter("mobile");
	String address=req.getParameter("address");
	
	EASYBUY_USER u=new EASYBUY_USER(username, name, pwd, sex, year, null, email, mobile, address, 1);
	int count=EASYBUY_USERDao.insert(u);
	PrintWriter out=resp.getWriter();
	if(count>0){
		resp.sendRedirect("manage-result.jsp");
	}else{
		out.write("<script>");
		out.write("alert('添加失败');");
		out.write("location.href='user-add.jsp'");
		out.write("</script>");
		out.close();
	}
}
}

public class RegisterInServlet extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
	req.setCharacterEncoding("UTF-8");
	String username=req.getParameter("userName");
	String name=req.getParameter("name");
	String rePassWord=req.getParameter("rePassWord");
	String sex=req.getParameter("sex");
	String year=req.getParameter("birthday");
	String email=req.getParameter("email");
	String mobile=req.getParameter("mobile");
	String address=req.getParameter("address");
	String veryCode=req.getParameter("veryCode");
	
	HttpSession session = req.getSession();

		req.setAttribute("tpage", tpage);
		//搜索关键字
		req.setAttribute("search_words", name);
		//父分类
		req.setAttribute("selected_fid", fid);
		req.getRequestDispatcher("product-list.jsp").forward(req, resp);
	}
}

public class gmServlet extends HttpServlet {
@Override
protected void service(HttpServletRequest arg0, HttpServletResponse arg1)
		throws ServletException, IOException {
	arg1.setContentType("text/html;charset=utf-8");
	PrintWriter out=arg1.getWriter();
	EncodeUtil.encode(arg0);
	HttpSession session=arg0.getSession();
	EASYBUY_USER list=(EASYBUY_USER)session.getAttribute("name");
	//用户id
	String id=list.getEU_USER_ID();
	//用户姓名
	String name=list.getEU_USER_NAME();
	//用户地址
	String address=list.getEU_ADDRESS();
	//总价钱
	String price=arg0.getParameter("jstext");
	
	//商品id

					//把当前页数传递给guestbook.jsp使用
					req.setAttribute("page", page);
					// 跳
				 	req.getRequestDispatcher("guestbook.jsp").forward(req,resp);
				}else{
					req.setAttribute("list", list);
					//把总页数传递给guestbook.jsp 使用
					req.setAttribute("max_page", max_page);
					//把当前页数传递给guestbook.jsp使用
					req.setAttribute("page", page);
					// 跳
				 	req.getRequestDispatcher("guestbook.jsp").forward(req,resp);
				}
				
			
			}
		 
		}
  

public class SelectDD extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
	req.setCharacterEncoding("UTF-8");
	//查询分类数据
	ArrayList<EASYBUY_PRODUCT_CATEGORY> flist = EASYBUY_PRODUCT_CATEGORYDao.selectFather();
	req.setAttribute("flist", flist);
	ArrayList<EASYBUY_PRODUCT_CATEGORY> clist = EASYBUY_PRODUCT_CATEGORYDao.selectChild();
	req.setAttribute("clist", clist);
	ArrayList<EASYBUY_PRODUCT> tlist = EASYBUY_PRODUCTDao.selectAllByT();
	req.setAttribute("tlist", tlist);

	req.setCharacterEncoding("UTF-8");
	//查询分类数据
	ArrayList<EASYBUY_PRODUCT_CATEGORY> flist = EASYBUY_PRODUCT_CATEGORYDao.selectFather();
	req.setAttribute("flist", flist);
	ArrayList<EASYBUY_PRODUCT_CATEGORY> clist = EASYBUY_PRODUCT_CATEGORYDao.selectChild();
	req.setAttribute("clist", clist);
	ArrayList<EASYBUY_PRODUCT> tlist = EASYBUY_PRODUCTDao.selectAllByT();
	req.setAttribute("tlist", tlist);
	ArrayList<EASYBUY_PRODUCT> hlist = EASYBUY_PRODUCTDao.selectAllByHot();
	req.setAttribute("hlist", hlist);
	ArrayList<EASYBUY_NEWS> nlist = EASYBUY_NEWSDao.selectAll();
	req.setAttribute("nlist", nlist);
	HttpSession session = req.getSession();
	//查询最近浏览的商品
	ArrayList<Integer> ids = (ArrayList<Integer>)session.getAttribute("ids");
	if(ids!=null){
		ArrayList<EASYBUY_PRODUCT> lastlylist = EASYBUY_PRODUCTDao.selectById(ids);
		req.setAttribute("lastlylist", lastlylist);
	}
	
		EncodeUtil.encode(req);
		String dd=req.getParameter("dd");
		ArrayList<EASYBUY_Ddan> dan=EASYBUY_DdanDao.selectById(dd);
		req.setAttribute("dan", dan);
		req.getRequestDispatcher("Dan.jsp").forward(req, resp);
}
}

public class DoProductUpdateServlet extends HttpServlet {
	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
SmartUpload su = new SmartUpload();
		
		su.initialize(this.getServletConfig(), req, resp);
		
		try {

	EASYBUY_USER list=(EASYBUY_USER)session.getAttribute("name");
	//用户id
	String id=list.getEU_USER_ID();
	//用户姓名
	String name=list.getEU_USER_NAME();
	//用户地址
	String address=list.getEU_ADDRESS();
	//总价钱
	String price=arg0.getParameter("jstext");
	
	//商品id
	String [] EP_ID=arg0.getParameterValues("spID");
	//购买数量
	String [] quantity=arg0.getParameterValues("number");
	//商品单价
	String [] sPPrice=arg0.getParameterValues("sPPrice");
	
	//购买后对商品表的库存进行修改
	for(int i=0;i<EP_ID.length;i++){
		int count5=ESDao.updateStock(Integer.parseInt(quantity[i]),Integer.parseInt(EP_ID[i]));
	}
	//商品单个总价
	int [] pprice=new int[EP_ID.length];
	for(int i=0;i<EP_ID.length;i++){
		pprice[i]=Integer.parseInt(quantity[i])*Integer.parseInt(sPPrice[i]);
	} 
	/得到序列
	//往订单表里添加数据
	int count=ESDao.insertDD(id, name, address,Integer.parseInt(price));
	int getSequenceId=ESDao.getSequenceId();
	//循环往订单详情添加
	for(int i=0;i<EP_ID.length;i++){
		EASYBUY_ORDER_DETAIL eod=new EASYBUY_ORDER_DETAIL(1,getSequenceId,Integer.parseInt(EP_ID[i]),Integer.parseInt(quantity[i]),pprice[i]);
		int count2=ESDao.eodInsert(eod);
	}
	
	
	
	// 开单后，修改购物车
	String [] esID=arg0.getParameterValues("esID");
	for(int i=0;i<esID.length;i++){

		ArrayList<EASYBUY_NEWS> nlist = EASYBUY_NEWSDao.selectAll();
		req.setAttribute("nlist", nlist);
		HttpSession session = req.getSession();
		//查询最近浏览的商品
		ArrayList<Integer> ids = (ArrayList<Integer>)session.getAttribute("ids");
		if(ids!=null){
			ArrayList<EASYBUY_PRODUCT> lastlylist = EASYBUY_PRODUCTDao.selectById(ids);
			req.setAttribute("lastlylist", lastlylist);
		}
		req.getRequestDispatcher("index.jsp").forward(req, resp);
	}
}

public class UserNumServlet extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
		int width=120;
		int height=60;
		BufferedImage img=new BufferedImage(width, height,BufferedImage.TYPE_INT_RGB);
		Graphics2D g=img.createGraphics();
		
		g.setColor(Color.LIGHT_GRAY);
		g.fillRect(0, 0, width, height);
		
		g.setColor(Color.YELLOW);
		Random rand=new Random();
		for (int i = 0; i < 15; i++) {
			int x1=rand.nextInt(width);
			int y1=rand.nextInt(width);
			int x2=rand.nextInt(width);
			int y2=rand.nextInt(width);

		} catch (SmartUploadException e) {
			e.printStackTrace();
		}
		Request req1 = su.getRequest();
		String id = req1.getParameter("id");
		String pname = req1.getParameter("productName");
		String pid = req1.getParameter("parentId");
		String price = req1.getParameter("productPrice");
		String desc = req1.getParameter("productDesc");
		String stock = req1.getParameter("productStock");
		EASYBUY_PRODUCT p = new EASYBUY_PRODUCT(Integer.parseInt(id), 
												pname, 
												desc, 
												Integer.parseInt(price), 
												Integer.parseInt(stock), 
												Integer.parseInt(pid.split("-")[0]), 
												Integer.parseInt(pid.split("-")[1]), 
												fname);
		int count = 0;
		if(p!=null){
			count = EASYBUY_PRODUCTDao.update(p);
		}
		
		req.getRequestDispatcher("productSelect").forward(req, resp);
		
	}
}

public class DoProductAddServlet extends HttpServlet {
	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {

		
	}
}

public class SelectProductViewServlet extends HttpServlet {
	@SuppressWarnings("unchecked")
	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		
		
		ArrayList<EASYBUY_PRODUCT_CATEGORY> flist = EASYBUY_PRODUCT_CATEGORYDao.selectFather();
		req.setAttribute("flist", flist);
		ArrayList<EASYBUY_PRODUCT_CATEGORY> clist = EASYBUY_PRODUCT_CATEGORYDao.selectChild();
		req.setAttribute("clist", clist);
		String id = req.getParameter("id");
		HttpSession session = req.getSession();
		//查询最近浏览的商品
		ArrayList<Integer> ids = (ArrayList<Integer>)session.getAttribute("ids");
		if(ids==null){
			ids = new ArrayList<Integer>();
		}
		if(ids.size()>=5){
			ids.remove(0);

	//商品单价
	String [] sPPrice=arg0.getParameterValues("sPPrice");
	
	//购买后对商品表的库存进行修改
	for(int i=0;i<EP_ID.length;i++){
		int count5=ESDao.updateStock(Integer.parseInt(quantity[i]),Integer.parseInt(EP_ID[i]));
	}
	//商品单个总价
	int [] pprice=new int[EP_ID.length];
	for(int i=0;i<EP_ID.length;i++){
		pprice[i]=Integer.parseInt(quantity[i])*Integer.parseInt(sPPrice[i]);
	} 
	/得到序列
	//往订单表里添加数据
	int count=ESDao.insertDD(id, name, address,Integer.parseInt(price));
	int getSequenceId=ESDao.getSequenceId();
	//循环往订单详情添加
	for(int i=0;i<EP_ID.length;i++){
		EASYBUY_ORDER_DETAIL eod=new EASYBUY_ORDER_DETAIL(1,getSequenceId,Integer.parseInt(EP_ID[i]),Integer.parseInt(quantity[i]),pprice[i]);
		int count2=ESDao.eodInsert(eod);
	}
	
	
	
	// 开单后，修改购物车
	String [] esID=arg0.getParameterValues("esID");
	for(int i=0;i<esID.length;i++){
		int count3 =ESDao.esdelete(Integer.parseInt(esID[i]));
	}
	/
	if(count>0){
			
		out.print("<script>");
		out.print("alert('购物成功');");
		out.print("location.href='shopping-result.jsp';");
		out.print("</script>");
		out.close();
	}else{
		out.print("<script>");
		out.print("alert('购物失败，请重新选择商品');");
		out.print("location.href='ShopSelect';");
		out.print("</script>");
		out.close();
	}
}
}

public class IndexSelectServlet extends HttpServlet {
	@SuppressWarnings("unchecked")
	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		//查询分类数据
		ArrayList<EASYBUY_PRODUCT_CATEGORY> flist = EASYBUY_PRODUCT_CATEGORYDao.selectFather();
		req.setAttribute("flist", flist);
		ArrayList<EASYBUY_PRODUCT_CATEGORY> clist = EASYBUY_PRODUCT_CATEGORYDao.selectChild();
		req.setAttribute("clist", clist);
		ArrayList<EASYBUY_PRODUCT> tlist = EASYBUY_PRODUCTDao.selectAllByT();
		req.setAttribute("tlist", tlist);
		ArrayList<EASYBUY_PRODUCT> hlist = EASYBUY_PRODUCTDao.selectAllByHot();
		req.setAttribute("hlist", hlist);
		ArrayList<EASYBUY_NEWS> nlist = EASYBUY_NEWSDao.selectAll();
		req.setAttribute("nlist", nlist);
		HttpSession session = req.getSession();
		//查询最近浏览的商品
		ArrayList<Integer> ids = (ArrayList<Integer>)session.getAttribute("ids");
		if(ids!=null){
			ArrayList<EASYBUY_PRODUCT> lastlylist = EASYBUY_PRODUCTDao.selectById(ids);
			req.setAttribute("lastlylist", lastlylist);
		}
		req.getRequestDispatcher("index.jsp").forward(req, resp);
	}
}

public class UserNumServlet extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)

  

public class SelectDD extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
	req.setCharacterEncoding("UTF-8");
	//查询分类数据
	ArrayList<EASYBUY_PRODUCT_CATEGORY> flist = EASYBUY_PRODUCT_CATEGORYDao.selectFather();
	req.setAttribute("flist", flist);
	ArrayList<EASYBUY_PRODUCT_CATEGORY> clist = EASYBUY_PRODUCT_CATEGORYDao.selectChild();
	req.setAttribute("clist", clist);
	ArrayList<EASYBUY_PRODUCT> tlist = EASYBUY_PRODUCTDao.selectAllByT();
	req.setAttribute("tlist", tlist);
	ArrayList<EASYBUY_PRODUCT> hlist = EASYBUY_PRODUCTDao.selectAllByHot();
	req.setAttribute("hlist", hlist);
	ArrayList<EASYBUY_NEWS> nlist = EASYBUY_NEWSDao.selectAll();
	req.setAttribute("nlist", nlist);
	HttpSession session = req.getSession();
	//查询最近浏览的商品
	ArrayList<Integer> ids = (ArrayList<Integer>)session.getAttribute("ids");
	if(ids!=null){
		ArrayList<EASYBUY_PRODUCT> lastlylist = EASYBUY_PRODUCTDao.selectById(ids);
		req.setAttribute("lastlylist", lastlylist);
	}
	

 

public class UpManage extends HttpServlet {
	@Override
	protected void service(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		int id=Integer.parseInt(request.getParameter("orderId"));
		String name=request.getParameter("name");
		String replyContent=request.getParameter("replyContent");
		String Content=request.getParameter("Content");
		Date date=new Date();
		System.out.println(Content);
		SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		String replyTime=sdf.format(date);
		EASYBUY_COMMENT comment=new EASYBUY_COMMENT(id,Content,replyTime,replyContent,replyTime,name);
	 
		//System.out.println(id+"--"+content+"--"+replyTime+"--"+replyContent+"--"+name);
		comment.setEC_ID(id);
		int num=EASYBUY_COMMENTDao.update(comment);
		if(num>0){
			response.sendRedirect("manage-result.jsp");
		}else{
		}
	}
}

			tpage = EASYBUY_PRODUCTDao.totalPage(count);
		}
		if(fid!=null){
			int id = Integer.parseInt(fid);
			list = EASYBUY_PRODUCTDao.selectAllByFid(cpage, count, id);
			tpage = EASYBUY_PRODUCTDao.totalPageByFid(count, id);
			req.setAttribute("title", EASYBUY_PRODUCT_CATEGORYDao.selectById(id).getEPC_NAME());
		}
		if(cid!=null){
			int id = Integer.parseInt(cid);
			list = EASYBUY_PRODUCTDao.selectAllByCid(cpage, count, id);
			tpage = EASYBUY_PRODUCTDao.totalPageByCid(count, id);
			req.setAttribute("title", EASYBUY_PRODUCT_CATEGORYDao.selectById(id).getEPC_NAME());
		}
		if(name!=null){
			list = EASYBUY_PRODUCTDao.selectAllByName(name);
			tpage = EASYBUY_PRODUCTDao.totalPageByName(count, name);
			req.setAttribute("title", "搜索商品："+name);
		} 
		req.setAttribute("list", list);
		//当前页数
		req.setAttribute("cpage", cpage);
		//总页数
		req.setAttribute("tpage", tpage);
		//搜索关键字
		req.setAttribute("search_words", name);
		//父分类
		req.setAttribute("selected_fid", fid);
		req.getRequestDispatcher("product-list.jsp").forward(req, resp);
	}
}

public class SelallServlet extends HttpServlet {
			@Override
			protected void service(HttpServletRequest req, HttpServletResponse resp)
					throws ServletException, IOException {
				req.setCharacterEncoding("utf-8");
				resp.setContentType("text/html;charset=utf-8");
				int page=1; //当前页数
				int pagesize=6;//每页行数
				String spage=req.getParameter("page");
				ArrayList<EASYBUY_PRODUCT_CATEGORY> flist = EASYBUY_PRODUCT_CATEGORYDao.selectFather();
				req.setAttribute("flist", flist);
				ArrayList<EASYBUY_PRODUCT_CATEGORY> clist = EASYBUY_PRODUCT_CATEGORYDao.selectChild();
				req.setAttribute("clist", clist);
				if(spage!=null){ //如果页面上传递了页数,将当前页数改变掉
					page=Integer.parseInt(spage);
				}
 
				//查出总页数
				
				ArrayList<EASYBUY_COMMENT> list=EASYBUY_COMMENTDao.selPage(page, pagesize);
				int max_page=EASYBUY_COMMENTDao.getMax(pagesize);
				if(list.size()>0&&max_page>0){ 
					req.setAttribute("list", list);
					//把总页数传递给guestbook.jsp 使用
					req.setAttribute("max_page", max_page);
					//把当前页数传递给guestbook.jsp使用
					req.setAttribute("page", page);
					// 跳
				 	req.getRequestDispatcher("guestbook.jsp").forward(req,resp);
				}else{
					req.setAttribute("list", list);
					//把总页数传递给guestbook.jsp 使用
					req.setAttribute("max_page", max_page);
					//把当前页数传递给guestbook.jsp使用
					req.setAttribute("page", page);
					// 跳

	}
	
	
	}
}

public class UserDoupdate extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
		EncodeUtil.encode(req);
		resp.setContentType("text/html;charset=utf-8");
		String username=req.getParameter("userName");
		String name=req.getParameter("name");
		String pwd=req.getParameter("passWord");
		String sex=req.getParameter("sex");
		String birthday=req.getParameter("birthday");
		String email=req.getParameter("email");
		String mobile=req.getParameter("mobile");
		String address=req.getParameter("address");
		String userStatus=req.getParameter("userStatus");
		int status = 1;
		if(userStatus != null && !"".equals(userStatus)){
			status = Integer.parseInt(userStatus);
		}
		EASYBUY_USER user=new EASYBUY_USER(username, name, pwd, sex, birthday, null, email, mobile, address, status);
		int count=EASYBUY_USERDao.update(user);
		if(count>0){
			resp.sendRedirect("manage-result.jsp");
		}else{
			PrintWriter out=resp.getWriter();