SQL Embedded in Java Part 1 Starting Out

   
     import java.sql.SQLException;
     import sqlj.runtime.ref.DefaultContext;
     public class HiScotty {
     public static void main(String[] args) throws SQLException
     { new oracle.jdbc.driver.OracleDriver();
     DefaultContext.setDefaultContext
     (new DefaultContext("jdbc:oracle:oci8:@", "scott", "tiger", false));
     String name = "SCOTT";
     #sql { UPDATE emp SET sal = sal * 1.1 WHERE ename = :name };
     #sql { COMMIT };
     DefaultContext.getDefaultContext().close();
     } }
     String[] emps = new String[] { "Scott", "Miller", "King" };
     double[] raises = new double[] { 8.0, 4.0, 0.0 };
     for (int i=0; i<emps.length; i++)
     #sql { UPDATE emp SET sal = sal * :(1.0 + raises[i] / 100.0)
     WHERE ename = :(emps[i].toUpperCase()) };
     int j=0; double[] s = new double[emps.length];
     while (j<emps.length) {
     #sql { SELECT sal INTO :(s[j]) FROM emp
     WHERE ename = :(emps[j++].toUpperCase()) }; }