Java源码社

基于javaweb的SSM+Maven电器商城系统(java+ssm+jsp+jquery+javascript+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

200923561103

210923561103

220923561103

230923561103

240923561103

260923561103

基于javaweb的SSM+Maven电器商城系统(java+ssm+jsp+jquery+javascript+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.是否Maven项目: 否；查看源码目录中是否包含pom.xml；若包含，则为maven项目，否则为非maven项目 6.数据库：MySql 5.7、8.0等版本均可；

技术栈

  1. 后端：Spring springmvc mybatis 2. 前端：JSP+css+javascript+jQuery

使用说明

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

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
public String deleteOrderdetail(int dId,String oId){
	List<Orderdetail> orderdetailList = adminOrderService.selectOrderdetailByoId(oId);
	if(orderdetailList.size()>=2){
		adminOrderService.deleteOrderdetailBydId(dId);
		return ResponseUtil.successToClient(1);
	}else{
		adminOrderService.deleteAdminOrder(oId);
		return ResponseUtil.successToClient(2);
	}
}


//导出订单详情
@RequestMapping("outExcelOrder")
@ResponseBody
public void outExcelOrder(HttpServletResponse response,String oId){
	SXSSFWorkbook workbook = new SXSSFWorkbook();
       reportSheet(workbook,oId);
       outputExcel(response, workbook, "订单详情");
}

private void reportSheet(SXSSFWorkbook workbook,String oId) {
	List<DoExcelOrder> outExcelOrderDetail = adminOrderService.outExcelOrderDetail(oId);
	for (int i = 0; i < outExcelOrderDetail.size(); i++) {
		if(i!=0){
			outExcelOrderDetail.get(i).setOId("");
			outExcelOrderDetail.get(i).setOName("");
			outExcelOrderDetail.get(i).setOPhone("");
			outExcelOrderDetail.get(i).setOAddress("");
		}
		outExcelOrderDetail.get(i).setMoney(outExcelOrderDetail.get(i).getMoney()+"元");
	}
	ExcelUtil2 excelUtil=new ExcelUtil2();
	
       List<JSONObject> columns = new ArrayList<>();
       columns.add(excelUtil.defaultGetColumn("订单号", "oId", 15 * 256, false, false));
       columns.add(excelUtil.defaultGetColumn("收货人", "oName", 15 * 256, false, false));
       columns.add(excelUtil.defaultGetColumn("电话", "oPhone", 15 * 256, false, false));
       columns.add(excelUtil.defaultGetColumn("地址", "oAddress", 26 * 256, false, false));
       columns.add(excelUtil.defaultGetColumn("商品名", "sName", 15 * 256, false, false));
       columns.add(excelUtil.defaultGetColumn("数量", "num", 12 * 256, false, false));
       columns.add(excelUtil.defaultGetColumn("单价", "money", 12 * 256, false, false));
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
@RequestMapping("adminUserinfoLimit")
@ResponseBody
public DataTables adminUserinfoLimit(HttpServletRequest request,int start,int length,Userinfo userinfo){
	Map<Object,Object> map=new HashMap<Object, Object>();
	map.put("pageStart",start);
	map.put("pageSize",length);
	PageHelp<Userinfo> pageHelp= adminUserService.selectAdminUserinfoLimit(map,userinfo);
	DataTables datatable=new DataTables();
	datatable.setData(pageHelp.getList());
	datatable.setRecordsFiltered(pageHelp.getRecord());
	datatable.setRecordsTotal(pageHelp.getRecord());
	return datatable;
}

//删除用户
@RequestMapping("delUserinfoById")
@ResponseBody
public String delUserinfoById(int uId){
	return ResponseUtil.successToClient(adminUserService.delUserinfoById(uId));
}

//更新加载用户
@RequestMapping("updateGoUserinfoById")
@ResponseBody
public String updateGoUserinfoById(int uId){
	return ResponseUtil.successToClient(adminUserService.updateGoUserinfoById(uId));
}

//更新用户
@RequestMapping("updateUserinfoById")
@ResponseBody
public String updateUserinfoById(Userinfo userinfo){
	return ResponseUtil.successToClient(adminUserService.updateUserinfoById(userinfo));
}

@RequestMapping("mainToAdmin")
public String mainToAdmin(){
	return "admin/user/adminAdmin";
}

//加载用户
@RequestMapping("adminAdminLimit")
@ResponseBody
public DataTables adminAdminLimit(HttpServletRequest request,int start,int length,DoAdmin doAdmin){
	Map<Object,Object> map=new HashMap<Object, Object>();
	map.put("pageStart",start);
	map.put("pageSize",length);
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
@Controller
@RequestMapping("/admin/order/")
public class AdminOrderControll {
	
	@Autowired
	private adminOrderService adminOrderService;
	
	@Autowired
	private userService userService; 
	
	
	@RequestMapping("mainToAdminOrder")
	public String mainToAdminOrder(){
		return "admin/order/adminOrder";
	} 
	
	//订单
	@RequestMapping("adminOrderLimit")
	@ResponseBody
	public DataTables adminOrderLimit(int start,int length,
			String oId,String oTimeStart,String oTimeEnd,String adUserName){
		Map<Object,Object> map=new HashMap<Object, Object>();
			map.put("pageStart",start);
			map.put("pageSize",length);
			map.put("oId",oId);
			map.put("oTimeStart",oTimeStart);
			map.put("oTimeEnd",oTimeEnd);
			map.put("adUserName",adUserName);
		PageHelp<DoAdminOrder> pageHelp= adminOrderService.selectAdminOrderLimit(map);
		DataTables datatable=new DataTables();
		datatable.setData(pageHelp.getList());
		datatable.setRecordsFiltered(pageHelp.getRecord());
		datatable.setRecordsTotal(pageHelp.getRecord());
		return datatable;
	}
	
	//删除订单
	@RequestMapping("deleteAdminOrder")
	@ResponseBody
	public String deleteAdminOrder(String oId){
		return ResponseUtil.successToClient(adminOrderService.deleteAdminOrder(oId));
	} 
	
	//update加载订单
	@RequestMapping("updateSelectAdminOrder")
	@ResponseBody
	public String updateSelectAdminOrder(int rId){
		return ResponseUtil.successToClient(adminOrderService.updateSelectAdminOrder(rId));
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
           //上传文件路径
           String path = request.getSession().getServletContext().getRealPath("/image/trimImg/");
           //上传文件名
           String filename = fileName;
           File filepath = new File(path,filename);
           //判断路径是否存在，如果不存在就创建一个
        //   filepath.delete();
           if (!filepath.getParentFile().exists()) { 
               filepath.getParentFile().mkdirs();
           }
           //将上传文件保存到一个目标文件当中
           file.transferTo(new File(path + File.separator + filename));
           return ResponseUtil.successToClient();
       } else {
           return ResponseUtil.errorToClient();
       }
    }
}
package com.snack.interceptor;






public class MyHandlerInterceptor implements HandlerInterceptor{

	@Override
	public boolean preHandle(HttpServletRequest request,
			HttpServletResponse response, Object handler) throws Exception {
		int k=0;
		int p=0;
		String uri=request.getRequestURI();
		if(uri.indexOf("login")!=-1){
			return true;
		}
		HttpSession session = request.getSession();
		List<Permission> list = (List<Permission>)session.getAttribute("allPer");
		List<Permission> list2 = (List<Permission>)session.getAttribute("userPer");
		for (int i = 0; i < list.size(); i++) {
			if(uri.equals((list.get(i).getUrl()))){
			for (int j = 0; j < list2.size(); j++) {
				k++;
				if(uri.contains(list2.get(j).getUrl())){
					return true;
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
		return "admin/adminLogin";
	}
	
	//登录
	@RequestMapping("adminGoLogin")
	public String adminGoLogin(HttpServletRequest request,Admin admin){
		List<Admin> adminSelect = adminLoginService.adminLogin(admin);
		if(adminSelect.size()==1){
			request.getSession().setAttribute("adminName", adminSelect.get(0).getAdUsername());
			request.getSession().setAttribute("adminId", adminSelect.get(0).getAdId());
			List<Permission> allPer = adminLoginService.selectAllPermission();
			List<Permission> userPer = adminLoginService.selectRolePermission(adminSelect.get(0).getRoleId());
			request.getSession().setAttribute("allPer", allPer);
			request.getSession().setAttribute("userPer", userPer);
			return "redirect:adminGoMain";
		}
		request.setAttribute("msg","用户名或密码错误");
		return "admin/adminLogin";
	}
	
	//登录Main
	@RequestMapping("adminGoMain")
	public String adminLogin(HttpServletRequest request){
		List<Type> typeList = typeService.getall();
		request.setAttribute("adminMenu",adminLoginService.selectAllAdminMenu());
		request.setAttribute("adminMenuChild",adminLoginService.selectAllAdminMenuChild());
		request.getSession().setAttribute("type",typeList);
		return "admin/adminMain";
	}
	
	//退出
	@RequestMapping("adminMainToLoginOut")
	@ResponseBody
	public String adminMainToLoginOut(HttpServletRequest request){
		request.getSession().removeAttribute("adminName");
		return ResponseUtil.successToClient();
	}
}
package com.snack.filter;


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

@Controller
@RequestMapping("/user/")
public class UserControll {
	
	@Autowired
	private userService userService;
	
	@Autowired
	private sorderService sorderService;
	
	@Autowired
	private adminOrderService adminOrderService;
	
	//跳转注册
	@RequestMapping("userRegisterGet")
	public String gotoRegister(){
		return "user/register";
	}	
	
	//注册判断用户名存在
	@RequestMapping("selectUserOne")
	@ResponseBody
	public AjaxResult getUserOne(Userinfo userinfo){
		AjaxResult aj=new AjaxResult();
		 Userinfo rs = userService.selectUserOne(userinfo);
		 aj.setTag(rs);
		 return aj;
	}
	
	//注册
	@RequestMapping("addUserRegister")
	@ResponseBody
	public AjaxResult addUserOne(Userinfo userinfo){
		 AjaxResult aj=new AjaxResult();
		 int rs = userService.addUserOne(userinfo);
		 aj.setTag(rs);
		 return aj;
	}
	
	//查登陆的用户
	@RequestMapping("readUserinfo")

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