<?xml version="1.0" encoding="UTF-8"?>
<!--xml約束信息 -->
<!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
 "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <!--引入數(shù)據(jù)源的配置文件 resource指定文件的位置 -->
    <properties resource="db.properties"></properties>

    <settings>
        <setting name="mapUnderscoreToCamelCase" value="true" />
    </settings>


    <!-- 設(shè)置別名 -->
    <typeAliases>
        <typeAlias type="pojo.User" alias="User" />
    </typeAliases>
    <!-- 配置開發(fā)環(huán)境 ，default用來設(shè)置默認(rèn)的開發(fā)環(huán)境 -->
    <environments default="test">
        <!--測試環(huán)境 -->
        <environment id="test">
            <!--事務(wù)管理器:mybatis的事務(wù)交個jdbc處理 -->
            <transactionManager type="jdbc"></transactionManager>
            <!--連接池:配置數(shù)據(jù)源拗踢，連接池 -->
            <dataSource type="pooled">
                <!--數(shù)據(jù)庫驅(qū)動的名字 -->
                <property name="driver" value="${driver}" />
                <!-- 數(shù)據(jù)庫的url地址 -->
                <property name="url" value="${url}" />
                <!-- 數(shù)據(jù)庫的用戶名 -->
                <property name="username" value="${username}" />
                <!-- 數(shù)據(jù)庫的密碼 -->
                <property name="password" value="${password}" />
            </dataSource>
        </environment>
    </environments>
    <!--引入映射文件 -->
    <mappers>
        <!--引入UserMapper文件 resource指定文件的位置 -->
        <mapper resource="mapper/DoorMaper.xml" />
    </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="doorns">
<select id="findAll" resultType="pojo.Door">
        select * from tb_door
</select>
</mapper>

    SqlSessionFactory ssf = null;

    @Before
    public void init() {
        // 1.創(chuàng)建會話工廠
        try {
            InputStream in = Resources.getResourceAsStream("sqlMapConfig.xml");
            ssf = new SqlSessionFactoryBuilder().build(in);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    
    
    
    @Test
    public void findAll(){
        //獲取sqlsession亲善，執(zhí)行SQL
        SqlSession session = ssf.openSession();
        //利用接口方法
        List<Door> list = session.selectList("doorns.findAll");
        //處理結(jié)果
        for (Door door : list) {
            System.out.println(door);
        }
        //釋放資源
        session.close();
    }