SQL/MX Programming Manual for Java

SQLJ Programming
HP NonStop SQL/MX Programming Manual for Java—523726-003
3-58
Converting Between SQLJ Iterators and JDBC
Result Sets
// Other Java variable declarations and initializations
String empname = null;
BigDecimal salary = null;
// Assign the result set of a query to an iterator object
// named iter
#sql iter = {SELECT last_name, salary
FROM samdbcat.persnl.employee
WHERE deptnum = :(argv[2])};
// Get the result set corresponding to the iter object
ResultSet rs = iter.getResultSet();
// Retrieve rows and assign columns while next() returns true
while (rs.next()) {
empname = rs.getString(1);
salary = rs.getBigDecimal(2);
System.out.println(empname + " earns " + salary);
}
iter.close();