Carnegie Mellon Univ' Dept' of Computer Science 15415 Database Applications

1
Carnegie Mellon Univ.Dept. of Computer
Science15-415 - Database Applications

• C. Faloutsos
• Guidelines for project

2
Overview

• concepts of SQL programs
• walkthrough of HW3_Create.java
• walkthrough of showAll.java
• (all on the web site)

3
ORACLE

• see the two Java programs
• HW3_Create.java
• showAll.java
• Concepts
• embedded SQL
• cursor

4
Outline of an SQL application

• establish connection with ORACLE server
• authenticate (user/password)
• execute SQL statement(s)
• process results
• close connection

5
Pictorially
dbclass.intro.cs.cmu.edu
andrew machine eg., sun4.andrew
JDBC/ODBC
Windows NT box with ORACLE Server
HW3_Create.java HW3_Create.class
6
HW1_Create.java

• Purpose to load the parent-child table
• No need for you to understand it fully - but you
  MUST run it, to load the (parent, child) table!

legend
7
Walk-through HW3_Create.java
8
Walk-through HW3_Create.java
9
Walk-through HW3_Create.java
10
Walk-through HW3_Create.java

• rest of program
• read input file
• insert one tuple at a time
• close connection

11
Walk-through HW3_Create.java
12
Overview

• concepts of SQL programs
• walkthrough of HW3_Create.java
• walkthrough of showAll.java

13
Walk-through showAll.java

• purpose print all (parent, child) pairs
• note very useful for the project just change
• (a) the SQL statements
• (b) the processing of the results

14
Walk-through showAll.java
15
Walk-through showAll.java
16
Conclusions

• concepts of SQL programs
• necessary HW1_Create.java
• modify showAll.java wrt
• SQL statements
• result processing