【mybatis】06 -查询 查询所有&结果映射

• 分析：接口的方法不需要参数，需要一个集合返回值。
• 注：数据库字段名和pojo类中的属性必须一致、或者起别名

1. 建立好项目，注意mapper接口和mapper.xml相对包路径要一致
   
2. 配置好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>
    <typeAliases>
<!--        可以让mapper的resultType不用写包-->
        <package name="com.ljh.pojo"/>
    </typeAliases>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <!--数据库连接信息-->
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql:///mybatis?useSSL=false"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
        <environment id="test">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <!--数据库连接信息-->
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql:///mybatis?useSSL=false"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--指定当前sql映射文件的路径-->
<!--        <mapper resource="UserMapper.xml"></mapper>-->
<!--        加载路径下所有mapper映射文件-->
<!--        3.添加注册信息，下一步测试-->
        <package name="com.ljh.mapper"/>

    </mappers>


</configuration>

3. 编写mapper接口，利用mybatisX生成对应的mapper.xml映射

package com.ljh.mapper;

import com.ljh.pojo.Brand;

import java.util.List;

public interface BrandMapper {
//    1.查询所有公司，下一步编写sql
    public List<Brand> selectAll();
}

4. 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.ljh.mapper.BrandMapper">
<!--    2. 编写sql语句，下一步注册mapper-->
<!--    <select id="selectAll" resultType="Brand">-->
<!--        解决数据库字段名和pojo类属性名不一致的问题-->
<!--        select  id, brand_name as brandName, company_name as companyName,ordered, description, status-->
<!--        from tb_brand;-->
<!--    </select>-->
<!--    简化-->
<!--    <sql id="brand_column">-->
<!--        id, brand_name as brandName, company_name as companyName,ordered, description, status-->
<!--    </sql>-->
<!--    <select id="selectAll" resultType="Brand">-->
<!--        select-->
<!--        <include refid="brand_column"></include>-->
<!--        from tb_brand;-->
<!--    </select>-->
<!--    最简化-->
<!--    利用resultMap进行属性值和数据库字段进行映射-->
    <resultMap id="brandResultMap" type="brand">
        <result column="brand_name" property="brandName"></result>
        <result column="company_name" property="companyName"></result>
    </resultMap>
    <!--注意：此处要用resultMap属性绑定resultMap字段-->
    <select id="selectAll" resultMap="brandResultMap">
        select *
        from tb_brand
    </select>
</mapper>

5. 单元测试

package com.ljh.test;

import com.ljh.mapper.BrandMapper;
import com.ljh.pojo.Brand;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class MybatisTest {
    @Test
    public void testSelectAll() throws IOException {
        //1.获取session工厂
        String resource = "mybatis-config";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //2.获取session
        SqlSession sqlSession = sqlSessionFactory.openSession();
        //3.获取mapper
        BrandMapper mapper = sqlSession.getMapper(BrandMapper.class);
        //4.执行sql
        List<Brand> brands = mapper.selectAll();
        System.out.println(brands);
        //5.关闭资源
        sqlSession.close();
    }
}

6. 运行结果