最新图书.txt

图书馆管理系统的作业

create table thushuchuli( /*图书损失处理*/
ChuLiyichi datetime,
name_no char(10),
book_no char(30),
book_destorykind char(20),
fakuanmoney money,
foreign key (book_no) references book(book_no),
foreign key (name_no) references readname(name_no));
create  unique index  name_no_index on thushuchuli(ChuLiyichi);

insert into ThuShuChuLi()
values("1992-2-2","0003","7-900084-17-7 9787900084678","bookbreak",50);



create table pop/*图书流行指数*/
(book_no char(30) primary key,
point   integer,
foreign key (book_no) references book(book_no));

/*读者的资料*/
CREATE TABLE readname(
	name_no char(10) primary key,
	name_name char(8),
	name_class char(20));


//读者帐号
create table readpass(
    name_name char(9) primary key,
    name_pass char(8) not null,
    sex char(2),
    department char(12),
    telephone char(13), 
    grade char(10) not null,    
    sign int, );


/*读者的欠款*/
CREATE TABLE money( 
	name_no char(10) primary key,
	name_name char(8),
	name_arrearage money);
insert into money
values('200105001','林健雄',0);
insert into money
values('200105002','何文杰',100);
/*管理员帐号*/

//书本信息
create table book(
  book_NO char(30)  primary key,/* 图书编号*/
  book_name char(30) not null,
  book_zname char(20),  
  book_publish char(26),
  enter_num integer, 
  book_jg  money,
  enter_date datetime,
  Book_leave integer,
  kind integer); 
insert into book
values('7-900084-17-7 9787900084170','photoshop6.0','斐红义','中科多脉管体电子',5,27,'2003-10-1',5,10);
insert into book
values('7-900084-17-7 9787900084678','pb8.0','power','石油大学pb',5,27,'2003-10-1',5,5);
insert into book
values('7-900084-17-7 9787900085688','asp','asp','石油大学asp',5,29,'2003-10-1',5,11);
insert into book
values('7-900084-17-7 9757900184678','java','power','石油大学java',5,28,'2003-10-1',5,11);
insert into book
values('7-900084-17-7 9787901084678','mx','power','石油大学mx',5,32,'2003-10-1',5,11);
insert into book
values('7-900084-17-7 9787910084678','autoware','ware','石油大学ware',5,26,'2003-10-1',5,7);
insert into book
values('7-900084-17-7 9788900084678','english','english','石油大学english',5,25,'2003-10-1',5,1);
insert into book
values('7-922084-17-7 9787900084678','sd','power','石油大学pb',5,27,'2003-10-1',5,5);
insert into book
values('7-922084-17-7 9787900085688','addd','asp','石油大学asp',5,29,'2003-10-1',5,11);
insert into book
values('7-922084-17-7 9757900184678','jggg','power','石油大学java',5,28,'2003-10-1',5,11);
insert into book
values('7-922084-17-7 9787901084678','mmm','power','石油大学mx',5,32,'2003-10-1',5,11);
insert into book
values('7-9022084-17-7 9787910084678','pkh','ware','石油大学ware',5,26,'2003-10-1',5,7);
insert into book
values('7-902284-17-7 9788900084678','yhh','en3glish','石油大学english',5,25,'2003-10-1',5,1);
insert into book
values('7-111084-17-7 9787900084678','sd','po3wer','石油大学pb',5,27,'2003-10-1',5,5);
insert into book
values('7-111084-17-7 9787900085688','addd','as3p','石油大学asp',5,29,'2003-10-1',5,11);
insert into book
values('7-111084-17-7 9757900184678','jggg','p3ower','石油大学java',5,28,'2003-10-1',5,11);
insert into book
values('7-111084-17-7 9787901084678','mmm','po3wer','石油大学mx',5,32,'2003-10-1',5,11);
insert into book
values('7-9111084-17-7 9787910084678','pkh','wa3re','石油大学ware',5,26,'2003-10-1',5,7);
insert into book
values('7-11184-17-7 9788900084678','yhh','engli3sh','石油大学english',5,25,'2003-10-1',5,1);
insert into book
values('7-922084-17-7 9787900084678','sd','powe5r','石油大学pb',5,27,'2003-10-1',5,5);
insert into book
values('7-922084-17-7 9787900085777','addd','as5p','石油大学asp',5,29,'2003-10-1',5,11);
insert into book
values('7-922084-17-7 97579001847777','jggg','powe5r','石油大学java',5,28,'2003-10-1',5,11);
insert into book
values('7-922084-17-7 9787901087777','mmm','powe5r','石油大学mx',5,32,'2003-10-1',5,11);
insert into book
values('7-9022084-17-7 9787910087777','pkh','war5e','石油大学ware',5,26,'2003-10-1',5,7);
insert into book
values('7-902284-17-7 9788900087777','yhh','englis5h','石油大学english',5,25,'2003-10-1',5,1);









/*创建书的类型名称与代号的对应表*/
create table kinds(kind integer primary key,
                   name char(26));
insert into kinds
values(1,'a');
insert into kinds
values(2,'b');
insert into kinds
values(3,'c');
insert into kinds
values(4,'d');
insert into kinds
values(5,'e');
insert into kinds
values(7,'f');
insert into kinds
values(8,'g');
insert into kinds
values(9,'h');
insert into kinds
values(10,'i');
insert into kinds
values(11,'j');



//系统设置
CREATE TABLE sz(
	sta char(1)  primary key,
	bmp char(1),
	flag char(1));
/*已借书的情况表*/在pb80中运行时会发生date5 is not null的错误
CREATE TABLE yjbook(     //读者借书情况
	name_no char(10) primary key,//读者
	book_no1 char(30),
        book1 char(30),
	date1 datetime,
book_no2 char(30),
	book2 char (30),
	date2 datetime,
book_no3 char(30),
	book3 char(30),
	date3 datetime,
book_no4 char(30),
	book4 char(30),
	date4 datetime,
book_no5 char(30),
	book5 char(30),
	date5 datetime
foreign key (name_no) references readname(name_no));

create table wantlend(   //已选择想借的书
name_no char(10) primary key,
book_NO1 char(30) ,/* 图书编号*/
  book_name1 char(26) ,//书名
book_NO2 char(30) ,
  book_name2 char(26),
book_NO3 char(30) ,
  book_name3 char(26) ,
book_NO4 char(30) ,
  book_name4 char(26),
book_NO5 char(30) ,
  book_name5 char(26) );
//入库图书详细信息表
create table book_in(
  book_NO char(30)  not null,/* 图书编号*/
  book_name char(30) not null,
  book_zname char(20),  
  book_publish char(26),
  enter_num integer, 
  book_jg  money,
  enter_date datetime primary key,
  Book_leave integer,
  kind integer); 
//保存删除图书的表
create table book_leave_stay(
  book_NO char(30)  primary key,/* 图书编号*/
  book_name char(30) not null,
  book_zname char(20),  
  book_publish char(26),
  book_leave integer, 
  book_jg  money,
  enter_date datetime,
  kind integer,
  detail char(50));

/*money_list*/
create table money_list
(name_no char(10) primary key,
name_arrearage money,
foreign key(name_no) references money(name_no)
);

/*yjlist*/
create table yjlist
(id char(1)primary key,
name_no char(10),
name_name char(8),
book_no char(30),
book char(30),
datej datetime
);