IBM PureQuery

Data data = DataFactory.getData (datasource);
// Insert an employee of type Employee bean in the database
data.update("insert into EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDATE, SALARY,
 BONUS, COMM) values( :employeeNumber, :firstName, :midinit, :lastname, :workdept, :phoneno, :hiredate, :job, :edlevel, :sex, 
 :birthdate, :salary, :bonus, :commision)", employee);
 
// Query the database for employees
Iterator<Employee> employees = data.queryIterator ("select * from EMPLOYEE", Employee.class);
 
// Query the database for one employee
Iterator<Employee> employee = data.queryFirst ("select * from EMPLOYEE where EMPNO = :employeeNumber", Employee.class, 
  employees);

// Annotate createEmployee method with sql to execute when method is invoked
@Update(sql="insert into EMPLOYEE (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDATE, SALARY,
  BONUS, COMM) values( :employeeNumber, :firstName, :midinit, :lastname, :workdept, :phoneno, :hiredate, :job, :edlevel, 
  :sex, :birthdate, :salary, :bonus, :commision)")
int createEmployee(Employee e);
 
// Annotate getEmployees method with sql to execute when method is invoked
@Select(sql="select EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDATE, 
  SALARY, BONUS, COMM from EMPLOYEE")
Employee getEmployees();      
 
// Annotate getEmployee method with sql to execute when method is invoked
@Select(sql="select EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDATE, 
  SALARY, BONUS, COMM from EMPLOYEE where EMPNO = :employeeNumber")
Employee getEmployee(Employee e);