SQLJ

 PreparedStatement statement = conn.prepareStatement(
    "SELECT LASTNAME"
  + " , FIRSTNME"
  + " , SALARY"
  + " FROM DSN8710.EMP"
  + " WHERE SALARY BETWEEN ? AND ?");
 statement.setBigDecimal(1, min);
 statement.setBigDecimal(2, max);
 ResultSet rs = statement.executeQuery();
 while (rs.next()) {
   lastname = rs.getString(1);
   firstname = rs.getString(2);
   salary = rs.getBigDecimal(3);
   // 行を表示させる...
 }
 rs.close();
 statement.close();

 #sql private static iterator EmployeeIterator(String, String, BigDecimal);
 ...
 EmployeeIterator iter;
 #sql [ctx] iter = {
   SELECT LASTNAME
        , FIRSTNME
        , SALARY
     FROM DSN8710.EMP
    WHERE SALARY BETWEEN :min AND :max
 };
 while (true) {
   #sql {
     FETCH :iter
      INTO :lastname, :firstname, :salary
   };
   if (iter.endFetch()) break;
   // 行を表示させる...
 }
 iter.close();

 PreparedStatement statement = conn.prepareStatement(
     "SELECT MAX(SALARY), AVG(SALARY)"
   + " FROM DSN8710.EMP");
 rs = statement.executeQuery();
 if (!rs.next()) {
   // エラー -- 該当行なし
 }
 maxSalary = rs.getBigDecimal(1);
 avgSalary = rs.getBigDecimal(2);
 if (rs.next()) {
   // エラー -- 複数行が存在
 }
 rs.close();
 statement.close();

 #sql [ctx] {
   SELECT MAX(SALARY), AVG(SALARY)
     INTO :maxSalary, :avgSalary
     FROM DSN8710.EMP
 };

 statement = conn.prepareStatement(
    "INSERT INTO DSN8710.EMP " +
    "(EMPNO, FIRSTNME, MIDINIT, LASTNAME, HIREDATE, SALARY) "
  + "VALUES (?, ?, ?, ?, CURRENT DATE, ?)");
 statement.setString(1, empno);
 statement.setString(2, firstname);
 statement.setString(3, midinit);
 statement.setString(4, lastname);
 statement.setBigDecimal(5, salary);
 statement.executeUpdate();
 statement.close();