5. Create a SQLj project to call function created in chapter 14 lab activity 2.

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);
int did=Integer.parseInt(JOptionPane.showInputDialog
("Enter department Id:"));
boolean found;
#sql found = {VALUES(find_dept(:in did))};
System.out.println(did+" exists - "+found);
}
catch (SQLException e) {
System.out.println(e.getMessage()); }
finally {
try {
Oracle.close();
}
catch(SQLException e) {
e.printStackTrace();
}
}
}
}
```