3. Create a JDBC project to call procedure created in chapter 14 lab activity 1.

Question

What will be an ideal response?

Answer 1

```
import sqlj.runtime.ref.*;
import java.io.*;
import java.sql.*;
import javax.swing.*;
public class TestSQLj {
public static void main(String [] args) {
try {
Oracle.connect
("jdbc:Oracle:thin:@localhost:1521:oracle",
"nshah", "india_usa", true);
String sid=JOptionPane.showInputDialog("Enter student Id:");
String lastName;
String firstName;
String phoneNum;
#sql {CALL(get_student
(:in sid,:out lastName,:out firstName,:out phoneNum))};
System.out.println(sid+"\t"+lastName+"\t"+firstName+"\t"+phoneNum);
}
catch (SQLException e) {
System.out.println(e.getMessage()); }
finally {
try {
Oracle.close();
}
catch(SQLException e) {
e.printStackTrace();
}
}
}
}
```