public int p_new_count(String id) throws Exception; //사진첩 뉴 개수
public int p_count(String id) throws Exception; //사진첩 총 개수
public int b_new_count(String id) throws Exception; //게시판 뉴 개수
public int b_count(String id) throws Exception; //게시판 총 개수
public int v_new_count(String id) throws Exception; // 방명록 뉴 개수
public int v_count(String id) throws Exception; //방명록 총 개수
BoardDAOImpl
// 게시판별 게시물 수
@Override
public int p_new_count(String id) throws Exception {
return sqlSession.selectOne(namespace+".p_new_count", id);
}
@Override
public int p_count(String id) throws Exception {
return sqlSession.selectOne(namespace+".p_count", id);
}
@Override
public int b_new_count(String id) throws Exception {
return sqlSession.selectOne(namespace+".b_new_count", id);
}
@Override
public int b_count(String id) throws Exception {
return sqlSession.selectOne(namespace+".b_count", id);
}
@Override
public int v_new_count(String id) throws Exception {
return sqlSession.selectOne(namespace+".v_new_count", id);
}
@Override
public int v_count(String id) throws Exception {
return sqlSession.selectOne(namespace+".v_count", id);
}
BoardService
public int p_new_count(String id) throws Exception; //사진첩 뉴 개수
public int p_count(String id) throws Exception; //사진첩 총 개수
public int b_new_count(String id) throws Exception; //게시판 뉴 개수
public int b_count(String id) throws Exception; //게시판 총 개수
public int v_new_count(String id) throws Exception; // 방명록 뉴 개수
public int v_count(String id) throws Exception; //방명록 총 개수
BoardServiceImpl
@Override
public int p_new_count(String id) throws Exception {
return dao.p_new_count(id);
}
@Override
public int p_count(String id) throws Exception {
return dao.p_count(id);
}
@Override
public int b_new_count(String id) throws Exception {
return dao.b_new_count(id);
}
@Override
public int b_count(String id) throws Exception {
return dao.b_count(id);
}
@Override
public int v_new_count(String id) throws Exception {
return dao.v_new_count(id);
}
@Override
public int v_count(String id) throws Exception {
return dao.v_count(id);
}
BoardMapper
<!-- main 게시물 수 -->
<select id="p_new_count" resultType="int">
select count(*) from board where id=#{id} and tab='p' and (DATE(regdate) >= DATE_SUB(now(),INTERVAL 1 DAY))
</select>
<select id="p_count" resultType="int">
select count(*) from board where id=#{id} and tab='p'
</select>
<select id="b_new_count" resultType="int">
select count(*) from board where id=#{id} and tab='b' and (DATE(regdate) >= DATE_SUB(now(),INTERVAL 1 DAY))
</select>
<select id="b_count" resultType="int">
select count(*) from board where id=#{id} and tab='b'
</select>
<select id="v_new_count" resultType="int">
select count(*) from board where id=#{id} and tab='v' and (DATE(regdate) >= DATE_SUB(now(),INTERVAL 1 DAY))
</select>
<select id="v_count" resultType="int">
select count(*) from board where id=#{id} and tab='v'
</select>
BoardController
@GetMapping("/main")
public void mainGET( Model model, BoardVO b) throws Exception {
//logger.info("main start====");
// main 각 게시판의 게시물 수
int p_new_count = service.p_new_count(b.getId()); //new 개수
int p_count = service.p_count(b.getId()); //총 개수
int b_new_count = service.b_new_count(b.getId()); //new 개수
int b_count = service.b_count(b.getId()); //총 개수
int v_new_count = service.v_new_count(b.getId()); //new 개수
int v_count = service.v_count(b.getId()); //총 개수
model.addAttribute("p_new_count", p_new_count);
model.addAttribute("p_count", p_count);
model.addAttribute("b_new_count", b_new_count);
model.addAttribute("b_count", b_count);
model.addAttribute("v_new_count", v_new_count);
model.addAttribute("v_count", v_count);
}
