package com.bofeng.dao; import com.baomidou.mybatisplus.mapper.BaseMapper; import com.bofeng.entity.SysUserRole; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; import org.springframework.stereotype.Repository; @Mapper @Repository public interface YeweihuiSysOwnerMapper extends BaseMapper { @Select("select uptown_id from sys_owner where owner_id=#{propertyId}") long queryUptownIdByUserId(@Param("propertyId") Long propertyId); }