Jsp message board source code 1: for jsp beginners _ MySQL

Jsp message board source code 1: for jsp beginners. author: precom (pig) oracle data table creation. createtableguestbook (clerk (100) notnull, -- message topic lw_authorvarchar2 (20) notnull, -- name pkauthor_httpvarchar2 (40), -- homepage address author_emailvarchar2 (40 jsp message board source code 1: for jsp beginners.
Prepared by: precom (pig)
Create an oracle data table.

Create table guestbook (
Lw_title varchar2 (100) not null, -- message subject
Lw_author varchar2 (20) not null, -- the online name pk
Author_http varchar2 (40), -- home address
Author_email varchar2 (40) not null, -- email pk
Expression varchar2 (2) not null, -- expression
Lw_time varchar2 (14) not null, -- Post response time
Answer_num number (3) not null, -- number of responses
Click_num number (4) not null, -- number of clicks
Author_ip varchar2 (16), -- source ip
Lw_class1 varchar2 (10) not null, -- main type of message board pk
Lw_class2 varchar2 (20) not null, -- Forum topic pk
Lw_type varchar2 (1) not null, -- message category, that is, whether the main post

Zt_time varchar2 (14), -- post time
Zt_author varchar2 (40), -- Post email
Lw_content varchar2 (4000), -- content
Constraint pk_guestbook primary key (lw_class1, lw_class2, lw
_ Time, lw_author)
) Storage (initial 5 M next 5 M pctincrease 1 );