import java.sql.*;

public class AfficherEmployes {
                                  
     static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";        
     static final String DATABASE_URL = "jdbc:mysql://localhost/ressources_humaines";


     public static void main( String args[] )      {
        Connection connection = null; 
        Statement statement = null; 

        try
        {
           Class.forName( JDBC_DRIVER );                             
           connection =  DriverManager.getConnection( DATABASE_URL, "user", "user");
           statement = connection.createStatement();                                       
           ResultSet resultSet = statement.executeQuery("SELECT * FROM employes");

           ResultSetMetaData metaData = resultSet.getMetaData();
           int numberOfColumns = metaData.getColumnCount();     
           System.out.println( "\nLes employes sont:" );
           System.out.println( "------------------\n" );

           for ( int i = 1; i <= numberOfColumns; i++ )
              System.out.printf( "%-8s\t", metaData.getColumnName( i ) );
           System.out.println("\n----------------------------------------------------------------");

           while ( resultSet.next() )
           {
              for ( int i = 1; i <= numberOfColumns; i++ )
                 System.out.printf( "%-8s\t", resultSet.getObject( i ) );
              System.out.println();
           } 
        } 
        catch ( SQLException sqlException )
        {
           sqlException.printStackTrace();
           System.exit( 1 );
        } 
        catch ( ClassNotFoundException classNotFound )
        {
           classNotFound.printStackTrace();
           System.exit( 1 );
        } 
        finally 
        {                                                             
           try                                                        
           {                                                          
              statement.close();                                      
              connection.close();                                     
           }                                               
           catch ( Exception exception )                              
           {                                                          
              exception.printStackTrace();                            
              System.exit( 1 );                                       
           }                                             
        }                                              
     } 
  }