IBM PureQuery: Difference between revisions

Revision as of 14:07, 21 August 2009

Revision as of 07:02, 31 October 2009

Line 38:

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, :commisioncommission)", employee);

// Query the database for employees

Line 53:

@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, :commisioncommission)")

int createEmployee(Employee e);