用SpringBoot+Mybatis做CRUD

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

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

首先我们的结构如下

| 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生成效果图完美落幕
在这里插入图片描述

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值