3. Create a JDBC project to call procedure created in chapter 14 lab activity 1.
What will be an ideal response?
```
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();
}
}
}
}
```
You might also like to view...
Processing speed and efficiency can be affected by all the following factors, except _____.
A. microprocessor type and speed B. network and modem connection speed C. memory capacity D. storage capacity
After you view the Summary screen in the New Template Wizard, a ______________ script is run to create the template.
Fill in the blank(s) with the appropriate word(s).
A (n) __________is a logical subgroup within a domain
a. Site b. Organizational unit c. Tree d. Child
Which of the following are characteristics of the core layer of a hierarchical design? (Choose all that apply.)
a. Rapid convergence b. Aggregates WAN connections at the edge of the campus c. High availability d. Connects users e. Connects remote sites f. Fast packet switching