springboot—Mapper注解版—多个参数查询需要加上@Param

@Mapper
public interface UserMapper {
    @Select("select * from t_user where id = #{id}")
    public User getUserById(Integer id);


    @Options(useGeneratedKeys = true,keyProperty = "id") //加入自增主键
    @Insert("insert into t_user(username,password,employeeNum,departmentId) values(#{username},#{password},#{employeeNum},#{departmentId})")
    public int insertUser(User user);

    @Delete("delete from t_user where id=#{id}")
    public int deleteById(Integer id);

    @Update("update t_user set username=#{username},password=#{password} where id=#{id}")
    public int updateUser(User user);

    @Select("select * from t_user")
    public List<User> getALLUsers();

    @Select("select u.*,r.rolename from t_user u left join t_role_user ru on u.id=ru.user_id left join t_role r on ru.role_id=r.id where username=#{username}")
    public List<Role> findByUserName(String username);


    @Select("select * from t_user where username like CONCAT('%',#{name},'%') and employeeNum like CONCAT('%',#{num},'%')")
    public List<User> searchUsers(@Param("name") String name,@Param("num") String num);

    @Select("select * from t_user where employeeNum like CONCAT('%',#{employeeNum},'%')")
    public List<User> searchUsersNum(String employeeNum);
}

  注意：多个条件进行查询时，需要加上@Param,否则查询无效

@Select("select * from t_user where username like CONCAT('%',#{name},'%') and employeeNum like CONCAT('%',#{num},'%')")
    public List<User> searchUsers(@Param("name") String name,@Param("num") String num);