Home - YounggilLee/OmegaS GitHub Wiki

Welcome to the OmegaS wiki!

Application details,

The project is to build an application that allows users to write, view, and modify contents. Also, the user can reply comment as well. The purpose of the project is learning spring framework. The application consists of multiple view pages, and services classes with interface. One controller class is handle the services classes and view pages. DAO(Data Access Object) and DTO(Data Transfer Object) are handle database.

-Project Design for MVC Board with Spring- images/design.PNG

-Data Base Design- Oracle images/dbTable.PNG

-Query-

drop table mvc_board; drop sequence mvc_board_seq;

create table mvc_board ( bId number(4) primary key, bName varchar2(20), bTitle varchar2(100), bcontent varchar2(300), bDate date default sysdate, bHit number(4) default 0, bGroup number(4), bStep number(4), bIndent number(4) );

create sequence mvc_board_seq;

insert into mvc_board(bId, bName, bTitle, bcontent, bHit, bGroup, bStep, bIndent) values(mvc_board_seq.nextval,'abcd', 'is title', 'is content', 0,mvc_board_seq.currval,0,0);