mybatis整合

【一】pom文件添加：

?

<dependency>

    <groupId>org.springframework.boot</groupId>

    <artifactId>spring-boot-starter-jdbc</artifactId>

</dependency>

 

<dependency>

    <groupId>org.mybatis.spring.boot</groupId>

    <artifactId>mybatis-spring-boot-starter</artifactId>

    <version>2.1.3</version>

</dependency>

　　

 

【二】application.properties

?

1 2 3 4 5 6

spring.datasource.url=jdbc:mysql://localhost:3306/test spring.datasource.username=sa spring.datasource.password=123 spring.datasource.driver-class-name=com.mysql.jdbc.Driver #将下划线转成驼峰 mybatis.configuration.map-underscore-to-camel-case=true

　　

【三】创建Mapper和Model（UserMapper和User model）

?

@Mapper

public interface UserMapper {

@Insert("inser into user(name,accountId,token,gmtCreate,gmtModified) values (#{name},#{accountId},#{token},#{gmtCreate},#{gmtModified})")

void insert(User user);

//普通变量需要添加@Param注解

@Select("select * from user where token = #{token}")

User findByToken(@Param("token") String token);}

　

 

MyBatis 与 SpringBoot 整合：注解和xml两种使用方式介绍

参考：https://blog.csdn.net/solocoder/article/details/84990904

https://blog.csdn.net/seashouwang/article/details/80210780