Use the Java CallableStatement method to develop a data query from the Student and StudentCourse Tables with

Question:

Use the Java CallableStatement method to develop a data query from the Student and StudentCourse Tables with the StudentFrame class in the OracleSelectFaculty project (the project file can be found in the folder ClassDB Projects\Chapter 6 that is located in the Students folder at the accompanying CRC Press ftp site [see Figure 1.2 in Chapter 1]). The procedures to develop this data query include the following steps:

a. Build two packages, Student_Info and Student_Course, using Oracle SQL Developer. For the second package, Student_Course, one can use the one built in Exercise 3.

b. Develop the code for the StudentFrame class to perform the data query to these Oracle packages (adding an else if block to the Select button Click event handler).

c. Add a new query method by using: ComboMethod.addItem(“Java Callable Method”); in the StudentFrame constructor.

Figure 1.2:

image text in transcribed