public class Account implements Serializable{
private Integer cardId;
private String username;
private String password;
private Double balance;
private String mobile;
}
修改对应的mapper文件:给数据库中的CARD_ID用别名cardId表示
<?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="com.baizhi.dao.AccountDao">
<!-- 自定义结果集封装映射关系 type 执行实体类全限定名或别名
id 是当前resultMap的唯一标识,也是未来使用这个resultMap的依据 -->
<resultMap type="Account" id="accResultMap">
<!-- 用于映射表的主键字段于实体指定属性的关系 -->
<id column="card_id" property="cardId"/>
<result column="username" property="username"/>
<result column="password" property="password"/>
<result column="balance" property="balance"/>
<result column="mobile" property="mobile"/>
</resultMap>
<select id="queryByPage" resultMap="accResultMap">
select card_id,username,password,balance,mobile,rn
from(select a.*,rownum rn from accounts a)
where rn > =3 and rn < =6
</select>
</mapper>