Java Programming with Oracle SQLJ

C.2. SQLJ in Servlets

A servlet is a Java program that may be deployed and run by an application server, and invoked using a browser. This section shows a simple servlet, named ServletExample.sqlj (Example C-2), that contains SQLJ statements. This section also describes how to compile the servlet and deploy it to the Oracle Internet Application Server (iAS) Version 1.0.2. For an introduction to servlets, I recommend Java Servlet Programming by Jason Hunter and William Crawford (O'Reilly).

ServletExample.sqlj retrieves the same customer details as AppletExample.sqlj, but displays them in an HTML table. When this servlet is invoked using a browser, the servlet's doGet( ) method is called. The doGet( ) method then retrieves and displays the details for all customers in the customers table.

Example C-2. ServletExample.sqlj

/* ServletExample.sqlj illustrates how to include SQLJ statements in a servlet. */ // import the servlet, io, and util classes import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.util.*; // import the SQLJ classes import java.sql.*; import oracle.sqlj.runtime.Oracle; import sqlj.runtime.ref.DefaultContext; public class ServletExample extends HttpServlet { // declare an iterator class #sql private static iterator CustIteratorClass( int id, String first_name, String last_name, java.sql.Date dob, String phone ); // handle get request public void doGet( HttpServletRequest req, HttpServletResponse res ) throws ServletException, IOException ...