前端模板框架为Bootstrap,系统分为前台和后台。后台主要为管理员角色,功能有:
商品类型管理、商品管理、订单管理、会员管理、管理员管理等。前台用户功能有:登录、注册、查看商品、加入购物车、付款、查看订单、个人中心等。该系统总共9张表

运行环境:windows/linux、jdk1.8、mysql5.x、maven3.5\3.6、tomcat7.0 

 

 

 

 

 

 

前端商品控制器:
/** * <p> * 前端控制器 * </p> */ @RestController @RequestMapping("/goods") public
class GoodsController { @Autowired private GoodsService goodsService;
@Autowired private ProviderService providerService; @Autowired private
CategoryService categoryService; /** * 商品模糊查询 * * @param * @return */
@SysLog("商品查询操作") @RequestMapping("/goodsList") public DataGridViewResult
goodsList(GoodsVO goodsVO) { //创建分页信息 参数1 当前页 参数2 每页显示条数 IPage<Goods> page =
new Page<>(goodsVO.getPage(), goodsVO.getLimit()); QueryWrapper<Goods>
queryWrapper = new QueryWrapper<>(); queryWrapper.eq(goodsVO.getProviderid() !=
null && goodsVO.getProviderid() != 0, "providerid", goodsVO.getProviderid());
queryWrapper.like(!StringUtils.isEmpty(goodsVO.getGname()), "gname",
goodsVO.getGname()); IPage<Goods> goodsIPage = goodsService.page(page,
queryWrapper); List<Goods> records = goodsIPage.getRecords(); for (Goods goods
: records) { Provider provider =
providerService.getById(goods.getProviderid()); if (null != provider) {
goods.setProvidername(provider.getProvidername()); } } return new
DataGridViewResult(goodsIPage.getTotal(), records); } /** * 添加商品信息 * * @param
goods * @return */ @SysLog("商品添加操作") @PostMapping("/addgoods") public Result
addGoods(Goods goods) { String id = RandomStringUtils.randomAlphanumeric(8); if
(goods.getGoodsimg()!=null&&goods.getGoodsimg().endsWith("_temp")){ String
newName = AppFileUtils.renameFile(goods.getGoodsimg());
goods.setGoodsimg(newName); } goods.setGnumbering(id); boolean bool =
goodsService.save(goods); if (bool) { return Result.success(true, "200",
"添加成功!"); } return Result.error(false, null, "添加失败!"); } /** * 修改商品信息 * *
@param goods * @return */ @SysLog("商品修改操作") @PostMapping("/updategoods") public
Result updateGoods(Goods goods) { //商品图片不是默认图片 if
(!(goods.getGoodsimg()!=null&&goods.getGoodsimg().equals(Constast.DEFAULT_IMG))){
if (goods.getGoodsimg().endsWith("_temp")){ String newName =
AppFileUtils.renameFile(goods.getGoodsimg()); goods.setGoodsimg(newName);
//删除原先的图片 String oldPath = goodsService.getById(goods.getGid()).getGoodsimg();
AppFileUtils.removeFileByPath(oldPath); } } boolean bool =
goodsService.updateById(goods); if (bool) { return Result.success(true, "200",
"修改成功!"); } return Result.error(false, null, "修改失败!"); } /** * 删除单条数据 * *
@param id * @return */ @SysLog("商品删除操作") @RequestMapping("/deleteOne") public
Result deleteOne(int id) { boolean bool = goodsService.removeById(id); if
(bool) { return Result.success(true, "200", "删除成功!"); } return
Result.error(false, null, "删除失败!"); } /** * 根据id查询当前商品拥有的类别 * * @param id *
@return */ @RequestMapping("/initGoodsByCategoryId") public DataGridViewResult
initGoodsByCategoryId(int id) { List<Map<String, Object>> mapList = null; try {
//查询所有类别列表 mapList = categoryService.listMaps(); //根据商品id查询商品拥有的类别 Set<Integer>
cateIdList = categoryService.findGoodsByCategoryId(id); for (Map<String,
Object> map : mapList) { //定义标记 默认不选中 boolean flag = false; int cateId = (int)
map.get("cateid"); for (Integer cid : cateIdList) { if (cid == cateId) { flag =
true; break; } } map.put("LAY_CHECKED", flag); } } catch (Exception e) {
e.printStackTrace(); } return new
DataGridViewResult(Long.valueOf(mapList.size()), mapList); } /** * 根据商品id加载商品信息
* @param goodsid * @return */ @GetMapping("/loadGoodsById") public
DataGridViewResult loadGoodsById(int goodsid) { QueryWrapper<Goods>
goodsQueryWrapper = new QueryWrapper<>(); goodsQueryWrapper.eq(goodsid != 0,
"gid", goodsid); Goods goods = goodsService.getById(goodsid); return new
DataGridViewResult(goods); } /** * 为商品分配类别 * * @param categoryids * @param
goodsid * @return */ @SysLog("类别添加操作") @RequestMapping("/saveGoodsCategory")
public Result saveGoodsCategory(String categoryids, int goodsid) { try { if
(goodsService.saveGoodsCategory(goodsid, categoryids)) { return
Result.success(true, null, "分配成功"); } } catch (Exception e) {
e.printStackTrace(); } return Result.error(false, null, "分配失败"); } /** * 加载下拉框
* * @return */ @RequestMapping("/loadAllGoods") public DataGridViewResult
loadAllGoods() { QueryWrapper<Goods> queryWrapper = new QueryWrapper<>();
List<Goods> list = goodsService.list(queryWrapper); return new
DataGridViewResult(list); } /** * 根据供应商查商品下拉框 * * @param providerid * @return
*/ @RequestMapping("/loadGoodsByProvidreId") public DataGridViewResult
loadGoodsByProvidreId(Integer providerid) { QueryWrapper<Goods>
goodsQueryWrapper = new QueryWrapper<>(); goodsQueryWrapper.eq(providerid !=
null, "providerid", providerid); List<Goods> list =
goodsService.list(goodsQueryWrapper); for (Goods goods : list) { Provider
provider = providerService.getById(goods.getProviderid()); if (null !=
provider) { goods.setProvidername(provider.getProvidername()); } } return new
DataGridViewResult(list); } }

前端销售控制器: 
/** * <p> * 前端控制器 * </p> */ @RestController @RequestMapping("/sale") public
class SaleController { @Autowired private SaleService saleService; @Autowired
private GoodsService goodsService; @Autowired private CustomerService
customerService; /** * 销售查询 * * @param * @return */ @SysLog("销售查询操作")
@RequestMapping("/saleList") public DataGridViewResult saleList(SaleVO saleVO)
{ //创建分页信息 参数1 当前页 参数2 每页显示条数 IPage<Sale> page = new Page<>(saleVO.getPage(),
saleVO.getLimit()); QueryWrapper<Sale> queryWrapper = new QueryWrapper<>();
queryWrapper.like(!StringUtils.isEmpty(saleVO.getNumbering()),"numbering",
saleVO.getNumbering()); queryWrapper.eq(saleVO.getGid() != null &&
saleVO.getGid() != 0, "gid", saleVO.getGid());
queryWrapper.ge(saleVO.getStartTime() != null, "buytime",
saleVO.getStartTime()); queryWrapper.le(saleVO.getEndTime() != null, "buytime",
saleVO.getEndTime()); queryWrapper.orderByDesc("buytime"); IPage<Sale>
saleIPage = saleService.page(page, queryWrapper); List<Sale> records =
saleIPage.getRecords(); for (Sale sale : records) {
sale.setAllmoney(sale.getMoney()*sale.getBuyquantity()); Customer customer =
customerService.getById(sale.getCustid()); if (null != customer) {
sale.setCustomervip(customer.getCustvip());
sale.setCustomername(customer.getCustname()); } Goods goods =
goodsService.getById(sale.getGid()); if (null != goods) {
sale.setGoodsname(goods.getGname()); sale.setGnumbering(goods.getGnumbering());
} } return new DataGridViewResult(saleIPage.getTotal(), records); } /** *
添加销售单信息 * * @param sale * @return */ @SysLog("销售添加操作") @PostMapping("/addsale")
public Result addsale(Sale sale, HttpSession session) { if (sale.getGid()==0){
return Result.error(false, null, "添加失败!未选商品"); } Goods goods =
goodsService.getById(sale.getGid()); Integer gquantity = goods.getGquantity();
if(gquantity<sale.getBuyquantity()){ return Result.error(false, null,
"添加失败!库存不足,库存为:"+gquantity); } User user = (User)
session.getAttribute("username"); String num =
RandomStringUtils.randomAlphanumeric(7); sale.setNumbering(num);
sale.setPerson(user.getUsername()); sale.setBuytime(new Date());
sale.setRealnumber(sale.getBuyquantity()); boolean bool =
saleService.save(sale); if (bool) { return Result.success(true, "200",
"添加成功!"); } return Result.error(false, null, "添加失败!库存不足"); } /** * 修改销售单信息 * *
@param sale * @return */ @SysLog("销售修改操作") @PostMapping("/updatesale") public
Result updatesale(Sale sale, HttpSession session) { User user = (User)
session.getAttribute("username"); sale.setPerson(user.getUsername());
sale.setBuytime(new Date()); boolean bool = saleService.updateById(sale); if
(bool) { return Result.success(true, "200", "修改成功!"); } return
Result.error(false, null, "修改失败!"); } /** * 删除单条数据 * * @param id * @return */
@SysLog("销售删除操作") @RequestMapping("/deleteOne") public Result deleteOne(int id)
{ boolean bool = saleService.removeById(id); if (bool) { return
Result.success(true, "200", "删除成功!"); } return Result.error(false, null,
"删除失败!"); } }

前端用户控制器:
/** * <p> * 前端控制器 * </p> * */ @RestController @RequestMapping("/user") public
class UserController { @Autowired private UserService userService; @Autowired
private RoleService roleService; /** * 登录 * * @param username 用户名 * @param
password 密码 * @param request * @return */ @SysLog("登陆操作")
@PostMapping("/login") public Result login(String username, String password,
HttpServletRequest request) { try { //获取当前登录主体对象 Subject subject =
SecurityUtils.getSubject(); UsernamePasswordToken token = new
UsernamePasswordToken(username, password); subject.login(token); LoginUserVO
userDTO = (LoginUserVO) subject.getPrincipal();
request.getSession().setAttribute("username", userDTO.getUser()); return
Result.success(true, "200", "登录成功"); } catch (UnknownAccountException e) {
e.printStackTrace(); return Result.error(false, "400", "登录失败,用户名不存在"); }catch
(IncorrectCredentialsException e) { e.printStackTrace(); return
Result.error(false, "400", "登录失败,密码错误"); }catch (AuthenticationException e) {
e.printStackTrace(); return Result.error(false, "400", "登录失败,账户禁用"); } } /** *
得到登陆验证码 * @param response * @param session * @throws IOException */
@RequestMapping("/getCode") public void getCode(HttpServletResponse response,
HttpSession session) throws IOException { //定义图形验证码的长和宽 LineCaptcha lineCaptcha
= CaptchaUtil.createLineCaptcha(116, 36,4,5);
session.setAttribute("code",lineCaptcha.getCode()); try { ServletOutputStream
outputStream = response.getOutputStream(); lineCaptcha.write(outputStream);
outputStream.close(); } catch (IOException e) { e.printStackTrace(); } } /** *
查询所有用户信息 * * @param userVO * @return */ @SysLog("用户查询操作")
@RequestMapping("/userList") public DataGridViewResult userList(UserVO userVO)
{ //分页构造函数 IPage<User> page = new Page<>(userVO.getPage(), userVO.getLimit());
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.like(!StringUtils.isEmpty(userVO.getUsername()), "username",
userVO.getUsername());
queryWrapper.like(!StringUtils.isEmpty(userVO.getUname()), "uname",
userVO.getUname()); /** * 翻页查询 * @param page 翻页对象 * @param queryWrapper
实体对象封装操作类 */ IPage<User> userIPage = userService.page(page, queryWrapper);
return new DataGridViewResult(userIPage.getTotal(), userIPage.getRecords()); }
/** * 添加用户信息 * * @param user * @return */ @SysLog("用户添加操作")
@PostMapping("/adduser") public Result addRole(User user) {
user.setUcreatetime(new Date()); String salt = UUIDUtil.randomUUID();
user.setPassword(PasswordUtil.md5("000000", salt, 2)); user.setSalt(salt);
user.setType(1); boolean bool = userService.save(user); try { if (bool) {
return Result.success(true, "200", "添加成功!"); } } catch (Exception e) {
e.printStackTrace(); } return Result.error(false, null, "添加失败!"); } /** *
校验用户名是否存在 * * @param username * @return */ @RequestMapping("/checkUserName")
public String checkUserName(String username) { Map<String, Object> map = new
HashMap<>(); try { QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.eq("username", username); User user =
userService.getOne(queryWrapper); if (user != null) { map.put("exist", true);
map.put("message", "用户名已存在"); } else { map.put("exist", false);
map.put("message", "用户名可以使用"); } } catch (Exception e) { e.printStackTrace(); }
return JSON.toJSONString(map); } /** * 修改用户信息 * * @param user * @return */
@SysLog("用户修改操作") @PostMapping("/updateuser") public Result updateUser(User
user) { boolean bool = userService.updateById(user); try { if (bool) { return
Result.success(true, "200", "修改成功!"); } } catch (Exception e) {
e.printStackTrace(); } return Result.error(false, null, "修改失败!"); } /** *
删除单条数据 * * @param id * @return */ @SysLog("用户删除操作")
@RequestMapping("/deleteOne") public Result deleteOne(int id) { boolean bool =
userService.removeById(id); try { if (bool) { return Result.success(true,
"200", "删除成功!"); } } catch (Exception e) { e.printStackTrace(); } return
Result.error(false, null, "删除失败!"); } /** * 重置密码 * * @param id * @return */
@SysLog("用户修改操作") @PostMapping("/resetPwd") public Result resetPwd(int id) {
User user = new User(); String salt = UUIDUtil.randomUUID(); user.setUid(id);
user.setPassword(PasswordUtil.md5("000000", salt, 2)); user.setSalt(salt);
boolean bool = userService.updateById(user); try { if (bool) { return
Result.success(true, "200", "重置成功!"); } } catch (Exception e) {
e.printStackTrace(); } return Result.error(false, null, "重置失败!"); } /** *
根据id查询当前用户拥有的角色 * * @param id * @return */ @RequestMapping("/initRoleByUserId")
public DataGridViewResult initRoleByUserId(int id) { List<Map<String, Object>>
mapList = null; try { //查询所有角色列表 mapList = roleService.listMaps();
//根据用户id查询用户拥有的角色 Set<Integer> roleIdList = userService.findRoleByUserId(id);
for (Map<String, Object> map : mapList) { //定义标记 默认不选中 boolean flag = false;
int roleId = (int) map.get("roleid"); for (Integer rid : roleIdList) { if (rid
== roleId) { flag = true; break; } } map.put("LAY_CHECKED", flag); } } catch
(Exception e) { e.printStackTrace(); } return new
DataGridViewResult(Long.valueOf(mapList.size()), mapList); } /** * 为用户分配角色 * *
@param roleids * @param userid * @return */ @SysLog("用户添加操作")
@RequestMapping("/saveUserRole") public Result saveUserRole(String roleids, int
userid) { try { if (userService.saveUserRole(userid, roleids)) { return
Result.success(true, null, "分配成功"); } } catch (Exception e) {
e.printStackTrace(); } return Result.error(false, null, "分配失败"); } /** * 修改密码 *
* @param newPassWord1 * @param newPassWord2 * @return */
@RequestMapping("/updateUserPassWord") public Result updateUserPassWord(String
newPassWord1, String newPassWord2,HttpSession session) { User sessionUser =
(User) session.getAttribute("username"); if
(newPassWord1.equals(newPassWord2)){ User user = new User(); String salt =
UUIDUtil.randomUUID(); user.setUid(sessionUser.getUid());
user.setPassword(PasswordUtil.md5(newPassWord1, salt, 2)); user.setSalt(salt);
boolean bool = userService.updateById(user); if (bool){ return
Result.success(true,null,"修改成功"); }else { return
Result.error(false,null,"修改失败!"); } }else { return
Result.error(false,null,"修改失败,两次密码不一致!"); } } }

技术
©2019-2020 Toolsou All rights reserved,
在算法研究过程中如何进行算法创新七大排序算法(java代码)MYSQL中的索引与事务———javaweb(8)(面试必考)2022蓝桥杯JavaB组省赛试题网络安全-wifi攻防网络层协议——ICMP协议MySQL查询表中指定条件下的最新记录JavaSE笔记(一)Java基础语法mysql 查询条件之外的数据_mysql 查询符合条件的数据qt使用数据库sqlite