获取昨日登录人数

1.在HomepageMepping.xml文件中添加id=findNum
<select id="findNum" resultType="java.lang.String" parameterType="com.huarui.common.entity.web.Req">       
   select COUNT (*) as companypeople from HRSW_T_LOGINLOG t
   where  to_char(t.LLOG005,'yyyy/mm/dd')=to_char(sysdate-1,'yyyy/mm/dd')
</select>

2.HomepageServiceImpl记得添加参数

public String findNum(Req req) {
    return homepageMapper.findNum(req);
}

 3.HomepageMepper.javazhong 添加

 public List<HomepageEntity> findByPage(Req req) ;
    public Integer updateall(HomepageEntity homepageEntity);
    public String findNum(Req req);
}

4.在controller里面添加

@RequestMapping("/index")
public String index(Model model, Req req) {
    String peopleNum = homepageService.findNum(req);
    model.addAttribute("Companypeople",peopleNum);
    return BINDING_INDEX_ADDRESS;
}

5.在homepageservice添加

public String findNum(Req req);

6Mepping里面的路径一定要正确

 

<mapper namespace="com.huarui.dao.jdbc.focus.hpage.HomepageMapper">