mybatis之SqlMapConf.xml配置文件中「mappers」标签的使用

mybatis之SqlMapConf.xml配置文件中标签的使用
1、SqlMapConf.xml与UserDao.xml都在resources目录下
（1）mapper标签：为resource方式；
UserMapper.xml文件与SqlMapConf.xml放在同一目录下。

<mappers>
        <mapper resource="UserDao.xml"></mapper>
</mappers>

（2）mapper标签：为package方式
UserMapper.xml文件与UserDao.java(接口)放在同一目录下。

<mappers>
	<package name="com.xsd.dao"></package>
</mappers>

pom.xml文件中要加：

<build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
                <!--默认是true-->
                <!--<filtering>true</filtering>-->
            </resource>
        </resources>
    </build>

mapper文件：

<mapper namespace="test">
    <select id="selectById" parameterType="Integer" resultType="com.xsd.domain.User">

        select * from t_user where tu_id = #{tu_id}

    </select>
</mapper>

同包下的接口名与mapper.xml文件名一样，要同名。

<mapper namespace="com.xsd.dao.UserDao">
    <select id="selectById" parameterType="Integer" resultType="com.xsd.domain.User">

        select * from t_user where tu_id = #{tu_id}

    </select>
</mapper>

jdbc接口调用之不同处：

public class UserTest {

    @Test
    public void TestGetById() throws IOException {
        InputStream resourceAsStream = Resources.getResourceAsStream("SqlMapConf.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        User user = sqlSession.selectOne("test.selectById", 6);
        System.out.println(user);
    }

    @Test
    public void testGetById() throws IOException {
        InputStream resourceAsStream = Resources.getResourceAsStream("SqlMapConf.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        SqlSession sqlSession = sqlSessionFactory.openSession();

        UserDao mapper = sqlSession.getMapper(UserDao.class);
        User user = mapper.selectById(6);
        System.out.println(user);

    }
}

注意：
namespace=“test”
namespace=“com.xsd.dao”

测试类的调用不同：
test.selectById
mapper.class