Spring Boot 编程思想学习笔记——整合Mybatis框架

1配置mysql数据源

依赖包

mysql-connector-java

spring-boot-starter-jdbc

application.properties
 

spring.datasource.url=jdbc:mysql://localhost:3306/db

spring.datasource.username=root

spring.datasource.password=123456
...其他配置

2整合Mybatis框架

依赖包

mybatis-spring-boot-starter

定义pojo

@Alias(value = "user")
public class User{
    private Long id = null;
    private String userName = null;
}

定义Mybatis操作接口
 

@Repository

public interface MyBatisUserDao{

public User getUser(Long id);

}

定义用户映射文件

<mapper namesacpe="com.spirngboot.dao.MyBatisUsrDao">
<select id="getUser" parameterType="long" resultType="user">
select id,user_name as username from t_user where id=#{id}
</select>
</mapper>

application.preperties配置

mybatis.mapper-locations=classpath:com/springboot/mapper/*.xml

使用MapperScan定义扫描
 

@MapperScan{

//指定扫描包

basePackages="com.....",

//扫描bean

annotationClass = Repository.class

}
public class Appliction{
........
}