답변형 게시판 제작
|
<답변형 게시판 테이블> 게시물 번호 |
CREATE TABLE reply_board( —답변형 게시판
no NUMBER,
name VARCHAR2(34) CONSTRAINT rb_nn_name NOT NULL,
email VARCHAR2(50),
subject VARCHAR2(1000) CONSTRAINT rb_nn_sub NOT NULL,
content CLOB CONSTRAINT rb_nn_cont NOT NULL,
pwd VARCHAR2(10) CONSTRAINT rb_nn_pwd NOT NULL,
regdate DATE DEFAULT SYSDATE,
hit NUMBER DEFAULT 0,
group_id NUMBER,
group_step NUMBER,
group_tab NUMBER,
root NUMBER,
depth NUMBER,
CONSTRAINT rb_pk_no PRIMARY KEY(no)
);
INSERT INTO reply_board VALUES(
(SELECT NVL(MAX(no)+1,1) FROM reply_board),
‘홍길동‘,”,‘답변형 게시판 연습중‘,‘답변형 게시판 연습중‘,‘1234’,SYSDATE,0,1,0,0,0,0);
INSERT INTO reply_board VALUES(
(SELECT NVL(MAX(no)+1,1) FROM reply_board),
‘홍길동‘,”,‘답변형 게시판 연습중‘,‘답변형 게시판 연습중‘,‘1234’,SYSDATE,0,2,0,0,0,0);
INSERT INTO reply_board VALUES(
(SELECT NVL(MAX(no)+1,1) FROM reply_board),
‘홍길동‘,”,‘답변형 게시판 연습중‘,‘답변형 게시판 연습중‘,‘1234’,SYSDATE,0,3,0,0,0,0);
INSERT INTO reply_board VALUES(
(SELECT NVL(MAX(no)+1,1) FROM reply_board),
‘홍길동‘,”,‘답변형 게시판 연습중‘,‘답변형 게시판 연습중‘,‘1234’,SYSDATE,0,4,0,0,0,0);
INSERT INTO reply_board VALUES(
(SELECT NVL(MAX(no)+1,1) FROM reply_board),
‘홍길동‘,”,‘답변형 게시판 연습중‘,‘답변형 게시판 연습중‘,‘1234’,SYSDATE,0,5,0,0,0,0);
INSERT INTO reply_board VALUES(
(SELECT NVL(MAX(no)+1,1) FROM reply_board),
‘홍길동‘,”,‘답변형 게시판 연습중‘,‘답변형 게시판 연습중‘,‘1234’,SYSDATE,0,6,0,0,0,0);
INSERT INTO reply_board VALUES(
(SELECT NVL(MAX(no)+1,1) FROM reply_board),
‘홍길동‘,”,‘답변형 게시판 연습중‘,‘답변형 게시판 연습중‘,‘1234’,SYSDATE,0,7,0,0,0,0);
INSERT INTO reply_board VALUES(
(SELECT NVL(MAX(no)+1,1) FROM reply_board),
‘홍길동‘,”,‘답변형 게시판 연습중‘,‘답변형 게시판 연습중‘,‘1234’,SYSDATE,0,8,0,0,0,0);
INSERT INTO reply_board VALUES(
(SELECT NVL(MAX(no)+1,1) FROM reply_board),
‘홍길동‘,”,‘답변형 게시판 연습중‘,‘답변형 게시판 연습중‘,‘1234’,SYSDATE,0,9,0,0,0,0);
INSERT INTO reply_board VALUES(
(SELECT NVL(MAX(no)+1,1) FROM reply_board),
‘홍길동‘,”,‘답변형 게시판 연습중‘,‘답변형 게시판 연습중‘,‘1234’,SYSDATE,0,10,0,0,0,0);
INSERT INTO reply_board VALUES(
(SELECT NVL(MAX(no)+1,1) FROM reply_board),
‘홍길동‘,”,‘답변형 게시판 연습중‘,‘답변형 게시판 연습중‘,‘1234’,SYSDATE,0,11,0,0,0,0);
INSERT INTO reply_board VALUES(
(SELECT NVL(MAX(no)+1,1) FROM reply_board),
‘홍길동‘,”,‘답변형 게시판 연습중‘,‘답변형 게시판 연습중‘,‘1234’,SYSDATE,0,12,0,0,0,0);
INSERT INTO reply_board VALUES(
(SELECT NVL(MAX(no)+1,1) FROM reply_board),
‘홍길동‘,”,‘답변형 게시판 연습중‘,‘답변형 게시판 연습중‘,‘1234’,SYSDATE,0,13,0,0,0,0);
INSERT INTO reply_board VALUES(
(SELECT NVL(MAX(no)+1,1) FROM reply_board),
‘홍길동‘,”,‘답변형 게시판 연습중‘,‘답변형 게시판 연습중‘,‘1234’,SYSDATE,0,14,0,0,0,0);
INSERT INTO reply_board VALUES(
(SELECT NVL(MAX(no)+1,1) FROM reply_board),
‘홍길동‘,”,‘답변형 게시판 연습중‘,‘답변형 게시판 연습중‘,‘1234’,SYSDATE,0,15,0,0,0,1);
INSERT INTO reply_board VALUES(
(SELECT NVL(MAX(no)+1,1) FROM reply_board),
‘홍길동‘,”,‘답변형 게시판 연습중‘,‘답변형 게시판 연습중‘,‘1234’,SYSDATE,0,16,1,1,16,1);
INSERT INTO reply_board VALUES(
(SELECT NVL(MAX(no)+1,1) FROM reply_board),
‘홍길동‘,”,‘답변형 게시판 연습중‘,‘답변형 게시판 연습중‘,‘1234’,SYSDATE,0,16,1,1,16,1);
INSERT INTO reply_board VALUES(
(SELECT NVL(MAX(no)+1,1) FROM reply_board),
‘홍길동‘,”,‘답변형 게시판 연습중‘,‘답변형 게시판 연습중‘,‘1234’,SYSDATE,0,16,2,2,17,0);
COMMIT;
SELECT * FROM reply_board
ORDER BY group_id DESC, group_step ASC;
//예비
//DELETE FROM reply_board;
//SELECT * FROM reply_board;
1. DTO 만들기
2. DAO 기본사항 만들기
private Connection conn;
private PreparedStatement ps;
private final String URL=“jdbc:oracle:thin:@localhost:1521:ORCL”;
private final String DRIVER=“oracle.jdbc.driver.OracleDriver“;
public 클래스이름(){ //생성자에 만드는 이유(한번만 실행)
try{
Class.forName(DRIVER);
}catch(Exception ex){System.out.println(ex.getMessage());}
}
public void getConnection(){
try{
conn=DriverManager.getConnection(URL,“scott”,“tiger“);
}catch(Exception ex){System.out.println(ex.getMessage());}
}
public void disConnection(){
try{
if(ps!=null) ps.close();
if(conn!=null) conn.close();
}catch(Exception ex){System.out.println(ex.getMessage());}
}