MyBatis 注解排序分页示例

àì夳堔傛蜴生んèń 2023-09-25 12:22 1阅读 0赞

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