Java源码社

基于javaweb的JSP+Servlet在线商城鲜花花卉商城(前台、后台)(java+jsp+servlet+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

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

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

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

idea或eclipse

582023270206

400123092502

410123092502

后台管理员

480123092502

490123092502

510123092502

520123092502

530123092502

540123092502

550123092502

560123092502

570123092502

580123092502

前台用户

420123092502

430123092502

440123092502

450123092502

460123092502

470123092502

技术框架

CSS JavaScript JSP Servlet JDBC MySQL

基于javaweb的JSP+Servlet在线商城鲜花花卉商城(前台、后台)(java+jsp+servlet+mysql)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

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);
}
}
package com.demo.Servlet;


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47

public class LoginServlet extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
		req.setCharacterEncoding("UTF-8");
		String username=req.getParameter("userName");
		String passWord=req.getParameter("passWord");
		String veryCode=req.getParameter("veryCode");
		resp.setContentType("text/html;charset=utf-8");
		HttpSession session = req.getSession();
		//获得系统生成的验证码
		String sysCode = (String)session.getAttribute("syscode");
		int count=EASYBUY_USERDao.selectByNM(username, passWord);
		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;



1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
		}
		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),--商品名
//		  es_ep_price     NUMBER,--商品单价
//		  es_eod_quantity NUMBER,--购买数量
//		  es_ep_stock     NUMBER,--商品库存
//		  es_ep_id        NUMBER,--商品id
//		  es_EU_USER_ID   NVARCHAR2(30),--用户id
//		  es_valid	  NUMBER --是否结账，1未结账，2已结账
		EASYBUY_PRODUCT p = null;
		String pid = req.getParameter("id");
		String count = req.getParameter("count");
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31


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);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
			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),--商品名
//		  es_ep_price     NUMBER,--商品单价
//		  es_eod_quantity NUMBER,--购买数量
//		  es_ep_stock     NUMBER,--商品库存
//		  es_ep_id        NUMBER,--商品id
//		  es_EU_USER_ID   NVARCHAR2(30),--用户id
//		  es_valid	  NUMBER --是否结账，1未结账，2已结账
		EASYBUY_PRODUCT p = null;
		String pid = req.getParameter("id");
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
		
		req.getRequestDispatcher("productSelect").forward(req, resp);
		
	}
}
package com.demo.Servlet;





public class DoProductAddServlet extends HttpServlet {
	@Override
	protected void service(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		SmartUpload su = new SmartUpload();
		
		su.initialize(this.getServletConfig(), req, resp);
		
		try {
			su.upload();
		} catch (SmartUploadException e) {
			e.printStackTrace();
		}
		
		Files fs = su.getFiles();//获得所有文件
		File f = fs.getFile(0);//获得上传的文件
		String fname = f.getFileName();//获得文件名

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