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

package model;

public class BBSAccount implements java.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= SEmail;}

public String getPassword（String Password）{
return Password;}
public void setBirthday(String Birthday){
this. Birthday= Birthday;}