基于javaweb+mysql的springboot前后端分离网上商城项目设计和实现(java+ssm+springboot+vue+redis)
运行环境
Java≥8、MySQL≥5.7、Node.js≥10
开发工具
后端:eclipse/idea/myeclipse/sts等均可配置运行
前端:WebStorm/VSCode/HBuilderX等均可
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SpringBoot前后端分离网上商城项目设计和实现(java+ssm+springboot+vue+redis)
主要实现技术:Java、springmvc、springboot、mybatis、mysql、tomcat、shiro权限框架、vue、jquery、node.js 、redis数据库、邮箱相关等技术。
主要功能实现:
用户登录、注册、商城浏览、购买、订单、购物车、退货、用户、个人中心、修改密码、角色等管理
前端主页面:商品关键字搜索和分类搜索功能以及首页轮播图配置展示
首页个人中心主要功能:密码修改、订单、购物车、商品详情模块、可以购买、加入购物车
购买时需要填写用户手机号和收获地址等信息、注册时默认生成支付宝模拟账号密码:
后台管理员主要对商品数据进行管理、分类管理、订单管理以及用户管理扥。
商品列表数据管理、后台添加商品信息、商品基础数据的维护管理、商品订单详情管理:根据关键字查询以及查看每一个订单的详情信息
首页轮播图配置展示、用户角色和权限管理控制:
前后端源码结构:
数据库图:
this.returnGoodsService = returnGoodsService;
this.logisticsService = logisticsService;
this.orderService = orderService;
this.productService = productService;
}
/*退货原因*/
@RequestMapping(value = "/returnReason/findReasonById")
private CommonResult findReasonById(Integer reasonId) {
ReturnReason returnReason = returnReasonService.selectById(reasonId);
if(returnReason!=null){
return CommonResult.success("退货原因查询成功",returnReason);
}else{
return CommonResult.error("退货原因查询失败");
}
}
/*查询全部退货原因*/
@RequestMapping(value = "/returnReason/findAllReason")
private CommonResult findAllReason() {
List<ReturnReason> returnReasons = returnReasonService.selectAll();
if(returnReasons!=null){
return CommonResult.success("退货原因查询成功",returnReasons);
}else{
return CommonResult.error("退货原因查询失败");
}
}
/*查询全部退货原因名称*/
@RequestMapping(value = "/returnReason/findReasonName")
private CommonResult findReasonName() {
List<String> names = returnReasonService.selectAllName();
if(names!=null){
return CommonResult.success("退货原因查询成功",names);
}else{
return CommonResult.error("退货原因查询失败");
}
}
/*查询退货原因是否存在*/
@RequestMapping(value = "/returnReason/existReasonName")
private CommonResult existReasonName(Integer reasonId,String reasonName) {
Boolean isExist = returnReasonService.existsWithReasonName(reasonId,reasonName);
if(isExist!=null){
return CommonResult.success("查询成功",isExist);
}else{
return CommonResult.error("查询失败");
}
}
@RequestMapping(value = "/returnReason/addReason")
private CommonResult addReason(ReturnReason returnReason) {
if(returnReason!=null){
if(returnReasonService.insertData(returnReason)){
response.sendRedirect("http://"+hostAddress+"/?#/myOrder");
}
}catch (IOException e) {
e.printStackTrace();
}
}
@ResponseBody
@PostMapping(value = "/payNotify")
public void payNotify(@RequestParam Map<String, String> map) {
String tradeStatus = map.get("trade_status");
if(tradeStatus.equals("TRADE_SUCCESS")){
String payTime = map.get("gmt_payment");
String tradeNo =map.get("out_trade_no");
String tradeName = map.get("subject");
String payAmount = map.get("buyer_pay_amount");
log.info("[支付成功] {交易时间:{},订单号:{},订单名称:{},交易金额:{}}",payTime,tradeNo,tradeName,payAmount);
}
}
}
/**
public CommonResult checkCode(String key, String code) {
String codeK = redisTemplate.opsForValue().get(key);
if (codeK == null) {
return CommonResult.error("验证码不存在或已过期,请重新发送!");
}
if (codeK.equals(code)) {
redisTemplate.delete(key);
return CommonResult.success("验证码成功!", true);
} else {
return CommonResult.success("验证码错误!", false);
}
}
/**
* 用于绑定手机号操作,发送验证码
*
* @param phone 发送的手机号
*/
@RequestMapping(value = "/util/smsCode")
public CommonResult aliYunSmsCode(String phone) {
String code = redisTemplate.opsForValue().get(phone);
if (!StringUtils.isEmpty(code)) {
return CommonResult.error(phone + "的验证码还未过期!");
}
//生成验证码并存储到redis中
code = MyUtils.getCode(6);
boolean isSend = aliYunSmsService.sendSms(phone, code);
if (isSend) {
redisTemplate.opsForValue().set(phone, code, 10, TimeUnit.MINUTES);
return CommonResult.success("验证码已发送,网络有延迟请稍等~");
} else {
return CommonResult.error("验证码发送失败,请稍后重试~");
}
}
}
Product newProduct = new Product();
newProduct.setProductId(product.getProductId());
int newStock = productStock - payAmount;
newProduct.setProductStock(newStock);
newProduct.setIsStockOut(newStock<product.getLowestStock());
// 如果库存小于等于0,自动下架
newProduct.setIsSale(newStock>0);
if(productService.updateById(newProduct)){
if(orderService.insertData(order)){
orderInfo.add(order.getOrderNo());
productInfo.add(order.getProductNo());
}
}
}
}
if(orderInfo.size()!=0){
String orderNoInfo = StringUtils.join(orderInfo, ",");
String productNoInfo = StringUtils.join(productInfo, ",");
redisTemplate.opsForValue().set(orderNo,orderNoInfo,24, TimeUnit.HOURS);
return CommonResult.success("创建订单成功",productNoInfo);
}else{
return CommonResult.success("创建订单失败");
}
}else{
return CommonResult.error("订单数据不完整");
}
}
@RequestMapping(value = "/order/update")
private CommonResult updateOrder(Order order) {
if(orderService.updateById(order)){
return CommonResult.success("修改订单成功",order);
}else{
return CommonResult.error("修改订单失败");
}
}
@RequestMapping(value = "/order/delete")
private CommonResult deleteOrder(Integer orderId) {
if(orderService.deleteById(orderId)){
return CommonResult.success("删除订单成功","订单id:"+orderId);
}else{
return CommonResult.error("删除订单失败");
}
}
@RequestMapping(value = "/order/receipt")
private CommonResult updateOrder(Integer orderId) {
Order order = new Order();
order.setOrderId(orderId);
* @email qiudb.top@aliyun.com
* @description 商品评价 业务类
*/
@RestController
@CrossOrigin
public class ProductReviewController {
final ProductReviewService ProductReviewService;
final OrderService orderService;
public ProductReviewController(ProductReviewService ProductReviewService,OrderService orderService){
this.ProductReviewService = ProductReviewService;
this.orderService = orderService;
}
/*商品类别*/
@RequestMapping(value = "/productReview/add")
private CommonResult addProductReview(ProductReview productReview) {
if(ProductReviewService.insertData(productReview)){
Integer orderId = orderService.selectIdByKey(productReview.getOrderNo());
Order order = new Order();
order.setOrderId(orderId);
order.setOrderState("已评价");
orderService.updateById(order);
return CommonResult.success("商品评论添加成功",productReview);
}else{
return CommonResult.error("商品评论添加失败");
}
}
@RequestMapping(value = "/productReview/update")
private CommonResult updateProductReview(ProductReview productReview) {
if(ProductReviewService.updateById(productReview)){
return CommonResult.success("商品评论修改成功",productReview);
}else{
return CommonResult.error("商品评论修改失败");
}
}
@RequestMapping(value = "/productReview/deleteById")
}
@RequestMapping(value = "/productBrand/findAll")
private CommonResult findAllBrand() {
List<ProductBrand> productBrands = productBrandService.selectAll();
if(productBrands!=null){
return CommonResult.success("商品品牌查询成功",productBrands);
}else{
return CommonResult.error("商品品牌查询失败");
}
}
@RequestMapping(value = "/productBrand/existsBrandName")
private CommonResult existsBrandName(Integer brandId,String brandName) {
Boolean isExist = productBrandService.existsWithBrandName(brandId,brandName);
if(isExist!=null){
return CommonResult.success("查询成功",isExist);
}else{
return CommonResult.error("查询失败");
}
}
@RequestMapping(value = "/productBrand/findAllName")
private CommonResult findAllBrandName() {
List<String> names = productBrandService.selectAllName();
if(names!=null){
return CommonResult.success("商品品牌名称查询成功",names);
}else{
return CommonResult.error("商品品牌名称查询失败");
}
}
}
@ResponseBody
@RequestMapping(value = "/refund")
public CommonResult refund(@RequestParam("orderNo") String orderNo,
@RequestParam("payPrice") String payPrice) {
//发起支付
try {
alipayService.refund(orderNo,payPrice);
} catch (AlipayApiException e) {
log.info("【支付宝支付】退款失败 error={}", e.toString());
}
return CommonResult.success("退款成功");
}
@GetMapping(value = "/paySuccess")
@ResponseBody
public void success(@RequestParam Map<String, String> map,HttpServletResponse response) {
try{
String tradeNo =map.get("out_trade_no");
if(tradeNo.contains("Vip")){
Integer orderId = orderService.selectIdByKey(tradeNo);
Order order = new Order();
order.setOrderId(orderId);
order.setOrderState("开通成功");
String serialNumber = redisTemplate.opsForValue().get(tradeNo);
if(serialNumber !=null){
response.sendRedirect("http://"+hostAddress+"/?#/personalCenter?serialNumber="+serialNumber);
redisTemplate.delete(tradeNo);
}else{
response.sendRedirect("http://"+hostAddress+"/?#/personalCenter?serialNumber="+"ERROR");
}
orderService.updateById(order);
}else{
String Str = redisTemplate.opsForValue().get(tradeNo);
redisTemplate.delete(tradeNo);
assert Str != null;
String[] ordersNo = Str.split(",");
System.out.println(Arrays.toString(ordersNo));
for (String orderNo : ordersNo) {
Integer orderId = orderService.selectIdByKey(orderNo);
Order order = new Order();
order.setOrderId(orderId);
order.setOrderState("待发货");
orderService.updateById(order);
}
response.sendRedirect("http://"+hostAddress+"/?#/myOrder");
}
}catch (IOException e) {
e.printStackTrace();
}
}
@ResponseBody
return CommonResult.success("查询成功",isExist);
}else{
return CommonResult.error("查询失败");
}
}
@RequestMapping(value = "/returnReason/addReason")
private CommonResult addReason(ReturnReason returnReason) {
if(returnReason!=null){
if(returnReasonService.insertData(returnReason)){
return CommonResult.success("添加成功",returnReason);
}else{
return CommonResult.error("添加失败");
}
}
return CommonResult.error("退货原因数据不存在");
}
@RequestMapping(value = "/returnReason/updateReason")
private CommonResult updateReason(ReturnReason returnReason) {
if(returnReason!=null){
if(returnReasonService.updateById(returnReason)){
return CommonResult.success("更新成功",returnReason);
}else{
return CommonResult.error("更新失败");
}
}
return CommonResult.error("退货原因数据不存在");
}
@RequestMapping(value = "/returnReason/deleteReason")
private CommonResult updateReason(Integer reasonId) {
if(reasonId!=null){
if(returnReasonService.deleteById(reasonId)){
return CommonResult.success("删除成功",reasonId);
}else{
return CommonResult.error("删除失败");
}
}
return CommonResult.error("退货原因数据不存在");
}
public String sendmailFile(String sendTo, String content) {
try {
String filePath = "F:\\IDEA\\JAVA_Program\\Springboot-Mall\\src\\main\\resources\\static\\1.zip";
mailService.sendAttachmentsMail(sendTo, "文件操作", content, filePath);
return "发送成功!";
} catch (Exception e) {
e.printStackTrace();
return "发送邮件时发生异常,稍后请重新发送!";
}
}
/**
* 验证输入的验证码是否正确
*
* @param key 验证的依据
* @param code 验证码
*/
@RequestMapping(value = "/allow/checkCode")
public CommonResult checkCode(String key, String code) {
String codeK = redisTemplate.opsForValue().get(key);
if (codeK == null) {
return CommonResult.error("验证码不存在或已过期,请重新发送!");
}
if (codeK.equals(code)) {
redisTemplate.delete(key);
return CommonResult.success("验证码成功!", true);
} else {
return CommonResult.success("验证码错误!", false);
}
}
/**
* 用于绑定手机号操作,发送验证码
*
* @param phone 发送的手机号
*/
@RequestMapping(value = "/util/smsCode")
public CommonResult aliYunSmsCode(String phone) {
String code = redisTemplate.opsForValue().get(phone);
if (!StringUtils.isEmpty(code)) {
return CommonResult.error(phone + "的验证码还未过期!");
if(returnGoodsService.updateById(returnGoods)){
return CommonResult.success("更新成功",returnGoods);
}else{
return CommonResult.error("更新失败");
}
}else {
return CommonResult.error("更新失败");
}
}
return CommonResult.error("商品退货数据不存在");
}
/*同意买家退货*/
@RequestMapping(value = "/returnGoods/dealRefund")
private CommonResult dealRefund(Integer returnId,String operatorNumber,String operatorName) {
if(returnId!=null){
ReturnGoods returnGoods = returnGoodsService.selectById(returnId);
returnGoods.setReturnState("退款完成");
returnGoods.setDealTime(new Date());
returnGoods.setOperatorNumber(operatorNumber);
returnGoods.setOperatorName(operatorName);
String orderNo = returnGoods.getOrderNo();
Integer orderId = orderService.selectIdByKey(orderNo);
Order order = new Order();
order.setOrderId(orderId);
order.setReturnState(true);
order.setOrderState("已退款");
Logistics logistics = logisticsService.selectOrderNo(orderNo);
if(logistics!=null){
logisticsService.deleteById(logistics.getLogisticId());
}
if(orderService.updateById(order)){
if(returnGoodsService.updateById(returnGoods)){
return CommonResult.success("更新成功",returnGoods);
}else{
return CommonResult.error("更新失败");
}
}else{
return CommonResult.error("更新失败");
}
}
return CommonResult.error("商品退款数据不存在");
}
/*拒绝买家退款申请*/
}else{
return CommonResult.error("添加失败");
}
}
return CommonResult.error("退货原因数据不存在");
}
@RequestMapping(value = "/returnReason/updateReason")
private CommonResult updateReason(ReturnReason returnReason) {
if(returnReason!=null){
if(returnReasonService.updateById(returnReason)){
return CommonResult.success("更新成功",returnReason);
}else{
return CommonResult.error("更新失败");
}
}
return CommonResult.error("退货原因数据不存在");
}
@RequestMapping(value = "/returnReason/deleteReason")
private CommonResult updateReason(Integer reasonId) {
if(reasonId!=null){
if(returnReasonService.deleteById(reasonId)){
return CommonResult.success("删除成功",reasonId);
}else{
return CommonResult.error("删除失败");
}
}
return CommonResult.error("退货原因数据不存在");
}
/*查询商品退货信息*/
@RequestMapping(value = "/returnGoods/findReturnById")
private CommonResult findReturnById(Integer returnId) {
ReturnGoods returnGoods = returnGoodsService.selectById(returnId);
if(returnGoods!=null){
return CommonResult.success("退货商品查询成功",returnGoods);
}else{
return CommonResult.error("退货商品查询失败");
}
}
/*查询全部退货商品*/
@RequestMapping(value = "/returnGoods/findAllReturn")
private CommonResult findAllReturn() {
}else{
return CommonResult.error("商品品牌查询失败");
}
}
@RequestMapping(value = "/productBrand/existsBrandName")
private CommonResult existsBrandName(Integer brandId,String brandName) {
Boolean isExist = productBrandService.existsWithBrandName(brandId,brandName);
if(isExist!=null){
return CommonResult.success("查询成功",isExist);
}else{
return CommonResult.error("查询失败");
}
}
@RequestMapping(value = "/productBrand/findAllName")
private CommonResult findAllBrandName() {
List<String> names = productBrandService.selectAllName();
if(names!=null){
return CommonResult.success("商品品牌名称查询成功",names);
}else{
return CommonResult.error("商品品牌名称查询失败");
}
}
}
/**
Logistics logistics = logisticsService.selectOrderNo(orderNo);
if(order!=null){
resultList.add(order);
}
if(logistics!=null){
resultList.add(logistics);
}
if(resultList.size()!=0){
return CommonResult.success("订单详情查询成功",resultList);
}else{
return CommonResult.error("订单详情查询失败");
}
}
}
/**
* @email qiudb.top@aliyun.com
* @description 供应商和采购 业务控制层
*/
@RestController
@CrossOrigin
public class PurchaseController {
final SupplierService supplierService;
final PurchaseService purchaseService;
final ProductService productService;
public PurchaseController(ProductService productService,SupplierService supplierService,PurchaseService purchaseService){
this.supplierService = supplierService;
this.purchaseService = purchaseService;
this.productService = productService;
}
newProduct.setIsSale(newStock>0);
if(productService.updateById(newProduct)){
if(orderService.insertData(order)){
redisTemplate.opsForValue().set(order.getOrderNo(),order.getOrderNo(),24, TimeUnit.HOURS);
return CommonResult.success("创建订单成功",order);
}else{
return CommonResult.error("创建订单失败");
}
}else{
return CommonResult.error("创建订单失败");
}
}else{
return CommonResult.error("商品库存不足");
}
}
}else{
return CommonResult.error("订单数据不完整");
}
}
@RequestMapping(value = "/order/cartOrder")
private CommonResult cartOrder(String orderNo,String ordersInfo) {
JSONArray jsonArray = JSON.parseArray(ordersInfo);
List<Order> orders = JSONObject.parseArray(jsonArray.toJSONString(), Order.class);
if(orders!=null){
ArrayList<String> orderInfo = new ArrayList<>();
ArrayList<String> productInfo = new ArrayList<>();
for (Order order : orders) {
Product product = productService.selectByKey(order.getProductNo());
Integer productStock = product.getProductStock();
Integer payAmount = order.getPayAmount();
boolean isOk =productStock >= payAmount;
if(isOk){
Product newProduct = new Product();
newProduct.setProductId(product.getProductId());
int newStock = productStock - payAmount;
newProduct.setProductStock(newStock);
newProduct.setIsStockOut(newStock<product.getLowestStock());
// 如果库存小于等于0,自动下架
newProduct.setIsSale(newStock>0);
if(productService.updateById(newProduct)){
if(orderService.insertData(order)){
orderInfo.add(order.getOrderNo());
productInfo.add(order.getProductNo());
}
}
/*同意买家退货*/
@RequestMapping(value = "/returnGoods/dealRefund")
private CommonResult dealRefund(Integer returnId,String operatorNumber,String operatorName) {
if(returnId!=null){
ReturnGoods returnGoods = returnGoodsService.selectById(returnId);
returnGoods.setReturnState("退款完成");
returnGoods.setDealTime(new Date());
returnGoods.setOperatorNumber(operatorNumber);
returnGoods.setOperatorName(operatorName);
String orderNo = returnGoods.getOrderNo();
Integer orderId = orderService.selectIdByKey(orderNo);
Order order = new Order();
order.setOrderId(orderId);
order.setReturnState(true);
order.setOrderState("已退款");
Logistics logistics = logisticsService.selectOrderNo(orderNo);
if(logistics!=null){
logisticsService.deleteById(logistics.getLogisticId());
}
if(orderService.updateById(order)){
if(returnGoodsService.updateById(returnGoods)){
return CommonResult.success("更新成功",returnGoods);
}else{
return CommonResult.error("更新失败");
}
}else{
return CommonResult.error("更新失败");
}
}
return CommonResult.error("商品退款数据不存在");
}
/*拒绝买家退款申请*/
@RequestMapping(value = "/returnGoods/rejectRefund")
private CommonResult rejectRefund(Integer returnId,String operatorNumber,String operatorName) {
if(returnId!=null){
ReturnGoods returnGoods = returnGoodsService.selectById(returnId);
returnGoods.setReturnState("拒绝退款");
returnGoods.setDealTime(new Date());
returnGoods.setOperatorNumber(operatorNumber);
returnGoods.setOperatorName(operatorName);
String orderNo = returnGoods.getOrderNo();
Integer orderId = orderService.selectIdByKey(orderNo);
Order order = new Order();
order.setOrderId(orderId);
order.setOrderState("待发货");
if(orderService.updateById(order)){
if(returnGoodsService.updateById(returnGoods)){
return CommonResult.success("更新成功",returnGoods);
@RequestMapping(value = "/productType/findAll")
private CommonResult findAllType() {
List<ProductType> productTypes = productTypeService.selectAll();
if(productTypes!=null){
return CommonResult.success("商品分类查询成功",productTypes);
}else{
return CommonResult.error("商品分类查询失败");
}
}
@RequestMapping(value = "/productType/findAllName")
private CommonResult findAllTypeName() {
List<String> names = productTypeService.selectAllName();
if(names!=null){
return CommonResult.success("商品分类名称查询成功",names);
}else{
return CommonResult.error("商品分类名称查询失败");
}
}
/*商品品牌*/
@RequestMapping(value = "/productBrand/add")
private CommonResult addBrand(ProductBrand productBrand) {
if(productBrandService.insertData(productBrand)){
return CommonResult.success("商品品牌添加成功",productBrand);
}else{
return CommonResult.error("商品品牌添加失败");
}
}
@RequestMapping(value = "/productBrand/update")
private CommonResult updateBrand(ProductBrand productBrand) {
if(productBrandService.updateById(productBrand)){
return CommonResult.success("商品品牌修改成功",productBrand);
}else{
return CommonResult.error("商品品牌修改失败");
}
}
@RequestMapping(value = "/productBrand/deleteById")
private CommonResult deleteBrandById(Integer brandId) {
if(productBrandService.deleteById(brandId)){
return CommonResult.success("商品品牌删除成功","brandId: "+brandId);
}
}
info.put("role", rs);
info.put("roleInfo", rsInfo);
return CommonResult.success("登录成功", info);
}catch (LockedAccountException e){
return CommonResult.error("您的帐号存在异常行为,已被封停(请联系工作人员)");
} catch (IncorrectCredentialsException e) {
return CommonResult.error("密码错误,请重新输入");
} catch (AuthenticationException e) {
return CommonResult.error("该用户不存在");
}
}
/**
* 退出登录操作
* @param key 用户登录的帐号
* @param session 前端存储的session(token)
*/
@RequestMapping(value = "/logout")
private CommonResult logout(String key,String session) {
if(key!=null){
try{
User user = userService.selectByKey(key);
Subject subject = SecurityUtils.getSubject();
//清除用户缓存
RealmSecurityManager securityManager = (RealmSecurityManager) SecurityUtils.getSecurityManager();
UserRealm userRealm = (UserRealm) securityManager.getRealms().iterator().next();
//清空redis中的缓存信息
userRealm.clearRedis(user,session);
userRealm.clearCache(SecurityUtils.getSubject().getPrincipals());
//退出登录
subject.logout();
return CommonResult.success("退出成功");
}catch(Exception e){
logger.error(e.getMessage());
}
}
return CommonResult.error("退出失败,未找到用户帐号");
}
//权限不够时,将转到此请求上来
@RequestMapping("/notRole")
private CommonResult notRole(){
return new CommonResult(403,"暂无权限!");
}
/*判断key是否存在 目前用于判断邮箱是否被注册过*/
@RequestMapping(value = "/allow/existUser")
private CommonResult existUser(String accountNumber) {
Boolean isExist = userService.existsWithPrimaryKey(accountNumber);
}
@ResponseBody
@PostMapping(value = "/vip", produces = "text/html;charset=utf-8")
public String create(@RequestParam("orderNo") String orderNo,
@RequestParam("orderName") String orderName,
@RequestParam("payPrice") String payPrice,
@RequestParam("serialNumber") String serialNumber) {
//开通vip的序列号暂时存入redis中
redisTemplate.opsForValue().set(orderNo,serialNumber,2, TimeUnit.HOURS);
//发起支付
return alipayService.create(orderNo, orderName, payPrice);
}
/*
https://qiustudy.utools.club/alipay/refund?orderNo=10060&payPrice=4000
*/
@ResponseBody
@RequestMapping(value = "/refund")
public CommonResult refund(@RequestParam("orderNo") String orderNo,
@RequestParam("payPrice") String payPrice) {
//发起支付
try {
alipayService.refund(orderNo,payPrice);
} catch (AlipayApiException e) {
log.info("【支付宝支付】退款失败 error={}", e.toString());
}
return CommonResult.success("退款成功");
}
@GetMapping(value = "/paySuccess")
@ResponseBody
public void success(@RequestParam Map<String, String> map,HttpServletResponse response) {
try{
String tradeNo =map.get("out_trade_no");
if(tradeNo.contains("Vip")){
Integer orderId = orderService.selectIdByKey(tradeNo);