public String generateUserInsertQuery(Staff staff) {
StringBuffer strQuery = new StringBuffer(INSERT_USER_QUERY);
strQuery.append(staff.getF_name());
strQuery.append("', '");
strQuery.append(staff.getL_name());
strQuery.append("', '");
strQuery.append(staff.getPassword());
strQuery.append("', '");
strQuery.append(staff.getEmail());
strQuery.append("', '");
strQuery.append(staff.getAddress());
strQuery.append("', '");
strQuery.append(staff.getCity());
strQuery.append("', '");
strQuery.append(staff.getState());
strQuery.append("', '");
strQuery.append(staff.getZipcode());
strQuery.append("', '");
strQuery.append(utility.convertStringToDate(staff.getDob()));
strQuery.append("', '");
strQuery.append(staff.getType());
strQuery.append("')");
System.out.println("Insert User query : " + strQuery.toString());
return strQuery.toString();
}
public void insertIntoStaffTable(int user_id, Staff staff) {
StringBuffer strQuery = new StringBuffer(INSERT_STAFF_QUERY);
strQuery.append(user_id);
strQuery.append("', '");
strQuery.append(staff.getStaff_ssn());
strQuery.append("', '");
strQuery.append(staff.getWork_desc());
strQuery.append("', '");
strQuery.append(staff.getPosition());
strQuery.append("', '");
strQuery.append(utility.convertStringToDate(staff.getHire_date()));
strQuery.append("')");
System.out.println("Insert Staff query : " + strQuery.toString());
try {
DBOperation.executeQuery(strQuery.toString());
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}