SpringBoot+Thymeleaf+Mybatis全套整合增删改查

配置文件形式

pom.xml

<dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <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.1.4</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

 在application.yml中配置数据源和mybatis+thymeleaf

server:
  port: 8888
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/kaifa?characterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true
    username: root
    password: root
  thymeleaf:
    mode: HTML5
    cache: false
    prefix: classpath:/templates/
    suffix: .html

# ??mybatis
mybatis:
  type-aliases-package: com.han.pojo #???
  mapper-locations: classpath:/mapper/*.xml # xml????
  configuration: #??
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

编写Customer实体类

 

package com.han.pojo;

import lombok.Data;

/**
 * @author YiHan
 * @date 2022-12-21 16:12
 * KoTai
 */
@Data
public class Customer {

    private Integer id;
    private String name;
    private String remark;
    private String telephone;
    private String address;
    private Integer typeId;
    private CustomerType customerType;


}

CustomerMapper

package com.han.mapper;

import com.han.pojo.Customer;
import org.apache.ibatis.ann