Example of a simple SQLJ application

import sqlj.runtime.*;                                              1 
import java.sql.*;

#sql context EzSqljCtx;                                             3a 
#sql iterator EzSqljNameIter (String LASTNAME);                     4a 

public class EzSqlj {
 public static void main(String args[]) 
    throws SQLException
 {
    EzSqljCtx ctx = null;
    String URLprefix = "jdbc:db2:";
    String url;
    url = new String(URLprefix + args[0]);
                                            // Location name is an input parameter
    String hvmgr="000010";                                          2 
    String hvdeptno="A00";
    try {                                                           3b 
      Class.forName("com.ibm.db2.jcc.DB2Driver");
    } catch (Exception e)
    {
       throw new SQLException("Error in EzSqlj: Could not load the driver");
    }
    try
    {
       System.out.println("About to connect using url: " + url);
       Connection con0 = DriverManager.getConnection(url);          3c 
                                            // Create a JDBC Connection
       con0.setAutoCommit(false);           // set autocommit OFF
       ctx = new EzSqljCtx(con0);                                   3d 

       try
       {
         EzSqljNameIter iter;
         int count=0;

         #sql [ctx] iter = 
           {SELECT LASTNAME FROM EMPLOYEE};                         4b 
                                            // Create result table of the SELECT
         while (iter.next()) {                                      4c 
            System.out.println(iter.LASTNAME()); 
                                            // Retrieve rows from result table
            count++;
         }
         System.out.println("Retrieved " + count + " rows of data");
         iter.close();                      // Close the iterator
       }
       catch( SQLException e )                                       5 
       {
          System.out.println ("**** SELECT SQLException...");
          while(e!=null) {
            System.out.println ("Error msg: " + e.getMessage());
            System.out.println ("SQLSTATE: " + e.getSQLState());
            System.out.println ("Error code: " + e.getErrorCode());
            e = e.getNextException(); // Check for chained exceptions
          }
       }
       catch( Exception e )
       {
          System.out.println("**** NON-SQL exception   = " + e);
          e.printStackTrace();
       }
       try
       {
         #sql [ctx]                                                  4d 
           {UPDATE DEPARTMENT SET MGRNO=:hvmgr 
              WHERE DEPTNO=:hvdeptno};   // Update data for one department                                  
                                                                     6 
         #sql [ctx] {COMMIT};            // Commit the update
       }
       catch( SQLException e )
       {
          System.out.println ("**** UPDATE SQLException...");
          System.out.println ("Error msg: " + e.getMessage() + ". SQLSTATE=" +
            e.getSQLState() + " Error code=" + e.getErrorCode());
          e.printStackTrace();
       }
       catch( Exception e )
       {
          System.out.println("**** NON-SQL exception   = " + e);
          e.printStackTrace();
       }
       ctx.close();                                                  7  
  }
  catch(SQLException e)
  {
     System.out.println ("**** SQLException ...");
     System.out.println ("Error msg: " + e.getMessage() + ". SQLSTATE=" + 
       e.getSQLState() + " Error code=" + e.getErrorCode());
     e.printStackTrace();
  }
  catch(Exception e)
  {
    System.out.println ("**** NON-SQL exception = " + e);
    e.printStackTrace();
  }
 }
}