[{"title":"( 25 个子文件 2.27MB ) Accp8.0\\S2\\使用Java实现数据库编程 第五章 ","children":[{"title":"Chapter05","children":[{"title":"01 提供给教员的内容","children":[{"title":"03 作业参考答案","children":[{"title":"作业6","children":[{"title":"数据备份和恢复.txt <span style='color:#111;'> 259B </span>","children":null,"spread":false}],"spread":true},{"title":"作业4","children":[{"title":"惩罚事务.sql <span style='color:#111;'> 817B </span>","children":null,"spread":false}],"spread":true},{"title":"作业5","children":[{"title":"视图.sql <span style='color:#111;'> 762B </span>","children":null,"spread":false}],"spread":true},{"title":"第5章作业答案.docx <span style='color:#111;'> 18.63KB </span>","children":null,"spread":false},{"title":"作业3","children":[{"title":"借阅事务.sql <span style='color:#111;'> 708B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"02 上机练习参考答案","children":[{"title":"练习5:myschool数据库的备份和恢复","children":[{"title":"myschool数据库的备份和恢复.txt <span style='color:#111;'> 476B </span>","children":null,"spread":false}],"spread":true},{"title":"练习1:批量插入成绩数据","children":[{"title":"批量插入学生考试成绩.sql <span style='color:#111;'> 857B </span>","children":null,"spread":false}],"spread":true},{"title":"练习2:为毕业生办理离校手续","children":[{"title":"为毕业学生办理离校手续.sql <span style='color:#111;'> 1.06KB </span>","children":null,"spread":false}],"spread":true},{"title":"练习4:创建学生表和成绩表索引并查看索引","children":[{"title":"创建学生表和成绩表索引并查看索引.sql <span style='color:#111;'> 303B </span>","children":null,"spread":false}],"spread":true},{"title":"练习3:查看学生各科目考试成绩平均分","children":[{"title":"查看学生各科目考试成绩平均分.sql <span style='color:#111;'> 811B </span>","children":null,"spread":false}],"spread":true},{"title":"练习6:科目表数据的导出和导入","children":[{"title":"科目表数据的导出和导入.sql <span style='color:#111;'> 650B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"01 教学演示案例","children":[{"title":"示例7:使用mysqldump备份数据库","children":[{"title":"使用mysqldump备份数据库.txt <span style='color:#111;'> 75B </span>","children":null,"spread":false},{"title":"backup","children":[{"title":"myschool_20160808.sql <span style='color:#111;'> 3.74KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"示例3:使用事务进行转账","children":[{"title":"回滚事务","children":[{"title":"回滚事务.sql <span style='color:#111;'> 189B </span>","children":null,"spread":false}],"spread":true},{"title":"提交事务","children":[{"title":"提交事务.sql <span style='color:#111;'> 488B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"示例9:表数据的导出和导入","children":[{"title":"表数据的导出和导入.sql <span style='color:#111;'> 712B </span>","children":null,"spread":false}],"spread":true},{"title":"示例8:mysql和source恢复数据库","children":[{"title":"mysql命令恢复数据库.txt <span style='color:#111;'> 284B </span>","children":null,"spread":false}],"spread":true},{"title":"示例4:关闭自动提交","children":[{"title":"关闭自动提交.sql <span style='color:#111;'> 575B </span>","children":null,"spread":false}],"spread":true},{"title":"示例1:创建账户表及测试数据","children":[{"title":"示例1 创建bank数据库.sql <span style='color:#111;'> 374B </span>","children":null,"spread":false}],"spread":true},{"title":"示例5:创建并查询视图","children":[{"title":"创建并查询视图.sql <span style='color:#111;'> 911B </span>","children":null,"spread":false}],"spread":true},{"title":"示例6:创建索引","children":[{"title":"创建索引.sql <span style='color:#111;'> 94B </span>","children":null,"spread":false}],"spread":true},{"title":"示例2:未使用事务进行转账","children":[{"title":"示例2 用户转账.sql <span style='color:#111;'> 317B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"02 提供给学员的内容","children":[{"title":"01 上机练习素材","children":[{"title":"说明.txt <span style='color:#111;'> 18B </span>","children":null,"spread":false}],"spread":true},{"title":"02 作业素材","children":[{"title":"说明.txt <span style='color:#111;'> 18B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"TP05.pptx <span style='color:#111;'> 2.37MB </span>","children":null,"spread":false}],"spread":true}],"spread":true}]