1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
| package com.example.springboot.mapper;
|
| import com.example.springboot.entity.User;
| import org.apache.ibatis.annotations.*;
|
| import java.util.List;
|
| @Mapper
| public interface UserMapper {
|
| @Select("select * from user where name like concat('%',#{name},'%') or date like concat('%',#{name},'%') " +
| "or address like concat('%',#{name},'%') or user_no like concat('%',#{name},'%')")
| List<User> selectAll(String name);
|
| @Select("select * from user where name like concat('%',#{name},'%') or date like concat('%',#{name},'%') " +
| "or address like concat('%',#{name},'%') or user_no like concat('%',#{name},'%') order by id desc limit #{start},#{pageSize}")
| List<User> selectPage(@Param("name") String name, @Param("start") Integer start, @Param("pageSize") Integer pageSize);
|
| @Select("select count(id) from user where name like concat('%',#{name},'%') or date like concat('%',#{name},'%') " +
| "or address like concat('%',#{name},'%') or user_no like concat('%',#{name},'%')")
| Integer selectTotal(@Param("name") String name);
|
| @Insert("insert into user(name, date, address, user_no) values (#{name}, #{date}, #{address}, #{userNo})")
| void insert(User user);
|
| void update(User user);
|
| @Delete("delete from user where id = #{id}")
| void delete(Integer id);
| }
| //@Update("update user set name = #{name}, date = #{date}, address = #{address}, user_no = #{userNo} where id = #{id}")
|
|
