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 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128
| import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
public class Avocat extends javax.swing.JInternalFrame {
public Avocat() {
initComponents();
this.ref();
}
Avocat(String string) {
super(string);
this.initComponents();
}
@SuppressWarnings("unchecked")
//Generated code , sous netbens private void ajouterActionPerformed(java.awt.event.ActionEvent evt) {
if(JOptionPane.showConfirmDialog(null,"VOULEZ-VOUS VRAIMENT AJOUTER CET Avocat?",
"CONFIRMATION",JOptionPane.YES_NO_OPTION)==JOptionPane.YES_OPTION){
int a=jTable2.getSelectedRow();
System.out.println(" la ligne "+a);
Object Av=jTable2.getModel().getValueAt(a,0);
System.out.println("la valeur de '"+a+" et 0' ="+Av);
Object Cab=jTable2.getModel().getValueAt(a,1);
System.out.println("la valeur de '"+a+" et 1' ="+Cab);
Object Adr=jTable2.getModel().getValueAt(a,2);
System.out.println("la valeur de '"+a+" et 2' ="+Adr);
Object GS=jTable2.getModel().getValueAt(a,3);
System.out.println("la valeur de '"+a+" et 3' ="+GS);
Object Tl=jTable2.getModel().getValueAt(a,4);
System.out.println("la valeur de '"+a+" et 4' ="+Tl);
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=null;
con = (Connection) DriverManager.getConnection( "jdbc:mysql://localhost:3306/mabase?user=root&password=");
Statement st=(Statement) con.createStatement();
st.executeUpdate("insert into Avocat values('"+Av+"','"+Cab+"','"+Adr+"','"+GS+"','"+Tl+"')");
}catch(Exception e)
{System.out.println(e.toString());
}
}
Object[][] bj=new Object[get_row_log()][5];
jTable2.setModel(new javax.swing.table.DefaultTableModel(bj,
new String [] {"Avocat","Cabinet", "Adresse","GSM", "Tél"}
));
jTable2.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton ajouter;
private javax.swing.JPanel jPanel2;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JTable jTable2;
// End of variables declaration
public int get_row_log()
{int i=0;
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/mabase?user=root&password=");
Statement st = (Statement) con.createStatement();
ResultSet rs = st.executeQuery("SELECT * from Avocat");
while(rs.next())
i++;
return i;
}
catch (Exception e) {
System.out.println(e.toString());
return i;
}
}
public void ref (){
try {
Class.forName("com.mysql.jdbc.Driver");
String urlData=new String("jdbc:mysql://localhost:3306/mabase?user=root&password=");
java.sql.Connection conn = DriverManager.getConnection(urlData);
Statement st = (Statement) conn.createStatement();
String query = "select * from Avocat";
st = (Statement) conn.createStatement();
ResultSet rs = st.executeQuery(query);
int m=0;
while(rs.next()){
jTable2.setValueAt(rs.getString("Nom_Prénom") , m, 0);
jTable2.setValueAt(rs.getString("Cabinet") , m, 1);
jTable2.setValueAt(rs.getString("Adresse") , m, 2);
jTable2.setValueAt(rs.getString("GSM") , m, 3);
jTable2.setValueAt(rs.getString("Tél") , m, 4);
m++;
}
st.close();
conn.close();
}
catch (Exception e) {
System.out.println(e.toString());
e.printStackTrace();
}
}
} |
Partager