1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
| package com.hxzk.mapper;
|
| import com.baomidou.mybatisplus.core.mapper.BaseMapper;
| import com.hxzk.pojo.TbZypSpace;
| import org.apache.ibatis.annotations.Param;
| import org.apache.ibatis.annotations.Select;
|
| import java.util.List;
|
| /**
| * <p>
| * 航锦化工受限空间安全作业证 Mapper 接口
| * </p>
| *
| * @author wangfei
| * @since 2024-04-22
| */
| public interface TbZypSpaceMapper extends BaseMapper<TbZypSpace> {
| // @Select({"SELECT * FROM tb_fuwuqi WHERE none = 0 and company LIKE CONCAT('%', #{company}, '%') or servername LIKE CONCAT('%', #{servername}, '%')"})
|
| @Select({"select * from tb_zyp_space where code LIKE CONCAT('%', #{code}, '%') or applicant LIKE CONCAT('%', #{applicant}, '%') ORDER BY createtime DESC"})
| public List<TbZypSpace> findSearch(@Param("code") String code, @Param("applicant") String applicant);
|
| }
|
|
