MySQL论坛数据库建表实例(张伟).doc

CREATE TABLE BBSAccount(AccountID bigint auto_increment primary key,NickName varchar(30) NOT NULL,Birthday datetime,Password varchar(20),State char(2),SEmail varchar(50);CREATE TABLE BBSSector(SectorID int auto_increment primary key,AccountID bigint not null,SectorName varchar(20) not null,ClickingRate int default 0,TopicCount bigint default 0,FOREIGN KEY(AccountID )REFERENCES BBSAccount(AccountID) ON UPDATE CASCADE ON DELETE RESTRICT);CREATE TABLE BBSTopic(TopicID bigint auto_increment primary key,AccountID bigint not null,Title varchar(50) not null,TopicText text not null,TopicDate timestamp null default current_timestamp,ReplyCount int not null,ClickingRate int default 0,SectorID int not null,FOREIGN KEY(AccountID) REFERENCES BBSAccount(AccountID) ON UPDATE CASCADE ON DELETE RESTRICT,FOREIGN KEY(SectorID) REFERENCES BBSSector(SectorID) ON UPDATE CASCADE ON DELETE RESTRICT); CREATE TABLE BBSReply(ReplyID bigint auto_increment primary key,TopicID bigint not null,AccountID bigint not null,ReplyText varchar(2000) not null,ReplyDate timestamp null default current_timestamp,ClickingRate int default 0,Foreign key(TopicID) references BBSTopic (TopicID) ON UPDATE CASCADE ON DELETE RESTRICT,FOREIGN KEY(AccountID) REFERENCES BBSAccount(AccountID) ON UPDATE CASCADE ON DELETE RESTRICT);packagemodel;public class BBSAccount implementsjava.io.Serializable private Integer AccountID; private String NickName; private String Birthday;/timestamp对应的是什么类型？ private String Password; private String State; private String SEmail; public BBSAccount() public BBSAccount(Integer AccountID, String NickName, String Birthday, String Password, String State ,String SEmail) this. AccountID = AccountID; this.NickName= NickName; this. Birthday= Birthday; this. Password= Password; this. State= State; this. SEmail= SEmail; public String getAccountID (Integer AccountID) return AccountID; public void setAccountID(Integer AccountID) this. AccountID = AccountID; public String getNickName(String NickName) return NickName; public void setNickName(String NickName) this.NickName= NickName; public String getBirthday(String Birthday) return Birthday; public void setPassword(String Password) this. Password= Password; public String getState(String State) return State; public void setState(String State) this. State= State; public String getSEmail(String SEmail) return SEmail；public void setSEmail（String SEmail） this. SEmail= SEmai