mybatis错误Available parameters are [ghNdeviceMaster, deptId, param1, param2]（已解决）

    <select id="selectGhNdeviceInDept" resultType="com.ruoyi.gh.ghdevice.domain.GhNdeviceMaster">
        select
        u.nDeviceId,
        u.updateTime,
        u.nDeviceName,
        u.nDeviceType,
        u.ndDeviceFWVer,
        u.nDeviceLocation,
        u.description,
        u.nDeviceLifeCycle,
        u.nDeviceLockReason,
        u.nDeviceBornTime,
        u.nDeviceBindTime,
        u.nDeviceVerifyTime,
        u.nDeviceLockTime,
        u.isOnline,
        u.details,
        u.dealerId,
        u.isEnable,
        u.createTime
        FROM gh_ndevice_master u
        JOIN gh_relation_dept_ndevice r on r.deptId = #{deptId} and r.nDeviceId = u.nDeviceId
        <where>
            <if test="nDeviceId != null and nDeviceId != ''">
                AND u.nDeviceId like concat('%', #{nDeviceId},'%')
            </if>
            <if test="nDeviceName !=null and nDeviceName != ''">
                AND u.nDeviceName like concat('%', #{nDeviceName},'%')
            </if>
            <if test="nDeviceType !=null and nDeviceType != ''">
                AND u.nDeviceType like concat('%', #{nDeviceType},'%')
            </if>
            <if test="nDeviceBindTime !=null">
                AND u.nDeviceBindTime like concat('%', #{nDeviceBindTime},'%')
            </if>
            AND u.isEnable = 1
            AND r.isEnable = 1
        </where>
    </select>

解决

修改代码

    <select id="selectGhNdeviceInDept" resultType="com.ruoyi.gh.ghdevice.domain.GhNdeviceMaster">
        select
        u.nDeviceId,
        u.updateTime,
        u.nDeviceName,
        u.nDeviceType,
        u.ndDeviceFWVer,
        u.nDeviceLocation,
        u.description,
        u.nDeviceLifeCycle,
        u.nDeviceLockReason,
        u.nDeviceBornTime,
        u.nDeviceBindTime,
        u.nDeviceVerifyTime,
        u.nDeviceLockTime,
        u.isOnline,
        u.details,
        u.dealerId,
        u.isEnable,
        u.createTime
        FROM gh_ndevice_master u
        JOIN gh_relation_dept_ndevice r on r.deptId = #{deptId} and r.nDeviceId = u.nDeviceId
        <where>
            <if test="ghNdeviceMaster.nDeviceId != null and ghNdeviceMaster.nDeviceId != ''">
                AND u.nDeviceId like concat('%', #{ghNdeviceMaster.nDeviceId},'%')
            </if>
            <if test="ghNdeviceMaster.nDeviceName !=null and ghNdeviceMaster.nDeviceName != ''">
                AND u.nDeviceName like concat('%', #{ghNdeviceMaster.nDeviceName},'%')
            </if>
            <if test="ghNdeviceMaster.nDeviceType !=null and ghNdeviceMaster.nDeviceType != ''">
                AND u.nDeviceType like concat('%', #{ghNdeviceMaster.nDeviceType},'%')
            </if>
            <if test="ghNdeviceMaster.nDeviceBindTime !=null">
                AND u.nDeviceBindTime like concat('%', #{ghNdeviceMaster.nDeviceBindTime},'%')
            </if>
            AND u.isEnable = 1
            AND r.isEnable = 1
        </where>
    </select>