List<Film> kodefilm = new ArrayList<>();
try (PreparedStatement stat = cp.getConn().prepareStatement("select id from film where namafilm = ?")) {
stat.setString(1, namaFilm);
ResultSet res = stat.executeQuery();
if (res.next()) {
Film kodeFilm = new Film();
kodeFilm.setId(res.getInt("id"));
kodefilm.add(kodeFilm);
}
} catch (SQLException ex) {
Logger.getLogger(ConcreteFilmDao.class.getName()).log(Level.SEVERE, null, ex);
}