Oracle and PL/SQL Recipes: A Problem-Solution Approach

15-1. Creating a Java Database Class

Problem

You want to write a Java class that will query the database and return a result.

Solution

Create a Java class that uses the Java Database Connectivity (JDBC) API to query the Oracle Database. For example, the Java class in the following example will query the EMPLOYEES table for all employees who belong to the IT department. The example entails a complete Java class that is named Employees. This class contains a method named getItEmps() that will become a Java stored procedure. The Employees class shown here will be stored into a file named Employees.java.

import java.sql.*; import oracle.jdbc.*; public class Employees {   public static void getItEmps(){       String firstName = null;       String ...