반응형
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>
반응형
'SPRING' 카테고리의 다른 글
[JSP, JSTL] JSP가 무엇인가, JSTL 태그 사용법 (0) | 2021.08.05 |
---|---|
스프링 부트로 만든 Restful API 서버와 안드로이드 Retrofit2 통신 (0) | 2021.07.11 |
[스프링] c:choose로 상태에 따른 값 출력하는 법 (0) | 2021.06.11 |
c:forEach : var, items, varStatus 정리 (0) | 2021.06.11 |
[오류 해결] The import org.springframework.test cannot be resolved (0) | 2021.05.30 |