-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathBoardDao.java
More file actions
92 lines (87 loc) · 3.25 KB
/
Copy pathBoardDao.java
File metadata and controls
92 lines (87 loc) · 3.25 KB
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
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
package mvc;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
public class BoardDao {
//insert here - 객체 주입코드 - myBatis Layer - 생성자 호출(인스턴스화)
/*******************************************************************
* 글쓰기 구현하기
* INSERT INTO mvc_board values(seq_board_no.nextval, '글제목', '작성자', '내용', 0,
* '2024-11-20') : 1 row inserted;
* @param pbvo
* @return int
******************************************************************/
public int boardInsert(BoardVO pbvo) {
System.out.println("Board Insert called");
int result = -1;
return result;
}
/*******************************************************************
* 글수정 구현하기
--UPDATE mvc_board
-- SET b_title = ?
-- ,b_content = ?
-- ,b_date = to_char(sysdate, 'YYYY-MM-DD')
-- WHERE b_no = ?;
* @param pbvo
* @return int
******************************************************************/
public int boardUpdate(BoardVO pbvo) {
System.out.println("Board Update called");
int result = -1;
return result;
}
/*******************************************************************
* 글삭제 구현하기
-- DELETE FROM mvc_board WHERE b_no = ?;
* @param b_no
* @return int
******************************************************************/
public int boardDelete(int b_no) {
System.out.println("Board Delete called");
int result = -1;
return result;
}
/*******************************************************************
* 글 상세 보기 구현하기
* SELECT b_no, b_title, b_writer, b_content, b_hit, b_date
* FROM mvc_board
* WHERE b_no =:u_no;
* @param b_no
* @return Map
******************************************************************/
public Map<String,Object> boardDetail(int b_no){
System.out.println("Board Detail called");
Map<String,Object> rmap = new HashMap<String,Object>();
rmap.put("b_no", 1);
rmap.put("b_title", "글제목1");
rmap.put("b_writer", "강감찬");
rmap.put("b_content", "글 내용");
return rmap;
}
/*******************************************************************
* 전체 조회 구현하기(조건검색 포함)
* SELECT b_no, b_title, b_writer, b_content, b_hit, b_date
* FROM mvc_board
* WHERE b_title LIKE '%'||?||'%'
* AND b_no > 5
* @param pbvo
* @return list
******************************************************************/
public List<Map<String,Object>> boardList(BoardVO pbvo){
System.out.println("BoardDao boardList called");
List<Map<String,Object>> list = new ArrayList<Map<String,Object>>();
Map<String,Object> rmap = new HashMap<>();
rmap.put("b_no", 1);
rmap.put("b_title", "글제목1");
rmap.put("b_writer", "강감찬");
list.add(rmap);
rmap = new HashMap<>();
rmap.put("b_no", 2);
rmap.put("b_title", "글제목2");
rmap.put("b_writer", "이성계");
list.add(rmap);
return list;
}
}