Fluent Mybatis实际开发中的优势对比

create table `student_score`

(

     id           bigint auto_increment comment '主键ID' primary key ,

     student_id   bigint             not null comment '学号' ,

     gender_man   tinyint default 0 not null comment '性别, 0:女; 1:男' ,

     school_term  int                null comment '学期' ,

     subject      varchar (30)       null comment '学科' ,

     score        int                null comment '成绩' ,

     gmt_create   datetime          not null comment '记录创建时间' ,

     gmt_modified datetime          not null comment '记录最后修改时间' ,

     is_deleted   tinyint default 0 not null comment '逻辑删除标识'

) engine = InnoDB default charset=utf8;

select school_term, subject, count (score), min (score), max (score), avg (score)

from student_score

where school_term between 2000 and 2019

   and subject in ( '英语' , '数学' , '语文' )

   and is_deleted = 0

group by school_term, subject

order by school_term, subject

@Data

public class ScoreStatistics {

     private int schoolTerm;

     private String subject;

     private long count;

     private Integer minScore;

     private Integer maxScore;

     private BigDecimal avgScore;

}

public interface StudentScoreDao extends IBaseDao<StudentScoreEntity> {

     /**

      * 统计从fromYear到endYear年间学科subjects的统计数据

      *

      * @param fromYear 统计年份区间开始

      * @param endYear  统计年份区间结尾

      * @param subjects 统计的学科列表

      * @return 统计数据

      */

     List<ScoreStatistics> statistics( int fromYear, int endYear, String[] subjects);

}

@Repository

public class StudentScoreDaoImpl extends StudentScoreBaseDao implements StudentScoreDao {

     @Override

     public List<ScoreStatistics> statistics( int fromSchoolTerm, int endSchoolTerm, String[] subjects) {

         return super .listPoJos(ScoreStatistics. class , super .query()

             .select.schoolTerm().subject()

             .count( "count" )

             .min.score( "min_score" )

             .max.score( "max_score" )

             .avg.score( "avg_score" )

             .end()

             .where.isDeleted().isFalse()

             .and.schoolTerm().between(fromSchoolTerm, endSchoolTerm)

             .and.subject().in(subjects)

             .end()

             .groupBy.schoolTerm().subject().end()

             .orderBy.schoolTerm().asc().subject().asc().end()

         );

     }

}

@RunWith (SpringRunner. class )

@SpringBootTest (classes = QuickStartApplication. class )

public class StudentScoreDaoImplTest {

     @Autowired

     private StudentScoreDao dao;

     @Test

     public void statistics() {

         List<ScoreStatistics> list = dao.statistics( 2000 , 2019 , new String[]{ "语文" , "数学" , "英语" });

         System.out.println(list);

     }

}