From 871d4095b07cedacb7fbef4c38d64982f539c404 Mon Sep 17 00:00:00 2001 From: fei.wang <wf18701153496@163.com> Date: 星期四, 09 五月 2024 15:40:15 +0800 Subject: [PATCH] 测试提交 --- src/main/java/com/flow/mapper/TbFuwuqiMapper.java | 20 ++++++++++++++++++++ 1 files changed, 20 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/flow/mapper/TbFuwuqiMapper.java b/src/main/java/com/flow/mapper/TbFuwuqiMapper.java new file mode 100644 index 0000000..965be7a --- /dev/null +++ b/src/main/java/com/flow/mapper/TbFuwuqiMapper.java @@ -0,0 +1,20 @@ +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); +} -- Gitblit v1.9.3