ex8_22.txt

j2ee core design patterns

Example 8.22 
public class EmployeeTO {
    public String id;
    public String lastName;
    public String firstName;
    public String ss;
    public float   salary;
    public String divisionId;

    public EmployeeTO(String id,
                      String lastName,
                      String firstName,
                      String ss,
                      float salary,
                      String divisionId ) {
        this.id = id;
        this.lastName = lastName;
        this.firstName = firstName;
        this.ss = ss;
        this.salary = salary;
        this.divisionId = divisionId;
    }
}


public class EmployeeStoreManager {
    public void storeNew(EmployeeTO to) {
        String sql =
                "Insert into Employee( id, last_name, first_name, ss, salary, division_id ) " +
                " values( '?', '?', '?', '?', '?', '?' )";
        // ...
    }

    public void update(EmployeeTO to) {
        String sql =
                "Update Employee set last_name = '?', first_name = '?', salary = '?', division_id = '?' where id = '?'";
        // ...
    }

    public void delete(String empId) {
        String sql =
                "Delete from Employee where id = '?'";
        // ...
    }

    public EmployeeTO load(String empId) {