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

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

070023422402

080023422402

100023422402

110023422402

120023422402

130023422402

140023422402

基于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+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

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
		
HttpSession session=req.getSession();
session.setAttribute("syscode", code);

ServletOutputStream out=resp.getOutputStream();
ImageIO.write(img, "jpg", out);


}
}
package com.hr.Servlet;





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

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
		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);
}
//System.out.println(!ids.contains(Integer.parseInt(id)));
if(id!=null&&(!ids.contains(Integer.parseInt(id)))){
ids.add(Integer.parseInt(id));
}
session.setAttribute("ids", ids);
ids = (ArrayList<Integer>) session.getAttribute("ids");
if(ids!=null){
ArrayList<EASYBUY_PRODUCT> lastlylist = EASYBUY_PRODUCTDao.selectById(ids);
req.setAttribute("lastlylist", lastlylist);
}
//查询商品
EASYBUY_PRODUCT p = null;
if(id!=null){
p = EASYBUY_PRODUCTDao.selectById(Integer.parseInt(id));
}
req.setAttribute("p", p);
req.getRequestDispatcher("product-view.jsp").forward(req, resp);
}
}
package com.hr.Servlet;





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");
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
48
49
50

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 {
su.upload();
} catch (SmartUploadException e) {
e.printStackTrace();
}

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

}
}
package com.hr.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
		}
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());
req.setAttribute("fid", fid);
}
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());
req.setAttribute("cid", cid);
}
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);
//类别ID
req.setAttribute("cid", cid);
//总页数
req.setAttribute("tpage", tpage);
//搜索关键字
req.setAttribute("search_words", name);
//父分类
req.setAttribute("selected_fid", fid);
req.getRequestDispatcher("product-list.jsp").forward(req, resp);
}
}
package com.web.shopservlet;






public class gmServlet extends HttpServlet {
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
				
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);
// 跳
req.getRequestDispatcher("guestbook.jsp").forward(req,resp);
}


}

}

package com.hr.Servlet;





项目链接:
https://javayms.github.io?id=451122512008200nc
https://javayms.pages.dev?id=451122512008200nc