1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
connection = ds.getconnection();
int NbrLigne = 0;
requete = "insert into article(nomarticle, descriptionarticle, prixarticle, datearticle,photoarticle, vignettearticle, etatarticle, id_categorie) values (?,?,?,?,?,?,?,?)";
PreparedStatement requetea = connection.PrepareStatement (requete);
requetea.setString(1, (String)article.getNomarticle());
requetea.setString(2, (String)article.getDescriptionarticle());
requetea.setString(3, (String)article.getPrixarticle());
requetea.setString(4, (String)article.getDateArticle());
requetea.setString(5, (String)article.getPhotoarticle());
requetea.setString(6, (String)article.getVignettearticle());
requetea.setString(7, (String)article.getEtatarticle());
requetea.setString(8, (String)article.getId_categorie());
NbrLigne = requetea.executeUpdate(); |
Partager