hust-epi/whepi-web/src/main/java/com/bofeng/dao/OwnerMapper.java

package com.bofeng.dao;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.bofeng.entity.Owner;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface OwnerMapper extends BaseMapper<Owner> {

    @Select("select * from sys_owner where uptown_id = #{uptownId}")
    List<Owner> getOwnerByUptownId(@Param("uptownId") Long uptownId);

    @Select("select * from sys_owner where phone = #{phone}")
    List<Owner> getOwnerByPhone(@Param("phone") String phone);
}