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>

 

반응형