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
|
public void create(Vehicule obj) {
try{
connect.setAutoCommit(true);
Statement state = connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
PreparedStatement prepare = connect.prepareStatement("INSERT INTO vehicule (marque, moteur, prix, nom) VALUES(?, ?, ?, ?)");
prepare.setInt(1,0);
prepare.setInt(2,3);
prepare.setDouble(3, 10000);
prepare.setString(4,"newCar");
int nbMaj = prepare.executeUpdate();
System.out.println("nb de mises à jour: " + nbMaj);
prepare.executeUpdate();
String query = "Select * FROM vehicule WHERE id = 19";
ResultSet res = state.executeQuery(query);
res.first();
System.out.println(res.getString("nom")+ " - " + res.getInt("marque") + " - " + res.getInt("moteur")+ " - " + res.getDouble("prix") + " - " + res.getInt("id"));
connect.commit();
prepare.close();
res.close();
state.close();
} catch (SQLException e) {
e.printStackTrace();
}
} |
Partager