private void suivantButtonActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_suivantButtonActionPerformed
pNumber++;
pageNumberLabel.setText(Integer.toString(pNumber));
GUI container = (GUI) SwingUtilities.getWindowAncestor(this); // on prend son grand pere
CallableStatement cs = null;
Connection conDB = container.getBeanbd().getConnexion();
ResultSet rs = null;
avisArea.setText("");
try {
cs = conDB.prepareCall("{? = call PACKAGERECHERCHE.getAvisFilm(?, ?)}");
cs.registerOutParameter(1, OracleTypes.CURSOR);
cs.setInt(2, filmID);
cs.setInt(3, pNumber);
cs.executeQuery();
rs = (ResultSet) cs.getObject(1);
while (rs.next()) {
avisArea.append("User : "******"\n");
avisArea.append("Avis : " + rs.getString(2) + "\n\n");
avisArea.append("---------------------------------\n\n");
}
} catch (SQLException ex) {
System.err.println("err " + ex);
}
} // GEN-LAST:event_suivantButtonActionPerformed
private void evaluerButtonActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_evaluerButtonActionPerformed
GUI container = (GUI) SwingUtilities.getWindowAncestor(this);
Connection conDB = container.getBeanbd().getConnexion();
NoterDialog dial =
new NoterDialog(
(Frame) SwingUtilities.getWindowAncestor(this),
true,
filmID,
conDB,
container.getUser());
dial.setVisible(true);
} // GEN-LAST:event_evaluerButtonActionPerformed
public void setFilm(Film f) {
// Affichage champs films
afficheLabel.setIcon(
new javax.swing.ImageIcon(getClass().getResource("/GUIapplicationFilm/Untitled.png")));
TitreLabel.setText(f.getTitre());
titreOriginalLabel.setText("Titre originale : " + f.getTitrOriginale());
runtimeLabel.setText("Runtime : " + f.getRuntime() + " min");
nbrVoteTmdbLabel.setText("Nombre votes tmdb : " + f.getNbrNote());
moyTmdbLabel.setText("Moyenne tmdb : " + f.getNoteMoyenne());
dateSortieLabel.setText(f.getDateSortie());
overviewArea.setLineWrap(true);
overviewArea.setWrapStyleWord(true);
overviewArea.setText(f.getOverview());
filmID = f.getId();
GUI container = (GUI) SwingUtilities.getWindowAncestor(this); // on prend son grand pere
CallableStatement cs = null;
Connection conDB = container.getBeanbd().getConnexion();
ResultSet rs = null;
/*RECUPERATION AFFICHE FILM*/
try {
cs = conDB.prepareCall("{? = call PACKAGERECHERCHE.getAfficheFilm(?)}");
cs.registerOutParameter(1, OracleTypes.CURSOR);
cs.setInt(2, f.getId());
cs.executeQuery();
rs = (ResultSet) cs.getObject(1);
if (rs.next()) {
Blob b = rs.getBlob(1);
ImageIcon im = new ImageIcon(b.getBytes(1, (int) b.length()));
afficheLabel.setIcon(im);
f.setAffiche(im);
}
} catch (SQLException ex) {
System.err.println("err " + ex);
}
/*RECUPERATION NOTES USER*/
try {
cs = conDB.prepareCall("{? = call PACKAGERECHERCHE.getNoteUtilisateurFilm(?)}");
cs.registerOutParameter(1, OracleTypes.CURSOR);
cs.setInt(2, f.getId());
cs.executeQuery();
rs = (ResultSet) cs.getObject(1);
if (rs.next()) {
nbrVoteLabel.setText("Nombre vote : " + rs.getString(1));
moyenneVoteLabel.setText("Moyenne vote : " + rs.getString(2));
}
} catch (SQLException ex) {
System.err.println("err " + ex);
}
/*RECUPERATION DES ACTEURS*/
DefaultListModel acteur = (DefaultListModel) acteurList.getModel();
acteur.clear();
try {
cs = conDB.prepareCall("{? = call PACKAGERECHERCHE.getActeursFilm(?)}");
cs.registerOutParameter(1, OracleTypes.CURSOR);
cs.setInt(2, f.getId());
cs.executeQuery();
rs = (ResultSet) cs.getObject(1);
while (rs.next()) {
acteur.addElement(rs.getString(1));
}
} catch (SQLException ex) {
System.err.println("err " + ex);
}
/*RECUPERATION REALISATEURS*/
DefaultListModel real = (DefaultListModel) realList.getModel();
real.clear();
try {
cs = conDB.prepareCall("{? = call PACKAGERECHERCHE.getRealisateursFilm(?)}");
cs.registerOutParameter(1, OracleTypes.CURSOR);
cs.setInt(2, f.getId());
cs.executeQuery();
rs = (ResultSet) cs.getObject(1);
while (rs.next()) {
real.addElement(rs.getString(1));
}
} catch (SQLException ex) {
System.err.println("err " + ex);
}
/*Affichage première page d'avis */
pNumber = 1;
pageNumberLabel.setText(Integer.toString(pNumber));
avisArea.setLineWrap(true);
avisArea.setWrapStyleWord(true);
avisArea.setText("");
try {
cs = conDB.prepareCall("{? = call PACKAGERECHERCHE.getAvisFilm(?, ?)}");
cs.registerOutParameter(1, OracleTypes.CURSOR);
cs.setInt(2, f.getId());
cs.setInt(3, pNumber);
cs.executeQuery();
rs = (ResultSet) cs.getObject(1);
while (rs.next()) {
avisArea.append("User : "******"\n");
avisArea.append("Avis : " + rs.getString(2) + "\n\n");
avisArea.append("---------------------------------\n\n");
}
} catch (SQLException ex) {
System.err.println("err " + ex);
}
}
