首先我们的结构如下
| dao | |
|entity |–|
| model | |
| service | |
| util | |
| web |
2. 第一个接收实体类请求为 request 响应为response
实现伙伴类型添加或編輯對象查询实体字段请求(PartnerTypeAddQueryRequest)
package com.humi.partner.manager.model.partnerType;
import com.humi.cloud.common.annotation.OBSFile;
import com.humi.cloud.mybatis.support.model.Entity;
import com.humi.partner.common.entity.PartnerType;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
/**
* @Auther: lishijie
* @Date: 2019/10/11 10:59
* @Description:Codes are far away from bugs with the animal protecting
*/
@Data
@NoArgsConstructor
@AllArgsConstructor
@ApiModel("伙伴类型添加或編輯對象")
public class PartnerTypeAddQueryRequest extends Entity<PartnerType> {
@ApiModelProperty(notes = "伙伴类型")
private String partnerName;
@ApiModelProperty(notes = "描述")
private String partnerDescribe;
@ApiModelProperty(notes = "加入条件")
private String joinCondition;
@OBSFile
@ApiModelProperty(notes = "icon")
private String partnerIcon;
}
实现伙伴类型添加或編輯對象查询实体字段响应(PartnerTypeAddQueryResponse)
package com.humi.partner.manager.model.partnerType;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.humi.cloud.common.annotation.OBSFile;
import com.humi.cloud.mybatis.support.model.Entity;
import com.humi.partner.common.entity.PartnerType;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
/**
* @Auther: lishijie
* @Date: 2019/10/11 10:59
* @Description:Codes are far away from bugs with the animal protecting
*/
@Data
@NoArgsConstructor
@AllArgsConstructor
@ApiModel("伙伴类型添加或編輯對象")
public class PartnerTypeAddQueryResponse extends Entity<PartnerType> {
@ApiModelProperty(notes = "伙伴类型")
private String partnerName;
@ApiModelProperty(notes = "描述")
private String partnerDescribe;
@ApiModelProperty(notes = "加入条件")
private String joinCondition;
@OBSFile
@ApiModelProperty(notes = "icon")
private String partnerIcon;
}
实现伙伴类型分页请求实体字段请求(PartnerTypeListQueryRequest)
package com.humi.partner.manager.model.partnerType;
import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.humi.cloud.common.utils.DateUtil;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
/**
* @Auther: lishijie
* @Date: 2019/10/11 10:59
* @Description:Codes are far away from bugs with the animal protecting
*/
@Data
@NoArgsConstructor
@AllArgsConstructor
@ApiModel("伙伴类型分页请求")
public class PartnerTypeListQueryRequest {
@ApiModelProperty(value = "分页时每页的条数,默认为10条,导出功能时不可天填")
Integer size= 10;
@ApiModelProperty(value = "当前页,导出功能时不可填")
Integer current= 1;
}
实现伙伴类型列表返回对象实体字段响应(PartnerTypeListQueryResponse)
package com.humi.partner.manager.model.partnerType;
import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.humi.cloud.common.utils.DateUtil;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
/**
* @Auther: lishijie
* @Date: 2019/10/11 10:59
* @Description:Codes are far away from bugs with the animal protecting
*/
@Data
@NoArgsConstructor
@AllArgsConstructor
@ApiModel("伙伴类型列表返回对象")
public class PartnerTypeListQueryResponse {
private Long id;
/** 伙伴类型 */
private String partnerName;
/** 描述 */
private String partnerDescribe;
/** 最后修改人:新增和修改时插入,默认sys. */
protected String updateBy;
/** 最后修改时间, 每次修改记录时变更, 默认:sysdate. */
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
protected Date updateTime;
/** 是否启用:0停用;1启用 */
private Integer useFlag;
}
3. 在service里写具体CRUD业务
所有CRUD具体业务实现都在一起(ManagerPartnerTypeService)
package com.humi.partner.manager.service;
import java.awt.Label;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.esotericsoftware.minlog.Log;
import com.humi.cloud.common.model.ResponseCode;
import com.humi.cloud.common.model.Result;
import com.humi.cloud.common.utils.BeanUtil;
import com.humi.cloud.mybatis.support.model.Page;
import com.humi.cloud.security.support.utils.SecurityUtil;
import com.humi.partner.common.entity.PartnerType;
import com.humi.partner.common.service.PartnerTypeService;
import com.humi.partner.manager.dao.ManagerPartnerTypeMapper;
import com.humi.partner.manager.model.partnerType.PartnerTypeAddQueryRequest;
import com.humi.partner.manager.model.partnerType.PartnerTypeAddQueryResponse;
import com.humi.partner.manager.model.partnerType.PartnerTypeListQueryRequest;
import com.humi.partner.manager.model.partnerType.PartnerTypeListQueryResponse;
import org.apache.commons.lang.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import java.util.List;
/**
* @Auther: lishijie
* @Date: 2019/10/11 14:12
* @Description:Codes are far away from bugs with the animal protecting
*/
@Service
public class ManagerPartnerTypeService extends ServiceImpl<ManagerPartnerTypeMapper,PartnerType>{
@Autowired
ManagerPartnerTypeMapper managerPartnerTypeMapper;
@Autowired
PartnerTypeService partnerTypeService;
private String partner;
/**
* 分页查询伙伴类型信息
* @param request
* @return
*/
public Result getPertnerType(PartnerTypeListQueryRequest request){
Result result = new Result();
Page< PartnerTypeListQueryResponse,PartnerTypeListQueryRequest> page = new Page<>(request.getCurrent(),request.getSize(),request);
List<PartnerTypeListQueryResponse> partnerTypeList = managerPartnerTypeMapper.getPartnerTypePages(page);
result.setData(partnerTypeList);
return result;
}
/**
* 伙伴类型添加或修改信息
* @return
*/
@Transactional
public Result getPertnerTypeAdd(PartnerTypeAddQueryRequest request){
String id = request.getId();
PartnerType partnerType = null;
if (StringUtils.isBlank(id)){//无ID 说明为新增
partnerType = new PartnerType();
}else { //有ID 说明为修改
partnerType = this.getOne(new LambdaQueryWrapper<PartnerType>().eq(PartnerType::getId, request.getId()));
}
//获取伙伴类型实体类
//PartnerType partnerType = this.getById(partnerType);方法二
if(partnerType != null) {
BeanUtil.copyProperties(request,partnerType);
}
//执行添加或修改操作
boolean saveOrUpdated =false;
saveOrUpdated = partnerTypeService.saveOrUpdate(partnerType);
if(!saveOrUpdated){
return Result.fail("修改伙伴类型失败");
}
return Result.ok();
}
/**
* <pre>
* 获取伙伴类型管理详情
* </pre>
* @param id
* @return
*/
public Result getPartnerTypeOrderDetail(String id) {
PartnerTypeAddQueryResponse data = this.baseMapper.getPartnerTypeOrderDetail(id);
if(data == null) {
return Result.argumentFail("伙伴信息不存在");
}
return Result.ok(data);
}
/**
* 删除伙伴类型
* @param id
* @return
*/
public Result delPartnerTypeById(String id){
Result result = new Result();
PartnerType partnerType = this.getById(id);
List<PartnerType> partnerTypeList=this.baseMapper.getPartnerName(partnerType.getPartnerName());
if(partnerTypeList.size()>=2){
result.build(ResponseCode.FAILED,"该类型下已有伙伴加入,不能直接删除,只能关闭启用");
}
if(StringUtils.isBlank(id)){
result.build(ResponseCode.FAILED,"参数不能为空");
}
if(partnerType.getId()!=null ){
result.build(ResponseCode.FAILED,"id不能为空");
}
this.removeById(partnerType);
result.setMessage("删除成功");
return result;
}
}
4. 在DAO层里操作数据库具体功能接口
数据库接口(ManagerPartnerTypeMapper)
package com.humi.partner.manager.dao;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.humi.cloud.mybatis.support.model.Page;
import com.humi.partner.common.entity.PartnerType;
import com.humi.partner.manager.model.partnerType.PartnerTypeAddQueryRequest;
import com.humi.partner.manager.model.partnerType.PartnerTypeAddQueryResponse;
import com.humi.partner.manager.model.partnerType.PartnerTypeListQueryRequest;
import com.humi.partner.manager.model.partnerType.PartnerTypeListQueryResponse;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Repository;
import java.util.List;
/**
* @author AAD
* 伙伴类型操作
*/
@Repository
public interface ManagerPartnerTypeMapper extends BaseMapper<PartnerType>{
/**
* 分页查询订单
* @param page
* @return
*/
List<PartnerTypeListQueryResponse> getPartnerTypePages(Page< PartnerTypeListQueryResponse, PartnerTypeListQueryRequest> page);
/**
* 获取伙伴类型管理详情
* @param id
* @return
*/
PartnerTypeAddQueryResponse getPartnerTypeOrderDetail(@Param("id")String id);
/**
* 通过id查询伙伴类型名称
* @param partnerName
* @return
*/
List<PartnerType> getPartnerName(String partnerName);
}
XML配置项(ManagerPartnerTypeMapper)、
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.humi.partner.manager.dao.ManagerPartnerTypeMapper">
<!-- <resultMap id="BrandMap" type="com.humi.partner.manager.model.partnerType.PartnerTypeListQueryResponse">
<id column="id" property="id" />
<result column="partner_name" property="partnerName" />
<result column="partner_describe" property="partnerDescribe" />
<result column="update_by" property="updateBy" />
<result column="update_time" property="updateTime" />
<result column="use_flag" property="useFlag" />
</resultMap>-->
<!--分页查询-伙伴类型-->
<select id="getPartnerTypePages" resultType="com.humi.partner.manager.model.partnerType.PartnerTypeListQueryResponse">
SELECT
pt.partner_name,
pt.partner_describe,
pt.update_by,
pt.update_time,
pt.use_flag
FROM
partner_type pt
</select>
<!--获取伙伴类型管理详情-->
<select id="getPartnerTypeOrderDetail"
resultType="com.humi.partner.manager.model.partnerType.PartnerTypeAddQueryResponse">
SELECT
pt.partner_name,
pt.partner_describe,
pt.join_condition,
pt.partner_icon
FROM
partner_type pt
WHERE pt.id=#{id} and pt.valid=1
</select>
<select id="getPartnerName" resultType="com.humi.partner.common.entity.PartnerType">
SELECT
pt.partner_name,
pt.partner_describe,
pt.join_condition,
pt.partner_icon
FROM
partner_type pt
WHERE pt.partner_name=#{partner_name}
</select>
</mapper>
5. 在Controller层里写接口连接
实现接口在用swagger来测试(ManagerPartnerTypeController)
package com.humi.partner.manager.web;
import java.net.Authenticator;
import java.awt.PageAttributes.MediaType;
import java.util.Collection;
import java.util.List;
import java.util.concurrent.Callable;
import com.humi.cloud.common.model.Result;
import com.humi.partner.manager.model.partnerType.PartnerTypeAddQueryRequest;
import com.humi.partner.manager.model.partnerType.PartnerTypeAddQueryResponse;
import com.humi.partner.manager.model.partnerType.PartnerTypeListQueryRequest;
import com.humi.partner.manager.service.ManagerPartnerTypeService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.MediaTypeEditor;
import org.springframework.validation.BindingResult;
import org.springframework.web.bind.annotation.*;
import javax.validation.Valid;
import static org.springframework.http.MediaType.APPLICATION_JSON_UTF8_VALUE;
/**
* @Auther: lishijie
* @Date: 2019/10/11 13:55
* @Description:Codes are far away from bugs with the animal protecting
*/
@RestController
@RequestMapping(value = "/partner_type")
@Api(produces = APPLICATION_JSON_UTF8_VALUE, tags = "中台-伙伴类型基础数据")
public class ManagerPartnerTypeController {
@Autowired
ManagerPartnerTypeService managerPartnerTypeService;
@PostMapping("/lib/page")
@ApiOperation(value = "分页查询伙伴类型列表",notes ="伙伴类型",response = PartnerTypeListQueryRequest.class)
public Callable<Result> getPartnerTypeLibPage(@Valid @ApiParam @RequestBody PartnerTypeListQueryRequest request, BindingResult error){
return () -> error.hasErrors() ? Result.argumentFail(error.getFieldError().getDefaultMessage()) : this.managerPartnerTypeService.getPertnerType(request);
}
@PostMapping("/getPertnerTypeAdd")
@ApiOperation(value = "添加或修改伙伴类型",notes ="有id就进行修改,判断没id就进行添加伙伴类型",response = PartnerTypeAddQueryRequest.class)
public Callable<Result> getPertnerTypeAdd(@Valid @ApiParam @RequestBody PartnerTypeAddQueryRequest request, BindingResult error){
return () -> error.hasErrors() ? Result.argumentFail(error.getFieldError().getDefaultMessage()) : this.managerPartnerTypeService.getPertnerTypeAdd(request);
}
@GetMapping("/detail/{id}")
@ApiOperation(value = "获取伙伴类型管理详情", response = PartnerTypeAddQueryResponse.class)
public Callable<Result> getPartnerTypeOrderDetail(@PathVariable(name = "id",required =true) String id) {
return () -> this.managerPartnerTypeService.getPartnerTypeOrderDetail(id);
}
@GetMapping("/lib/del")
@ApiOperation(value = "通过id删除伙伴类型", notes = "成功则返回提示语,不成功则返回失败信息")
public Callable<Result> delPartnerTypeById(@Valid @ApiParam("伙伴类型ID") @RequestParam("id") String id) {
return () -> managerPartnerTypeService.delPartnerTypeById(id);
}
}
来一张swagger生成效果图完美落幕

本文档详细介绍了如何使用SpringBoot和Mybatis进行CRUD操作,包括实体类请求与响应、Service层业务处理、DAO层数据库接口及XML配置、Controller层接口连接,最后展示了使用Swagger进行接口测试的效果。
302

被折叠的 条评论
为什么被折叠?



