基于javaweb+mysql的springboot汽车配件销售管理系统(java+springboot+layui+html+maven+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的SpringBoot汽车配件销售管理系统(java+springboot+layui+html+maven+mysql)
项目介绍
本项目为后台管理系统, 主要功能包括:
公告增删改查,用户管理,登录页面,订单查询,配件添加等等
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。
2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA;
3.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS;
4.数据库:MySql 5.7版本;
技术栈
-
后端:SpringBoot
-
前端:HTML+CSS+JavaScript+layui
使用说明
运行项目,输入localhost:8081/ 登录
管理员:admin/123456
return result;
}
/**
* 根据id删除
*
* @param id
* @return
*/
@ApiOperation(value = "公告删除接口",notes = "根据公告id删除公告")
@GetMapping("/admin/notice/del")
public String delete(Integer id) {
System.out.println("id = " + id);
int row = noticeService.deleteByPrimaryKey(id);
if (row > 0) {
return "success";
}
return "error";
}
/**
* 更新
*
* @param notice
* @return
*/
@ApiOperation(value = "更新公告接口",notes = "根据公告前台json数据对象进行删除公告!")
@PostMapping("/admin/notice/update")
public String update(@RequestBody Notice notice) {
Notice upNotice = notice;
upNotice.setNtime(new Date());
if (upNotice != null) {
int index = noticeService.updateByPrimaryKey(upNotice);
if (index > 0) {
return "success";
}
}
return "error";
}
/**
}
/**
* 订单Controller
*/
@Api("后台订单接口")
@RestController
public class OrderController {
private Logger logger = LoggerFactory.getLogger(this.getClass());
// 注入Service
@Autowired
private OrderService orderService;
// 注入订单详情Service
@Autowired
private OrderDetailService orderDetailService;
/**
* 订单列表
*
* @param page
* @param limit
* @return
*/
@ApiOperation(value = "订单列表", notes = "查询结果集合数据")
@GetMapping("/admin/order/list")
/**
* 根据配件类型删除
*
* @param goodsType
* @return
*/
@ApiOperation(value = "配件类型接口",notes = "根据json数据更新配件类型")
@PostMapping("/admin/goodsType/update")
public String updateGoodsType(@RequestBody GoodsType goodsType) {
logger.info("更新配件类型数据=" + goodsType);
int update = goodsTypeService.updateByPrimaryKey(goodsType);
if (update > 0) {
return "success";
}
return "error";
}
}
/**
* 公告控制器
*/
@Api(value = "公告模块AIP接口")
@RestController
public class NoticeController {
@Autowired
private NoticeService noticeService;
int del = goodsTypeService.deleteByPrimaryKey(id);
if (del > 0) {
return "success";
}
return "error";
}
/**
* 根据配件类型删除
*
* @param goodsType
* @return
*/
@ApiOperation(value = "配件类型接口",notes = "根据json数据更新配件类型")
@PostMapping("/admin/goodsType/update")
public String updateGoodsType(@RequestBody GoodsType goodsType) {
logger.info("更新配件类型数据=" + goodsType);
int update = goodsTypeService.updateByPrimaryKey(goodsType);
if (update > 0) {
return "success";
}
return "error";
}
}
@PostMapping("/admin/notice/save")
public String save(@RequestBody Notice notice) {
Notice saveNotice = notice;
saveNotice.setNtime(new Date());
if (saveNotice != null) {
int index = noticeService.insert(saveNotice);
if (index > 0) {
return "success";
}
}
return "error";
}
}
/**
* 订单Controller
*/
@Api("后台订单接口")
@RestController
public class OrderController {
private Logger logger = LoggerFactory.getLogger(this.getClass());
// 注入Service
@Autowired
private OrderService orderService;
// 注入订单详情Service
@Autowired
private OrderDetailService orderDetailService;
/**
* 订单列表
@GetMapping("/admin/order/list")
public ServerLayResult<Order> OrderList(@RequestParam(value = "page", defaultValue = "1") Integer page,
@RequestParam(value = "limit", defaultValue = "10") Integer limit) {
return new ServerLayResult(0, "", orderService.count(), orderService.selectAll(page, limit));
}
/**
* 根据id删除
*
* @param id
* @return
*/
@ApiOperation(value = "订单删除", notes = "根据订单的id删除订单")
@GetMapping("/admin/order/del")
public String orderDel(@RequestParam(value = "id") Integer id) {
logger.info("订单id----" + id);
if (id != null && id > 0) {
// 删除关联订单详情
int index = orderDetailService.deleteByOrderId(id);
if (index > 0) {
int delete = orderService.deleteByPrimaryKey(id);
if (delete > 0) {
return "success";
}
}
}
return "error";
}
}
/**
* 登入拦截器
*/
public class LoginInterceptor implements HandlerInterceptor {
private Logger logger = LoggerFactory.getLogger(this.getClass());
@Override
public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
//每一个请求检查是否已经登入
logger.info("LoginInterceptor.preHandle拦截器执行");
return "error";
}
Goods goods = new Goods();
goods.setId(id);
goods.setGname(gname);
goods.setGoprice(goprice);
goods.setGrprice(grprice);
goods.setGstore(gstore);
GoodsType goodsType = new GoodsType();
goodsType.setId(Integer.parseInt(goodstypeId));
goods.setGoodstypeId(goodsType);
goods.setIputTime(new Date());
goods.setGpicture("/views/upload/" + image);
logger.info(String.valueOf(goods));
int insert = goodsService.updateByPrimaryKey(goods);
if (insert > 0) {
return "success";
}
return "error";
}
@ApiOperation(value = "配件保存接口", notes = "根据json数据来保存配件")
@PostMapping("/admin/goods/add")
public String addGoods(@RequestBody JSONObject ob) {
com.alibaba.fastjson.JSONObject json = JSON.parseObject(ob.toJSONString());
String gname = json.getString("gname");
Double goprice = json.getDouble("goprice");
Double grprice = json.getDouble("grprice");
Integer gstore = json.getInteger("gstore");
String goodstypeId = json.getString("goodstypeId");
Goods goods = new Goods();
goods.setGname(gname);
goods.setGoprice(goprice);
goods.setGrprice(grprice);
goods.setGstore(gstore);
GoodsType goodsType = new GoodsType();
goodsType.setId(Integer.parseInt(goodstypeId));
goods.setGoodstypeId(goodsType);
goods.setIputTime(new Date());
goods.setGpicture("/views/upload/" + image);
int insert = goodsService.insert(goods);
if (insert > 0) {
return "success";
}
return "error";
}
/**
* 实现文件上传
*/
/**
* 查询结果列表
*
* @param page
* @param limit
* @return
*/
@SuppressWarnings("rawtypes")
@ApiOperation(value = "公告模块接口",notes = "公告结果列表")
@GetMapping("/admin/notice/list")
public ServerLayResult<Notice> list(@RequestParam(value = "page", defaultValue = "1") Integer page,
@RequestParam(value = "limit", defaultValue = "10") Integer limit) {
@SuppressWarnings("unchecked")
ServerLayResult<Notice> result = new ServerLayResult(0, "", noticeService.count(), noticeService.selectAll(page, limit));
return result;
}
/**
* 根据id删除
*
* @param id
* @return
*/
@ApiOperation(value = "公告删除接口",notes = "根据公告id删除公告")
@GetMapping("/admin/notice/del")
public String delete(Integer id) {
System.out.println("id = " + id);
int row = noticeService.deleteByPrimaryKey(id);
if (row > 0) {
return "success";
}
return "error";
}
/**
* 更新
*
* @param notice
* @return
*/
@ApiOperation(value = "更新公告接口",notes = "根据公告前台json数据对象进行删除公告!")
@PostMapping("/admin/notice/update")
public String update(@RequestBody Notice notice) {
Notice upNotice = notice;
upNotice.setNtime(new Date());
if (upNotice != null) {
int index = noticeService.updateByPrimaryKey(upNotice);
if (index > 0) {
return "success";
}
/**
* 更新
*
* @param notice
* @return
*/
@ApiOperation(value = "更新公告接口",notes = "根据公告前台json数据对象进行删除公告!")
@PostMapping("/admin/notice/update")
public String update(@RequestBody Notice notice) {
Notice upNotice = notice;
upNotice.setNtime(new Date());
if (upNotice != null) {
int index = noticeService.updateByPrimaryKey(upNotice);
if (index > 0) {
return "success";
}
}
return "error";
}
/**
* 保存操作
*
* @param notice
* @return
*/
@ApiOperation(value = "保存公告接口",notes = "根据前台传入json数据对象进行保存公告")
@PostMapping("/admin/notice/save")
public String save(@RequestBody Notice notice) {
Notice saveNotice = notice;
saveNotice.setNtime(new Date());
if (saveNotice != null) {
int index = noticeService.insert(saveNotice);
if (index > 0) {
return "success";
}
}
return "error";
}
}
public void defaultKaptcha(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse)
throws Exception {
byte[] captchaChallengeAsJpeg = null;
ByteArrayOutputStream jpegOutputStream = new ByteArrayOutputStream();
try {
//生产验证码字符串并保存到session中
String createText = producer.createText();
httpServletRequest.getSession().setAttribute("vrifyCode", createText);
//使用生产的验证码字符串返回一个BufferedImage对象并转为byte写入到byte数组中
BufferedImage challenge = producer.createImage(createText);
ImageIO.write(challenge, "jpg", jpegOutputStream);
} catch (IllegalArgumentException e) {
httpServletResponse.sendError(HttpServletResponse.SC_NOT_FOUND);
return;
}
//定义response输出类型为image/jpeg类型,使用response输出流输出图片的byte数组
captchaChallengeAsJpeg = jpegOutputStream.toByteArray();
httpServletResponse.setHeader("Cache-Control", "no-store");
httpServletResponse.setHeader("Pragma", "no-cache");
httpServletResponse.setDateHeader("Expires", 0);
httpServletResponse.setContentType("image/jpeg");
ServletOutputStream responseOutputStream =
httpServletResponse.getOutputStream();
responseOutputStream.write(captchaChallengeAsJpeg);
responseOutputStream.flush();
responseOutputStream.close();
}
@ApiOperation(value = "登出接口", notes = "注销接口")
@GetMapping("/logout")
public String logout(HttpSession session) {
//销毁session
session.invalidate();
return "/admin/login";
}
}
/**
* 后台系统登入控制器
*/
@Api(value = "登入接口API")
@Controller
public class LoginController {
private Logger logger = LoggerFactory.getLogger(this.getClass());
//注入
@Autowired
private Producer producer;
@Autowired
private AdminUserService adminUserService;
/**
* @return
*/
@ApiOperation(value = "控制登入跳转", notes = "登入控制器跳转")
@GetMapping("/admin/login")
public String showLogin() {
return "admin/login";
}
@ApiOperation(value = "登入处理接口", notes = "根据json对象处理登入")
@PostMapping("/admin/login_do")
@ResponseBody
public String loginDo(@RequestBody AdminUser user, HttpServletRequest request) {
logger.info("登入用户的信息:" + user);
String vrifyCode = (String) request.getSession().getAttribute("vrifyCode");
if (user != null) {
AdminUser adminUser = adminUserService.selectByUser(user.getAusername(), user.getApassword());
if (adminUser == null) {
return "passwordError";
} else if (!vrifyCode.equals(user.getVercode())) {
return "vrifyCodeErroe";
}
request.getSession().setAttribute("loginName", user);
return "success";
} else {
return "userNull";
}
}
/**
* 生成验证码
*
* @return
*/
@ApiOperation(value = "配件类型保存接口",notes = "根据前台传入的json数据对象进行保存配件类型")
@PostMapping("/admin/goodsType/save")
public String addGoodsType(@RequestBody GoodsType goodsType) {
logger.info("goodsType===" + goodsType);
int insert = goodsTypeService.insert(goodsType);
if (insert > 0) {
return "success";
}
return "error";
}
/**
* 根据id删除配件类型
*
* @param id
* @return
*/
@ApiOperation(value = "配件类型删除接口",notes = "根据配件ID删除配件类型")
@GetMapping("/admin/goodsType/del")
public String delGoodsType(@RequestParam(value = "id") Integer id) {
logger.info("删除的配件类型ID=" + id);
int del = goodsTypeService.deleteByPrimaryKey(id);
if (del > 0) {
return "success";
}
return "error";
}
/**
* 根据配件类型删除
*
* @param goodsType
* @return
*/
@ApiOperation(value = "配件类型接口",notes = "根据json数据更新配件类型")
@PostMapping("/admin/goodsType/update")
public String updateGoodsType(@RequestBody GoodsType goodsType) {
logger.info("更新配件类型数据=" + goodsType);
int update = goodsTypeService.updateByPrimaryKey(goodsType);
if (update > 0) {
return "success";
}
return "error";
}
/**
* 公告控制器
*/
@Api(value = "公告模块AIP接口")
@RestController
public class NoticeController {
@Autowired
private NoticeService noticeService;
/**
* 查询结果列表
*
* @param page
* @param limit
* @return
*/
@SuppressWarnings("rawtypes")
@ApiOperation(value = "公告模块接口",notes = "公告结果列表")
@GetMapping("/admin/notice/list")
public ServerLayResult<Notice> list(@RequestParam(value = "page", defaultValue = "1") Integer page,
@RequestParam(value = "limit", defaultValue = "10") Integer limit) {
@SuppressWarnings("unchecked")
ServerLayResult<Notice> result = new ServerLayResult(0, "", noticeService.count(), noticeService.selectAll(page, limit));
return result;
}
/**
* 根据id删除
*
* @param id
* @return
*/
@ApiOperation(value = "公告删除接口",notes = "根据公告id删除公告")
@GetMapping("/admin/notice/del")
public String delete(Integer id) {
System.out.println("id = " + id);
int row = noticeService.deleteByPrimaryKey(id);
if (row > 0) {
return "success";
}
return "error";
}
private Logger logger = LoggerFactory.getLogger(this.getClass());
@Autowired
private GoodsTypeService goodsTypeService;
/**
* 下拉动态加载
*
* @return
*/
@ApiOperation(value = "配件类型接口",notes = "用于动态更新加载配件类型")
@PostMapping("/admin/goodstype/list")
public List<GoodsType> list() {
List<GoodsType> goodsTypes = goodsTypeService.selectAll();
return goodsTypes;
}
/**
* 列表查询
*
* @param page
* @param limit
* @return
*/
@ApiOperation(value = "配件类型列表接口",notes = "配件类型结果集")
@RequestMapping("/admin/goodstype/tableList")
public ServerLayResult goodsTypeList(@RequestParam(value = "page", defaultValue = "1") Integer page,
@RequestParam(value = "limit", defaultValue = "10") Integer limit) {
int count = goodsTypeService.count();
//分页
PageHelper.startPage(page, limit);
List<GoodsType> goodsTypes = goodsTypeService.selectAll();
PageInfo info = new PageInfo(goodsTypes);
//组装数据
ServerLayResult result = new ServerLayResult(0, "", count, info.getList());
return result;
}
/**
* 配件添加
*
* @param goodsType
* @return
*/
@ApiOperation(value = "配件类型保存接口",notes = "根据前台传入的json数据对象进行保存配件类型")
@PostMapping("/admin/goodsType/save")
public String addGoodsType(@RequestBody GoodsType goodsType) {
logger.info("goodsType===" + goodsType);
public String delGoodsType(@RequestParam(value = "id") Integer id) {
logger.info("删除的配件类型ID=" + id);
int del = goodsTypeService.deleteByPrimaryKey(id);
if (del > 0) {
return "success";
}
return "error";
}
/**
* 根据配件类型删除
*
* @param goodsType
* @return
*/
@ApiOperation(value = "配件类型接口",notes = "根据json数据更新配件类型")
@PostMapping("/admin/goodsType/update")
public String updateGoodsType(@RequestBody GoodsType goodsType) {
logger.info("更新配件类型数据=" + goodsType);
int update = goodsTypeService.updateByPrimaryKey(goodsType);
if (update > 0) {
return "success";
}
return "error";
}
}
/**
* 后台系统登入控制器
*/
@Api(value = "登入接口API")
@Controller
public class LoginController {
private Logger logger = LoggerFactory.getLogger(this.getClass());
//注入
@Autowired
private Producer producer;
@Autowired
private AdminUserService adminUserService;
/**
* @return
*/
@ApiOperation(value = "控制登入跳转", notes = "登入控制器跳转")
@GetMapping("/admin/login")
public String showLogin() {
return "admin/login";
}
@ApiOperation(value = "登入处理接口", notes = "根据json对象处理登入")
@PostMapping("/admin/login_do")
@ResponseBody
public String loginDo(@RequestBody AdminUser user, HttpServletRequest request) {
logger.info("登入用户的信息:" + user);
String vrifyCode = (String) request.getSession().getAttribute("vrifyCode");
if (user != null) {
AdminUser adminUser = adminUserService.selectByUser(user.getAusername(), user.getApassword());
if (adminUser == null) {
return "passwordError";
} else if (!vrifyCode.equals(user.getVercode())) {
return "vrifyCodeErroe";
}
request.getSession().setAttribute("loginName", user);
return "success";
} else {
return "userNull";
}
}
* 配件控制器
*/
@Api("配件接口API")
@RestController
public class GoodsController {
private Logger logger = LoggerFactory.getLogger(this.getClass());
@Autowired
private GoodsService goodsService;
private String image = "";
@ApiOperation(value = "配件列表接口", notes = "配件结果集列表")
@GetMapping("/admin/goodsList")
public ServerLayResult<Goods> list(@RequestParam(value = "page", defaultValue = "1") Integer page,
@RequestParam(value = "limit", defaultValue = "10") Integer limit) {
//查询结果总数
int count = goodsService.count();
List<Goods> goods = goodsService.selectAll(page, limit);
//组装Json数据
ServerLayResult result = new ServerLayResult(0, "", count, goods);
return result;
}
@ApiOperation(value = "配件删除接口", notes = "根据配件ID删除配件")
@GetMapping("/admin/goods/del")
public String delete(Integer id) {
System.out.println("id = " + id);
int row = goodsService.deleteByPrimaryKey(id);
if (row > 0) {
return "success";
}
return "error";
}
@ApiOperation(value = "配件更新接口", notes = "根据json数据对象来更新接口")
@PostMapping("/admin/goods/update")
public String update(@RequestBody JSONObject ob) {
com.alibaba.fastjson.JSONObject json = JSON.parseObject(ob.toJSONString());
logger.info(ob.toJSONString());
String gname = json.getString("gname");
Integer id = json.getInteger("id");
Double goprice = json.getDouble("goprice");
Double grprice = json.getDouble("grprice");
Integer gstore = json.getInteger("gstore");
String goodstypeId = json.getString("goodstypeId");
if (goodstypeId == null) {
return "error";
}
Goods goods = new Goods();
goods.setId(id);
goods.setGname(gname);
goods.setGoprice(goprice);
goods.setGrprice(grprice);