Mapper代理初学

1.编写Mapper接口方法

public List<Brand> selectAll();

2.编写sql语句：SQL映射文件

<mapper namespace="com.dengji.mapper.BrandMapper">
    <select id="selectAll" resultType="com.dengji.pojo.Brand">
        select * from tb_brand;
    </select>
</mapper>

3.执行方法：测试

    //1.获取SqlSessionFactory
    String resource = "mybatis_config.xml";
    InputStream inputStream = Resources.getResourceAsStream(resource);
    SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

    //2.获取SqlSession对象
    SqlSession sqlSession  = sqlSessionFactory.openSession();

    //3.获取Mapper接口的代理对像
    BrandMapper brandMapper = sqlSession.getMapper(BrandMapper.class);

    //4.执行方法
    List<Brand> brands = brandMapper.selectAll();
    System.out.println(brands);

    //5.释放资源
    sqlSession.close();

4.报错：
Error parsing SQL Mapper Configuration
检查：IDEA未连接数据库，点击界面右边的database
-> “+” -> data source -> mysql ,输入用户名等信息，测试连接，完成后再次运行无问题