锁的位置管理

whyclxw

2025-04-22 b75d9ff63e12ead54aace07ccb66d97981d0cc7d

锁的位置管理

 src/main/java/com/whyc/pojo/plus_inf/LockAddress.java

@@ -1,6 +1,7 @@
package com.whyc.pojo.plus_inf;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
@@ -41,6 +42,10 @@
    @ApiModelProperty(value = "锁id")
    private Integer lockId;

    @ApiModelProperty(value = "锁名")
    @TableField(exist = false)
    private String lockName;

    @ApiModelProperty(value = "屏柜位置")
    private Integer screenFlag;


 src/main/resources/mapper/LockAddressMapper.xml

@@ -3,9 +3,10 @@
<mapper namespace="com.whyc.mapper.LockAddressMapper">

    <select id="getAddressList" resultType="com.whyc.pojo.plus_inf.LockAddress">
        select tb_lock_address.*
        from plus_inf.tb_lock_address
        select tb_lock_address.*,tb_lock_inf.lock_name
        from plus_inf.tb_lock_address,plus_inf.tb_lock_inf
        <where>
            tb_lock_address.lock_id=tb_lock_inf.lock_id
            <if test="lockIdList!=null">
                and tb_lock_address.lock_id in
                <foreach collection="lockIdList" item="id" open="(" separator="," close=")">