作者主页:夜未央5788
简介:Java领域优质创作者、Java项目、学习资料、技术互助
文末获取源码
本项目分为前后台,前台普通用户登录,后台管理员登录;
管理员角色包含以下功能:
管理员角色登录,个人信息修改,商城用户管理,订单管理,商品管理等功能。
用户角色包含以下功能:
用户角色首页,用户角色登录注册,查看图书详情,加入购物车,提交订单,订单付款,个人信息修改,个人订单查询等功能。
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项目:是;
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
后台地址:http://localhost:8080/snack/admin/login/adminLogin



- @Controller
- @RequestMapping("/shop/")
- public class ShopControll {
-
- @Autowired
- public shopService shopService=null;
- @Autowired
- public typeService typeService;
-
- //主页
- @RequestMapping("index")
- public String gotoIndex(HttpServletRequest request){
- List
HotSnackList = shopService.getHotSnack(); - List
newSnackList = shopService.getNewSnack(); - List
typeList = typeService.getall(); - request.setAttribute("HotSnackList",HotSnackList);
- request.setAttribute("newSnackList",newSnackList);
- request.getSession().setAttribute("type", typeList);
- System.out.println("00");
- return "user/index";
- }
-
- //登录
- @RequestMapping("userLoginGet")
- public String gotoUserLogin(){
- return "user/userLogin";
- }
-
- @RequestMapping("userLoginPost")
- public String gotoUserLogin(Userinfo userinfo,HttpServletRequest request){
- Userinfo exituser = shopService.userLogin(userinfo);
- if(exituser ==null){
- request.setAttribute("msg","用户名或密码错误");
- return "user/userLogin";
- }
- request.getSession().setAttribute("exituser", exituser);
- request.getSession().setAttribute("frontuser", exituser.getuUsername());
- request.getSession().setAttribute("frontuserId", exituser.getuId());
- request.getSession().setAttribute("money", exituser.getuMoney());
- return "redirect:index";
- }
-
- //退出登录
- @RequestMapping("userlogout")
- public String showlogin(HttpServletRequest request){
- HttpSession session = request.getSession();
- session.removeAttribute("frontuser");
- session.removeAttribute("frontuserId");
- return "redirect:userLoginGet";
- }
-
- //商品详情
- @RequestMapping("proDatail")
- public String gotoProDatail(HttpServletRequest request,Snackinfo snack){
- Snackinfo sck = shopService.selectById(snack);
- request.setAttribute("sck", sck);
- return "product/proDetail";
- }
-
- //查询订单
- @RequestMapping("selectOrderSnack")
- @ResponseBody
- public DataTables selectOrderSnack(String oId,int start,int length){
- Map
- map.put("oId", oId);
- map.put("pageStart",start);
- map.put("pageSize",length);
- PageHelp
pageHelp = shopService.selectOrderSnack(map); - DataTables datatable=new DataTables();
- datatable.setData(pageHelp.getList());
- datatable.setRecordsFiltered(pageHelp.getRecord());
- datatable.setRecordsTotal(pageHelp.getRecord());
- return datatable;
- }
-
- //type页面
- @RequestMapping("puffingType")
- public String puffing(HttpServletRequest request,DoSnackType doSnackType){
- List
TypeSnackList=shopService.selectPuffing(doSnackType.getType(),doSnackType.getSnackName()); - Type type = typeService.getOne(doSnackType.getType());
- request.setAttribute("TypeSnackTitle",type.getName());
- request.setAttribute("TypeNum",doSnackType.getType());
- request.setAttribute("TypeSnackList",TypeSnackList);
- return "user/typePage";
- }
- }
- @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
map=new HashMap(); - 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
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));
- }
-
- //update订单
- @RequestMapping("updateAdminOrder")
- @ResponseBody
- public String updateAdminOrder(Receiptinfo receiptinfo){
- return ResponseUtil.successToClient(adminOrderService.updateAdminOrder(receiptinfo));
- }
-
- //updateOrderDetial加载订单
- @RequestMapping("updateSelectAdminOrderDetial")
- @ResponseBody
- public String updateSelectAdminOrderDetial(int dId){
- return ResponseUtil.successToClient(adminOrderService.updateSelectAdminOrderDetial(dId));
- }
-
- //updateOrderDetial订单
- @RequestMapping("updateOrderdetail")
- @ResponseBody
- public String updateOrderdetail(Orderdetail orderdetail){
- return ResponseUtil.successToClient(adminOrderService.updateOrderdetail(orderdetail));
- }
-
- //删除OrderDetial
- @RequestMapping("deleteOrderdetail")
- @ResponseBody
- public String deleteOrderdetail(int dId,String oId){
- List
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
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
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));
-
- excelUtil.createSheet(workbook, outExcelOrderDetail, columns, "订单详情");
- }
-
- private void outputExcel(HttpServletResponse response, SXSSFWorkbook workbook, String excelName) {
- response.setContentType("application/vnd.ms-excel");
- try {
- // 进行转码,使其支持中文文件名
- response.setHeader("content-disposition", "attachment;filename=" + new String(excelName.getBytes("GB2312"), "ISO-8859-1") + ".xlsx");
- workbook.write(response.getOutputStream());
- } catch (IOException e) {
- e.printStackTrace();
- }
- }
-
- //请确认收货
- @RequestMapping("userOrderConfirm")
- @ResponseBody
- public String userOrderConfirm(HttpServletRequest request,int id,int typeNum){
- int eId;
- if(typeNum==0){
- eId = (int)request.getSession().getAttribute("adminId");
- }else{
- eId=0;
- }
- return ResponseUtil.successToClient(userService.upDateByorderConfirm(id,typeNum,eId));
- }
-
- }
如果也想学习本系统,下面领取。关注并回复:133ssm