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
| public void ajouterEleve(Connection con, String nom, String prenom, int age, String sexe)
{
try{
int i=0;
PreparedStatement statement = con.prepareStatement("INSERT INTO \"Joueur\" (\"nom\", \"prénom\", \"âge\", \"sexe\",\"ID_joueur\",\"adresse\",\"code postal\",\"téléphone\",\"email\",\"classement\") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
statement.setString(1, nom);
statement.setString(2, prenom);
statement.setInt(3, age);
statement.setString(4, sexe);
statement.setInt(5,552556565);
statement.setString(6, "france");
statement.setInt(7, 63000);
statement.setString(8, "0615465465");
statement.setString(9, "test@free.fr");
statement.setString(10, "30/0");
i = statement.executeUpdate();
con.commit();
con.close();
System.out.println("nombre de colonnes concernées :" +i);
}
catch(SQLException e)
{
System.out.println("Exception SQL : ");
while (e != null)
{
String message = e.getMessage();
String sqlState = e.getSQLState();
int errorCode = e.getErrorCode();
System.out.println("Message = "+message);
System.out.println("SQLState = "+sqlState);
System.out.println("ErrorCode = "+errorCode);
e = e.getNextException();
}
}
} |
Partager