SpringBoot整合Mybatis

项目结构

po

m.xml

<dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.2</version>
        </dependency>

        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

 application.properties

# 应用名称
spring.application.name=Spring1219
# 应用服务 WEB 访问端口
server.port=8080
# 数据库驱动：
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
# 数据源名称
spring.datasource.name=defaultDataSource
# 数据库连接地址
spring.datasource.url=jdbc:mysql://localhost:3306/goods?serverTimezone=UTC
# 数据库用户名&密码：
spring.datasource.username=root
spring.datasource.password=root
#下面这些内容是为了让MyBatis映射
#指定Mybatis的Mapper文件
mybatis.mapper-locations=classpath:mapper/*.xml
#指定Mybatis的实体目录
mybatis.type-aliases-package=com.han.pojo

 实体类

package com.han.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

/**
*
*@author han
*@version 1.0
@since 2022-12-19  21:27
*/
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Goods {
    private Integer id;

    private String goodsName;

    private Integer goodsPrice;

    private Integer goodsNum;

    private Integer goodsType;

    private String remark;
}

service

package com.han.service;

import com.han.pojo.Goods;

import java.util.List;

/**
*
*@author han
*@version 1.0
@since 2022-12-19  21:27
*/
public interface GoodsService{

        int delete(Integer id);

        int insert(Goods goods);

        List<Goods> select();

        int update(Goods goods);

}

serviceImpl

package com.han.service.impl;

import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import com.han.pojo.Goods;
import com.han.mapper.GoodsMapper;
import com.han.service.GoodsService;

import java.util.List;

/**
*
*@author han
*@version 1.0
@since 2022-12-19  21:27
*/
@Service
public class GoodsServiceImpl implements GoodsService{

    @Resource
    private GoodsMapper goodsMapper;

    @Override
    public int delete(Integer id) {
        return goodsMapper.delete(id);
    }

    @Override
    public int insert(Goods record) {
        return goodsMapper.insert(record);
    }

    @Override
    public List<Goods> select() {
        return goodsMapper.select();
    }

    @Override
    public int update(Goods record) {
        return goodsMapper.update(record);
    }

}

工具类

复制粘贴即可使用

R.java

package com.han.utils;



import lombok.Data;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * 统一返回数据 json 格式 前后端 分离 json
 **/
@Data
public class R {

    //状态值
    private Boolean success;

    //状态吗
    private Integer code;

    //数据
    private String message;

    private Map<String, Object> data = new HashMap<String, Object>();

    private R(){}

    public static R ok(){
        R r = new R();
        r.setSuccess(ResultCodeEnum.SUCCESS.getSuccess());
        r.setCode(ResultCodeEnum.SUCCESS.getCode());
        r.setMessage(ResultCodeEnum.SUCCESS.getMessage());
        return r;
    }

    public static R error(){
        R r = new R();
        r.setSuccess(ResultCodeEnum.UNKNOWN_REASON.getSuccess());
        r.setCode(ResultCodeEnum.UNKNOWN_REASON.getCode());
        r.setMessage(ResultCodeEnum.UNKNOWN_REASON.getMessage());
        return r;
    }

    public static R setResult(ResultCodeEnum resultCodeEnum){
        R r = new R();
        r.setSuccess(resultCodeEnum.getSuccess());
        r.setCode(resultCodeEnum.getCode());
        r.setMessage(resultCodeEnum.getMessage());
        return r;
    }

    public R success(Boolean success){
        this.setSuccess(success);
        return this;
    }

    public R message(String message){
        this.setMessage(message);
        return this;
    }

    public R code(Integer code){
        this.setCode(code);
        return this;
    }

    public R data(String key, Object value){
        this.data.put(key, value);
        return this;
    }

    public R data(Map<String, Object> map){
        this.setData(map);
        return this;
    }

}

ResultCodeEnum.java

package com.han.utils;

import lombok.Getter;

@Getter
public enum ResultCodeEnum {

    SUCCESS(true, 20000,"成功"),
    UNKNOWN_REASON(false, 20001, "未知错误"),
    BAD_SQL_GRAMMAR(false, 21001, "sql语法错误"),
    JSON_PARSE_ERROR(false, 21002, "json解析异常"),
    PARAM_ERROR(false, 21003, "参数不正确"),
    FILE_UPLOAD_ERROR(false, 21004, "文件上传错误"),
    EXCEL_DATA_IMPORT_ERROR(false, 21005, "Excel数据导入错误"),
    USERLOGIN_INVALID_ERROR(false, 21007,"登录信息过期，请重新登录"),
    USERUNLOGIN_ERROR(false, 21008,"用户未登录，请重新登录");

    private Boolean success;

    private Integer code;

    private String message;

    private ResultCodeEnum(Boolean success, Integer code, String message) {
        this.success = success;
        this.code = code;
        this.message = message;
    }
}

Controller

package com.han.controller;

import com.han.pojo.Goods;
import com.han.service.GoodsService;
import com.han.utils.R;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

/**
 * @author han
 * @version 1.0
 * @since 2022-12-19  21:41
 */
@RestController
public class GoodsController {

    @Autowired
    private GoodsService service;

    @RequestMapping("get")
    public R get(){
        List<Goods> list = service.select();
        return R.ok().data("get",list);
    }

    @RequestMapping("add")
    public R add(Goods goods){
        int i = service.insert(goods);
        return R.ok().data("add",i);
    }

    @RequestMapping("upd")
    public R upd(Goods goods){
        int i = service.update(goods);
        return R.ok().data("upd",i);
    }

    @RequestMapping("del")
    public R del(int id){
        int i = service.delete(id);
        return R.ok().data("del",i);
    }

}