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
| for(Iterator j=mt.values().iterator();j.hasNext(); ){
Terme termeCourant=(Terme)j.next();
requete="select * from terme where terme="+"\""+termeCourant.getTerme()+"\"";
ResultSet exist=statement.executeQuery(requete);
if(!exist.next()){
ref_terme=termeCourant.getRef_terme();
terme=termeCourant.getTerme();
frq=termeCourant.getFrq();
doccount=termeCourant.getDoccount();
elements=termeCourant.getElements();
elmcount=termeCourant.getElmcount();
requete="insert into terme(terme, frq,doccount,elmcount,elements) values("+"\""+terme+"\""+","+termeCourant.getFrq()+","+doccount+","+elmcount+","+"?"+")";
PreparedStatement statement1 = getConnection().prepareStatement(requete);
statement1.setString(1,elements);
statement1.executeUpdate();
exist.close();
}//fin exist
else{
frq=termeCourant.getFrq()+exist.getInt("frq");
doccount=termeCourant.getDoccount()+exist.getInt("doccount");
elements=termeCourant.getElements()+exist.getString("elements");
elmcount=termeCourant.getElmcount()+exist.getInt("elmcount");
String requete1="update terme set frq="+frq+", doccount="+doccount+", elmcount="+elmcount+", elements = ? where terme="+"\""+terme+"\"";
PreparedStatement statement1 = getConnection().prepareStatement(requete1);
statement1.setString(1,elements);
statement1.executeUpdate();
exist.close();
}
}//fin mise à jour de terme |
Partager