基于jsp的通讯录设计

/*---------创建数据库-------------*/ create database txl go use txl go /*-----------用户表---------------*/ create table users (Uid int identity(1,1) primary key, Uname char(16) unique not null, Upassword char(16) not null, Ulevel int check(Ulevel in(1,2,3)) default 1 ) /*-----------成员表---------------*/ create table membership (Mid int identity(1,1) primary key, Mname char(16) unique not null, Msex char(2) check(Msex='男' or Msex='女'), Mbirthday datetime ) /*-----------分组方式表---------------*/ create table PacketMode (Pid int identity(1,1) primary key, Pname char(16) unique not null ) go /*-----------分组表---------------*/ create table Relations ( Uid int references users(Uid), Mid int references membership(Mid), Pid int references PacketMode(Pid), primary key (Uid,Mid,Pid) ) /*-----------联系方式表---------------*/ create table Contact ( Cid int identity(1,1) primary key, Cname char(16) unique not null ) /*-----------通讯录表---------------*/ create table AddressBook ( Mid int references membership(Mid), Cid int references Contact(Cid), ADate char(60) not null, primary key (Mid,Cid) )