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;}。