@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; }