01 : MyBatis - 2 기본 보기

Notice

Recent Posts

Recent Comments

Link 😐

원 블로그

« 2024/05 »
일	월	화	수	목	금	토
			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

Tags 😝 more

Archives 🤔

Today

Total

관리 메뉴

KKH_RECORDS

01 : MyBatis - 2 기본 보기 본문

Records 1 : Study/Framework

01 : MyBatis - 2 기본 보기

피아노치는 개발자, kkim 2020. 3. 18. 16:23

index, 회원가입, 로그인, 내 정보 보기, 비밀번호 수정, 내 정보 수정 기능을 포함합니다.

Category :

web
= js
: jquery-3.4.1.min.js
= META-INF (skip)
= resources
- images
: MyBatis.jpg
= views
- board (empty)
- common
: errorPage.jsp
: menubar.jsp
- member
: memberInfo.jsp
: memberInsertForm.jsp
: memberPwdUpdateVIew.jsp
: memberUpdateForm.js
= WEB-INF
- classes (skip)
- lib
: mybatis-3.5.4.jar
: ojdbc6.jar
: taglibs-standard-compat-1.2.5.jar
: taglibs-standard-impl-1.2.5.jar
: taglibs-standard-jstlel-1.2.5jar
: taglibs-standard-spec-1.2.5.jar
src
= board
- controller
- model
- dao
- exception
- service
- vo
= common
: Template.java
= filter
: CommonFilter.java
= member
- controller (empty)
- model
- dao (empty)
- exception (empty)
- service (empty)
- vo (empty)
resources
: mybatis-config.xml
: driver.properties
= mapper
: member-mapper.xml

SQL File (Oracle DB)

CREATE USER MyBatis IDENTIFIED BY MyBatis ;
-- Grant는 직접 해주시길...!

DROP TABLE REPLY;
DROP TABLE BOARD;
DROP TABLE MEMBER;

DROP SEQUENCE SEQ_BID;
DROP SEQUENCE SEQ_RID;

--------------------------------------------------
--------------     MEMBER 관련	------------------	
--------------------------------------------------

CREATE TABLE MEMBER (
  USER_ID VARCHAR2(30) PRIMARY KEY,
  USER_PWD VARCHAR2(100) NOT NULL,
  USER_NAME VARCHAR2(30) NOT NULL,
  NICKNAME VARCHAR2(30) NOT NULL,
  EMAIL VARCHAR2(100),
  BIRTHDAY DATE,
  GENDER VARCHAR2(1) CHECK (GENDER IN('M', 'F')),
  PHONE VARCHAR2(13),
  ADDRESS VARCHAR2(100),
  ENROLL_DATE DATE DEFAULT SYSDATE,
  UPDATE_DATE DATE DEFAULT SYSDATE,
  M_STATUS VARCHAR2(1) DEFAULT 'Y' CHECK(M_STATUS IN('Y', 'N'))
);

INSERT INTO MEMBER 
VALUES ('admin', '1234', '관리자', '운영자', 'admin@kh.or.kr', '19800918', 'F', '010-1111-2222', '서울시 강남구 역삼동', '20180101', '20180101', DEFAULT);

INSERT INTO MEMBER 
VALUES ('user01', 'pass01', '홍길동', '미스터홍', 'user01@kh.or.kr', '19900213', 'M','010-3333-4444', '서울시 양천구 목동', '20180201', '20180202', DEFAULT);

COMMIT;



----------------------------------------------------
-----------------     BOARD 관련        ------------------	
----------------------------------------------------

CREATE TABLE BOARD(
  BID NUMBER PRIMARY KEY,
  BTYPE NUMBER, 
  BTITLE VARCHAR2(100) NOT NULL,
  BCONTENT VARCHAR2(4000),
  BWRITER VARCHAR2(30),
  BCOUNT NUMBER DEFAULT 0,
  B_CREATE_DATE DATE,
  B_MODIFY_DATE DATE,
  B_STATUS VARCHAR2(1) DEFAULT 'Y' CHECK (B_STATUS IN('Y', 'N')),
  FOREIGN KEY (BWRITER) REFERENCES MEMBER
);

CREATE SEQUENCE SEQ_BID;

INSERT INTO BOARD 
VALUES(SEQ_BID.NEXTVAL, 1, '첫번째 게시판 서비스를 시작하겠습니다.', '안녕하세요. 첫 게시판입니다.', 'admin', DEFAULT, '20180210', '20180210', DEFAULT);

INSERT INTO BOARD 
VALUES(SEQ_BID.NEXTVAL, 1, '두번째 게시판 서비스를 시작하겠습니다.', '안녕하세요. 2 게시판입니다.', 'user01', DEFAULT, '20180211', '20180211', DEFAULT);

INSERT INTO BOARD 
VALUES(SEQ_BID.NEXTVAL, 1, '하이 에브리원 게시판 서비스를 시작하겠습니다.', '안녕하세요. 3 게시판입니다.', 'admin', DEFAULT, '20180212', '20180212', DEFAULT);

INSERT INTO BOARD 
VALUES(SEQ_BID.NEXTVAL, 1, '안녕.. 마이바티스는 처음이지?', '안녕하세요. 첫 게시판입니다.', 'user01', DEFAULT, '20180220', '20180220', DEFAULT);

INSERT INTO BOARD 
VALUES(SEQ_BID.NEXTVAL, 1, '어서와 ㅎㅎㅎㅎ', '반갑습니다.', 'admin', DEFAULT, '20180220', '20180220', DEFAULT);

INSERT INTO BOARD 
VALUES(SEQ_BID.NEXTVAL, 1, '페이징 처리때문에 샘플데이터 많이 넣어놓는다...', '안녕하십니까', 'admin', DEFAULT, '20180221', '20180221', DEFAULT);

INSERT INTO BOARD 
VALUES(SEQ_BID.NEXTVAL, 1, '게시판 서비스', '안녕하세요. 게시판입니다.', 'admin', DEFAULT, '20180221', '20180221', DEFAULT);

INSERT INTO BOARD 
VALUES(SEQ_BID.NEXTVAL, 1, '샘플데이터들 ', '안녕하세요.', 'user01', DEFAULT, '20180224', '20180225', DEFAULT);

INSERT INTO BOARD 
VALUES(SEQ_BID.NEXTVAL, 1, '모두들 화이팅!!', '화이팅 하세요!!', 'admin', DEFAULT, '20180301', '20180301', DEFAULT);

INSERT INTO BOARD 
VALUES(SEQ_BID.NEXTVAL, 1, '힘내세요!!!', ' 게시판입니다.', 'admin', DEFAULT, '20180301', '20180301', DEFAULT);

INSERT INTO BOARD 
VALUES(SEQ_BID.NEXTVAL, 1, '게시판 서비스', '프레임워크는 처음이지?', 'admin', DEFAULT, '20180301', '20180301', DEFAULT);

INSERT INTO BOARD 
VALUES(SEQ_BID.NEXTVAL, 1, '시작하겠습니다.', '지금부터 시작!!', 'user01', DEFAULT, '20181021', '20181021', DEFAULT);

INSERT INTO BOARD 
VALUES(SEQ_BID.NEXTVAL, 1, '마지막 게시판 시작하겠습니다.', '안녕하세요. 마지막 게시판입니다.', 'admin', DEFAULT, '20181021', '20181021', DEFAULT);



----------------------------------------------------
----------------    REPLY 관련         -------------------	
----------------------------------------------------

CREATE TABLE REPLY(
  RID NUMBER PRIMARY KEY,
  RCONTENT VARCHAR2(400),
  REF_BID NUMBER,
  RWRITER VARCHAR2(30),
  R_CREATE_DATE DATE,
  R_MODIFY_DATE DATE,
  R_STATUS VARCHAR2(1) DEFAULT 'Y' CHECK (R_STATUS IN ('Y', 'N')),
  FOREIGN KEY (REF_BID) REFERENCES BOARD,
  FOREIGN KEY (RWRITER) REFERENCES MEMBER
);

CREATE SEQUENCE SEQ_RID;

INSERT INTO REPLY
VALUES(SEQ_RID.NEXTVAL, '첫번째 댓글입니다.', 1, 'user01', '20180213', '20180213', DEFAULT);

INSERT INTO REPLY
VALUES(SEQ_RID.NEXTVAL, '첫번째 댓글입니다.', 13, 'user01', '20181030', '20181030', DEFAULT);

INSERT INTO REPLY
VALUES(SEQ_RID.NEXTVAL, '두번째 댓글입니다.', 13, 'user01', '20181030', '20181030', DEFAULT);

INSERT INTO REPLY
VALUES(SEQ_RID.NEXTVAL, '마지막 댓글입니다.', 13, 'user01', '20181030', '20181030', DEFAULT);



COMMIT;

MyBatis.sql

0.00MB