mybatis 接口向xml文件传递参数,结果反射实体中不存在的属性。

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版权协议,转载请附上原文出处链接和本声明。