Spring Boot注解方式集成Mybatis

一、无配置文件注解版

1.pom文件必要jar包的引入

<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>

 

2.application.properties添加相关配置

　　SpringBoot会自动加载application.properties配置文件，会读取spring.datasource.*相关的配置，数据源会自动注入到sqlSessionFactory中，sqlSessionFactory会自动注入到Mapper中

　　会扫描的model实体类路径

mybatis.type-aliases-package=com.neo.entity spring.datasource.driverClassName = com.mysql.jdbc.Driver spring.datasource.url = jdbc:mysql://localhost:3306/test1?
useUnicode=true&characterEncoding=utf-8
spring.datasource.username = root
spring.datasource.password = root

 

3.建立启动类

@SpringBootApplication @MapperScan("com.neo.mapper") 
public class Application { 
    public static void main(String[] args) {         
        SpringApplication.run(Application.class, args); 
    } 
}

 　　或者在Mapper雷尚添加注解@Mapper

4.mapper文件配置

 

public interface UserMapper { 
@Select("SELECT * FROM users") @Results({ @Result(property = "userSex", column = "user_sex", javaType = UserSexEnum.class), @Result(property = "nickName", column = "nick_name") }) List<UserEntity> getAll();
@Select("SELECT * FROM users WHERE id = #{id}") 
@Results({ @Result(property = "userSex", column = "user_sex", javaType = UserSexEnum.class), 
@Result(property = "nickName", column = "nick_name") }) 
UserEntity getOne(Long id); @Insert("INSERT INTO users(userName,passWord,user_sex) VALUES(#{userName}, #{passWord}, #{userSex})") void insert(UserEntity user); 
@Update("UPDATE users SET userName=#{userName},nick_name=#{nickName} WHERE id =#{id}") 
void update(UserEntity user); 
@Delete("DELETE FROM users WHERE id =#{id}") 
void delete(Long id); }

 

5测试类