测试类
package com.zhaoxin;
import com.zhaoxin.dao.UserDao;
import com.zhaoxin.pojo.User;
import com.zhaoxin.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import java.util.List;
/**
* @program: maven_project
* @description:
* @author: ZhaoXin
* @create: 2021-05-31 19:20
**/
public class TestMybatis {
@Test
public void testFindAll(){
// 1-4 获取SqlSession
SqlSession sqlSession = MybatisUtils.getSqlSession();
// 5. 获取代理对象
UserDao userDao = sqlSession.getMapper(UserDao.class);
// 6. 执行findAll方法
List<User> userList = userDao.findAll();
// 7. 处理结果
for (User user : userList) {
System.out.println(user);
}
// 8. 关闭资源
MybatisUtils.commitAndClose(sqlSession);
}
}
文件结构
pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.zhaoxin</groupId>
<artifactId>mybatis_practice</artifactId>
<version>1.0-SNAPSHOT</version>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
<!--引入lombok的依赖-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.20</version>
</dependency>
<!--mysql驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<!--mybatis的依赖-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.3</version>
</dependency>
</dependencies>
</project>
主配置文件
<?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>
<environments default="dev">
<environment id="dev">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="username" value="root"/>
<property name="password" value="z77"/>
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql:///mybatis_day?characterEncoding=utf8"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com\zhaoxin\dao\UserDao.xml"></mapper>
</mappers>
</configuration>
<?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.zhaoxin.dao.UserDao">
<select id="findAll" resultType="com.zhaoxin.pojo.User">
select * from t_user
</select>
</mapper>
target文件