1、导入相应依赖
<dependencies>
<!--mybatis核心依赖-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.13.1</version>
<scope>test</scope>
</dependency>
<!--mysql驱动,根据自己的数据库选择-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.21</version>
</dependency>
<!--懒人工具,用相应注解生成pojo类的get and set等-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.16</version>
</dependency>
</dependencies>
2、编写mybatis核心配置文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config
3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!-- 配置 mybatis 的环境 -->
<environments default="mysql">
<!-- 配置 mysql 的环境 -->
<environment id="mysql">
<transactionManager type="JDBC"></transactionManager>
<!-- 配置连接数据库的信息:用的是数据源(连接池) -->
<dataSource type="POOLED">
<property name="driver" value="com.mysql.cj.jdbc.Driver"/>
<!--因为我是mysql8会出现时区问题,所以要在后面加上?serverTimezone=GMT-->
<property name="url" value="jdbc:mysql:///mybatis?serverTimezone=GMT"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<!-- 告知 mybatis 映射配置的位置 -->
<mappers>
<mapper resource="com/xz/mapper/UserMapper.xml"/>
</mappers>
</configuration>
3、编写实体类
//需要用到Lombok依赖
//生成get和set
@Data
//生成无参构造函数
@NoArgsConstructor
//生成有参构造函数
@AllArgsConstructor
public class User {
private Integer id;
private String username;
private String password;
private String phone;
}
4、编写usermapper接口
public interface UserMapper {
public List<User> findAll();
}
5、编写接口对应的映射文件
<?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">
<!--namespace的值对应相应的接口-->
<mapper namespace="com.xz.mapper.UserMapper">
<!--
配置查询所有操作
id:方法名称
resultType:返回值类型
-->
<select id="findAll" resultType="com.xz.pojo.User">
select * from `user`
</select>
</mapper>
注意:usermapper接口所在位置要和其对应的xml文件在同一个包下,步骤2中mappers下引入映射文件。
6、整体包结构图
蓝鸟和红鸟来自mybatisX插件,让我们写的接口和方法和相对于的xml文件一一对应
7、测试
public class T1 {
@Test
public void t1(){
try {
//获取mybatis的核心配置文件(“路径名”),因为我放在跟目录下所有直接写包名,resource就是跟目录
InputStream in = Resources.getResourceAsStream("mybatis-config.xml");
//创建SqlSessionFactoryBuilder
SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
SqlSessionFactory factory = builder.build(in);
//获取sqlsession对象
SqlSession sqlSession = factory.openSession();
//通过反射创建对象
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
//执行方法
List<User> all = mapper.findAll();
System.out.println(all);
sqlSession.close();
in.close();
} catch (IOException e) {
throw new RuntimeException(e);
}
}
}