{filelink=23}

import java.sql.*;
import javax.swing.*;

public class TempsExecutionSQL
{
  
   public static void main(String argv[])
    {
      
                  String myDB="";
        try
        {
          myDB="jdbc:derby://localhost:1527/Avocats";
          Class.forName("org.apache.derby.jdbc.ClientDriver");
          Properties pro=new Properties();
          pro.put("charSet", "utf-8");
          pro.put("username","dd");
          pro.put("password","ddd");
          long debut=System.currentTimeMillis();
          Connection avocatoo_conn=DriverManager.getConnection(myDB,pro);
          ResultSet rs=avocatoo_conn.createStatement()
                  .executeQuery("Select ID, Fonction,\"Nom Complet\",Téléphone"
              + ",GSM,Email,adresse,ville from Contacts");
          while(rs.next())
          {
             String ID=rs.getString(1);
             String fonc=rs.getString(2);
             String nom=rs.getString(3);
             String tel=rs.getString(4);
             String gsm=rs.getString(5);
             String email=rs.getString(6);
             String adresse=rs.getString(7);
             String ville=rs.getString(8);
          }
          long fin=System.currentTimeMillis();
          long diff=fin-debut;
          JOptionPane.showMessageDialog(mainPanel, "Opération terminée en: "+(diff/100f)+"sec");
        }
        catch(Exception err)
            {
                err.printStackTrace();
            }

    }

}