优化

liuhaonan

2022-07-28 23e1e52aa20bda049a0d023fe3b4a0e7cf769d07

优化

 dao/src/main/java/com/sandu/ximon/dao/domain/Client.java

@@ -55,6 +55,12 @@
    @JsonIgnore
    private String password;

    /**
     * 无需账号密码登录所使用的key
     */
    @JsonIgnore
    private String userKey;

    /*灯杆数量*/
    private Integer countLight;


 dao/src/main/resources/mapper/ClientMapper.xml

@@ -12,16 +12,21 @@
        <result property="mobile" column="mobile" jdbcType="VARCHAR"/>
        <result property="icon" column="icon" jdbcType="VARCHAR"/>
        <result property="password" column="password" jdbcType="VARCHAR"/>
        <result property="userKey" column="user_key" jdbcType="VARCHAR"/>
        <result property="countLight" column="count_light" jdbcType="INTEGER"/>
        <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
        <result property="loginTime" column="login_time" jdbcType="TIMESTAMP"/>
    </resultMap>
    <select id="clientList" resultType="com.sandu.ximon.dao.domain.Client">
    select * from  client where superiorId=#{userId}
        select *
        from client
        where superiorId = #{userId}

    </select>
    <select id="findClientIdByName" resultType="java.lang.Long">
        select id from client where client_name=#{belongsClient}
        select id
        from client
        where client_name = #{belongsClient}
    </select>