1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| public void insert(String nom , Vector f){
String queryInsert = "insert into IMAGE (nom,Tr) values ('"+nom+"','"+f.size()+"')";
String querySelectId = "select id from IMAGE where nom=\""+nom+"\"";
//String queryInsertFourrier=
try {// connexion et execution de la requete
stmt = con.createStatement();
stmt.executeUpdate(queryInsert);
System.out.println(queryInsert);
//stmt.close(); //Close the statement
ResultSet rset = stmt.executeQuery(querySelectId);
String id ="0";
while (rset.next()) {
id=rset.getString(1);
} |
Partager