private Vendor getVendorAset(int idVendor) throws SQLException {
String query = "SELECT * FROM " + VENDOR_TABLE + " WHERE id = " + idVendor;
ResultSet rs = executeQuery(query);
Vendor vendor = null;
if (rs.next()) {
vendor = new Vendor();
vendor.setId(rs.getInt("id"));
vendor.setNama(rs.getString("nama"));
vendor.setAlamat(rs.getString("alamat"));
vendor.setTelepon(rs.getString("telepon"));
vendor.setEmail(rs.getString("email"));
}
return vendor;
}
