1 2 3 4 5 6 7 8 9 10 11 12 13 14
| sql = "insert into t_annonce (ID, SSTHEME, TITRE, CONTENU,PHOTOPR, PHOTOSC1, PHOTOSC2) values (?,?,?,?,?,?,?)";
connection = getConnection();
PreparedStatement ps = connection.prepareStatement(sql);
try
{
ps.setString(1, annonce.getId());
ps.setString(2,annonce.getSsTheme() );
ps.setString(5,annonce.getTitre() );
ps.setString(6, annonce.getContenu());
ps.setBinaryStream(8, annonce.getPhotopr());
ps.setBinaryStream(9, annonce.getPhotosc1());
ps.setBinaryStream(10, annonce.getPhotosc2());
ps.executeUpdate(); |
Partager