MyBatis 注解排序分页示例

package com.example.StudentCrud.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectKey;
import org.apache.ibatis.annotations.Update;

import com.example.StudentCrud.domain.Student;
import org.apache.ibatis.annotations.Param;

@Mapper		//Tells Spring Boot this is a myBatis class
public interface StudentMapper {

    @Select("select count(*) from student")
    int countAll();

    @Select("select * from student order by id desc")
    List<Student> listAll();

    @Select("select * from student order by ${sortField}  ${sortDir}")
    List<Student> listAllSort(@Param("sortField") String sortField, @Param("sortDir") String sortDir);

    @Select("select * from student order by ${sortField}  ${sortDir} LIMIT ${pageSize} OFFSET ${pageOffset}")
    List<Student> listAllSortPage(@Param("sortField") String sortField, @Param("sortDir") String sortDir, @Param("pageSize") Integer pageSize, @Param("pageOffset") Integer pageOffset);

    @Insert("insert into student(student_name, course, favourite_movie) values(#{student_name}, #{course}, #{favourite_movie})")
    @SelectKey(statement = "SELECT LAST_INSERT_ID()", keyProperty = "id", before = false, resultType = Long.class)
    void insert(Student student);

    @Update("update student set student_name = #{student_name}, course = #{course}, favourite_movie = #{favourite_movie} where id = #{id}")
    void update(Student student);

    @Delete("delete from student where id = #{id}")
    void delete(long id);
}