SpringBoot（二）：分页插件，SQL映射文件的标准格式

编写：HorinJsor

• 前言
• 一、SQL映射文件
• 二、分页插件
• • 1.引入依赖
  • 2.逻辑层
• 总结

介绍分页插件，SQL映射文件的标准增删改查。

提示：以下是本篇文章正文内容，下面案例可供参考

可以当一个模板使用。

    

    
    
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
    

    
    
        INSERT INTO leaves(leave_type,leave_details,leave_address,leave_start,leave_end,
                           leave_submit,leave_approval,leave_review,
                           create_user,create_time,modified_user,modified_time,teacher_id,student_id,leave_state)
        VALUES(#{leaveType}, #{leaveDetails}, #{leaveAddress}, #{leaveStart}, #{leaveEnd}, #{leaveSubmit}, #{leaveApproval}, #{leaveReview}, #{createUser}, #{createTime}, #{modifiedUser}, #{modifiedTime}, #{teacherId}, #{studentId}, #{leaveState}  )

    

    
    
        DELETE from leaves WHERe leave_id = #{leaveId}
    

    
    
        UPDATE `leaves`
        
            
                leave_type = #{leaveType},
            
            
                leave_details = #{leaveDetails},
            
            
                leave_address = #{leaveAddress},
            
            
                leave_start = #{leaveStart},
            
            
                leave_end = #{leaveEnd},
            
            
                leave_submit = #{leaveSubmit},
            
            
                leave_approval = #{leaveApproval},
            
            
                leave_review = #{leaveReview},
            
            
                create_user = #{createUser},
            
            
                create_time = #{createTime},
            
            
                modified_user = #{modifiedUser},
            
            
                modified_time = #{modifiedTime},
            
            
                teacher_id = #{teacherId},
            
            
                student_id = #{studentId},
            
            
                leave_state = #{leaveState},
            
        

        WHERe `leave_id` =#{leaveId};

    

    
    
        UPDATE `leaves`
        
            
                leave_approval = #{leaveApproval},
            
            
                leave_Review = #{leaveReview},
            
        

        WHERe `leave_id` =#{leaveId};

    

    
    

        SELECT
            `leaves`.*,
            student.student_name,
            student.student_departments,
            student.student_professional,
            student.student_class,
            student.student_id,
            classes.class_grade,
            teacher.teacher_name
        FROM
            `leaves`
                INNER JOIN
            student
            ON
                `leaves`.student_id = student.student_id
                INNER JOIN
            classes
            ON
                classes.class_id = student.student_class
                INNER JOIN
            teacher
            ON
                `leaves`.teacher_id = teacher.teacher_id

    

    
    
        SELECT
        `leaves`.*,
        student.student_name,
        student.student_departments,
        student.student_professional,
        student.student_class,
        student.student_id,
        classes.class_grade,
        teacher.teacher_name
        FROM
        `leaves`
        INNER JOIN
        student
        ON
        `leaves`.student_id = student.student_id
        INNER JOIN
        classes
        ON
        classes.class_id = student.student_class
        INNER JOIN
        teacher
        ON
        `leaves`.teacher_id = teacher.teacher_id


        

            
            
            
                AND DATE_FORMAT(leave_submit, '%Y-%m-%d %H:%i:%s') ">>= DATE_FORMAT(#{leaveQueryStart}, '%Y-%m-%d %H:%i:%s')
            
            
                AND DATE_FORMAT(leave_submit, '%Y-%m-%d %H:%i:%s') <= DATE_FORMAT(#{leaveQueryEnd}, '%Y-%m-%d %H:%i:%s')
            
            
            
                AND student.student_departments = #{studentDepartments}
            
            
            
                AND student.student_professional = #{studentProfessional}
            
            
            
                AND classes.class_grade = #{classGrade}
            
            
            
                AND student.student_class = #{studentClass}
            
            
            
                AND leaves.student_id = #{studentId}
            
            
            
                AND student.student_name = #{studentName}
            
            
            
                AND leaves.leave_Type = #{leaveType}
            
            
            
                AND leaves.leave_approval = #{leaveApproval}
            
            
            
                AND teacher.teacher_name = #{teacherName}
            
            
            
                AND leaves.leave_submit = #{leaveSubmit}
            

        

    


    
    

        SELECT
            `leaves`.*,
            student.student_name,
            student.student_departments,
            student.student_professional,
            student.student_class,
            student.student_id,
            classes.class_grade,
            teacher.teacher_name
        FROM
            `leaves`
                INNER JOIN
            student
            ON
                `leaves`.student_id = student.student_id
                INNER JOIN
            classes
            ON
                classes.class_id = student.student_class
                INNER JOIN
            teacher
            ON
                `leaves`.teacher_id = teacher.teacher_id

        WHERe `leave_id` = #{leaveId};

    

    
    
        SELECT
            depart_name
        FROM
            depart
    

    
    
        SELECT
            teacher_name
        FROM
            teacher
    


    
    
        SELECT
            major_name
        FROM
            major
    

    
    
        SELECT
            class_grade
        FROM
            classes
    

    
    
        SELECT
            class_id
        FROM
            classes
    

    
    
        SELECT
            teacher.teacher_id
        FROM
            student
                INNER JOIN
            group_student
            ON
                student.student_id = group_student.student_id
                INNER JOIN
            group_teacher
            ON
                group_student.group_id = group_teacher.group_id
                INNER JOIN
            teacher
            ON
                teacher.teacher_id = group_teacher.teacher_id

        where student.student_id = #{stuId}
    

    
    
        SELECT
            `leaves`.teacher_id
        FROM
            `leaves`

        WHERe leave_id = #{leaveId}
    

代码如下（示例）：

       com.github.pagehelper
       pagehelper-spring-boot-starter
       1.4.2

代码如下（示例）：

@GetMapping("/query")
    public Result selectLeaveByCondition(@RequestBody LeavesVo leavesVo,
                                         @RequestParam(value = "pageNum",defaultValue ="1") Integer pageNum,
                                         @RequestParam(value ="pageSize",defaultValue ="10") Integer pageSize) {
		
        PageHelper.startPage(pageNum, pageSize);//启动
        List a = leavesMapper.selectLeaveByCondition(leavesVo);
        PageInfo leavesPoPageInfo = new PageInfo<>(a);//导入结果对象
        System.out.println("leavesPoPageInfo = " + leavesPoPageInfo);//控制台测试
        if (a != null){
            Result> result = Result.success(200,"查询成功", leavesPoPageInfo);
            return result;
        }else {
            Result result = Result.error(500,"查询失败");
            return result;
        }

    }

分页插件最新版本查看
https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper-spring-boot-starter