SPRING
[스프링 부트] int 값 받아오는 법
merryna
2021. 6. 19. 14:50
반응형
MemberController.Java
int MyCommentCnt = 0;
try {
MyCommentCnt = service.getMyCommentCnt(loginVO);
} catch (Exception e) {
e.printStackTrace();
}
model.addAttribute("MyCommentCnt",MyCommentCnt);
MemeberService.Java
public int getMyCommentCnt(MemberVO memberVO)throws Exception;
MemeberServiceImpl.Java
@Override
public int getMyCommentCnt(MemberVO memberVO)throws Exception{
return dao.getMyCommentCnt(memberVO);
}
MemberDao.Java
public int getMyCommentCnt(MemberVO memberVO)throws Exception;
MemberDaoImpl.Java
@Override
public int getMyCommentCnt(MemberVO memberVO)throws Exception{
return sql.selectOne("getMyCommentCnt", memberVO);
}
MemberMapper.xml
<select id="getMyCommentCnt" parameterType="memberVO" resultType="int">
<![CDATA[
SELECT COUNT(*)
FROM t_comment
WHERE co_user_id = #{me_id};
]]>
</select>
반응형