MyBatis 数据查询步骤

创建实体类

创建mapper xml，编写<select>SQL标签

<?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="goods">
    <!-- 定义查询语句 -->
    <select id="selectAll" resultType="com.demo.mybatis.entity.Goods">
    select * from t_goods order by goods_id desc limit 10
    </select>

</mapper>

开启驼峰命名转换

 <settings>
        <setting name="mapUnderscoreToCamelCase" value="true" />
    </settings>

新增<mapper>

 <mappers>
        <mapper resource="mappers/goods.xml"/>
    </mappers>

SqlSession 执行select语句