Accp8.0\S2\使用Java实现数据库编程

[{"title":"（ 26 个子文件 576KB ） Accp8.0\\S2\\使用Java实现数据库编程 ","children":[{"title":"Chapter03","children":[{"title":"02 提供给学员的内容","children":[{"title":"02 作业素材","children":[{"title":"说明.txt <span style='color:#111;'> 18B </span>","children":null,"spread":false}],"spread":true},{"title":"01 上机练习素材","children":[{"title":"练习3：成绩表数据脚本.txt <span style='color:#111;'> 1.13KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"01 提供给教员的内容","children":[{"title":"01 教学演示案例","children":[{"title":"示例4：使用LIMIT子句查询学生信息","children":[{"title":"使用LIMIT子句查询学生信息.sql <span style='color:#111;'> 456B </span>","children":null,"spread":false}],"spread":true},{"title":"示例2：设置主键、外键关联","children":[{"title":"设置主键、外键关联.sql <span style='color:#111;'> 326B </span>","children":null,"spread":false}],"spread":true},{"title":"示例6：用子查询查年龄比李斯文大的学生","children":[{"title":"用子查询查年龄比李斯文大的学生.sql <span style='color:#111;'> 183B </span>","children":null,"spread":false}],"spread":true},{"title":"示例1：修改表名、添加表、修改和删除字段","children":[{"title":"修改表名、添加表、修改和删除字段.sql <span style='color:#111;'> 434B </span>","children":null,"spread":false}],"spread":true},{"title":"示例5：分步实现查询年龄比“李斯文”大的学生","children":[{"title":"分步实现查询年龄比“李斯文”大的学生.sql <span style='color:#111;'> 290B </span>","children":null,"spread":false}],"spread":true},{"title":"示例7：用表连接查询成绩是60分的学生","children":[{"title":"用表连接查询成绩是60分的学生.sql <span style='color:#111;'> 332B </span>","children":null,"spread":false}],"spread":true},{"title":"示例11：使用NOT IN子查询","children":[{"title":"使用NOT IN子查询.sql <span style='color:#111;'> 809B </span>","children":null,"spread":false}],"spread":true},{"title":"示例10：IN子查询2","children":[{"title":"IN子查询2.sql <span style='color:#111;'> 707B </span>","children":null,"spread":false}],"spread":true},{"title":"示例3：将查询结果插入新表","children":[{"title":"将查询结果插入新表.sql <span style='color:#111;'> 84B </span>","children":null,"spread":false}],"spread":true},{"title":"示例9：IN子查询","children":[{"title":"IN子查询.sql <span style='color:#111;'> 363B </span>","children":null,"spread":false}],"spread":true},{"title":"示例8：子查询实现查询成绩是60分的学生","children":[{"title":"用子查询方式查询成绩是60分的学生.sql <span style='color:#111;'> 346B </span>","children":null,"spread":false}],"spread":false}],"spread":false},{"title":"03 作业参考答案","children":[{"title":"作业3","children":[{"title":"3.查询没人借阅的图书.sql <span style='color:#111;'> 161B </span>","children":null,"spread":false}],"spread":true},{"title":"作业5","children":[{"title":"归还清单.sql <span style='color:#111;'> 295B </span>","children":null,"spread":false}],"spread":true},{"title":"第3章作业答案.docx <span style='color:#111;'> 18.35KB </span>","children":null,"spread":false},{"title":"作业4","children":[{"title":"4查询罚款清单.sql <span style='color:#111;'> 196B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"02 上机练习参考答案","children":[{"title":"练习4：修改学生表科目表数据","children":[{"title":"修改学生表科目表数据.sql <span style='color:#111;'> 377B </span>","children":null,"spread":false}],"spread":true},{"title":"练习8：查询最近一次考试缺考学生","children":[{"title":"使用NOT IN关键字的子查询.sql <span style='color:#111;'> 542B </span>","children":null,"spread":false}],"spread":true},{"title":"练习7：查询某学期开设的课程","children":[{"title":"使用IN关键字的子查询.sql <span style='color:#111;'> 121B </span>","children":null,"spread":false}],"spread":true},{"title":"练习2：使用SQL语句为myschool数据库中result表添加约束","children":[{"title":"使用SQL语句为myschool数据库中result表添加约束.sql <span style='color:#111;'> 377B </span>","children":null,"spread":false}],"spread":true},{"title":"练习3：为学生表、科目表、成绩表添加数据","children":[{"title":"添加数据SQL语句.sql <span style='color:#111;'> 3.31KB </span>","children":null,"spread":false}],"spread":true},{"title":"练习1：创建数据表并实现对表的修改操作","children":[{"title":"创建数据表并实现对表的修改操作.sql <span style='color:#111;'> 583B </span>","children":null,"spread":false}],"spread":true},{"title":"练习5：查询学生信息","children":[{"title":"查询学生信息.sql <span style='color:#111;'> 869B </span>","children":null,"spread":false}],"spread":true},{"title":"练习6：查询指定学生成绩","children":[{"title":"使用子查询查特定学生成绩.sql <span style='color:#111;'> 366B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"TP03.pptx <span style='color:#111;'> 671.51KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}]