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 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92
| public void partagerPublicationReçueAToutLeMonde(PageFacebook p,Publication pub){
PrintWriter fluxSortie = null;
try
{
fluxSortie =
new PrintWriter(new FileOutputStream("partagePubCreesAToutLeMonde.txt"));
}
catch(FileNotFoundException e)
{ System.out.println("Erreur douverture fichier.txt.");
System.exit(0);
}
fluxSortie.print("Num Du Reseau ");
fluxSortie.print("Id Page Creatrice Du Pub ");
fluxSortie.print("Id Publication Créee ");
fluxSortie.print("Id Ami Reçu Pub ");
fluxSortie.print("Pourcentage De Partage ");
fluxSortie.print("Decision De Partage ");
fluxSortie.print("Id Ami Reçu Publication Partagée ");
fluxSortie.println(" ");
Connection connexion;
Statement statement;
ResultSet resultat;
try{
Class.forName("com.mysql.jdbc.Driver");
connexion=DriverManager.getConnection("jdbc:mysql://localhost/memoire","root","boutheina");
statement = connexion.createStatement();
for(int i=0;i<p.getAmis().size();i++){
PageFacebook pageAmi=p.getAmis().get(i);
if(pageAmi.aEteDiffusee){
return;
}
else{
pageAmi.setPublicationReçues(pub.getIdPublication());
float pourcentage=pourcentagePartage();
boolean a=partagerPublicationReçueSurMonMur(pageAmi,pub,pourcentage);
pageAmi.aEteDiffusee=true;
if(a==false){
String queryString = "INSERT INTO partagePubCreesAToutLeMonde" +
"(reseau,idPageCreatrice,idPubCreee,idAmiRecuPub,pourcentagePartage,decisionPartage)" +
" VALUES ((SELECT MAX(numReseau)FROM reseau),"+p.getIdPage()+","+pub.getIdPublication()+","+pageAmi.getIdPage()+","+pourcentage+","+a+")";
statement.executeUpdate(queryString);
//return;
}
if(a==true){
// pageAmiDeMonAmi.setPublicationReçues(pub.getIdPublication());
String queryString = "INSERT INTO partagePubCreesAToutLeMonde" +
"(reseau,idPageCreatrice,idPubCreee,idAmiRecuPub,pourcentagePartage,decisionPartage,idAmiRecuPubPartagee)" +
" VALUES ((SELECT MAX(numReseau)FROM reseau),"+p.getIdPage()+","+pub.getIdPublication()+","+pageAmi.getIdPage()+","+pourcentage+","+a+","+pageAmi.getAmis().get(i).getIdPage()+")";
statement.executeUpdate(queryString);
partagerPublicationReçueAToutLeMonde(pageAmi,pub);
}
}
}
resultat = statement.executeQuery("SELECT * FROM partagePubCreesAToutLeMonde");
while(resultat.next()){
fluxSortie.print(" ");
fluxSortie.print(resultat.getInt("reseau"));
fluxSortie.print(" ");
fluxSortie.print(resultat.getInt("idPageCreatrice"));
fluxSortie.print(" ");
fluxSortie.print(resultat.getInt("idPubCreee"));
fluxSortie.print(" ");
fluxSortie.print(resultat.getInt("idAmiRecuPub"));
fluxSortie.print(" ");
fluxSortie.print(resultat.getDouble("pourcentagePartage"));
fluxSortie.print(" ");
fluxSortie.print(resultat.getBoolean("decisionPartage"));
fluxSortie.print(" ");
fluxSortie.print(resultat.getInt("idAmiRecuPubPartagee"));
fluxSortie.println(" ");
fluxSortie.println("****************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************");
}
}
catch(Exception e){
e.printStackTrace();
System.out.print("Impossible de se connecter à MySQL");
}
fluxSortie.close( );
} |