原生方式简单测试mybatis连接数据库

原生方式简单测试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&amp;useUnicode=true&amp;characterEncoding=utf-8&amp;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();
        }
    }
}