/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

package migration;
import java.io.*;
import java.io.BufferedWriter.*;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.List;
import javax.swing.DefaultListModel;
import javax.swing.JTextArea;
import javax.swing.SwingUtilities;
import javax.swing.SwingWorker;
import javax.swing.text.html.parser.DTDConstants;
import org.json.simple.JSONObject;

/**
 *
 * @author help
 */
public class Generer_JSON extends javax.swing.JFrame {

    /**
     * Creates new form Generer_JSON
     */
    public Generer_JSON() {
        initComponents();
    }

    /**
     * This method is called from within the constructor to initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is always
     * regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        jScrollPane1 = new javax.swing.JScrollPane();
        jList1 = new javax.swing.JList();
        jScrollPane2 = new javax.swing.JScrollPane();
        jList2 = new javax.swing.JList();
        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();
        jScrollPane3 = new javax.swing.JScrollPane();
        jTextArea1 = new javax.swing.JTextArea();
        jProgressBar1 = new javax.swing.JProgressBar();
        jButton3 = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);

        jList1.setModel(new javax.swing.AbstractListModel() {
            String[] strings = { "User", "Message", "Commune", "Adress", "Statut", "Commenter_statut", "Aimer_Statut", "Image", "Album", "Composer", "Aimer_Image", "Commenter_Image", "Groupe", "Adherer", "Message", "Evenement", "Inviter", "Participer", "Etre_Amie" };
            public int getSize() { return strings.length; }
            public Object getElementAt(int i) { return strings[i]; }
        });
        jScrollPane1.setViewportView(jList1);

        jScrollPane2.setViewportView(jList2);

        jButton1.setText("Selectionner");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });

        jButton2.setText("Generer_les_ficher_JSON");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });

        jTextArea1.setColumns(20);
        jTextArea1.setRows(5);
        jScrollPane3.setViewportView(jTextArea1);

        jButton3.setText("jButton3");
        jButton3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton3ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGap(24, 24, 24)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                        .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(layout.createSequentialGroup()
                                .addGap(101, 101, 101)
                                .addComponent(jButton1)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 140, Short.MAX_VALUE)
                                .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 150, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addGap(22, 22, 22))
                            .addGroup(layout.createSequentialGroup()
                                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addGroup(layout.createSequentialGroup()
                                        .addGap(81, 81, 81)
                                        .addComponent(jButton2))
                                    .addGroup(layout.createSequentialGroup()
                                        .addGap(8, 8, 8)
                                        .addComponent(jProgressBar1, javax.swing.GroupLayout.PREFERRED_SIZE, 356, javax.swing.GroupLayout.PREFERRED_SIZE)))
                                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))))
                    .addGroup(layout.createSequentialGroup()
                        .addComponent(jScrollPane3)
                        .addContainerGap())))
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(jButton3)
                .addGap(281, 281, 281))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addGroup(layout.createSequentialGroup()
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(layout.createSequentialGroup()
                                .addContainerGap()
                                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 209, javax.swing.GroupLayout.PREFERRED_SIZE))
                            .addGroup(layout.createSequentialGroup()
                                .addGap(12, 12, 12)
                                .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 196, javax.swing.GroupLayout.PREFERRED_SIZE)))
                        .addGap(18, 18, 18))
                    .addGroup(layout.createSequentialGroup()
                        .addGap(64, 64, 64)
                        .addComponent(jButton1)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 73, Short.MAX_VALUE)
                        .addComponent(jButton2)
                        .addGap(55, 55, 55)))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 5, Short.MAX_VALUE)
                .addComponent(jButton3)
                .addGap(26, 26, 26)
                .addComponent(jProgressBar1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(74, 74, 74)
                .addComponent(jScrollPane3, javax.swing.GroupLayout.PREFERRED_SIZE, 202, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap())
        );

        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
        // TODO add your handling code here:
             jList1.getSelectionModel().addListSelectionListener(null);
    DefaultListModel<String> model=new DefaultListModel<>(); 
       for(Object selected :jList1.getSelectedValuesList()) {
          model.addElement((String) selected);
         // System.out.println(    model.contains("users"));
          
       }
       jList2.setModel(model); 
    }//GEN-LAST:event_jButton1ActionPerformed

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
     try{
     
        Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/reseau_social","root","root");//?user=root&password=root\"");
        System.out.println("connexion à la base de données réussie ");
        Statement stmt = connect.createStatement(); 
        
    // Task task = new Task();
          //  task.start();{
         DefaultListModel<String> model=new DefaultListModel<>();
         for(Object selected :jList1.getSelectedValuesList()) {
         model.addElement((String) selected);
         }
     
if(model.contains("User")){
    ResultSet rs1 = stmt.executeQuery( "select * from user  " ) ;
    ResultSetMetaData resultMeta = rs1.getMetaData();
    JSONObject obj = new JSONObject();
    File file1 =new File ("C:\\Users\\help\\Desktop\\users.json") ;
    file1.createNewFile();
    FileWriter writer =new FileWriter(file1);
      
while(rs1.next()){ 
    obj.put("id_user", rs1.getObject(1).toString()) ;
    obj.put("nom", rs1.getObject(2).toString());
    obj.put("prenom", rs1.getObject(3).toString()) ;
    obj.put("email", rs1.getObject(4).toString());
    obj.put("mot_de_pass", rs1.getObject(5).toString()) ;
    obj.put("id_commune", rs1.getObject(6).toString());
       
    Object jsoncontent = obj;
    System.out.println("le"+jsoncontent);
    jTextArea1.append(jsoncontent.toString()+"\n");
    writer.write(jsoncontent.toString()+"\n");
    writer.flush();
    }  rs1.close();
    }
     
     
/**************************************commune*****************************************/    
     
 if(model.contains("Commune")){
    JSONObject obj2 = new JSONObject();
    ResultSet rs2 = stmt.executeQuery( "select * from commune " ) ;
    ResultSetMetaData	  resultMeta3 = rs2.getMetaData();
   
    File file2 =new File ("C:\\Users\\help\\Desktop\\commune.json") ;
    file2.createNewFile();
    FileWriter writer2 =new FileWriter(file2);
    while(rs2.next())
    { 
        obj2.put("id_commune", rs2.getObject(1).toString()) ;   // for(int i = 1; i <=  resultMeta.getColumnCount(); i++){
        obj2.put("nom_commune", rs2.getObject(2).toString());
         obj2.put("id_adress", rs2.getObject(3).toString());
        Object jsoncontent2 = obj2;
        System.out.println("le"+jsoncontent2);
    
        writer2.write(jsoncontent2.toString()+"\n");
        writer2.flush();
        jTextArea1.append(jsoncontent2.toString()+"\n");
         }  rs2.close();  
 }
 
 
 //////////////////////******************adress****************************///////////
 
 
  if(model.contains("Adress")){
 JSONObject obj1 = new JSONObject();
    ResultSet rs2 = stmt.executeQuery( "select * from adress " ) ;
    ResultSetMetaData	  resultMeta2 = rs2.getMetaData();
    File file1 =new File ("C:\\Users\\help\\Desktop\\adress.json") ;
    file1.createNewFile();
    FileWriter writer1 =new FileWriter(file1);
    while(rs2.next())
    { 
        obj1.put("id_adress", rs2.getObject(1).toString()) ;   // for(int i = 1; i <=  resultMeta.getColumnCount(); i++){
        obj1.put("nom_adress", rs2.getObject(2).toString());
        Object jsoncontent1 = obj1;
        System.out.println("le"+jsoncontent1);
        jTextArea1.append(jsoncontent1.toString()+"\n");
        writer1.write(jsoncontent1.toString()+"\n");
        writer1.flush();
        }  rs2.close();                                       // writer.close();
  }
 
 
 //////////////////////***************etre_amie*************************************************************/
 
   if(model.contains("Etre_Amie")){
   JSONObject obj4 = new JSONObject();
 
    ResultSet rs4 = stmt.executeQuery( "select * from etre_amie " );
    ResultSetMetaData	  resultMeta4 = rs4.getMetaData();
      // System.out.println("+++++++++"+rs4.getMetaData());
    File file4 =new File ("C:\\Users\\help\\Desktop\\etre_amie.json") ;
    file4.createNewFile();
    FileWriter writer4 =new FileWriter(file4);
 while(rs4.next())
    { 
        obj4.put("id_user", rs4.getObject(1).toString()) ;   // for(int i = 1; i <=  resultMeta.getColumnCount(); i++){
        obj4.put("id_user_1", rs4.getObject(2).toString());
        Object jsoncontent4 = obj4;
        System.out.println("le"+jsoncontent4);
        jTextArea1.append(jsoncontent4.toString());
        writer4.write(jsoncontent4.toString()+"\n");
        writer4.flush();
        }  rs4.close();             
   }
   
   
   
  /***************************statut************************************************/ 
  if(model.contains("Statut")){
   JSONObject obj4 = new JSONObject();
 
    ResultSet rs4 = stmt.executeQuery( "select * from statu " );
    ResultSetMetaData	  resultMeta4 = rs4.getMetaData();
      // System.out.println("+++++++++"+rs4.getMetaData());
    File file4 =new File ("C:\\Users\\help\\Desktop\\statut.json") ;
    file4.createNewFile();
    FileWriter writer4 =new FileWriter(file4);
 while(rs4.next())
    { 
        obj4.put("id_statu", rs4.getObject(1).toString()) ;   // for(int i = 1; i <=  resultMeta.getColumnCount(); i++){
        obj4.put("id_user", rs4.getObject(2).toString());
        Object jsoncontent4 = obj4;
        System.out.println("le"+jsoncontent4);
        jTextArea1.append(jsoncontent4.toString());
        writer4.write(jsoncontent4.toString()+"\n");
        writer4.flush();
        }  rs4.close();             
   }  
   
 /*****************************************commenter le statut***************************************************/  
  if(model.contains("Commenter_statut")){
   JSONObject obj4 = new JSONObject();
 
    ResultSet rs4 = stmt.executeQuery( "select * from commenter_statu " );
    ResultSetMetaData	  resultMeta4 = rs4.getMetaData();
      // System.out.println("+++++++++"+rs4.getMetaData());
    File file4 =new File ("C:\\Users\\help\\Desktop\\cmnt_statu.json") ;
    file4.createNewFile();
    FileWriter writer4 =new FileWriter(file4);
 while(rs4.next())
    { 
        obj4.put("id_statu", rs4.getObject(1).toString()) ;   
        obj4.put("commentaire", rs4.getObject(2).toString()) ; 
        obj4.put("id_user", rs4.getObject(3).toString());
        Object jsoncontent4 = obj4;
        System.out.println("le"+jsoncontent4);
        jTextArea1.append(jsoncontent4.toString()+"\n");
        writer4.write(jsoncontent4.toString()+"\n");
        writer4.flush();
        }  rs4.close();             
   }  
 
  
 /******************************     Aimer un statu         ***********************************///
   if(model.contains("Aimer_Statut")){
   JSONObject obj4 = new JSONObject();
 
    ResultSet rs4 = stmt.executeQuery( "select * from aimer_statu " );
    ResultSetMetaData	  resultMeta4 = rs4.getMetaData();
      // System.out.println("+++++++++"+rs4.getMetaData());
    File file4 =new File ("C:\\Users\\help\\Desktop\\aime_statu.json") ;
    file4.createNewFile();
    FileWriter writer4 =new FileWriter(file4);
 while(rs4.next())
    { 
        obj4.put("id_statu", rs4.getObject(1).toString()) ;   
       
        obj4.put("id_user", rs4.getObject(2).toString());
        Object jsoncontent4 = obj4;
        System.out.println("le"+jsoncontent4);
        jTextArea1.append(jsoncontent4.toString()+"\n");
        writer4.write(jsoncontent4.toString()+"\n");
        writer4.flush();
        }  rs4.close();             
   }     
     
     
/*******************************         image                *************************************************************/     
    if(model.contains("Image")){
   JSONObject obj4 = new JSONObject();
 
    ResultSet rs4 = stmt.executeQuery( "select * from image " );
    ResultSetMetaData	  resultMeta4 = rs4.getMetaData();
      // System.out.println("+++++++++"+rs4.getMetaData());
    File file4 =new File ("C:\\Users\\help\\Desktop\\image.json") ;
    file4.createNewFile();
    FileWriter writer4 =new FileWriter(file4);
 while(rs4.next())
    { 
        obj4.put("id_image", rs4.getObject(1).toString()) ;   
        obj4.put("type_image", rs4.getObject(2).toString()) ; 
        Object jsoncontent4 = obj4;
        System.out.println("le"+jsoncontent4);
        jTextArea1.append(jsoncontent4.toString()+"\n");
        writer4.write(jsoncontent4.toString()+"\n");
        writer4.flush();
        }  rs4.close();             
   }    
     
 /****************************************Album *************************************************************************/    
     
  if(model.contains("Album")){
   JSONObject obj4 = new JSONObject();
 
    ResultSet rs4 = stmt.executeQuery( "select * from album " );
    ResultSetMetaData	  resultMeta4 = rs4.getMetaData();
      // System.out.println("+++++++++"+rs4.getMetaData());
    File file4 =new File ("C:\\Users\\help\\Desktop\\album.json") ;
    file4.createNewFile();
    FileWriter writer4 =new FileWriter(file4);
 while(rs4.next())
    { 
        obj4.put("id_album", rs4.getObject(1).toString()) ;   
        obj4.put("id_user", rs4.getObject(2).toString());
        Object jsoncontent4 = obj4;
        System.out.println("le"+jsoncontent4);
        jTextArea1.append(jsoncontent4.toString()+"\n");
        writer4.write(jsoncontent4.toString()+"\n");
        writer4.flush();
        }  rs4.close();             
   }      
     
/*************************composer*********************************************************/  
 if(model.contains("Composer")){
   JSONObject obj4 = new JSONObject();
 
    ResultSet rs4 = stmt.executeQuery( "select * from composer " );
    ResultSetMetaData	  resultMeta4 = rs4.getMetaData();
      // System.out.println("+++++++++"+rs4.getMetaData());
    File file4 =new File ("C:\\Users\\help\\Desktop\\composer.json") ;
    file4.createNewFile();
    FileWriter writer4 =new FileWriter(file4);
 while(rs4.next())
    { 
        obj4.put("id_album", rs4.getObject(1).toString()) ;   
        obj4.put("id_user", rs4.getObject(2).toString());
        Object jsoncontent4 = obj4;
        System.out.println("le"+jsoncontent4);
        jTextArea1.append(jsoncontent4.toString()+"\n");
        writer4.write(jsoncontent4.toString()+"\n");
        writer4.flush();
        }  rs4.close();             
   }    
  
     
 
 /*************************************************aimer image**********************************************************/
  if(model.contains("Aimer_Image")){
   JSONObject obj4 = new JSONObject();
 
    ResultSet rs4 = stmt.executeQuery( "select * from aimer_image " );
    ResultSetMetaData	  resultMeta4 = rs4.getMetaData();
      // System.out.println("+++++++++"+rs4.getMetaData());
    File file4 =new File ("C:\\Users\\help\\Desktop\\aime_image.json") ;
    file4.createNewFile();
    FileWriter writer4 =new FileWriter(file4);
 while(rs4.next())
    { 
        obj4.put("id_user", rs4.getObject(1).toString()) ;   
         
        obj4.put("id_image", rs4.getObject(2).toString());
        Object jsoncontent4 = obj4;
        System.out.println("le"+jsoncontent4);
        jTextArea1.append(jsoncontent4.toString()+"\n");
        writer4.write(jsoncontent4.toString()+"\n");
        writer4.flush();
        }  rs4.close();             
   }  
 /**********************************COMMENTER IMAGE*****************************************************************/
 if(model.contains("Commenter_Image")){
   JSONObject obj4 = new JSONObject();
 
    ResultSet rs4 = stmt.executeQuery( "select * from commenter_image " );
    ResultSetMetaData	  resultMeta4 = rs4.getMetaData();
      // System.out.println("+++++++++"+rs4.getMetaData());
    File file4 =new File ("C:\\Users\\help\\Desktop\\aime_image.json") ;
    file4.createNewFile();
    FileWriter writer4 =new FileWriter(file4);
 while(rs4.next())
    { 
        obj4.put("id_user", rs4.getObject(1).toString()) ;   
         
        obj4.put("id_image", rs4.getObject(2).toString());
        Object jsoncontent4 = obj4;
        System.out.println("le"+jsoncontent4);
        jTextArea1.append(jsoncontent4.toString()+"\n");
        writer4.write(jsoncontent4.toString()+"\n");
        writer4.flush();
        }  rs4.close();             
   }  
 
 /************************************ groupe***********************************************************************/
 if(model.contains("Groupe")){
   JSONObject obj4 = new JSONObject();
 
    ResultSet rs4 = stmt.executeQuery( "select * from groupe " );
    ResultSetMetaData	  resultMeta4 = rs4.getMetaData();
      // System.out.println("+++++++++"+rs4.getMetaData());
    File file4 =new File ("C:\\Users\\help\\Desktop\\groupe.json") ;
    file4.createNewFile();
    FileWriter writer4 =new FileWriter(file4);
 while(rs4.next())
    { 
         obj4.put("id_groupe", rs4.getObject(1).toString()) ; 
        obj4.put("id_user", rs4.getObject(2).toString()) ;   
         
        obj4.put("id_image", rs4.getObject(3).toString());
        Object jsoncontent4 = obj4;
        System.out.println("le"+jsoncontent4);
        jTextArea1.append(jsoncontent4.toString()+"\n");
        writer4.write(jsoncontent4.toString()+"\n");
        writer4.flush();
        }  rs4.close();             
   }  
 
 /**************************************adherer *************************************************/
 if(model.contains("Adherer")){
   JSONObject obj4 = new JSONObject();
 
    ResultSet rs4 = stmt.executeQuery( "select * from adherer " );
    ResultSetMetaData	  resultMeta4 = rs4.getMetaData();
      // System.out.println("+++++++++"+rs4.getMetaData());
    File file4 =new File ("C:\\Users\\help\\Desktop\\adherer.json") ;
    file4.createNewFile();
    FileWriter writer4 =new FileWriter(file4);
 while(rs4.next())
    { 
         obj4.put("id_user", rs4.getObject(1).toString()) ; 
        obj4.put("id_groupe", rs4.getObject(2).toString()) ;   
       
        Object jsoncontent4 = obj4;
        System.out.println("le"+jsoncontent4);
        jTextArea1.append(jsoncontent4.toString()+"\n");
        writer4.write(jsoncontent4.toString()+"\n");
        writer4.flush();
        }  rs4.close();             
   } 
  
/////////*****************************************************message***************************************/
 if(model.contains("Message")){
   JSONObject obj4 = new JSONObject();
 
    ResultSet rs4 = stmt.executeQuery( "select * from message " );
    ResultSetMetaData	  resultMeta4 = rs4.getMetaData();
      // System.out.println("+++++++++"+rs4.getMetaData());
    File file4 =new File ("C:\\Users\\help\\Desktop\\message.json") ;
    file4.createNewFile();
    FileWriter writer4 =new FileWriter(file4);
 while(rs4.next())
    { 
         obj4.put("id_message", rs4.getObject(1).toString()) ;
         obj4.put("contenu", rs4.getObject(2).toString());
        obj4.put("id_user", rs4.getObject(3).toString()) ;   
        obj4.put("id_user_1", rs4.getObject(4).toString()) ;  
       
        Object jsoncontent4 = obj4;
        System.out.println("le"+jsoncontent4);
        jTextArea1.append(jsoncontent4.toString()+"\n");
        writer4.write(jsoncontent4.toString()+"\n");
        writer4.flush();
        }  rs4.close();             
   } 
 
 
 /****************************evenement***********************************/
  if(model.contains("Evenement")){
   JSONObject obj4 = new JSONObject();
 
    ResultSet rs4 = stmt.executeQuery( "select * from evenement " );
    ResultSetMetaData	  resultMeta4 = rs4.getMetaData();
      // System.out.println("+++++++++"+rs4.getMetaData());
    File file4 =new File ("C:\\Users\\help\\Desktop\\evenement.json") ;
    file4.createNewFile();
    FileWriter writer4 =new FileWriter(file4);
 while(rs4.next())
    { 
        obj4.put("id_evenement", rs4.getObject(1));
        obj4.put("id_commune", rs4.getObject(2));
        obj4.put("id_user", rs4.getObject(3).toString()) ;   
        
       
        Object jsoncontent4 = obj4;
        System.out.println("le"+jsoncontent4);
        jTextArea1.append(jsoncontent4.toString()+"\n");
        writer4.write(jsoncontent4.toString()+"\n");
        writer4.flush();
        }  rs4.close();             
   } 
 
 /*****************************inviter******************************************/
  if(model.contains("Inviter")){
   JSONObject obj4 = new JSONObject();
 
    ResultSet rs4 = stmt.executeQuery( "select * from inviter " );
    ResultSetMetaData	  resultMeta4 = rs4.getMetaData();
      // System.out.println("+++++++++"+rs4.getMetaData());
    File file4 =new File ("C:\\Users\\help\\Desktop\\inviter.json") ;
    file4.createNewFile();
    FileWriter writer4 =new FileWriter(file4);
 while(rs4.next())
    { 
        obj4.put("id_evenement", rs4.getObject(1));
   
        obj4.put("id_user", rs4.getObject(2).toString()) ;   
        
       
        Object jsoncontent4 = obj4;
        System.out.println("le"+jsoncontent4);
        jTextArea1.append(jsoncontent4.toString()+"\n");
        writer4.write(jsoncontent4.toString()+"\n");
        writer4.flush();
        }  rs4.close();             
   } 
 /*************************************** participer*********************************/
  if(model.contains("Participer")){
   JSONObject obj4 = new JSONObject();
 
    ResultSet rs4 = stmt.executeQuery( "select * from participer " );
    ResultSetMetaData	  resultMeta4 = rs4.getMetaData();
      // System.out.println("+++++++++"+rs4.getMetaData());
    File file4 =new File ("C:\\Users\\help\\Desktop\\participer.json") ;
    file4.createNewFile();
    FileWriter writer4 =new FileWriter(file4);
 while(rs4.next())
    { 
        obj4.put("id_evenement", rs4.getObject(1));
   
        obj4.put("id_user", rs4.getObject(2).toString()) ;   
        
       
        Object jsoncontent4 = obj4;
        System.out.println("le"+jsoncontent4);
        jTextArea1.append(jsoncontent4.toString()+"\n");
        writer4.write(jsoncontent4.toString()+"\n");
        writer4.flush();
        }  rs4.close();             
   }
     
      
         
          }catch (Exception e){}  
        
    }//GEN-LAST:event_jButton2ActionPerformed

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed
     
/*  Task task = new Task(jList1.getSelectedValues(), jTextArea1);
 
     task.addPropertyChangeListener(evt-> {
         if ("progress".equals(evt.getPropertyName())) {
              int progress = (Integer) evt.getNewValue();
             jProgressBar1.setValue(progress); 
         }
      }); 
 
     task.execute();
   */
    }//GEN-LAST:event_jButton3ActionPerformed
 /*public class Task extends SwingWorker<Object, JSONObject> {
 
	private final static String PATH = "C:/Users/help/Desktop/";
 
	private final String[] values;
 
	private final JTextArea jtextArea;
 
/*	public Task(String [] values /*JTextArea jtextArea*//*) {
	/*	this.values=values;
		//this.jtextArea=jtextArea;
	}
 
	@Override
	protected Object doInBackground() throws Exception {
 
		int progression = 0;
 
		try( Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/reseau_social","root","root") ) {
			Statement stmt = connect.createStatement(); 
 
			for(String value : values) {
 
				createJSon(value, getTableName(value.toLowerCase()), getFileName(value.toLowerCase()), stmt);
				setProgress(++progression); // par exemple, pour une progression par objet
 
			}
 
		}
 
		return null;
	}
 
 
 
	private String getTableName(String value) {
		return value;
		/* ou si tu as besoin d'avoir des noms différents*/
 
	/*	String tableName;
		switch(value) {
		case "user":
			tableName = "user";
			break;
		case "adress":
			tableName = "adress";
			break;
			// JE TE LAISSE COMPLETER
		default:
			throw new IllegalStateException();
		}
		return tableName;
	}
 
    private String getFileName(String value) {
    	//return value + ".json"
    	String filename;
		switch(value) {
		case "user":
			filename = "users";
			break;
		case "adress":
			filename = "adress";
			break;
			// JE TE LAISSE COMPLETER
		default:
			throw new IllegalStateException();
		}
		return filename + ".json";
	}
 
	private void createJSon(String value, String tableName, String fileName, Statement stmt) throws SQLException, IOException {
    	try(ResultSet rs1 = stmt.executeQuery( "select * from " + tableName )) { 
	        ResultSetMetaData resultMeta = rs1.getMetaData();
 
	        try( BufferedWriter writer = Files.newBufferedWriter(Paths.get(PATH, fileName)) ) {
 
	        	 while(rs1.next()){ 
	        		 JSONObject json = new JSONObject(); 
	        		 for(int i=1; i<=resultMeta.getColumnCount(); i++) {
	        			 String columnName = resultMeta.getColumnName(i);
	        			 json.put(columnName, rs1.getObject(i).toString()) ;
	        		 }
	        		 writer.write(json.toString());
	        		 writer.write(System.lineSeparator());
	        		 publish(json);
	        	 }
 
	        }
 
    	}
 
        }}  
    }*/
//}
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        /* Set the Nimbus look and feel */
        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
        /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
         * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
         */
        try {
            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
                if ("Nimbus".equals(info.getName())) {
                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
                    break;
                }
            }
        } catch (ClassNotFoundException ex) {
            java.util.logging.Logger.getLogger(Generer_JSON.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(Generer_JSON.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(Generer_JSON.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(Generer_JSON.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        //</editor-fold>

        /* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new Generer_JSON().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton3;
    private javax.swing.JList jList1;
    private javax.swing.JList jList2;
    private javax.swing.JProgressBar jProgressBar1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JTextArea jTextArea1;
    // End of variables declaration//GEN-END:variables
}