• Java项目:零食超市商城系统(java+SSM+JSP+jQuery+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/8.0版本均可；
    6.是否Maven项目：是；

    技术栈

    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命令，然后运行；
    3. 将项目中jdbc.properties配置文件中的数据库配置改为自己的配置;
    4. 运行项目，前台地址：http://localhost:8080/snack/shop/index  注：tomcat中配置的路径必须为snack 
    后台地址：http://localhost:8080/snack/admin/login/adminLogin

     

     

     

    商城首页管理控制层：

    1. @Controller
    2. @RequestMapping("/shop/")
    3. public class ShopControll {
    4. 	
    5. 	@Autowired
    6. 	public shopService shopService=null;
    7. 	
    8. 	//主页
    9. 	@RequestMapping("index")
    10. 	public String gotoIndex(HttpServletRequest request){
    11. 		List<Snackinfo> HotSnackList = shopService.getHotSnack();
    12. 		List<Snackinfo> newSnackList = shopService.getNewSnack();
    13. 		request.setAttribute("HotSnackList",HotSnackList);
    14. 		request.setAttribute("newSnackList",newSnackList);
    15. 		System.out.println("00");
    16. 		return "user/index";
    17. 	}
    18. 	
    19. 	//登录
    20. 	@RequestMapping("userLoginGet")
    21. 	public String gotoUserLogin(){
    22. 		return "user/userLogin";
    23. 	}
    24. 	
    25. 	@RequestMapping("userLoginPost")
    26. 	public String gotoUserLogin(Userinfo userinfo,HttpServletRequest request){
    27. 		Userinfo exituser =  shopService.userLogin(userinfo);
    28. 		if(exituser ==null){
    29. 			request.setAttribute("msg","用户名或密码错误");
    30. 			return "user/userLogin";
    31. 		}
    32. 		request.getSession().setAttribute("exituser", exituser);
    33. 		request.getSession().setAttribute("frontuser", exituser.getuUsername());
    34. 		request.getSession().setAttribute("frontuserId", exituser.getuId());
    35. 		request.getSession().setAttribute("money", exituser.getuMoney());
    36. 		return "redirect:index";
    37. 	}
    38. 	
    39. 	//退出登录
    40. 	@RequestMapping("userlogout")
    41. 	public String showlogin(HttpServletRequest request){
    42. 		HttpSession session = request.getSession();
    43. 		session.removeAttribute("frontuser");
    44. 		session.removeAttribute("frontuserId");
    45. 		return "redirect:userLoginGet";
    46. 	}
    47. 	
    48. 	
    49. 	//商品详情
    50. 	@RequestMapping("proDatail")
    51. 	public String gotoProDatail(HttpServletRequest request,Snackinfo snack){
    52. 		Snackinfo sck = shopService.selectById(snack);
    53. 		request.setAttribute("sck", sck);
    54. 		return "product/proDetail";
    55. 	}
    56. 	
    57. 	//查询订单
    58. 	@RequestMapping("selectOrderSnack")
    59. 	@ResponseBody
    60. 	public DataTables selectOrderSnack(String oId,int start,int length){
    61. 		Map<Object,Object> map=new HashMap<Object, Object>();
    62. 		map.put("oId", oId);
    63. 		map.put("pageStart",start);
    64. 		map.put("pageSize",length);
    65. 		PageHelp<DoSnack> pageHelp = shopService.selectOrderSnack(map);
    66. 		DataTables datatable=new DataTables();
    67. 		datatable.setData(pageHelp.getList());
    68. 		datatable.setRecordsFiltered(pageHelp.getRecord());
    69. 		datatable.setRecordsTotal(pageHelp.getRecord());
    70. 		return datatable;
    71. 	}
    72. 	
    73. 	//type页面
    74. 	@RequestMapping("puffingType")
    75. 	public String puffing(HttpServletRequest request,DoSnackType doSnackType){
    76. 		List<Snackinfo> TypeSnackList=shopService.selectPuffing(doSnackType.getType(),doSnackType.getSnackName());
    77. 		if(doSnackType.getType()==1){
    78. 			request.setAttribute("TypeSnackTitle","膨化类");
    79. 		}else if(doSnackType.getType()==2){
    80. 			request.setAttribute("TypeSnackTitle","肉制类");
    81. 		}else if(doSnackType.getType()==3){
    82. 			request.setAttribute("TypeSnackTitle","饮料类");
    83. 		}else if(doSnackType.getType()==4){
    84. 			request.setAttribute("TypeSnackTitle","其他");
    85. 		}else if(doSnackType.getType()==5){
    86. 			request.setAttribute("TypeSnackTitle","搜索结果");
    87. 		}else if(doSnackType.getType()==6){
    88. 			request.setAttribute("TypeSnackTitle","进口类");
    89. 		}
    90. 		request.setAttribute("TypeNum",doSnackType.getType());
    91. 		request.setAttribute("TypeSnackList",TypeSnackList);
    92. 		return "user/typePage";
    93. 	}
    94. 	
    95. }

    管理员登录管理控制层：

    1. @Controller
    2. @RequestMapping("/admin/login/")
    3. public class AdminLogin {
    4. 	
    5. 	@Autowired
    6. 	private adminLoginService adminLoginService;
    7. 	
    8. 	@Autowired
    9. 	private AccountMapper accountMapper;
    10. 	
    11. 	//登录login
    12. 	@RequestMapping("adminLogin")
    13. 	public String adminLogin(){
    14. 		System.out.println("存储过程相加:"+accountMapper.selectNum(4, 6));
    15. 		return "admin/adminLogin";
    16. 	}
    17. 	
    18. 	//登录
    19. 	@RequestMapping("adminGoLogin")
    20. 	public String adminGoLogin(HttpServletRequest request,Admin admin){
    21. 		List<Admin> adminSelect = adminLoginService.adminLogin(admin);
    22. 		if(adminSelect.size()==1){
    23. 			request.getSession().setAttribute("adminName", adminSelect.get(0).getAdUsername());
    24. 			request.getSession().setAttribute("adminId", adminSelect.get(0).getAdId());
    25. 			List<Permission> allPer = adminLoginService.selectAllPermission();
    26. 			List<Permission> userPer = adminLoginService.selectRolePermission(adminSelect.get(0).getRoleId());
    27. 			request.getSession().setAttribute("allPer", allPer);
    28. 			request.getSession().setAttribute("userPer", userPer);
    29. 			return "redirect:adminGoMain";
    30. 		}
    31. 		request.setAttribute("msg","用户名或密码错误");
    32. 		return "admin/adminLogin";
    33. 	}
    34. 	
    35. 	//登录Main
    36. 	@RequestMapping("adminGoMain")
    37. 	public String adminLogin(HttpServletRequest request){
    38. 		request.setAttribute("adminMenu",adminLoginService.selectAllAdminMenu());
    39. 		request.setAttribute("adminMenuChild",adminLoginService.selectAllAdminMenuChild());
    40. 		return "admin/adminMain";
    41. 	}
    42. 	
    43. 	//退出
    44. 	@RequestMapping("adminMainToLoginOut")
    45. 	@ResponseBody
    46. 	public String adminMainToLoginOut(HttpServletRequest request){
    47. 		request.getSession().removeAttribute("adminName");
    48. 		return ResponseUtil.successToClient();
    49. 	}
    50. 	
    51.  
    52. }

    订单管理控制层：

    1. @Controller
    2. @RequestMapping("/admin/order/")
    3. public class AdminOrderControll {
    4. 	
    5. 	@Autowired
    6. 	private adminOrderService adminOrderService;
    7. 	
    8. 	@Autowired
    9. 	private userService userService; 
    10. 	
    11. 	
    12. 	@RequestMapping("mainToAdminOrder")
    13. 	public String mainToAdminOrder(){
    14. 		return "admin/order/adminOrder";
    15. 	} 
    16. 	
    17. 	//订单
    18. 	@RequestMapping("adminOrderLimit")
    19. 	@ResponseBody
    20. 	public DataTables adminOrderLimit(int start,int length,
    21. 			String oId,String oTimeStart,String oTimeEnd,String adUserName){
    22. 		Map<Object,Object> map=new HashMap<Object, Object>();
    23. 			map.put("pageStart",start);
    24. 			map.put("pageSize",length);
    25. 			map.put("oId",oId);
    26. 			map.put("oTimeStart",oTimeStart);
    27. 			map.put("oTimeEnd",oTimeEnd);
    28. 			map.put("adUserName",adUserName);
    29. 		PageHelp<DoAdminOrder> pageHelp= adminOrderService.selectAdminOrderLimit(map);
    30. 		DataTables datatable=new DataTables();
    31. 		datatable.setData(pageHelp.getList());
    32. 		datatable.setRecordsFiltered(pageHelp.getRecord());
    33. 		datatable.setRecordsTotal(pageHelp.getRecord());
    34. 		return datatable;
    35. 	}
    36. 	
    37. 	//删除订单
    38. 	@RequestMapping("deleteAdminOrder")
    39. 	@ResponseBody
    40. 	public String deleteAdminOrder(String oId){
    41. 		return ResponseUtil.successToClient(adminOrderService.deleteAdminOrder(oId));
    42. 	} 
    43. 	
    44. 	//update加载订单
    45. 	@RequestMapping("updateSelectAdminOrder")
    46. 	@ResponseBody
    47. 	public String updateSelectAdminOrder(int rId){
    48. 		return ResponseUtil.successToClient(adminOrderService.updateSelectAdminOrder(rId));
    49. 	} 
    50. 	
    51. 	//update订单
    52. 	@RequestMapping("updateAdminOrder")
    53. 	@ResponseBody
    54. 	public String updateAdminOrder(Receiptinfo receiptinfo){
    55. 		return ResponseUtil.successToClient(adminOrderService.updateAdminOrder(receiptinfo));
    56. 	} 
    57. 	
    58. 	//updateOrderDetial加载订单
    59. 	@RequestMapping("updateSelectAdminOrderDetial")
    60. 	@ResponseBody
    61. 	public String updateSelectAdminOrderDetial(int dId){
    62. 		return ResponseUtil.successToClient(adminOrderService.updateSelectAdminOrderDetial(dId));
    63. 	} 
    64. 	
    65. 	//updateOrderDetial订单
    66. 	@RequestMapping("updateOrderdetail")
    67. 	@ResponseBody
    68. 	public String updateOrderdetail(Orderdetail orderdetail){
    69. 		return ResponseUtil.successToClient(adminOrderService.updateOrderdetail(orderdetail));
    70. 	} 
    71. 	
    72. 	//删除OrderDetial
    73. 	@RequestMapping("deleteOrderdetail")
    74. 	@ResponseBody
    75. 	public String deleteOrderdetail(int dId,String oId){
    76. 		List<Orderdetail> orderdetailList = adminOrderService.selectOrderdetailByoId(oId);
    77. 		if(orderdetailList.size()>=2){
    78. 			adminOrderService.deleteOrderdetailBydId(dId);
    79. 			return ResponseUtil.successToClient(1);
    80. 		}else{
    81. 			adminOrderService.deleteAdminOrder(oId);
    82. 			return ResponseUtil.successToClient(2);
    83. 		}
    84. 	}
    85. 	
    86. 	
    87. 	//导出订单详情
    88. 	@RequestMapping("outExcelOrder")
    89. 	@ResponseBody
    90. 	public void outExcelOrder(HttpServletResponse response,String oId){
    91. 		SXSSFWorkbook workbook = new SXSSFWorkbook();
    92.         reportSheet(workbook,oId);
    93.         outputExcel(response, workbook, "订单详情");
    94. 	}
    95. 	
    96. 	private void reportSheet(SXSSFWorkbook workbook,String oId) {
    97. 		List<DoExcelOrder> outExcelOrderDetail = adminOrderService.outExcelOrderDetail(oId);
    98. 		for (int i = 0; i < outExcelOrderDetail.size(); i++) {
    99. 			if(i!=0){
    100. 				outExcelOrderDetail.get(i).setOId("");
    101. 				outExcelOrderDetail.get(i).setOName("");
    102. 				outExcelOrderDetail.get(i).setOPhone("");
    103. 				outExcelOrderDetail.get(i).setOAddress("");
    104. 			}
    105. 			outExcelOrderDetail.get(i).setMoney(outExcelOrderDetail.get(i).getMoney()+"元");
    106. 		}
    107. 		ExcelUtil2 excelUtil=new ExcelUtil2();
    108. 		
    109.         List<JSONObject> columns = new ArrayList<>();
    110.         columns.add(excelUtil.defaultGetColumn("订单号", "oId", 15 * 256, false, false));
    111.         columns.add(excelUtil.defaultGetColumn("收货人", "oName", 15 * 256, false, false));
    112.         columns.add(excelUtil.defaultGetColumn("电话", "oPhone", 15 * 256, false, false));
    113.         columns.add(excelUtil.defaultGetColumn("地址", "oAddress", 26 * 256, false, false));
    114.         columns.add(excelUtil.defaultGetColumn("商品名", "sName", 15 * 256, false, false));
    115.         columns.add(excelUtil.defaultGetColumn("数量", "num", 12 * 256, false, false));
    116.         columns.add(excelUtil.defaultGetColumn("单价", "money", 12 * 256, false, false));
    117.  
    118.         excelUtil.createSheet(workbook, outExcelOrderDetail, columns, "订单详情");
    119.     }
    120.  
    121.     private void outputExcel(HttpServletResponse response, SXSSFWorkbook workbook, String excelName) {
    122.         response.setContentType("application/vnd.ms-excel");
    123.         try {
    124.             // 进行转码，使其支持中文文件名
    125.             response.setHeader("content-disposition", "attachment;filename=" + new String(excelName.getBytes("GB2312"), "ISO-8859-1") + ".xlsx");
    126.             workbook.write(response.getOutputStream());
    127.         } catch (IOException e) {
    128.             e.printStackTrace();
    129.         }
    130.     }
    131.     
    132.   //请确认收货
    133.   	@RequestMapping("userOrderConfirm")
    134.   	@ResponseBody
    135.   	public String userOrderConfirm(HttpServletRequest request,int id,int typeNum){
    136.   		int eId;
    137.   		if(typeNum==0){
    138.   		    eId = (int)request.getSession().getAttribute("adminId");
    139.   		}else{
    140.   			eId=0;
    141.   		}
    142.   	return ResponseUtil.successToClient(userService.upDateByorderConfirm(id,typeNum,eId));
    143.   	}
    144.  
    145. }

    源码获取：俺的博客首页 "资源" 里下载！

  • 相关阅读:
    基于左逆的三点法测距，MATLAB函数
    LeetCode 面试题 04.02. 最小高度树
    彻底解决Microsoft store闪退问题
    构建工具Webpack简介
    “比特币市场风起云涌：第三季度报告揭示表现和未来趋势“
    QT--多线程与MySQL数据库
    【马蹄集】—— 百度之星 2023
    C语言理论--笔试面试基础稳固
    说话人识别声纹识别CAM++，ECAPA-TDNN等算法
    BERT： 面向语言理解的深度双向Transformer预训练
  • 原文地址：https://blog.csdn.net/m0_66863468/article/details/125568779