기존(310)/🏀Jsp
[JSP] 게시판 조회수 구현
조각남자
2022. 5. 31. 09:40
jsp 회원등록,수정,삭제,리스트(CRUD) 로직 구현하기 게시판 조회수
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
public void boardCnt(int bidx) { // 게시판 조회수
int cnt = 0 ;
int rs = 0;
String sql = "update board SET HIT =(HIT+1) where bidx = ?";
try {
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, bidx);
rs = pstmt.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
}
|
cs |
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
public BoardVo boardSelectOne(int bidx) {
boardCnt(bidx); // 글작성 조회수 같이 실행해주기.. 같은 bidx 이니 글내용볼때 증가시켜주기 !!
BoardVo bv = null;
ResultSet rs= null;
String sql="select * from board where bidx=?";
try {
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, bidx);
rs = pstmt.executeQuery();
if(rs.next()) {
bv = new BoardVo();
bv.setBidx(rs.getInt("bidx"));
bv.setOriginbidx(rs.getInt("originbidx"));
bv.setDepth(rs.getInt("depth"));
bv.setLevel_(rs.getInt("level_"));
bv.setSubject(rs.getString("subject"));
bv.setContent(rs.getString("content"));
bv.setWriter(rs.getString("writer"));
bv.setWriteday(rs.getString("writeday"));
bv.setFilename(rs.getString("filename"));
bv.setHit(rs.getInt("hit"));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
rs.close();
pstmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return bv;
}
|
cs |