6일차 답변형 게시판

JSP/2012.04강의(MySQL)

6일차 답변형 게시판

Bohemian life 2012. 5. 30. 10:57

chap17.zip

<요렇게 복사해주자~~~~>

1. jsp.*

2. WEB-INF/web.xml

3. WEB-INF/src/board.joc

4. WEB-INF/src/kame/*

5. WEB-INF/src/sql/*

6. 4.WEB-INF/src/lib/*

-WEB-INF/src/test/ (x)

DB생성을 하자~

article_mysql.sql

create table id_sequence (
	sequence_name varchar(10) not null,
	next_value int not null,
	primary key (sequence_name)
)

insert into id_sequence values ('article', 0)

create table article (
	article_id int not null auto_increment,
	group_id int not null,
	sequence_no char(16) not null,
	posting_date datetime not null,
	read_count int not null,
	writer_name varchar(20) not null,
	password varchar(10),
	title varchar(100),
	content text,
	primary key (article_id),
	index (sequence_no)
)

Path가 지워졌을 경우....