@Override
public List<TravelAgent> getAll() {
this.list = new ArrayList<TravelAgent>();
try {
this.stat = this.conn.createStatement();
this.rs = this.stat.executeQuery(SELECT_ALL);
while (rs.next()) {
TravelAgent ag = new TravelAgent();
ag.setId(rs.getString("id_agent"));
ag.setName(rs.getString("name_agent"));
ag.setAlamat(rs.getString("alamat_agent"));
ag.setNegara(rs.getString("negara_agent"));
ag.setProvinsi(rs.getString("provinsi_agent"));
ag.setWebsite(rs.getString("website_agent"));
ag.setPhone(rs.getString("telp_agent"));
ag.setEmail(rs.getString("email_agent"));
ag.setFax(rs.getString("fax_agent"));
ag.setRegDate(rs.getString("reg_agent"));
ag.setStatus(rs.getInt("status_agent"));
ag.setContactName(rs.getString("contact_name_agent"));
ag.setContactPosisi(rs.getString("contact_posisi_agent"));
ag.setContactPhone(rs.getString("contact_phone_agent"));
ag.setFee(rs.getInt("fee_agent"));
this.list.add(ag);
}
} catch (SQLException ex) {
Logger.getLogger(PegawaiDAO.class.getName()).log(Level.SEVERE, null, ex);
}
return this.list;
}
