基于javaweb+mysql的springboot+mybatis在线水果商城系统(springboot+spring+springmvc+mybatis+html+mysql+redis)
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SpringBoot+MyBatis在线水果商城系统(springboot+spring+springmvc+mybatis+html+mysql+redis)
一、项目简述
功能: 区分为管理员用户和普通用户,普通用户:用户注册登录,首页水果展示,商品分类展示,购物车添加,下单,订单查询,个人信息修改,管理员用户:包括水果基本信息维护增删改查,分类管理,订单管理,用户管理等等功能。
二、项目运行
环境配置:
Jdk1.8 + Tomcat8.5 + mysql + Eclispe(IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持)
项目技术:
springboot+spring+springmvc+mybatis+html+mysql+redis+thymeleaf
return "admin_login";
}
//管理员修改密码
@RequestMapping("/userToAdminForgetpwd")
public String toAdminForgetpwd(){
return "admin_forgetPwd";
}
//管理员信息页
@RequestMapping("/toAdmin")
public String admin() {
return "admin";
}
//管理员主页
@RequestMapping("/userAdminIndex")
public String AdminIndex(){
return "admin_index";
}
//用户主页
@RequestMapping({"/","/toIndex"})
public String index() {
return "index";
}
//商品列表页面
@RequestMapping("/toGoodList")
public String goodsList() {
return "goodslist";
}
//已上架商品列表页面
@RequestMapping("/toGoodsUp")
public String goodsUp() {
return "goodsUp";
}
//已下架商品列表页面
@RequestMapping("/toGoodsDown")
public String goodsDown() {
return "goodsDown";
}
//商品订单页面
@RequestMapping("/toOrdersList")
public String ordersList(HttpServletRequest request){
HttpSession session = request.getSession();
session.removeAttribute("count");
session.removeAttribute("goodscarCount");
session.removeAttribute("orders");
session.removeAttribute("ordersEndListById");
App.goodscarList = null;
App.ADDRESS = null;
session.setAttribute("saveUsername", App.USERNAME);
}
return "redirect:toIndex";
}
/**
* 管理员退出
*/
@RequestMapping("/userAdminQuit")
public String userAdminQuit(HttpServletRequest request){
HttpSession session = request.getSession();
// session.invalidate();
session.removeAttribute("adminUsername");
session.removeAttribute("adminEmail");
session.removeAttribute("saveadminUsername");
session.removeAttribute("saveadminPassword");
session.removeAttribute("ordersList");
session.removeAttribute("ordersWaitList");
session.removeAttribute("ordersEndList");
session.setAttribute("saveadminUsername", App.ADMIN_USERNAME);
session.setAttribute("saveadminPassword", App.ADMIN_PASSWORD);
return "redirect:toAdminLogin";
}
}
resultMap.put("status", 0);
resultMap.put("message", "有数据");
resultMap.put("result", pageBean);
}
}
return resultMap;
}
/**
* 商品上架
*/
@RequestMapping("/goodsUp")
@ResponseBody
public Map<String, Object> goodsUp(String id) {
Map<String, Object> map = new HashMap<String, Object>();
int result = goodsService.goodsUp(id);
if (result == 1) {
map.put("status", 0);
map.put("message", "上架成功");
} else {
map.put("status", 1);
map.put("message", "上架失败");
}
return map;
}
/**
* 商品下架
*/
@RequestMapping("/goodsDown")
@ResponseBody
public Map<String, Object> goodsDown(String id) {
Map<String, Object> map = new HashMap<String, Object>();
int result = goodsService.goodsDown(id);
if (result == 1) {
map.put("status", 0);
map.put("message", "下架成功");
} else {
map.put("status", 1);
map.put("message", "下架失败");
}
return map;
}
HttpSession session = request.getSession();
String checkcode_server = (String) session.getAttribute("CHECKCODE");
session.removeAttribute("CHECKCODE");//为了保证验证码只能使用一次
User u = userService.findUserByUsername(username);
if (u == null || u.getDr() == 1) {
map.put("status", 1);
map.put("message", "登录失败,请检查信息是否正确");
} else {
if (u.getPassword().equals(pwd) && checkcode.equalsIgnoreCase(checkcode_server)) {
String userid = u.getId();
List<Goodscar> goodscars = goodsCarService.findGoodscarByUserId(userid);
App.goodscarList = goodscars;
session.setAttribute("goodscarList", App.goodscarList);
session.setAttribute("count", App.goodscarList.size());
session.setAttribute("username", username);
session.setAttribute("email", u.getEmail());
List<Ordergoods> orders = new ArrayList<Ordergoods>();
List<Ordergoods> ordersEndList = orderService.ordersEndListById(userid);
if (ordersEndList.size()>0){
session.setAttribute("ordersEndListById",ordersEndList);
}
List<Ordergoods> gcs = orderService.selectOrderByuserId(u.getId());
for (Ordergoods gs : gcs) {
orders.add(gs);
}
if (orders.size() > 0) {
session.setAttribute("orders", orders);
}
if (checked == 1) {
App.USERNAME = username;
} else if (checked == 0) {
App.USERNAME = null;
}
map.put("status", 0);
map.put("message", "登录成功");
} else {
map.put("status", 1);
map.put("message", "登录失败,请检查信息是否正确");
}
}
return map;
}
/**
* 管理员登录
mav.addObject("ids",ids);
return mav;
}
//商品找不到页面
@RequestMapping("/toNoPage")
public String noPage(){
return "404";
}
/**
* 验证码的绘制
*/
@RequestMapping("/checkCode")
public void checkCode(HttpServletRequest request, HttpServletResponse response) throws IOException {
int width = 120;
int height = 50;
BufferedImage image = new BufferedImage(width, height, BufferedImage.TYPE_INT_RGB);
Graphics g = image.getGraphics();
g.setColor(Color.white);
g.fillRect(0, 0, width, height);
String checkCode = getCheckCode();
request.getSession().setAttribute("CHECKCODE", checkCode);
g.setColor(Color.green);
g.setFont(new Font("黑体", Font.BOLD, 36));
g.drawString(checkCode, 25, 35);
ImageIO.write(image, "PNG", response.getOutputStream());
}
/**
* 验证码的获取
*/
private String getCheckCode() {
String code = "0123456789ABCDEFGabcdefg";
int size = code.length();
Random r = new Random();
StringBuffer sb = new StringBuffer();
for (int i = 1; i <= 4; i++) {
int index = r.nextInt(size);
char c = code.charAt(index);
HttpSession session = request.getSession();
session.setAttribute("saveUsername", App.USERNAME);
return "login";
}
//用户注册
@RequestMapping("/toUserRegister")
public String userRegister() {
return "register";
}
//用户修改密码
@RequestMapping("/userToForgetPwd")
public String toForgetPwd(){
return "fogetPwd";
}
//管理员登录
@RequestMapping("/toAdminLogin")
public String adminLogin(HttpServletRequest request) {
HttpSession session = request.getSession();
session.setAttribute("saveadminUsername", App.ADMIN_USERNAME);
session.setAttribute("saveadminPassword", App.ADMIN_PASSWORD);
return "admin_login";
}
//管理员修改密码
@RequestMapping("/userToAdminForgetpwd")
public String toAdminForgetpwd(){
return "admin_forgetPwd";
}
//管理员信息页
@RequestMapping("/toAdmin")
public String admin() {
return "admin";
}
//管理员主页
@RequestMapping("/userAdminIndex")
public String AdminIndex(){
map.put("status", 1);
map.put("message", "修改失败,请检查信息是否正确");
}
} else {
map.put("status", 1);
map.put("message", "修改失败,请检查信息是否正确");
}
return map;
}
/**
* 用户退出
*/
@RequestMapping("/userQuit")
public String userQuit(HttpServletRequest request){
HttpSession session = request.getSession();
String auname = (String) session.getAttribute("adminUsername");
if (auname == null){
session.invalidate();
App.goodscarList = null;
App.ADDRESS = null;
HttpSession session1 = request.getSession();
session1.setAttribute("saveUsername", App.USERNAME);
}else {
session.removeAttribute("username");
session.removeAttribute("saveUsername");
session.removeAttribute("email");
session.removeAttribute("goodsBrowse");
session.removeAttribute("goodscarList");
session.removeAttribute("count");
session.removeAttribute("goodscarCount");
session.removeAttribute("orders");
session.removeAttribute("ordersEndListById");
App.goodscarList = null;
App.ADDRESS = null;
session.setAttribute("saveUsername", App.USERNAME);
}
return "redirect:toIndex";
}
/**
* 管理员退出
*/
@RequestMapping("/userAdminQuit")
public String userAdminQuit(HttpServletRequest request){
map.put("typeDr",typeDr);
List<Goods> lists = goodsService.findByPageDr(map);
// List<Goods> list = goodsService.selectCountDr(typeDr);
int count = goodsService.selectCountDr(typeDr);
if (count <= 0) {
resultMap.put("status", 1);
resultMap.put("message", "没有数据");
resultMap.put("result", null);
} else {
int totalCount = count;
double tc = totalCount;
int totalPage = (int) Math.ceil(tc / pageSize);
pageBean.setCurrentage(currentPage);
pageBean.setPageSize(pageSize);
pageBean.setTotalCount(totalCount);
pageBean.setTotalPage(totalPage);
pageBean.setLists(lists);
resultMap.put("status", 0);
resultMap.put("message", "有数据");
resultMap.put("result", pageBean);
}
} else {
// String search1 = "";
// search1 += ("%" + search + "%");
Map<String, Object> map = new HashMap<String, Object>();
map.put("start",start);
map.put("size",size);
map.put("typeDr",typeDr);
map.put("search",search);
List<Goods> lists = goodsService.findByPageSearchDr(map);
Map<String, Object> map1 = new HashMap<String, Object>();
map1.put("typeDr",typeDr);
map1.put("search",search);
// List<Goods> list = goodsService.selectSearchCountDr(map1);
int count = goodsService.selectSearchCountDr(map1);
if (count <= 0) {
resultMap.put("status", 1);
resultMap.put("message", "没有数据");
resultMap.put("result", null);
} else {
int totalCount = count;
double tc = totalCount;
int totalPage = (int) Math.ceil(tc / pageSize);
pageBean.setCurrentage(currentPage);
pageBean.setPageSize(pageSize);
pageBean.setTotalCount(totalCount);
}
/**
* 分页查询商品列表信息
*/
@RequestMapping("/goodsList")
@ResponseBody
public Map<String, Object> goodsList(int currentPage, String search) {
Map<String, Object> resultMap = new HashMap<String, Object>();
PageBean<Goods> pageBean = new PageBean<Goods>();
int pageSize = 5;
int start = (currentPage - 1) * pageSize;
int size = pageSize;
if (search == "" || search == null) {
Map<String, Object> map = new HashMap<String, Object>();
map.put("start",start);
map.put("size",size);
List<Goods> lists = goodsService.findByPage(map);
// List<Goods> list = goodsService.selectCount();
int count = goodsService.selectCount();
if (count <= 0) {
resultMap.put("status", 1);
resultMap.put("message", "没有数据");
resultMap.put("result", null);
} else {
int totalCount = count;
double tc = totalCount;
int totalPage = (int) Math.ceil(tc / pageSize);
pageBean.setCurrentage(currentPage);
pageBean.setPageSize(pageSize);
pageBean.setTotalCount(totalCount);
pageBean.setTotalPage(totalPage);
pageBean.setLists(lists);
resultMap.put("status", 0);
resultMap.put("message", "有数据");
resultMap.put("result", pageBean);
}
} else {
// String search1 = "";
// search1 += ("%" + search + "%");
// System.out.println(search1);
map1.put("reserved1",shuliang);
int result = goodsCarService.addGoodsCar(map1);
Map<String, Object> map2 = new HashMap<String, Object>();
map2.put("id",App.getUid());
map2.put("userid",userid);
map2.put("goodsid",goodsid);
map2.put("goodscarid",id);
map2.put("dr",dr);
int result2 = orderService.addOrdergoods(map2);
if (result == 1 && result2 == 1){
List<Ordergoods> orders = new ArrayList<Ordergoods>();
List<Ordergoods> gcs = orderService.selectOrderByuserId(u.getId());
for (Ordergoods gs : gcs) {
orders.add(gs);
}
session.setAttribute("orders", orders);
map.put("status", 0);
map.put("message", "购买成功");
map.put("result",id);
}else {
map.put("status", 1);
map.put("message", "购买失败");
map.put("result",null);
}
return map;
}
}
@Controller
public class OrdergoodsController {
@Resource(name = "orderService")
OrderService orderService;
} else {
map.put("status", 0);
map.put("message", "正在加载,请稍后");
map.put("result", goodslist);
}
return map;
}
/**
* 查看更多
*/
// @RequestMapping("/readMore")
// public String readMore(String groupid, Model model) {
// List<Goods> goodslist = goodsService.readMore(groupid);
// if (goodslist.size() <= 0) {
// return "redirect:toIndex";
// } else {
// List<Goods> goodsPart = new ArrayList<Goods>();
// if (goodslist.size()>=2){
// goodsPart.add(goodslist.get(goodslist.size() - 2));
// goodsPart.add(goodslist.get(goodslist.size() - 1));
// }else if((goodslist.size()==1)){
// goodsPart.add(goodslist.get(goodslist.size() - 1));
// }
// model.addAttribute("groupid", groupid);
// model.addAttribute("goodsPart", goodsPart);
// model.addAttribute("goodslist", goodslist);
// }
// return "readmoreShop";
// }
@RequestMapping("/readMore")
@ResponseBody
public Map<String, Object> readMore(String groupid) {
Map<String, Object> map = new HashMap<String, Object>();
List<Goods> goodslist = goodsService.readMore(groupid);
if (goodslist.size() <= 0) {
map.put("status",1);
map.put("message","抱歉没有相关的商品");
} else {
map.put("status",0);
map.put("message","商品展现成功");
gdsList = goodslist;
}
return map;
}
@GetMapping("/readMoreByMessage")
public String readMoreByMessage(String groupid, Model model){
List<Goods> goodslist = goodsService.readMore(groupid);
List<Goods> goodsPart = new ArrayList<Goods>();
if (goodslist.size()>=2){
goodsPart.add(goodslist.get(goodslist.size() - 2));
goodsPart.add(goodslist.get(goodslist.size() - 1));
}else if((goodslist.size()==1)){
return "goodsTypeList";
}
//增加商品类别列表页面
@RequestMapping("/toAddGoodsType")
public String addGoodsType() {
return "addGoodsType";
}
//日历页面
@RequestMapping("/toWelcome")
public String welcome() {
return "welcome";
}
//用户中心页面
@RequestMapping("/toCustomer")
public String customer() {
return "customer";
}
//购物车页面
@RequestMapping("/toShop")
public String shop() {
return "shop";
}
//订单页面
@RequestMapping("/toOrder")
public String order(HttpServletRequest request) {
HttpSession session = request.getSession();
String uname = (String) session.getAttribute("username");
if(uname!=null){
User u = userService.findUserByUsername(uname);
List<Ordergoods> orders = new ArrayList<Ordergoods>();
List<Ordergoods> gcs = orderService.selectOrderByuserId(u.getId());
for (Ordergoods gs : gcs) {
orders.add(gs);
}
session.setAttribute("orders", orders);
List<Ordergoods> ordersEndList = orderService.ordersEndListById(u.getId());
if (ordersEndList.size()>0){
session.setAttribute("ordersEndListById",ordersEndList);
}
}
}
return map;
}
/**
* 商品主页加载
*/
@RequestMapping("/indexList")
@ResponseBody
public Map<String, Object> indexList() {
Map<String, Object> map = new HashMap<String, Object>();
List<Goods> goodslist = goodsService.indexList();
if (goodslist.size() <= 0) {
map.put("status", 1);
map.put("message", "暂无上架商品");
map.put("result", null);
} else {
map.put("status", 0);
map.put("message", "正在加载,请稍后");
map.put("result", goodslist);
}
return map;
}
/**
* 查看更多
*/
// @RequestMapping("/readMore")
// public String readMore(String groupid, Model model) {
// List<Goods> goodslist = goodsService.readMore(groupid);
// if (goodslist.size() <= 0) {
// return "redirect:toIndex";
// } else {
// List<Goods> goodsPart = new ArrayList<Goods>();
// if (goodslist.size()>=2){
// goodsPart.add(goodslist.get(goodslist.size() - 2));
// goodsPart.add(goodslist.get(goodslist.size() - 1));
// }else if((goodslist.size()==1)){
// goodsPart.add(goodslist.get(goodslist.size() - 1));
// }
// model.addAttribute("groupid", groupid);
// model.addAttribute("goodsPart", goodsPart);
// model.addAttribute("goodslist", goodslist);
// }
// return "readmoreShop";
// }
@RequestMapping("/readMore")
@ResponseBody
public Map<String, Object> readMore(String groupid) {
resultMap.put("result", null);
} else {
int totalCount = count;
double tc = totalCount;
int totalPage = (int) Math.ceil(tc / pageSize);
pageBean.setCurrentage(currentPage);
pageBean.setPageSize(pageSize);
pageBean.setTotalCount(totalCount);
pageBean.setTotalPage(totalPage);
pageBean.setLists(lists);
resultMap.put("status", 0);
resultMap.put("message", "有数据");
resultMap.put("result", pageBean);
}
}
return resultMap;
}
/**
* 添加商品
*/
@RequestMapping("/addGoods")
@ResponseBody
public Map<String, Object> addGoods(MultipartFile file, Goods goods) {
Map<String, Object> map = new HashMap<String, Object>();
try {
//获取文件名
String pname = file.getOriginalFilename();
//获取文件格式
String type = pname.substring(pname.lastIndexOf("."));
//重命名
String photo_name = App.getUid() + type;
//将图片存到指定的位置
//windows系统配置图片路径
file.transferTo(new File(GoodsPhotoPath, photo_name));
//mac系统配置图片路径
//file.transferTo(new File("/Users/hanmeng/Desktop/java源码/Springboot生鲜水果商城/源码/GoodsPhoto", photo_name));
//将图片信息存入商品对象
goods.setPhoto(photo_name);
//商品id
goods.setId(App.getUid());
//商品状态
goods.setDr(1);
int i = goodsService.addGoods(goods);
if (i == 1) {
map.put("status", 0);
map.put("message", "添加成功");
} else {
map.put("status", 1);
map.put("message", "添加失败");
}
} catch (IOException e) {
@Controller
public class GoodstypeController {
@Resource(name = "goodstypeService")
GoodstypeService goodstypeService;
/**
* 分页查询增加商品分类列表信息
*/
@RequestMapping("/addGoodsTypeList")
@ResponseBody
public Map<String, Object> addGoodsTypeList(int currentPage, String search) {
Map<String, Object> resultMap = new HashMap<String, Object>();
PageBean<Goodstype> pageBean = new PageBean<Goodstype>();
int pageSize = 5;
int start = (currentPage - 1) * pageSize;
int size = pageSize;
if (search == "" || search == null) {
Map<String, Object> map = new HashMap<String, Object>();
map.put("start",start);
map.put("size",size);
List<Goodstype> lists = goodstypeService.findByPageType(map);
// List<Goodstype> list = goodstypeService.selectCountType();
int count = goodstypeService.selectCountType();
if (count <= 0) {
resultMap.put("status", 1);
resultMap.put("message", "没有数据");
resultMap.put("result", null);
} else {
int totalCount = count;
double tc = totalCount;
int totalPage = (int) Math.ceil(tc / pageSize);
pageBean.setCurrentage(currentPage);
pageBean.setPageSize(pageSize);
pageBean.setTotalCount(totalCount);
pageBean.setTotalPage(totalPage);
pageBean.setLists(lists);
resultMap.put("status", 0);
resultMap.put("message", "有数据");
resultMap.put("result", pageBean);
}
} else {
// String search1 = "";
map1.put("userid",userid);
map1.put("dr",dr);
map1.put("count",count);
map1.put("reserved1",shuliang);
int result = goodsCarService.addGoodsCar(map1);
Map<String, Object> map2 = new HashMap<String, Object>();
map2.put("id",App.getUid());
map2.put("userid",userid);
map2.put("goodsid",goodsid);
map2.put("goodscarid",id);
map2.put("dr",dr);
int result2 = orderService.addOrdergoods(map2);
if (result == 1 && result2 == 1){
List<Ordergoods> orders = new ArrayList<Ordergoods>();
List<Ordergoods> gcs = orderService.selectOrderByuserId(u.getId());
for (Ordergoods gs : gcs) {
orders.add(gs);
}
session.setAttribute("orders", orders);
map.put("status", 0);
map.put("message", "购买成功");
map.put("result",id);
}else {
map.put("status", 1);
map.put("message", "购买失败");
map.put("result",null);
}
return map;
}
}
@Controller
map.put("message", "交易失败");
} else {
String uname = (String) session.getAttribute("username");
User u = userService.findUserByUsername(uname);
List<Goodscar> goodscars = goodsCarService.findGoodscarDrById(gcids);
List<Ordergoods> orders = new ArrayList<Ordergoods>();
Map<String, Object> map1 = new HashMap<String, Object>();
for (Goodscar gc : goodscars) {
String id = App.getUid();
String uid = gc.getUserid();
String gid = gc.getGoodsid();
String gcid = gc.getId();
int dr = gc.getDr();
map1.put("id",id);
map1.put("userid",uid);
map1.put("goodsid",gid);
map1.put("goodscarid",gcid);
map1.put("dr",dr);
orderService.addOrdergoods(map1);
}
List<Ordergoods> gcs = orderService.selectOrderByuserId(u.getId());
for (Ordergoods gs : gcs) {
orders.add(gs);
}
if (orders.size() <= 0) {
map.put("status", 1);
map.put("message", "交易失败");
} else {
session.setAttribute("orders", orders);
String userid = u.getId();
List<Goodscar> gc = goodsCarService.findGoodscarByUserId(userid);
App.goodscarList = gc;
session.setAttribute("goodscarList", App.goodscarList);
session.setAttribute("count", App.goodscarList.size());
map.put("status", 0);
map.put("message", "交易成功");
}
}
return map;
}
/**
* 立即购买
*/
@RequestMapping("/buyGoodsImmediately")
@ResponseBody
public Map<String, Object> buyGoodsImmediately(String goodsid, String shuliang,HttpServletRequest request){
Map<String, Object> map = new HashMap<String, Object>();
HttpSession session = request.getSession();
String username = (String) session.getAttribute("username");
User u = userService.findUserByUsername(username);
String userid = u.getId();
String id = App.getUid();
map.put("status", 1);
map.put("message", "编辑失败");
}
return map;
}
/**
* 商品主页加载
*/
@RequestMapping("/indexList")
@ResponseBody
public Map<String, Object> indexList() {
Map<String, Object> map = new HashMap<String, Object>();
List<Goods> goodslist = goodsService.indexList();
if (goodslist.size() <= 0) {
map.put("status", 1);
map.put("message", "暂无上架商品");
map.put("result", null);
} else {
map.put("status", 0);
map.put("message", "正在加载,请稍后");
map.put("result", goodslist);
}
return map;
}
/**
* 查看更多
*/
// @RequestMapping("/readMore")
// public String readMore(String groupid, Model model) {
// List<Goods> goodslist = goodsService.readMore(groupid);
// if (goodslist.size() <= 0) {
// return "redirect:toIndex";
// } else {
// List<Goods> goodsPart = new ArrayList<Goods>();
// if (goodslist.size()>=2){
// goodsPart.add(goodslist.get(goodslist.size() - 2));
// goodsPart.add(goodslist.get(goodslist.size() - 1));
// }else if((goodslist.size()==1)){