SpringBoot整合mybatis

①搭建SpringBoot工程

②引入mybatis起步依赖，添加mysql驱动

        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            2.1.0
        

        
            mysql
            mysql-connector-java
            
        
        
            org.springframework.boot
            spring-boot-starter-test
            test
        
    

③编写DataSource和MyBatis相关配置

application.yml

# datasource
spring:
  datasource:
    url: jdbc:mysql:///springboot?serverTimezone=UTC
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver


# mybatis配置文件
mybatis:
  mapper-locations: classpath:mapper/*Mapper.xml # mapper映射文件路径
  type-aliases-package: com.itheima.springbootmybatis.domain

  # config-location:  # 指定mybatis的核心配置文件

④定义表和实体类

public class User {
    private int id;
    private String username;
    private String password;


    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + ''' +
                ", password='" + password + ''' +
                '}';
    }
}

⑤编写dao和mapper文件/纯注解开发

编写dao

@Mapper
@Repository
public interface UserXmlMapper {

    public List findAll();
}

mapper.xml

    
        select * from t_user
    

纯注解开发

@Mapper
@Repository
public interface UserMapper {

    @Select("select * from t_user")
    public List findAll();
}