导入 MyBatis 所需要的依赖
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.4</version>
</dependency>
实体类
@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {
private String username;
private Integer pwd;
}
创建mapper目录以及对应的 Mapper 接口
@Repository
@Mapper
public interface UserMapper {
List<User> getUserInfo();
}
Mapper注解的作用:扫描这个接口,动态代理生成对象
用这个注解的作用是一样的 然后写映射文件,当然你也可以写注解去实现 映射文件的命名空间必须要对应Mapper接口的路径 id对应接口中的方法 resultType要对应所查实体类的对象
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.kuang.springboot_jdbc.mapper.UserMapper">
<select id="getUserInfo" resultType="User">
select * from t_user;
</select>
</mapper>
配置文件
spring.application.name=springboot_jdbc
#端口
server.port=8080
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.filters=stat,wall,log4j
mybatis.type-aliases-package=com.kuang.springboot_jdbc.pojo
mybatis.mapper-locations=classpath:mapper/*.xml
测试结果