package com.flow.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.flow.pojo.TbFuwuqi;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
public interface TbFuwuqiMapper extends BaseMapper<TbFuwuqi> {
|
|
@Select({"select * from tb_fuwuqi where none = 0"})
|
List<TbFuwuqi> findAllUsers();
|
|
@Select({"select * from tb_fuwuqi where none = 0 and company = #{Zong}"})
|
List<TbFuwuqi> findTbFuwuqiZi(String var1);
|
|
@Select({"SELECT * FROM tb_fuwuqi WHERE none = 0 and company LIKE CONCAT('%', #{company}, '%') or servername LIKE CONCAT('%', #{servername}, '%')"})
|
List<TbFuwuqi> FindSearch(@Param("company") String var2,@Param("servername") String var3);
|
}
|
