基于javaweb的SSM音乐专辑商城系统(java+ssm+jsp+jquery+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb的SSM音乐专辑商城系统(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版本； 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  

	//加载用户
	@RequestMapping("selectAdminUserinfoBysId")
	@ResponseBody
	public String selectAdminUserinfoBysId(int sId){
		return ResponseUtil.successToClient(adminSnackInfoService.selectAdminUserinfoBysId(sId));
	}
	
	@RequestMapping(value="updateAdminSnack")
	@ResponseBody
    public String updateAdminSnack(HttpServletRequest request,MultipartFile file,String fileName,Snackinfo snackinfo) throws Exception {
       //如果文件不为空，写入上传路径
       if(file !=null) {
    	   snackinfo.setsPictureurl(fileName);
    	   adminSnackInfoService.updateAdminSnackinfo(snackinfo);
           //上传文件路径
           String path = request.getSession().getServletContext().getRealPath("/image/");
           //上传文件名
           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 {
    	   adminSnackInfoService.updateAdminSnackinfo(snackinfo);
    	   return ResponseUtil.successToClient();
       }

    }
}

@RequestMapping("addUserRegister")
@ResponseBody
public AjaxResult addUserOne(Userinfo userinfo){
	 AjaxResult aj=new AjaxResult();
	 int rs = userService.addUserOne(userinfo);
	 aj.setTag(rs);
	 return aj;
}

//查登陆的用户
@RequestMapping("readUserinfo")
@ResponseBody
public AjaxResult readUserinfo(Userinfo userinfo,HttpServletRequest request){
	 AjaxResult aj=new AjaxResult();
	 Userinfo usr= userService.selectUserinfoById(userinfo);
	 if(usr!=null){
		 aj.setTag(usr);
	 }
	 return aj;
}

//修改个人信息
@RequestMapping("editUserinfo")
@ResponseBody
public int editUserinfo(Userinfo userinfo){
	 int rs= userService.updateUserinfoById(userinfo);
	 return rs;
}

//跳转注册
@RequestMapping("userPersonalInfo")
public String gotoPersonalInfo(){
	return "user/personalInfo";
}

//加载个人信息界面
@RequestMapping("userInfo")
public String gotoUserInfo(){
	return "user/userInfo";
}

//跳转个人积分页面

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

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

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

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

@Controller
@RequestMapping("/admin/login/")
public class AdminLogin {
	
	@Autowired
	private adminLoginService adminLoginService;
	
	@Autowired
	private AccountMapper accountMapper;
	
	//登录login
	@RequestMapping("adminLogin")
	public String adminLogin(){
		System.out.println("存储过程相加:"+accountMapper.selectNum(4, 6));
		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());
			request.getSession().setAttribute("roleId", adminSelect.get(0).getRoleId());
			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){
		request.setAttribute("adminMenu",adminLoginService.selectAllAdminMenu());
		request.setAttribute("adminMenuChild",adminLoginService.selectAllAdminMenuChild());
		return "admin/adminMain";
	}
	
	//退出

	map.put("uId",request.getSession().getAttribute("frontuserId"));
	map.put("pageStart",start);
	map.put("pageSize",length);
	PageHelp<DoMyOrder> pageHelp= userService.selectOrderLimit(map);
	DataTables datatable=new DataTables();
	datatable.setData(pageHelp.getList());
	datatable.setRecordsFiltered(pageHelp.getRecord());
	datatable.setRecordsTotal(pageHelp.getRecord());
	return datatable;
}

//跳转订单页面
@RequestMapping("userGoOrder")
public String userGoOrder(HttpSession session){
	return "user/myOrder";
}

//跳转历史订单
@RequestMapping("userGoSuccessOrder")
public String userGoSuccessOrder(){
	return "user/myOrderSuccess";
}

//查看当前订单
@RequestMapping("userSucOrderLimit")
@ResponseBody
public DataTables userSucOrderLimit(HttpServletRequest request,int start,int length){
	Map<Object,Object> map=new HashMap<Object, Object>();
	map.put("uId",request.getSession().getAttribute("frontuserId"));
	map.put("pageStart",start);
	map.put("pageSize",length);
	PageHelp<DoMyOrder> pageHelp= userService.selectMySuccessOrderLimit(map);
	DataTables datatable=new DataTables();
	datatable.setData(pageHelp.getList());
	datatable.setRecordsFiltered(pageHelp.getRecord());
	datatable.setRecordsTotal(pageHelp.getRecord());
	return datatable;
}

//请确认收货
@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));
}

//去付款

---

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