1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93
|
import java.awt.BorderLayout;
import java.awt.Component;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.*;
import javax.swing.table.DefaultTableCellRenderer;
public class modifier_enseig {
public modifier_enseig() throws SQLException {
Statement state = Connect.getInstance()
.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY
);
ResultSet res = state.executeQuery("SELECT num_ensig,nom FROM enseignant");
res.last();
int rowCount = res.getRow();
System.out.println(rowCount);
res.beforeFirst();
Object[] data = new Object[rowCount];
int i=0;
while(res.next()){
data[i] = res.getString("num_ensig")+" > "+res.getString("nom");
i++;
}
JOptionPane jop = new JOptionPane(), jop2 = new JOptionPane();
ImageIcon img = new ImageIcon("images/admin.jpg");
String modele = (String)jop.showInputDialog(null,
"Veuillez choisir le num d'enseignant a modifier !",
"Modification d'un enseig !",
JOptionPane.QUESTION_MESSAGE,
img,
data,
null);
//PreparedStatement prepare = Connect.getInstance().prepareStatement("UPDATE professeur set prof_prenom = ? WHERE prof_nom = 'MAMOU'");
try{
String[] str = modele.split("\\ > ");
res = state.executeQuery("SELECT * FROM enseignant WHERE num_ensig= '"+str[1]+"' ");
res.first();
res.next()
//ici la ligne 69 qui est renvoyé au niveau des erreur! mais je sais pas //pourquoi???
String num_ensig = res.getString("num_ensig");
String nom = res.getString("nom");
String prenom = res.getString("prenom");
String grade = res.getString("grade");
String mail = res.getString("mail");
//int id = res.getInt("id");
System.out.println(nom);
String prenom1 = res.getString("prenom");
ajouter_enseig a = new ajouter_enseig (num_ensig,nom,prenom,grade,mail);
ajouter_enseig zd = new ajouter_enseig (null, "Modifier un enseignant", true);
}catch(NullPointerException e) {}
res.close();
state.close();
}
} |
Partager