原生方式简单测试mybatis连接数据库
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运行环境 -->
<properties resource="db.properties"/>
<environments default="development">
<environment id="development">
<!-- 配置JDBC事务管理 -->
<transactionManager type="JDBC"></transactionManager>
<!-- POOLED配置JDBC数据源连接池 -->
<dataSource type="POOLED">
<!--<property name="driver" value="com.mysql.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/test?serverTimezone=GMT&useUnicode=true&characterEncoding=utf-8&useSSL=false"></property>
<property name="username" value="root"></property>
<property name="password" value="123456"></property>-->
<property name="driver" value="${driver}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
<!-- 注册AccountMapper.xml -->
<mappers>
<mapper resource="com/fu/mapper/UserMapper.xml"></mapper>
</mappers>
</configuration>
实体类
public class User {
private int id;
private String name;
private int age;
private String address;
private String email;
}
mapper层接口
public interface UserMapper {
//查询接口
public List<User> selUsers();
}
mapper.xml
<?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.fu.mapper.UserMapper">
<select id="selUsers" resultType="com.fu.pojo.User">
select * from User;
</select>
</mapper>
测试类
public class TestUserController {
private static SqlSessionFactory sqlSessionFactory;
private static Reader resourceAsReader;
//private static InputStream resourceAsStream;
public static void main(String[] args) throws IOException {
//以两种流的形式读取mybatis配置文件
//resourceAsStream = Resources.getResourceAsStream("mybatis-config.xml");
SqlSession sqlSession = null;
resourceAsReader = Resources.getResourceAsReader("mybatis-config.xml");
try {
//sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
//创建SqlSession工厂
sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsReader);
//打开连接
sqlSession = sqlSessionFactory.openSession();
//两种执行方式
List<User> users = sqlSession.selectList("com.fu.mapper.UserMapper.selUsers");
/*UserMapper mapper = sqlSession.getMapper(UserMapper.class);
List<User> users = mapper.selUsers();*/
for (User user : users) {
System.out.println(user.toString());
}
} finally {
sqlSession.close();
}
}
}