[{"title":"( 24 个子文件 1.61MB ) sql图书管理系统","children":[{"title":"图书管理系统","children":[{"title":"SQL图书管理系统设计课题报告.rar <span style='color:#111;'> 78.46KB </span>","children":null,"spread":false},{"title":"图书管理系统设计.doc <span style='color:#111;'> 27.00KB </span>","children":null,"spread":false},{"title":"JDGL.ldf <span style='color:#111;'> 1024.00KB </span>","children":null,"spread":false},{"title":"JDGL_data.mdf <span style='color:#111;'> 3.00MB </span>","children":null,"spread":false},{"title":"SQL图书管理系统设计课题报告.doc <span style='color:#111;'> 186.50KB </span>","children":null,"spread":false},{"title":"为图书编号建立索引.sql <span style='color:#111;'> 57B </span>","children":null,"spread":false},{"title":"E-R.JPG <span style='color:#111;'> 81.72KB </span>","children":null,"spread":false},{"title":"约束和建表建库","children":[{"title":"读者表里面字段的约束条件.sql <span style='color:#111;'> 474B </span>","children":null,"spread":false},{"title":"性别缺省约束.sql <span style='color:#111;'> 87B </span>","children":null,"spread":false},{"title":"建表.sql <span style='color:#111;'> 1.07KB </span>","children":null,"spread":false},{"title":"借阅表里面字段约束.sql <span style='color:#111;'> 166B </span>","children":null,"spread":false},{"title":"可借数量小于馆藏数量约束.sql <span style='color:#111;'> 126B </span>","children":null,"spread":false},{"title":"书名非空约束.sql <span style='color:#111;'> 87B </span>","children":null,"spread":false},{"title":"JDGL建库表.sql <span style='color:#111;'> 223B </span>","children":null,"spread":false}],"spread":true},{"title":"视图","children":[{"title":"所有到期图书查询视图.sql <span style='color:#111;'> 442B </span>","children":null,"spread":false}],"spread":true},{"title":"触发器","children":[{"title":"借阅图书的触发器.sql <span style='color:#111;'> 1.03KB </span>","children":null,"spread":false},{"title":"还书触发器.sql <span style='color:#111;'> 783B </span>","children":null,"spread":false},{"title":"读者信息表的触发器.sql <span style='color:#111;'> 287B </span>","children":null,"spread":false}],"spread":true},{"title":"E-R.vsd <span style='color:#111;'> 52.00KB </span>","children":null,"spread":false},{"title":"存储过程","children":[{"title":"以书名建立的模糊查询存储过程.sql <span style='color:#111;'> 241B </span>","children":null,"spread":false},{"title":"某段时间之内图书借阅次数.sql <span style='color:#111;'> 507B </span>","children":null,"spread":false},{"title":"以借书证号为参数返回该读者未归还图书的信息.sql <span style='color:#111;'> 490B </span>","children":null,"spread":false},{"title":"以ISBN编号为参数查询返回未归还图书的读者信息.sql <span style='color:#111;'> 385B </span>","children":null,"spread":false},{"title":"以借书证号和姓名为参数返回读者的信息.sql <span style='color:#111;'> 216B </span>","children":null,"spread":false}],"spread":true}],"spread":false}],"spread":true}]