使用JSP和Oracle开发的站内邮件收发系统

create table users( userName varchar2(50) constraint PK_userName PRIMARY KEY, userPwd varchar2(50) not null, name varchar2(50), gender varchar2(10), userEmail varchar2(50), userQQ varchar2(50), userPhone varchar2(50), userMphone varchar2(50), regTime date, loginCount number(6), lastLoginTime date, lastIP varchar2(50), isOnline number(1), isLock number(1) ); create table adminUser( adminUser varchar2(50) constraint PK_adminUser PRIMARY KEY, adminPwd varchar2(50) not null, isLock number(1) ); insert into adminUser values('admin','E10ADC3949B',0); create table mail( mailId number(6) constraint PK_mailId PRIMARY KEY, fromUserName varchar2(50) not null, toUserName varchar2(50) not null, mailSubject varchar2(50) not null, mailMessage varchar2(500), mailDate date, isRead number(1), senderDel number(1), receiverDel number(1) ); create sequence mail_seq increment by 1 start with 1 nomaxvalue nocycle cache 10;