<!-- 传参一位数 -->
        <!--parameterType 外部传参一个整数 -->
        <!--resultType 结果的类型 -->
        <select id="findOneById" parameterType="integer" resultType="com.imooc.mybatis.entity.GoodsEntity">
            SELECT * FROM t_goods WHERE goods_id = #{value}
        </select>


    public void testFindOne() throws Exception {
        SqlSession sqlSession = null;
        try {
            //获取sql对象
            sqlSession = MybatisUtils.openSession();
            //执行sql
            GoodsEntity good = sqlSession.selectOne("goods.findOneById",739);
            System.out.println(good.getTilte());
            //查看连接状态
            Connection conn = MybatisUtils.getConnection(sqlSession);

        }catch (Exception e){
            throw e;
        }finally {
            MybatisUtils.release(sqlSession);
        }
    }

        <!--传递多位参数 -->
        <!--parameterType 传递多位参数-->
        <select id="findMoreParam" parameterType="java.util.Map" resultType="com.imooc.mybatis.entity.GoodsEntity">
            SELECT * FROM t_goods
                WHERE current_price
                BETWEEN #{min} AND #{max}
                ORDER BY current_price DESC limit 0,#{limit}
        </select>


    public void testMoreParam() throws Exception {
        SqlSession sqlSession = null;
        try {
            //获取sql对象
            sqlSession = MybatisUtils.openSession();
            //执行sql
            Map para = new HashMap();

            para.put("min",100);
            para.put("max",200);
            para.put("limit",5);

            List<GoodsEntity> list = sqlSession.selectList("goods.findMoreParam",para);
            for (GoodsEntity good:list
                 ) {
                System.out.println(good.getTilte()+"---"+good.getCurrentPrice());
            }
            //查看连接状态
            Connection conn = MybatisUtils.getConnection(sqlSession);

        }catch (Exception e){
            throw e;
        }finally {
            MybatisUtils.release(sqlSession);
        }
    }