From 0f2202dfcea3309c1b0e7515f6db5fbdc83d51d1 Mon Sep 17 00:00:00 2001 From: wang-hao-jie <1550036656@qq.com> Date: 星期五, 07 一月 2022 11:06:51 +0800 Subject: [PATCH] 违章记录 --- xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/CustomerMapper.java | 3 +++ 1 files changed, 3 insertions(+), 0 deletions(-) diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/CustomerMapper.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/CustomerMapper.java index 24a4d60..ce1a54e 100644 --- a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/CustomerMapper.java +++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/CustomerMapper.java @@ -30,4 +30,7 @@ "sum(case when create_time < '${year}-12' then 1 else 0 end) as december\n" + "from t_customer") Month getCustomerCount(@Param("year")Integer year); + + @Select("select sum(login_num) from t_customer") + int sumLogin(); } \ No newline at end of file -- Gitblit v1.9.1