发布时间 : 星期日 文章图书借阅系统2更新完毕开始阅读
insert into 读者信息 values
('H200121001','程晓曦 ','可用','18900000000') insert into 读者信息 values
('H200121002 ','周鼎 ','可用','15800000000') insert into 读者信息 values
('H200121004 ','马骁 ','可用','15600000000') insert into 读者信息 values
('H200121006 ','王小虎','可用','15800000000') insert into 读者信息 values
('H200121009 ','王力 ','可用','13600000000') insert into 读者信息 values
('H200121010 ','杨华','可用','15200000000') insert into 读者信息 values
('J200902001','王浩粗 ','可用','13200000000') insert into 读者信息 values
('J200902002 ','王朝 ','失效','15200000000') insert into 读者信息 values
('J200902003','崔定科 ','可用','15600000000') insert into 读者信息 values
('J200902005 ','李晨 ','失效','13200000000') insert into 读者信息 values
('J200902006','周大华','可用','13700000000') insert into 读者信息 values
('J200902007 ','马威 ','可用','13800000000') insert into 读者信息 values
('J200902008','马晓华 ','可用','13900000000') insert into 读者信息 values
('W200912001','崔灿 ','可用','13400000000') insert into 读者信息 values
('W200912002 ','李涵 ','可用','13200000000') insert into 读者信息 values
('W200912003','陈晓晨','可用','15200000000') insert into 读者信息 values
('W200912004','陈晓琪 ','失效','15800000000') 借阅信息表数据
insert into 借阅信息 values
('J200902001','9787115224262','2011-04-06 ','2011-05-06','2011-05-10','0.4000') insert into 借阅信息 values
('W200912002 ','9787115224996','2011-05-06 ','2011-06-06 ','2011-06-16 ','1.0000') insert into 借阅信息 values
('J200902006','9787115226334','2011-04-05','2011-05-05 ','2011-06-05','3.0000') insert into 借阅信息 values
('H200121004','9787115225481','2011-07-10 ','2011-08-10 ','2011-09-10 ','3.0000') insert into 借阅信息 values
('J200902007','9787115231048','2011-07-10 ','2011-08-10','2011-08-10','0.0000') insert into 借阅信息 values
('J200902007','9787115231048','2011-09-18 ','2011-10-18','2011-10-18','0.0000') insert into 借阅信息 values
('H200121006','9787115232267','2011-08-10 ','2011-09-10','2011-10-18','0.5000') insert into 借阅信息 values
('J200902006','9787115227898','2011-04-05','2011-05-05 ','2011-05-05 ','0.0000') insert into 借阅信息 values
('J200902006','9787115231048','2011-04-05','2011-05-05 ','2011-05-05 ','0.0000') insert into 借阅信息 values
('J200902006','9787115225481','2011-04-05','2011-05-05 ','2011-05-05 ','0.0000') insert into 借阅信息 values
('J200902006','9787115227478','2011-04-05 ','2011-05-05 ','2011-05-05 ','0.0000') insert into 借阅信息 values
('W200912004','9787115224996','2011-06-06 ','2011-07-06 ','2011-08-06 ','3.0000') insert into 借阅信息 values
('J200902005','9787115231130','2011-07-10 ','2011-08-10 ','2011-08-10 ','0.0000') insert into 借阅信息 values
('W200912003 ','9787115232601','2011-07-10 ','2011-08-10 ','2011-08-10 ','0.0000') insert into 借阅信息 values
('W200912004','9787115226505','2011-09-18 ','2011-10-18 ','2011-10-18','0.0000') insert into 借阅信息 values
('J200902006','9787115230294','2011-08-10','2011-09-10','2011-09-10 ','0.0000') insert into 借阅信息 values
('W200912004 ','9787115230805','2011-10-10','2011-11-10','NULL','0.0000') insert into 借阅信息 values
('J200902006','9787115231130','2011-09-09','2011-10-09','NULL','0.0000') insert into 借阅信息 values
('H200121001','9787115232601','2011-09-10','2011-10-10','NULL','0.0000') insert into 借阅信息 values
('H200121002','9787115228505','2011-10-11 ','2011-11-11','NULL ','0.0000')
图书表数据
insert into 图书 values
('9787115179043','Excel高效办公—市场与销售管理','TP312.7','沈登华','机械工业出版社
','49.0000')
insert into 图书 values
('9787115219619','随身查—Office办公高手应用技巧','TP312.7','沈丽','清华大学出版社','12.8000')
insert into 图书 values
('9787115220578','说服力让你的PPT会说话','TP312.7','周舟','清华大学出版社','39.0000') insert into 图书 values
('9787115221674','精通Linux设备驱动程序开发','TP316.2','陈华亭','机械工业出版社','89.0000')
insert into 图书 values
('9787115222817','spss统计分析标准教程（附光盘）','TP312.7','江铠同','机械工业出版社','48.0000')
insert into 图书 values
('9787115223104','Office 2003办公应用完全','TP312.7','蒋健','清华大学出版社','49.0000') insert into 图书 values
('9787115223883','软件测试技术（第二版）','TP302.7','于丹','清华大学出版社','32.0000') insert into 图书 values
('9787115224132','苹果Mac OS X10.6 SnowLeo','TP316.2','陈廷飞','清华大学出版社','79.0000') insert into 图书 values
('9787115224262','电路基础','O411','王红','安徽科学技术出版社','24.0000') insert into 图书 values
('9787115224996','模拟电子技术','O412','陈晨','安徽科学技术出版社','22.0000') insert into 图书 values
('9787115225184','电子技术基础与技能（通信）','O411','张震','中国商务出版社','25.0000') insert into 图书 values
('9787115225481','Office办公软件案例教程','TP312.7','杨启申','清华大学出版社','24.5000') insert into 图书 values
('9787115226075','Java程序设计实例教程','TP312','渝万里','科学出版社','32.5000') insert into 图书 values
('9787115226334','电工基础','O412','陈忠彪','安徽科学技术出版社','39.0000') insert into 图书 values
('9787115226662','常用工具软件','TP319','李大力','中国农业出版社','32.0000') insert into 图书 values
('9787115226846','计算机主板维修从业技能','TP301','徐燕','安徽科学技术出版社','39.0000') insert into 图书 values
('9787115227430','深入Linux内核架构','TP316.2','陈登','清华大学出版社','149.0000') insert into 图书 values
('9787115227478','金蝶ERP-K/3培训教程—','TP312.7','杨万华','清华大学出版社','59.0000') insert into 图书 values
('9787115227607','金蝶KIS模拟实训—财务/','TP312.7','李丽莎','清华大学出版社','35.0000') insert into 图书 values
('9787115227874','PhotoShop CS4中文版基础','TP317.2','李丽','安徽科学技术出版社','39.0000')
insert into 图书 values
('9787115227898','从零开始—PhotoShop CS','TP317.2','于从三','清华大学出版社','29.0000') insert into 图书 values
('9787115228505','3ds Max 2010中文版基础','TP319','刘瓦尼','安徽科学技术出版社','42.0000') insert into 图书 values
('9787115229946','电路分析基础','O411','李航','安徽科学技术出版社','27.0000') insert into 图书 values
('9787115230294','SQL Server 2008查询性能','TP392','马莎莉','安徽科学技术出版社','69.0000') insert into 图书 values
('9787115230805','Shell脚本专家指南','TP312','袁世华','高等教育出版社','39.0000') insert into 图书 values
('9787115231048','C语言从入门到精通','TP312','肖云飞','清华大学出版社','59.0000') insert into 图书 values
('9787115231086','大学计算机基础','TP301','崔晓雪','人民出版社','29.5000')
图书类型表数据
insert into 图书类型 values
('O411','电子类-电工技术','电子类图书') insert into 图书类型 values ('O412','电子类-自动控制','') insert into 图书类型 values
('TP301','电子类-家电维修','电子类的家电控制') insert into 图书类型 values ('TP302.7','计算机类-其他','') insert into 图书类型 values ('TP312','计算机类-软件开发','') insert into 图书类型 values ('TP312.7','计算机类-办公软件','') insert into 图书类型 values ('TP316.2','计算机类-操作系统','') insert into 图书类型 values ('TP317.2','计算机类-平面设计','') insert into 图书类型 values ('TP319','计算机类-办公软件','') insert into 图书类型 values ('TP392','计算机类-数据库','') insert into 图书类型 values ('TP393','计算机类-网络技术','')
5.3管理基本表
1.使用SSMS给图书表中的属性列“价格”添加默认值“10.00”