JSP Message Board source code one: to JSP beginners. _JSP Programming

JSP Message Board source code one: to JSP beginners.
Author: precom (preserved egg)
Oracle data table creation.

CREATE TABLE Guestbook (
Lw_title varchar2 NOT NULL,--message theme
Lw_author varchar2 NOT NULL,--web name PK
Author_http VARCHAR2 (40),--Home address
Author_email varchar2 NOT null,--email PK
Expression VARCHAR2 (2) NOT null,--expression
Lw_time varchar2 NOT NULL,--publish response time
Answer_num Number (3) NOT NULL,--response
Click_num Number (4) NOT null,--clicks
Author_ip varchar2 (),--Source IP
Lw_class1 VARCHAR2 (a) NOT NULL,--message board Big class PK
Lw_class2 varchar2 NOT NULL,--Forum column PK
Lw_type VARCHAR2 (1) NOT NULL,--message category, that is, whether the main paste

Zt_time varchar2,--Main paste Time
Zt_author varchar2 Email,--main Post
Lw_content varchar2 (4000),--content
Constraint Pk_guestbook primary KEY (LW_CLASS1,LW_CLASS2,LW
_time,lw_author)
) Storage (initial 5M next 5M pctincrease 1);