From 97b74f99421ae0af00b3dcfa5c875a15ec287e6d Mon Sep 17 00:00:00 2001 From: wang-hao-jie <1550036656@qq.com> Date: 星期四, 25 十一月 2021 13:35:38 +0800 Subject: [PATCH] 修改 --- xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/DrivingRecordMapper.java | 20 ++++++++++++++++++++ 1 files changed, 20 insertions(+), 0 deletions(-) diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/DrivingRecordMapper.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/DrivingRecordMapper.java new file mode 100644 index 0000000..248ce3e --- /dev/null +++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/DrivingRecordMapper.java @@ -0,0 +1,20 @@ +package cn.exrick.xboot.your.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import cn.exrick.xboot.your.entity.DrivingRecord; +import org.apache.ibatis.annotations.Select; + +import java.util.List; + +/** + * 琛岃溅璁板綍鏁版嵁澶勭悊灞� + * @author zhangzeli + */ +public interface DrivingRecordMapper extends BaseMapper<DrivingRecord> { + + @Select("select max(mileage) from t_driving_record where user_id=#{userId}") + Integer maxByUserId(String userId); + + @Select("select min(mileage) from t_driving_record where user_id=#{userId}") + Integer minByUserId(String userId); +} \ No newline at end of file -- Gitblit v1.9.1