iden_server/src/main/java/com/iden/common/mapper/IdenCommunityMapper.java

package com.iden.common.mapper;

import com.iden.common.entity.IdenCommunity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;


/**
 * 小区表(IdenCommunity)表数据库访问层
 *
 * @author makejava
 * @since 2021-12-22 17:23:45
 */
public interface IdenCommunityMapper extends BaseMapper<IdenCommunity> {
    @Select(value = "select * from iden_community where id =(select COMMUNITY_ID from iden_camera where ip=#{ip,jdbcType = VARCHAR})")
    public IdenCommunity queryRtspServiceUrl(String ip);
}