1、 实现controller
在service_ucenter模块中的UcenterMemberController添加方法。
@ApiOperation(value = "统计某一天注册人数，统计分析远程调用")
@GetMapping("countRegister/{day}")
public R countRegister(@PathVariable String day){
Integer count = ucenterService.countRegister(day);
return R.ok().data("registerCount",count);
}
2、在UcenterMemberService中添加接口方法
Integer countRegister(String day);
3、在UcenterMemberServiceImpl中实现接口方法
/
/统计某一天注册人数，统计分析远程调用
@Override
public Integer countRegister(String day) {
Integer count = baseMapper.countRegister(day);
return count;
}
4、在UcenterMemberMapper中添加接口
package com.atguigu.ucenterservice.mapper;
import com.atguigu.ucenterservice.entity.UcenterMember;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
public interface UcenterMemberMapper extends BaseMapper<UcenterMember> {
Integer countRegister(String day);
}
5、在UcenterMemberMapper.xml中实现接口
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.atguigu.ucenterservice.mapper.UcenterMemberMapper">
<select id="countRegister" resultType="java.lang.Integer">
SELECT COUNT(*) FROM ucenter_member um
WHERE DATE(um.`gmt_create`)=#{day}
</select>
</mapper>
