基于javaweb的JSP+Servlet二手自行车商城系统(java+jsp+javascript+servlet+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb的JSP+Servlet二手自行车商城系统(java+jsp+javascript+servlet+mysql)

项目介绍

本系统分为前后台，分为普通用户和管理员两种角色；

管理员角色包含以下功能： 管理员登录,用户管理,自行车分类管理,商品管理,订单管理,留言和公告管理等功能。

用户角色包含以下功能： 浏览自行车,查看自行车,结算订单,用户登录注册,查看订单,在线留言等功能。

环境需要

1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可 4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS；  5.数据库：MySql 5.7版本； 6.是否Maven项目：否；

技术栈

JSP+CSS+JavaScript+java+servlet+mysql

使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven; 若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中src/com/hr/dao/Basedao.java配置文件中的数据库配置改为自己的配置; 4. 运行项目，输入http://localhost:8080/ 登录 管理员账号/密码：admin/admin  用户账号/密码：user/123456

			red=rand.nextInt(255);
			green=rand.nextInt(255);
			blue=rand.nextInt(255);
			
			Color c=new Color(red,green,blue);
			g.setColor(c);
			int num=rand.nextInt(10);
			code+=num;
			g.drawString(num+"", i*20+20, 49);
		}
		
		HttpSession session=req.getSession();
		session.setAttribute("syscode", code);
		
		ServletOutputStream out=resp.getOutputStream();
		ImageIO.write(img, "jpg", out);
		
		
	}
}
package com.demo.Servlet;





public class UseraddServlet 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");

			
			}
		 
		}
  
package com.demo.Servlet;





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();
	//查询最近浏览的商品

			String id=(String)eu.getEU_USER_ID();
			ArrayList<eb_shop> list=ESDao.getShop(id);
			req.setAttribute("shoplist",list);
			//req.getRequestDispatcher("shopping.jsp").forward(req, resp);
		}else{
			out.print("<script>");
			out.print("alert('请先登录');");
			out.print("location.href='login.jsp';");
			out.print("</script>");
			out.close();
			return;
		}
		String uid = user.getEU_USER_ID();
		int valid = 1;
		eb_shop sp = new eb_shop(0, p.getEP_FILE_NAME(), p.getEP_NAME(), p.getEP_PRICE(), Integer.parseInt(count), p.getEP_STOCK(), p.getEP_ID(), uid, valid);
		int epid=p.getEP_ID();
		ESDao.insert(sp);
		resp.sendRedirect("selectProductView?id="+epid);
		
		//req.getRequestDispatcher("selectProductView?id=").forward(req, resp);
	}
}
package com.demo.Servlet;





public class ShopAddServlet extends HttpServlet {
	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
//		  es_id           NUMBER primary key not null,--id
//		  es_ep_file_name NVARCHAR2(30),--图片名称
//		  es_ep_name      NVARCHAR2(30),--商品名

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);
	}
	
		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);
}

		EASYBUY_USER user=EASYBUY_USERDao.selectAdmin(username, passWord);
		if(sysCode.equals(veryCode)){
			if(count>0){
				session.setAttribute("name", user);
				if(user.getEU_STATUS()==2){
					//System.out.println(user.getEU_STATUS());
					//resp.sendRedirect("manage/index.jsp");
					resp.sendRedirect("manage/index.jsp");
				}else{
					resp.sendRedirect("indexSelect");
				}
			}else{
				PrintWriter out = resp.getWriter();
				out.print("<script>");
				out.print("alert('用户名或密码错误');");
				out.print("location.href='login.jsp';");
				out.print("</script>");
				out.close();
			}
		}else{
			PrintWriter out = resp.getWriter();
			out.print("<script>");
			out.print("alert('验证码错误');");
			out.print("location.href='login.jsp';");
			out.print("</script>");
			out.close();
		}
	}
}
package com.demo.Servlet;





public class IndexSelectServlet extends HttpServlet {
	@SuppressWarnings("unchecked")
	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp)

---

项目链接：
https://javayms.github.io?id=501122512008200ng
https://javayms.pages.dev?id=501122512008200ng