Jsp message board source code 1: for jsp beginners.

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 );