Java框架MyBatis学习历程（3）——Sql传参，多表关联查询、ResultMap结果映射

1、带参查询select

代码实例：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="goods">
    <select id="selectAll" resultType="com.imooc.mybatis.entity.Goods">
        select  * from t_goods order by goods_id desc limit 10
    </select>
    
    <select id="selectById" parameterType="Integer" resultType="com.imooc.mybatis.entity.Goods">
        select * from t_goods where goods_id = #{value}
    </select>
    
    <select id="selectByPriceRange" parameterType="java.util.Map" resultType="com.imooc.mybatis.entity.Goods">
        select * from t_goods
        where
          current_price between #{min} and #{max}
        order by current_price
        limit 0,#{limt}
    </select>
</mapper>

    @Test
    public void testSelectById() {
   
        SqlSession session = null;
        try {
   
            session = MyBatisUtils.openSession();
            Goods goods = session.selectOne("goods.selectById", 1603);
            System.out.println(goods.getTitle());
        } catch (Exception e) {
   
            e.printStackTrace();
        } finally {
   
            MyBatisUtils.closeSession(session);
        }
    }
    @Test
    public void te