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
|
// INSERTION DANS LA TABLE Tissu_Plaque
try{ PreparedStatement ps1 = null;
Class.forName(driver);
Connection con = DriverManager.getConnection(url,user,pass);
//Statement st = con.createStatement();
String requete =" use Dep_CAD INSERT INTO Tissu_Plaque (Ref_Tissu_P, Designation_Tissu, Laize,Rotation,\n" +
" Url_Image, Longueur_Plaque, Vitesse_Coupe, Seuil ) VALUES (?,?,?,?,?,?,?,?)";
ps1 = con.prepareStatement(requete);
float L = Float.parseFloat(JTF_Laize.getText());
float F= Float.parseFloat(JTF_Longueur_Plaque.getText());
ps1 = con.prepareStatement(requete);
ps1.setString(1, JTF_Reference.getText());
ps1.setString(2, JTF_Designation.getText());
ps1.setFloat(3, L);
ps1.setString(4, JTF_Rotation.getText());
ps1.setString(5, JTF_Url_Image.getText());
ps1.setFloat(6, F);
ps1.setString(7, JTF_Vitesse_Coupe.getText());
ps1.setString(8, JTF_Seuil.getText());
ps1.setInt(9,0);
javax.swing.JOptionPane.showMessageDialog(null,"OK");
System.out.println("Le code d'insertion s'est exécuté");
}
catch (Exception e)
{
} |
Partager