mybatis动态sql中的bind绑定

List<RoleDTO> getRoleList(@Param("record")RoleQUERY role);

<select id="getRoleList" parameterType="map" resultMap="RoleDtoResultMap">
  <bind name="cur" value="(record.currentPage-1)*record.pageSize"/>
  select
  <include refid="com.hanshow.wise.base.privileges.dao.RoleMapper.Base_Column_List" />
  from role
  <include refid="roleListSql"/>
  <if test="record.currentPage!=null and record.pageSize!=null">
    limit #{cur,jdbcType=INTEGER}, #{record.pageSize,jdbcType=INTEGER}
  </if>
</select>

 

public class RoleQUERY implements Serializable {
    /**
     * app编号
     */
    private String appId;
    /**
     * 用户编号
     */
    private String userId;
    /**
     * 角色编号
     */
    private String roleId;
    /**
     * 商户编号
     */
    private String merchantId;
    /**
     * 当前页数
     */
    private Integer currentPage;
    /**
     * 每页条数
     */
    private Integer pageSize;

}