目录
1、普通查询
<select id="selectAll" resultMap="BaseResultMap">
select * from chart
</select>
2、通过参数查询
(1)一个参数
<select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
select * from chart
where id = #{id,jdbcType=INTEGER}
</select>
对应mapper
Chart selectByPrimaryKey(Integer id);
(2)多个参数
分页查询的例子:
<select id="findByPage" resultMap="BaseResultMap" parameterType="java.lang.Integer">
select * from chart order by