基于javaweb的宠物商城带后台管理系统(java+ssm+jsp+jquery+ajax+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
功能说明
基于javaweb+mysql的宠物商城带后台管理系统(java+SSM+JSP+jQuery+Ajax+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项目：否；
技术栈
后端：Spring+SpringMVC+Mybatis 2. 前端：JSP+jQuery+Ajax
使用说明
使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven; 若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中jdbc.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目，在浏览器中输入http://localhost:8080/ 登录 用户账号/密码： user/123456 管理员账号/密码：admin/admin
购物车Controller:
/**
购物车Controller
*/
@Controller
@RequestMapping(“/system/cart”)
public class CartController extends BaseController
private String prefix = “system/cart”;
@Autowired
private ICartService cartService;
@RequiresPermissions(“system:cart:view”)
@GetMapping()
public String cart()
return prefix + “/cart”;
/**
查询购物车列表
*/
@RequiresPermissions(“system:cart:list”)
@PostMapping(“/list”)
@ResponseBody
public TableDataInfo list(Cart cart)
Long userId = ShiroUtils.getSysUser().getUserId();
cart.setUserId(userId);
startPage();
List list = cartService.selectCartList(cart);
return getDataTable(list);
/**
导出购物车列表
*/
@RequiresPermissions(“system:cart:export”)
@Log(title = “购物车”, businessType = BusinessType.EXPORT)
@PostMapping(“/export”)
@ResponseBody
public AjaxResult export(Cart cart)
List list = cartService.selectCartList(cart);
ExcelUtil util = new ExcelUtil(Cart.class);
return util.exportExcel(list, “cart”);
/**
新增购物车
*/
@GetMapping(“/add”)
public String add()
return prefix + “/add”;
/**
新增保存购物车
*/
@RequiresPermissions(“system:cart:add”)
@Log(title = “购物车”, businessType = BusinessType.INSERT)
@PostMapping(“/add”)
@ResponseBody
public AjaxResult addSave(Cart cart)
return toAjax(cartService.insertCart(cart));
/**
新增保存购物车
*/
@Log(title = “购物车”, businessType = BusinessType.INSERT)
@GetMapping(“/addcart/{productId}”)
@ResponseBody
public AjaxResult addcart(@PathVariable(“productId”) Long productId,Cart cart)
Long userId = ShiroUtils.getSysUser().getUserId();
cart.setProductId(productId);
cart.setUserId(userId);
cartService.insertCart(cart);
return AjaxResult.success(“加入购物车成功！”);
/**
修改购物车
*/
@GetMapping(“/edit/{cartId}”)
public String edit(@PathVariable(“cartId”) Long cartId, ModelMap mmap)
Cart cart = cartService.selectCartById(cartId);
mmap.put(“cart”, cart);
return prefix + “/edit”;
/**
修改保存购物车
*/
@RequiresPermissions(“system:cart:edit”)
@Log(title = “购物车”, businessType = BusinessType.UPDATE)
@PostMapping(“/edit”)
@ResponseBody
public AjaxResult editSave(Cart cart)
return toAjax(cartService.updateCart(cart));
/**
删除购物车
*/
@RequiresPermissions(“system:cart:remove”)
@Log(title = “购物车”, businessType = BusinessType.DELETE)
@PostMapping( “/remove”)
@ResponseBody
public AjaxResult remove(String ids)
return toAjax(cartService.deleteCartByIds(ids));
订单管理Controller:
/**
订单管理Controller
*/
@Controller
@RequestMapping(“/system/order”)
public class OrderController extends BaseController
private String prefix = “system/order”;
@Autowired
private IOrderService orderService;
@Autowired
private IRoleService roleService;
@Autowired
private IProductService productService;
@Autowired
private IUserService userService;
@Autowired
private ICartService cartService;
@RequiresPermissions(“system:order:view”)
@GetMapping()
public String order(ModelMap mmap)
User user = ShiroUtils.getSysUser();
String roleString = roleService.selectRoleKeys(user.getUserId()).toString();
if(roleString.contains(“admin”)){
mmap.put(“loginRole”, “admin”);
}else if(roleString.contains(“seller”)){
mmap.put(“loginRole”, “seller”);
}else{
mmap.put(“loginRole”, “buyer”);
return prefix + “/order”;
/**
查询订单管理列表
*/
@RequiresPermissions(“system:order:list”)
@PostMapping(“/list”)
@ResponseBody
public TableDataInfo list(Order order)
User user = ShiroUtils.getSysUser();
String roleString = roleService.selectRoleKeys(user.getUserId()).toString();
startPage();
List list;
if(roleString.contains(“admin”)){
list = orderService.selectOrderList(order);
}else if(roleString.contains(“seller”)){
list = orderService.selectOrderBySellerId(user.getUserId());
List queryList = new ArrayList();
if(StringUtils.isNotEmpty(order.getOrderStatus())){
for(int i = 0 ; i < list.size();i++){
if(list.get(i).getOrderStatus().equals(order.getOrderStatus())){
queryList.add(list.get(i));
list = queryList;
}else{
order.setUserId(user.getUserId());
list = orderService.selectOrderList(order);
return getDataTable(list);
/**
导出订单管理列表
*/
@RequiresPermissions(“system:order:export”)
@Log(title = “订单管理”, businessType = BusinessType.EXPORT)
@PostMapping(“/export”)
@ResponseBody
public AjaxResult export(Order order)
List list = orderService.selectOrderList(order);
ExcelUtil util = new ExcelUtil(Order.class);
return util.exportExcel(list, “order”);
/**
新增订单管理
*/
@GetMapping(“/add”)
public String add()
return prefix + “/add”;
/**
新增保存订单管理
*/
@RequiresPermissions(“system:order:add”)
@Log(title = “订单管理”, businessType = BusinessType.INSERT)
@PostMapping(“/add”)
@ResponseBody
public AjaxResult addSave(Order order)
return toAjax(orderService.insertOrder(order));
/**
前台创建订单
*/
@Log(title = “订单管理”, businessType = BusinessType.INSERT)
@PostMapping(“/create”)
@ResponseBody
public AjaxResult create(Order order)
// 先判断用户积分是否充足
User user = userService.selectUserById(ShiroUtils.getSysUser().getUserId());
// 订单为待支付的状态
order.setOrderStatus(“0”);
order.setUserId(user.getUserId());
order.setOrderTime(new Date());
order.setPayWay(“0”);
orderService.insertOrder(order);
// 删除购物车数据
Cart cart = new Cart();
cart.setUserId(order.getUserId());
cart.setProductId(order.getProductId());
List carts = cartService.selectCartList(cart);
for(Cart item : carts){
cartService.deleteCartById(item.getCartId());
return AjaxResult.success(order.getOrderId());
/**
前台创建订单
*/
@Log(title = “订单管理”, businessType = BusinessType.INSERT)
@GetMapping(“/createorder/{productId}”)
public String createorder(@PathVariable(“productId”) Long productId , ModelMap mmap)
Product product = productService.selectProductById(productId);
mmap.put(“productId”, productId);
mmap.put(“orderPrice”, product.getProductPrice());
return “front/createorder”;
/**
修改订单管理
*/
@GetMapping(“/edit/{orderId}”)
public String edit(@PathVariable(“orderId”) Long orderId, ModelMap mmap)
Order order = orderService.selectOrderById(orderId);
mmap.put(“order”, order);
return prefix + “/edit”;
/**
修改订单管理
*/
@GetMapping(“/pay/{orderId}”)
public String pay(@PathVariable(“orderId”) Long orderId, ModelMap mmap)
Order order = orderService.selectOrderById(orderId);
mmap.put(“order”, order);
return prefix + “/pay”;
@GetMapping(“/comment/{orderId}”)
public String comment(@PathVariable(“orderId”) Long orderId, ModelMap mmap)
Order order = orderService.selectOrderById(orderId);
mmap.put(“order”, order);
return prefix + “/comment”;
/**
修改保存订单管理
*/
@Log(title = “订单管理”, businessType = BusinessType.UPDATE)
@PostMapping(“/comment”)
@ResponseBody
public AjaxResult commentSave(Order order)
Order saveOrder = orderService.selectOrderById(order.getOrderId());
saveOrder.setOrderComment(order.getOrderComment());
saveOrder.setOrderCommentTime(new Date());
saveOrder.setOrderStatus(“5”);
saveOrder.setCommentUrl(order.getCommentUrl());
return toAjax(orderService.updateOrder(saveOrder));
@GetMapping(“/payOrder/{orderId}”)
@ResponseBody
public AjaxResult payOrder(@PathVariable(“orderId”) Long orderId, ModelMap mmap)
Order order = orderService.selectOrderById(orderId);
order.setOrderStatus(“1”);
return toAjax(orderService.updateOrder(order));
@PostMapping(“/payOrder”)
@ResponseBody
public AjaxResult payOrder(Order order, ModelMap mmap)
order.setOrderStatus(“1”);
return toAjax(orderService.updateOrder(order));
@GetMapping(“/confirmStatus/{orderId}”)
@ResponseBody
public AjaxResult confirmStatus(@PathVariable(“orderId”) Long orderId, ModelMap mmap)
Order order = orderService.selectOrderById(orderId);
order.setOrderStatus(“2”);
return toAjax(orderService.updateOrder(order));
@GetMapping(“/sendStatus/{orderId}”)
@ResponseBody
public AjaxResult sendStatus(@PathVariable(“orderId”) Long orderId, ModelMap mmap)
Order order = orderService.selectOrderById(orderId);
order.setOrderStatus(“3”);
return toAjax(orderService.updateOrder(order));
@GetMapping(“/receiveStatus/{orderId}”)
@ResponseBody
public AjaxResult receiveStatus(@PathVariable(“orderId”) Long orderId, ModelMap mmap)
Order order = orderService.selectOrderById(orderId);
order.setOrderStatus(“4”);
return toAjax(orderService.updateOrder(order));
/**
修改保存订单管理
*/
@RequiresPermissions(“system:order:edit”)
@Log(title = “订单管理”, businessType = BusinessType.UPDATE)
@PostMapping(“/edit”)
@ResponseBody
public AjaxResult editSave(Order order)
return toAjax(orderService.updateOrder(order));
/**
删除订单管理
*/
@RequiresPermissions(“system:order:remove”)
@Log(title = “订单管理”, businessType = BusinessType.DELETE)
@PostMapping( “/remove”)
@ResponseBody
public AjaxResult remove(String ids)
return toAjax(orderService.deleteOrderByIds(ids));
用户信息管理控制层:
/**
用户信息
*/
@Controller
@RequestMapping(“/system/user”)
public class UserController extends BaseController
private String prefix = “system/user”;
@Autowired
private IUserService userService;
@Autowired
private IRoleService roleService;
@Autowired
private IPostService postService;
@RequiresPermissions(“system:user:view”)
@GetMapping()
public String user()
return prefix + “/user”;
@RequiresPermissions(“system:user:list”)
@PostMapping(“/list”)
@ResponseBody
public TableDataInfo list(User user)
startPage();
List list = userService.selectUserList(user);
return getDataTable(list);
@Log(title = “用户管理”, businessType = BusinessType.EXPORT)
@RequiresPermissions(“system:user:export”)
@PostMapping(“/export”)
@ResponseBody
public AjaxResult export(User user)
List list = userService.selectUserList(user);
ExcelUtil util = new ExcelUtil(User.class);
return util.exportExcel(list, “用户数据”);
@Log(title = “用户管理”, businessType = BusinessType.IMPORT)
@RequiresPermissions(“system:user:import”)
@PostMapping(“/importData”)
@ResponseBody
public AjaxResult importData(MultipartFile file, boolean updateSupport) throws Exception
ExcelUtil util = new ExcelUtil(User.class);
List userList = util.importExcel(file.getInputStream());
String message = userService.importUser(userList, updateSupport);
return AjaxResult.success(message);
@RequiresPermissions(“system:user:view”)
@GetMapping(“/importTemplate”)
@ResponseBody
public AjaxResult importTemplate()
ExcelUtil util = new ExcelUtil(User.class);
return util.importTemplateExcel(“用户数据”);
/**
新增用户
*/
@GetMapping(“/add”)
public String add(ModelMap mmap)
mmap.put(“roles”, roleService.selectRoleAll());
mmap.put(“posts”, postService.selectPostAll());
return prefix + “/add”;
/**
新增保存用户
*/
@RequiresPermissions(“system:user:add”)
@Log(title = “用户管理”, businessType = BusinessType.INSERT)
@PostMapping(“/add”)
@ResponseBody
public AjaxResult addSave(@Validated User user)
if (UserConstants.USER_NAME_NOT_UNIQUE.equals(userService.checkLoginNameUnique(user.getLoginName())))
return error(“新增用户’” + user.getLoginName() + “'失败，登录账号已存在”);
else if (UserConstants.USER_PHONE_NOT_UNIQUE.equals(userService.checkPhoneUnique(user)))
return error(“新增用户’” + user.getLoginName() + “'失败，手机号码已存在”);
else if (UserConstants.USER_EMAIL_NOT_UNIQUE.equals(userService.checkEmailUnique(user)))
return error(“新增用户’” + user.getLoginName() + “'失败，邮箱账号已存在”);
return toAjax(userService.insertUser(user));
/**
修改用户
*/
@GetMapping(“/edit/{userId}”)
public String edit(@PathVariable(“userId”) Long userId, ModelMap mmap)
mmap.put(“user”, userService.selectUserById(userId));
mmap.put(“roles”, roleService.selectRolesByUserId(userId));
mmap.put(“posts”, postService.selectPostsByUserId(userId));
return prefix + “/edit”;
/**
修改保存用户
*/
@RequiresPermissions(“system:user:edit”)
@Log(title = “用户管理”, businessType = BusinessType.UPDATE)
@PostMapping(“/edit”)
@ResponseBody
public AjaxResult editSave(@Validated User user)
userService.checkUserAllowed(user);
if (UserConstants.USER_PHONE_NOT_UNIQUE.equals(userService.checkPhoneUnique(user)))
return error(“修改用户’” + user.getLoginName() + “'失败，手机号码已存在”);
else if (UserConstants.USER_EMAIL_NOT_UNIQUE.equals(userService.checkEmailUnique(user)))
return error(“修改用户’” + user.getLoginName() + “'失败，邮箱账号已存在”);
return toAjax(userService.updateUser(user));
@RequiresPermissions(“system:user:resetPwd”)
@Log(title = “重置密码”, businessType = BusinessType.UPDATE)
@GetMapping(“/resetPwd/{userId}”)
public String resetPwd(@PathVariable(“userId”) Long userId, ModelMap mmap)
mmap.put(“user”, userService.selectUserById(userId));
return prefix + “/resetPwd”;
@RequiresPermissions(“system:user:resetPwd”)
@Log(title = “重置密码”, businessType = BusinessType.UPDATE)
@PostMapping(“/resetPwd”)
@ResponseBody
public AjaxResult resetPwdSave(User user)
userService.checkUserAllowed(user);
if (userService.resetUserPwd(user) > 0)
if (ShiroUtils.getUserId() == user.getUserId())
setSysUser(userService.selectUserById(user.getUserId()));
return success();
return error();
@RequiresPermissions(“system:user:remove”)
@Log(title = “用户管理”, businessType = BusinessType.DELETE)
@PostMapping(“/remove”)
@ResponseBody
public AjaxResult remove(String ids)
try
return toAjax(userService.deleteUserByIds(ids));
catch (Exception e)
return error(e.getMessage());
/**
校验用户名
*/
@PostMapping(“/checkLoginNameUnique”)
@ResponseBody
public String checkLoginNameUnique(User user)
return userService.checkLoginNameUnique(user.getLoginName());
/**
校验手机号码
*/
@PostMapping(“/checkPhoneUnique”)
@ResponseBody
public String checkPhoneUnique(User user)
return userService.checkPhoneUnique(user);
/**
校验email邮箱
*/
@PostMapping(“/checkEmailUnique”)
@ResponseBody
public String checkEmailUnique(User user)
return userService.checkEmailUnique(user);
/**
用户状态修改
*/
@Log(title = “用户管理”, businessType = BusinessType.UPDATE)
@RequiresPermissions(“system:user:edit”)
@PostMapping(“/changeStatus”)
@ResponseBody
public AjaxResult changeStatus(User user)
userService.checkUserAllowed(user);
return toAjax(userService.changeStatus(user));
