数据库连接eclipse已经完成,后面的不是很会,请大神指点一下,最好能给一个增删改查的例子,谢谢大神们了。
1.创建数据库的SQL语句
create database wangdian
on primary
(name=wangdian_data,
filename='D:\wangdian\wangdian_data.mdf',
size=15MB,
maxsize=unlimited
),
(name=wangdian_data1,
filename='D:\wangdian\wangdian_data1.ndf',
size=10MB,
maxsize=20MB
)
LOG ON
(name=wangdian_log,
filename='D:\wangdian\shengvhan_log.ldf',
size=10MB,
maxsize=20MB,
filegrowth=2)
2.创建所有表的SQL语句
create database wangdian
on primary
(name=wangdian_data,
filename='D:\wangdian\wangdian_data.mdf',
size=15MB,
maxsize=unlimited
),
(name=wangdian_data1,
filename='D:\wangdian\wangdian_data1.ndf',
size=10MB,
maxsize=20MB
)
LOG ON
(name=wangdian_log,
filename='D:\wangdian\shengvhan_log.ldf',
size=10MB,
maxsize=20MB,
filegrowth=2)
create table yuangong
(
yid int not null primary key,
yusername char(20) not null,
ytruename char(20) not null,
ypassword char(20) not null,
ysex char(2) default '男',
)
create table huiyuan
(
hid int not null primary key,
husername char(20) not null,
hpassword char(20) not null,
hmobile char(11) check(hmobile like '[1-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'),
haddress char(30) not null,
)
create table shangpin
(
sno char(10) not null primary key,
sname char(10)not null,
sprize float(10)not null,
leixing char(10)
)
create table dingdan
(
dno int not null primary key,
dsaletime datetime not null,
hid int not null,
foreign key(hid) references huiyuan(hid),
)
create table xiadan
(
hid int not null,
yid int not null,
primary key(hid,yid),
foreign key(hid) references huiyuan(hid),
foreign key(yid) references yuangong(yid),
xsaletime datetime not null,
)