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}")