通讯表.sql

E家园 是 利用java做的 很好 的 是 初学者的宝贝

create database addressBook
on primary 
(
name='addressBook.mdf',
filename='D:\在线通讯录\Database\addressBook.mdf'
)

use addressBook


create table USERS
(
userID int identity(1,1) primary key,
userName varchar(20) not null,
password varchar(20) not null,
realName varchar(20),
sex varchar(2) check(sex='男' or sex='女')
)



create table BOOK
(
id int identity(1,1) primary key not null,
name varchar(20) not null,
sex varchar(2) check(sex='男' or sex='女'),
phone varchar(15),
address varchar(50),
mobilePhone varchar(15),
company varchar(50),
comPhone varchar(15),
comAddress varchar(15),
relation int not null,
userID int foreign key references USERS(userID) not null
)


insert into USERS(userName,password,realName,sex) values('Administrator','admin','Administrator','男')
insert into USERS(userName,password,realName,sex) values('1','1','李红','女')
insert into USERS(userName,password,realName,sex) values('yuanpeng','6104916','袁朋','男')

select *from USERS where(userName='1' and password='1')


insert into BOOK(name,sex,phone,address,mobilePhone,company,comPhone,comAddress,relation,userID) values('张三','男','1234567','湖南长沙','1320469875698','物流公司','55350','湖北武汉',4,'1')



select *from BOOK where(userID=3 and relation='3')

delete from BOOK where(id=6)