SpringBoot整合Mybatis

最新推荐文章于 2023-10-30 15:07:11 发布

qq_57382621

最新推荐文章于 2023-10-30 15:07:11 发布

阅读量147

点赞数

CC 4.0 BY-SA版权

文章标签： mybatis spring boot java

本文链接：https://blog.youkuaiyun.com/qq_57382621/article/details/128381505

本文档详细介绍了如何使用Spring Boot搭建项目，配置数据源，引入MyBatis依赖，创建数据库和POJO类，编写Mapper、Service、Controller层，并进行了测试。主要涉及Spring Boot、MyBatis、MySQL、Thymeleaf等相关技术，实现了商品管理的CRUD功能。

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

新建一个新项目并且选择文件结构、选择jdk

1.选择项目需要的依赖

2.查看项目新建完成后的pom文件

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.6.11</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.demo</groupId>
    <artifactId>boot-01</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>boot-01</name>
    <description>Demo project for Spring Boot</description>

    <properties>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <!--模板引擎-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <!--web-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!--mybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.2</version>
        </dependency>
        <!--mysql-->
        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <scope>runtime</scope>
        </dependency>
        <!--给实体类添加get/set等-->
        <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>

    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.8.1</version>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                    <encoding>UTF-8</encoding>
                </configuration>
            </plugin>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

3、修改application.properties文件，改为.yml格式

server:
  port: 8080    //端口号
 
spring:
  datasource:    //数据源
    username: root
    password: 123456
    #url中database为对应的数据库名称    加上对应的时区和字符编码格式
    url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
    driver-class-name: com.mysql.cj.jdbc.Driver
 
mybatis:
  mapper-locations: classpath:mapping/*.xml        //mapper对应映射文件
  type-aliases-package: com.demo.entity    //实体类起别名对应路径

2、创建对应的包和类

1、创建数据库和编写pojo类

CREATE TABLE `goods`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品名称',
  `price` double(10, 2) NOT NULL COMMENT '商品价格',
  `num` int(255) NOT NULL COMMENT '商品数量',
  `typeId` int(255) NOT NULL COMMENT '商品类型',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '商品介绍',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

CREATE TABLE `type`  (
  `id` int(11) NOT NULL,
  `typeName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

goods类，这里的type字段用来写mapper时双表联查

package com.demo.boot01.pojo;

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

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Goods {
    private String goodsname;
    private Integer goodsprice;
    private Integer goodsnum;
    private Integer goodstype;
    private String remark;
    private Type type;
}

type类

package com.demo.boot01.pojo;

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

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Type {
    private Integer typeid;

    private String typename;
}

工具类utils

public class R extends HashMap<String, Object> {
	private static final long serialVersionUID = 1L;
 
	public R() {
		put("code", 0);
		put("msg", "success");
	}
 
	public static R error() {
		return error(HttpStatus.SC_INTERNAL_SERVER_ERROR, "未知异常，请联系管理员");
	}
 
	public static R error(String msg) {
		return error(HttpStatus.SC_INTERNAL_SERVER_ERROR, msg);
	}
 
	public static R error(int code, String msg) {
		R r = new R();
		r.put("code", code);
		r.put("msg", msg);
		return r;
	}
 
	public static R ok(String msg) {
		R r = new R();
		r.put("msg", msg);
		return r;
	}
 
	public static R ok(Map<String, Object> map) {
		R r = new R();
		r.putAll(map);
		return r;
	}
 
	public static R ok() {
		return new R();
	}
 
	public R put(String key, Object value) {
		super.put(key, value);
		return this;
	}
}


@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;
    }
}

编写mapper接口

@Mapper
public interface GoodsMapper {
    int insert(Goods record);
    int insertSelective(Goods record);
    List<Goods> getAll();
    int delById(@Param("goodsName")String goodsName);
    int update(Goods  goods);
    Goods findByGoodsName(String name);
}

编写service业务层

@Service
public class GoodsServiceImpl implements GoodsService{

    @Resource
    private GoodsMapper goodsMapper;

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

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

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

    @Override
    public int delById(String goodsName) {
        return goodsMapper.delById(goodsName);
    }
    @Override
    public int update(Goods goods) {
        return goodsMapper.update(goods);
    }

    @Override
    public Goods findByGoodsName(String name) {
        return goodsMapper.findByGoodsName(name);
    }

}

编写controller

@Controller
public class GoodsController {

    @Autowired
    private GoodsService goodsService;

    @GetMapping("/getAll")
    @ResponseBody
    public R getAll() {
        List<Goods> all = goodsService.getAll();
        return R.ok().code(200).data("goodList", all);
    }

    @GetMapping("/findByName")
    @ResponseBody
    public R findByName(@RequestParam("goodsName") String goodsName) {
        Goods goods = goodsService.findByGoodsName(goodsName);
        return R.ok().code(200).data("goods", goods);
    }

    @GetMapping("/del")
    @ResponseBody
    public R del(@RequestParam("goodsName") String goodsName) {
        System.out.println("名称=============>" + goodsName);
        int delcount = goodsService.delById(goodsName);
        return R.ok().code(200).data("isFlag", delcount);
    }

    @GetMapping("/add")
    @ResponseBody
    public R add( Goods goods) {
        int addCount = goodsService.insertSelective(goods);
        return R.ok().code(200).data("isFlag", addCount);
    }

}