List<User> list = new ArrayList<>();
while(resultSet .next){
User user = new User;
user.setUserId= (resultSet.getInt("userId"));
user.setUserName = (resultSet.getInt("userName"));
list.add(user)
}
<?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="development">
<!-- id:数据源名称-->
<environment id="development">
<!-- 事务类型:使用JDBC的事务,使用Connection的提交和回滚-->
<transactionManager type="JDBC"/>
<!-- 数据源:dataSource数据源,创建Connection对象 type=“POOLED“ 使用数据库连接池技术 -->
<dataSource type="POOLED">
<!-- 连接数据库的四个参数 mysql8.0-->
<property name="driver" value="com.mysql.cj.jdbc.Driver"/>
<property name="url"
value="jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/ftz/demo/pojo/User.xml"/>
</mappers>
</configuration>
package com.ftz.demo.test;
import com.ftz.demo.pojo.User;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;
import java.io.IOException;
import java.io.Reader;
import java.util.List;
public class Test01 {
@Test
public void test01() throws IOException {
//1:读取mybatis配置文件
Reader reader = Resources.getResourceAsReader("mybatis.xml");
//2:创建sqlSessionFactory对象,目的是获取sqlSession的创建工厂:其实就是connection对象的封装
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
//3:创建SqlSession
SqlSession sqlSession = sqlSessionFactory.openSession();
//4:执行sql语句
List<User> userList = sqlSession.selectList("com.ftz.demo.pojo.User.queryALL");
// 5:遍历结果
for (User user:userList){
System.out.println(user);
}
//6:关闭资源
sqlSession.close();
}
}
List<User> userList = sqlSession.selectList("com.ftz.demo.pojo.User.queryALL");
版权说明 : 本文为转载文章, 版权归原作者所有 版权申明
原文链接 : https://blog.csdn.net/justleavel/article/details/123339283
内容来源于网络,如有侵权,请联系作者删除!
List<User> userList = sqlSession.selectList("com.ftz.demo.pojo.User.queryALL");