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();
}
}
}
}
```

Computer Science & Information Technology

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

Computer Science & Information Technology

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).

Computer Science & Information Technology

A (n) __________is a logical subgroup within a domain

a. Site b. Organizational unit c. Tree d. Child

Computer Science & Information Technology

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

Computer Science & Information Technology