<insert id="boardCreate" parameterClass="java.util.Map">
CREATE TABLE $boardTitle$ (
BOARD_NUM INTEGER NOT NULL,
BOARD_NAME VARCHAR2(20 BYTE) NOT NULL,
BOARD_PASS VARCHAR2(15 BYTE) NOT NULL,
BOARD_EMAIL VARCHAR2(30 BYTE),
BOARD_SUBJECT VARCHAR2(50 BYTE) NOT NULL,
BOARD_CONTENT VARCHAR2(2000 BYTE) NOT NULL,
BOARD_RE_REF INTEGER NOT NULL,
BOARD_RE_LEV INTEGER NOT NULL,
BOARD_RE_SEQ INTEGER NOT NULL,
BOARD_READCOUNT INTEGER NOT NULL,
BOARD_DATE DATE NOT NULL,
BOARD_FILE VARCHAR2(50 BYTE),
PRIMARY KEY (BOARD_NUM) )
</insert>
CREATE TABLE $boardTitle$ (
BOARD_NUM INTEGER NOT NULL,
BOARD_NAME VARCHAR2(20 BYTE) NOT NULL,
BOARD_PASS VARCHAR2(15 BYTE) NOT NULL,
BOARD_EMAIL VARCHAR2(30 BYTE),
BOARD_SUBJECT VARCHAR2(50 BYTE) NOT NULL,
BOARD_CONTENT VARCHAR2(2000 BYTE) NOT NULL,
BOARD_RE_REF INTEGER NOT NULL,
BOARD_RE_LEV INTEGER NOT NULL,
BOARD_RE_SEQ INTEGER NOT NULL,
BOARD_READCOUNT INTEGER NOT NULL,
BOARD_DATE DATE NOT NULL,
BOARD_FILE VARCHAR2(50 BYTE),
PRIMARY KEY (BOARD_NUM) )
</insert>
'Java' 카테고리의 다른 글
UTF-8로 개발환경을 도배하자. (0) | 2009.12.10 |
---|---|
파일업로드 실습 (0) | 2009.11.28 |
iBatis에서 테이블 생성하기 - 당근 퍼왔죠!! (0) | 2009.11.17 |
자바 정규 표현식 (0) | 2009.11.13 |
자바의 Exception (0) | 2009.11.06 |