1. 传单个参数,@Param("XXXX")
public GdRunWaringRecord selectLastTimeByUserId(@Param("userId") Long userId, @Param("warnType") int warnType);
<select id="selectLastTimeByUserId" resultMap="GdRunWaringRecordResult">
<include refid="selectGdRunWaringRecordVo2"/>
where user_id = #{userId} and warn_type = #{warnType}
order by waring_time desc
limit 0,1
</select>2.传入实体 parameterType="xxxx"
<select id="selectGdRunWaringRecordList" parameterType="GdRunWaringRecord" resultMap="GdRunWaringRecordResult">
<include refid="selectGdRunWaringRecordVo"/>
<where>
<if test="userId != null "> and user_id = #{userId}</if>
<if test="params.beginWaringTime != null and params.beginWaringTime != '' and params.endWaringTime != null and params.endWaringTime != ''"> and waring_time between #{params.beginWaringTime} and #{params.endWaringTime}</if>
<if test="readstate != null "> and readState = #{readstate}</if>
<if test="warnType != null "> and warn_type = #{warnType}</if>
<if test="warnValue != null and warnValue != ''"> and warn_value = #{warnValue}</if>
</where>
order by waring_time desc
</select>二、返回结果,domain中添加对象以及get()和set()方法。xml中添加相应的resultMap。
private SysUser sysUser;
public SysUser getSysUser() {
return sysUser;
}
public void setSysUser(SysUser sysUser) {
this.sysUser = sysUser;
}<resultMap type="GdRunWaringRecord" id="GdRunWaringRecordResult">
<result property="id" column="id" />
<result property="userId" column="user_id" />
<result property="waringTime" column="waring_time" />
<result property="readstate" column="readState" />
<result property="warnType" column="warn_type" />
<result property="warnValue" column="warn_value" />
<association property="sysUser" javaType="SysUser"
resultMap="sysUser"/>
</resultMap>
<resultMap id="sysUser" type="SysUser">
<result property="userId" column="user_id"/>
<result property="realName" column="real_name"/>
<result property="pcUserName" column="pc_user_name"/>
<result property="nickName" column="nick_name"/>
<result property="sex" column="sex"/>
<result property="deptId" column="dept_id"/>
<result property="status" column="status"/>
<result property="createTime" column="create_time"/>
<result property="openId" column="open_Id" />
</resultMap>版权声明:本文为qq_33286757原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。