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

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

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb+mysql的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

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

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;

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;

return ResponseUtil.successToClient(userService.updateAdminInfo(admin));

登录管理控制层：

@Controller

@RequestMapping("/admin/login/")

public class AdminLogin {

@Autowired

private adminLoginService adminLoginService;

@Autowired

private AccountMapper accountMapper;

@Autowired

用户管理控制层：

@Controller

@RequestMapping("/user/")

public class UserControll {

@Autowired

private userService userService;

@Autowired

private sorderService sorderService;

@Autowired

private adminOrderService adminOrderService;

//跳转注册

@RequestMapping("userRegisterGet")

@RequestMapping("mainToUserinfo")

public String mainToUserinfo(){

return "admin/user/adminUserinfo";

//加载用户

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

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;

//注册

datatable.setData(pageHelp.getList());

datatable.setRecordsFiltered(pageHelp.getRecord());

datatable.setRecordsTotal(pageHelp.getRecord());

return datatable;

//跳转个人账户页面

@RequestMapping("userAccount")

public String userAccount(){

return "user/account";

//加载个人积分

@RequestMapping("userAccountLimit")

@ResponseBody

private userService userService;

@Autowired

private sorderService sorderService;

@Autowired

private adminOrderService adminOrderService;

//跳转注册

@RequestMapping("userRegisterGet")

public String gotoRegister(){

return "user/register";

//注册判断用户名存在

@RequestMapping("selectUserOne")

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

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("delAdminById")

@ResponseBody

public String delAdminById(Admin admin){

return ResponseUtil.successToClient(adminUserService.delAdmin(admin));

//更新加载用户

@RequestMapping("updateGoAdminById")

@ResponseBody

public String updateGoAdminById(HttpServletRequest request,Admin admin){

return ResponseUtil.successToClient(adminUserService.selectAdminByOne(admin));

//更新用户

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

//注册判断用户名存在

@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){

datatable.setData(pageHelp.getList());

datatable.setRecordsFiltered(pageHelp.getRecord());

datatable.setRecordsTotal(pageHelp.getRecord());

return datatable;

//获得金额

@RequestMapping("getMoneyAcount")

@ResponseBody

public Object getMoneyAcount(HttpServletRequest request){

return request.getSession().getAttribute("money");

//查看当前订单

@RequestMapping("userAccountLimit")

@ResponseBody

public DataTables userAccountLimit(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<Account> pageHelp= userService.selectAccountLimit(map);

DataTables datatable=new DataTables();

datatable.setData(pageHelp.getList());

datatable.setRecordsFiltered(pageHelp.getRecord());

datatable.setRecordsTotal(pageHelp.getRecord());

return datatable;

@ResponseBody

public String userOrderPayMoneyConfirm(HttpServletRequest request,Float payNumber,Float uMoney,String uPasword,String oId){

Userinfo userinfo = (Userinfo)request.getSession().getAttribute("exituser");

if(userinfo.getuPassword().equals(uPasword)){

sorderService.updateOrderByoId(oId);

userService.updateUserinfoBypay(userinfo.getuId(), uMoney-payNumber);

}else{

return ResponseUtil.errorToClient();

return ResponseUtil.successToClient();

//删除订单

@RequestMapping("deleteMyOrder")

@ResponseBody

public String deleteAdminOrder(String oId){

Map<Object,Object> map=new HashMap<Object, Object>();

map.put("uId",request.getSession().getAttribute("frontuserId"));

map.put("pageStart",start);

map.put("pageSize",length);

PageHelp<Account> pageHelp= userService.selectAccountLimit(map);

DataTables datatable=new DataTables();

datatable.setData(pageHelp.getList());

datatable.setRecordsFiltered(pageHelp.getRecord());

datatable.setRecordsTotal(pageHelp.getRecord());

return datatable;

//获得金额

@RequestMapping("getMoneyAcount")

@ResponseBody