Mybatis项目构建 -- xml版

1、项目目录结构

2、jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/lucene?charsetEncoding=utf-8
jdbc.username=root
jdbc.password=password

3、mybatis-config.xml

<?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>
    <!--引入外部配置文件-->
    <properties resource="jdbc.properties"></properties>

    <!--使用typeAliases配置别名，它只能配置domain中类的别名 -->
    <typeAliases>
        <package name="com.dhu.bean"/>
    </typeAliases>

    <!--配置环境-->
    <environments default="mysql">
        <environment id="mysql">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"></property>
                <property name="url" value="${jdbc.url}"></property>
                <property name="username" value="${jdbc.username}"></property>
                <property name="password" value="${jdbc.password}"></property>
            </dataSource>
        </environment>
    </environments>

    <!-- 配置映射文件的位置 -->
    <mappers>
        <package name="com.dhu.mapper"/>
    </mappers>

</configuration>

4、SkuDao.xml

<mapper namespace="com.dhu.mapper.SkuDao">
    <select id="querySkuList" resultMap="skuDao">
        SELECT * FROM tb_sku
    </select>
    <resultMap id="skuDao" type="sku">
        <id property="id" column="id"></id>
        <result property="name" column="name"></result>
        <result property="price" column="price"></result>
        <result property="num" column="num"></result>
        <result property="image" column="image"></result>
        <result property="categoryName" column="category_name"></result>
        <result property="brandName" column="brand_name"></result>
        <result property="spec" column="spec"></result>
        <result property="saleNum" column="sale_num"></result>
    </resultMap>
</mapper>

 

5、测试类

public class SkuTest {

    private SkuDao skuDao;

    @Test
    public void test() throws IOException {
        //读取配置文件，生成字节输入流
        InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
        //获取SqlSession对象
        SqlSession sqlSession = factory.openSession();
        //获取dao代理对象
        skuDao = sqlSession.getMapper(SkuDao.class);
        List<Sku> list = skuDao.querySkuList();
        System.out.println(list.get(0));
        return;
    }
}