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
| package gestionoutilbricolage;
import java.awt.Component;
import java.sql.*;
import javax.swing.JOptionPane;
public class FenetreAjoutOutil extends javax.swing.JFrame {
Statement stmt;
Connexion maconnexion = new Connexion();
private Component mainFrame;
/** Creates new form FenetreAjoutOutil */
public FenetreAjoutOutil() {
initComponents();
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String nomOutil = JTNomOutil.getText();
String fabricantOutil = JTFabricantOutil.getText();
String anneeFabrication = JTAnneeFabrication.getText();
String prix = JTPrix.getText();
String requete = "INSERT INTO OUTIL(nom_outil,fabricant_outil,annee_fabrication,prix_outil) VALUES('"+nomOutil+"','"+fabricantOutil+"','"+anneeFabrication+"','"+prix+"')";
try{
stmt = maconnexion.ObtenirConnexion().createStatement();
//stmt.executeQuery(requete);// executeQuery ne passe pas pour l'insertion d'une valeur dans une base MySQL
stmt.executeUpdate(requete);
JOptionPane.showMessageDialog(mainFrame, "Votre requête a été exécuté" );
JTNomOutil.setText("");
JTFabricantOutil.setText("");
JTAnneeFabrication.setText("");
JTPrix.setText("");
}
catch(SQLException ex){
System.err.println(ex);
}
}
public static void main(String args[]) {
/* Set the Nimbus look and feel */
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
* For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(FenetreAjoutOutil.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(FenetreAjoutOutil.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(FenetreAjoutOutil.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(FenetreAjoutOutil.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new FenetreAjoutOutil().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JTextField JTAnneeFabrication;
private javax.swing.JTextField JTFabricantOutil;
private javax.swing.JTextField JTNomOutil;
private javax.swing.JTextField JTPrix;
private javax.swing.JButton jButton1;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JPanel jPanel1;
// End of variables declaration
} |
Partager