基于 java springboot+mybatis二手网站系统设计和实现

个人信息查看和修改 后台管理： 后台管理员主要对前端客户端一些用户的管理、商品的管理、轮播图管理、商品分类管理以及订单信息和订单流程管理 轮播图配置 商品分类以及排序等 *** 作 商品管理和上下架等具体 *** 作

package ltd.newbee.mall.controller.admin;

import ltd.newbee.mall.common.ServiceResultEnum;

import ltd.newbee.mall.controller.vo.NewBeeMallOrderItemVO;

import ltd.newbee.mall.entity.NewBeeMallOrder;

import ltd.newbee.mall.service.NewBeeMallOrderService;

import ltd.newbee.mall.util.PageQueryUtil;

import ltd.newbee.mall.util.Result;

import ltd.newbee.mall.util.ResultGenerator;

import org.springframework.stereotype.Controller;

import org.springframework.util.CollectionUtils;

import org.springframework.util.StringUtils;

import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;

import javax.servlet.http.HttpServletRequest;

import java.util.List;

import java.util.Map;

import java.util.Objects;

/**

• @author 13

*/

@Controller

@RequestMapping(“/admin”)

public class NewBeeMallOrderController {

@Resource

private NewBeeMallOrderService newBeeMallOrderService;

@GetMapping(“/orders”)

public String ordersPage(HttpServletRequest request) {

request.setAttribute(“path”, “orders”);

return “admin/newbee_mall_order”;

}

/**

• 列表

*/

@RequestMapping(value = “/orders/list”, method = RequestMethod.GET)

@ResponseBody

public Result list(@RequestParam Map params) {

if (StringUtils.isEmpty(params.get(“page”)) || StringUtils.isEmpty(params.get(“limit”))) {

return ResultGenerator.genFailResult(“参数异常！”);

}

PageQueryUtil pageUtil = new PageQueryUtil(params);

return ResultGenerator.genSuccessResult(newBeeMallOrderService.getNewBeeMallOrdersPage(pageUtil));

}

/**

• 修改

*/

@RequestMapping(value = “/orders/update”, method = RequestMethod.POST)

@ResponseBody

public Result update(@RequestBody NewBeeMallOrder newBeeMallOrder) {

if (Objects.isNull(newBeeMallOrder.getTotalPrice())

|| Objects.isNull(newBeeMallOrder.getOrderId())

|| newBeeMallOrder.getOrderId() < 1

|| newBeeMallOrder.getTotalPrice() < 1

|| StringUtils.isEmpty(newBeeMallOrder.getUserAddress())) {

return ResultGenerator.genFailResult(“参数异常！”);

}

String result = newBeeMallOrderService.updateOrderInfo(newBeeMallOrder);

if (ServiceResultEnum.SUCCESS.getResult().equals(result)) {

return ResultGenerator.genSuccessResult();

} else {

return ResultGenerator.genFailResult(result);

}

}

/**

• 详情

*/

@GetMapping(“/order-items/{id}”)

@ResponseBody

public Result info(@PathVariable(“id”) Long id) {

List orderItems = newBeeMallOrderService.getOrderItems(id);

if (!CollectionUtils.isEmpty(orderItems)) {

return ResultGenerator.genSuccessResult(orderItems);

}

return ResultGenerator.genFailResult(ServiceResultEnum.DATA_NOT_EXIST.getResult());

}

/**

• 配货

*/

@RequestMapping(value = “/orders/checkDone”, method = RequestMethod.POST)

@ResponseBody

public Result checkDon 《一线大厂Java面试题解析+后端开发学习笔记+最新架构讲解视频+实战项目源码讲义》无偿开源 威信搜索公众号【编程进阶路】 e(@RequestBody Long[] ids) {

if (ids.length < 1) {

return ResultGenerator.genFailResult(“参数异常！”);

}

String result = newBeeMallOrderService.checkDone(ids);

if (ServiceResultEnum.SUCCESS.getResult().equals(result)) {

return ResultGenerator.genSuccessResult();

} else {

return ResultGenerator.genFailResult(result);

}

}

/**

• 出库

*/

@RequestMapping(value = “/orders/checkOut”, method = RequestMethod.POST)

@ResponseBody

public Result checkOut(@RequestBody Long[] ids) {

if (ids.length < 1) {

return ResultGenerator.genFailResult(“参数异常！”);

}

String result = newBeeMallOrderService.checkOut(ids);

if (ServiceResultEnum.SUCCESS.getResult().equals(result)) {

return ResultGenerator.genSuccessResult();

} else {

return ResultGenerator.genFailResult(result);

}

}

/**

• 关闭订单

*/

@RequestMapping(value = “/orders/close”, method = RequestMethod.POST)

@ResponseBody

public Result closeOrder(@RequestBody Long[] ids) {

if (ids.length < 1) {

return ResultGenerator.genFailResult(“参数异常！”);

}

String result = newBeeMallOrderService.closeOrder(ids);

if (ServiceResultEnum.SUCCESS.getResult().equals(result)) {

return ResultGenerator.genSuccessResult();

} else {

return ResultGenerator.genFailResult(result);

}

}

}

后台商品信息的维护 商品订单的处理和流程控制 修改密码： 数据库主要表设计： 用户表：

CREATE TABLE NewTable (

user_id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘用户主键id’ ,

nick_name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘用户昵称’ ,

login_name varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘登陆名称(默认为手机号)’ ,

password_md5 varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘MD5加密后的密码’ ,

introduce_sign varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘个性签名’ ,

address varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘收货地址’ ,

is_deleted tinyint(4) NOT NULL DEFAULT 0 COMMENT ‘注销标识字段(0-正常 1-已注销)’ ,

locked_flag tinyint(4) NOT NULL DEFAULT 0 COMMENT ‘锁定标识字段(0-未锁定 1-已锁定)’ ,

create_time datetime NULL DEFAULT NULL COMMENT ‘注册时间’ ,

PRIMARY KEY (user_id)

)

商品信息表：

CREATE TABLE NewTable (

goods_id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘商品表主键id’ ,

goods_name varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商品名’ ,

goods_intro varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商品简介’ ,

goods_category_id bigint(20) NOT NULL DEFAULT 0 COMMENT ‘关联分类id’ ,

goods_cover_img varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘/admin/dist/img/no-img.png’ COMMENT ‘商品主图’ ,

goods_carousel varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘/admin/dist/img/no-img.png’ COMMENT ‘商品轮播图’ ,

goods_detail_content text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘商品详情’ ,

original_price int(11) NOT NULL DEFAULT 1 COMMENT ‘商品价格’ ,

selling_price int(11) NOT NULL DEFAULT 1 COMMENT ‘商品实际售价’ ,

stock_num int(11) NOT NULL DEFAULT 0 COMMENT ‘商品库存数量’ ,

tag varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘商品标签’ ,

goods_sell_status tinyint(4) NOT NULL DEFAULT 0 COMMENT ‘商品上架状态 0-下架 1-上架’ ,

create_user int(11) NOT NULL DEFAULT 0 COMMENT ‘添加者主键id’ ,

create_time datetime NULL DEFAULT NULL COMMENT ‘商品添加时间’ ,

update_user int(11) NOT NULL DEFAULT 0 COMMENT ‘修改者主键id’ ,

update_time datetime NULL DEFAULT NULL COMMENT ‘商品修改时间’ ,

PRIMARY KEY (goods_id)

)

订单表设计：

CREATE TABLE NewTable (

order_id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘订单表主键id’ ,

order_no varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘订单号’ ,

user_id bigint(20) NOT NULL DEFAULT 0 COMMENT ‘用户主键id’ ,

total_price int(11) NOT NULL DEFAULT 1 COMMENT ‘订单总价’ ,

pay_status bigint(20) NOT NULL DEFAULT 0 COMMENT ‘支付状态:0.未支付,1.支付成功,-1:支付失败’ ,

pay_type bigint(20) NOT NULL DEFAULT 0 COMMENT ‘0.无 1.支付宝支付 2.微信支付’ ,

pay_time datetime NULL DEFAULT NULL COMMENT ‘支付时间’ ,

order_status bigint(20) NOT NULL DEFAULT 0 COMMENT ‘订单状态:0.待支付 1.已支付 2.配货完成 3:出库成功 4.交易成功 -1.手动关闭 -2.超时关闭 -3.商家关闭’ ,

extra_info varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘订单body’ ,

user_name varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘收货人姓名’ ,

user_phone varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘收货人手机号’ ,

user_address varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’ COMMENT ‘收货人收货地址’ ,

is_deleted tinyint(4) NOT NULL DEFAULT 0 COMMENT ‘删除标识字段(0-未删除 1-已删除)’ ,

create_time datetime NULL DEFAULT NULL COMMENT ‘创建时间’ ,

update_time datetime NULL DEFAULT NULL COMMENT ‘最新修改时间’ ,

PRIMARY KEY (order_id)