67,513
社区成员
发帖
与我相关
我的任务
分享
select user_id,user_name,user_password,user_salt,user_account_deadline,user_integration,user_downloadtimes from bank_user
<where>
user_id = #{userId}
</where>
// 用户id
private String user_id;
// 用户名
private String user_name;
// 密码
private String user_password;
// 盐值
private String user_salt;
// 账户过期时间
private Date user_account_deadline;
// 账户的积分
private Integer user_integration;
// 账户剩余下载次数
private Integer user_downloadtimes;
<select id="doLogin" resultMap="test12345">
select user_id,user_name,user_password,user_salt,user_account_deadline,user_integration,user_downloadtimes from bank_user
<where>
user_id = #{userId}
</where>
</select>
<resultMap type="com.codeliu.entity.User" id="test12345">
<id property="user_id" column="user_id"></id>
<id property="user_name" column="user_name"></id>
<id property="user_password" column="user_password"></id>
<id property="user_salt" column="user_salt"></id>
<id property="user_account_deadline" column="user_account_deadline"></id>
<id property="user_integration" column="user_integration"></id>
<id property="user_downloadtimes" column="user_downloadtimes"></id>
</resultMap>