package org.llgc;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

import org.apache.commons.dbcp2.BasicDataSource;

public class SQL1
{
  public static void main (String[] args)
  {
    try (BasicDataSource bds = new BasicDataSource ())
    {
      bds.setDriverClassName ("com.mysql.jdbc.Driver");
      String url = "jdbc:mysql://localhost/elearning";
      bds.setUrl (url);
      bds.setUsername ("root");
      bds.setPassword ("aui");

      try (Connection cn = bds.getConnection (); Statement st = cn.createStatement ())
      {
        ResultSet rs = st.executeQuery ("SELECT * FROM civilite");
        ResultSetMetaData rsmd = rs.getMetaData ();
        int NbCol = rsmd.getColumnCount ();
        for (int i = 1; i <= NbCol; i++)
        {
          System.out.print (rsmd.getColumnName (i) + "\t");
        }
        System.out.println ();
        while (rs.next ())
        {
          for (int i = 1; i <= NbCol; i++)
          {
            System.out.print (rs.getString (i) + "\t");
          }
          System.out.println ();
        }
      }
    }
    catch (SQLException e)
    {
      e.printStackTrace ();
      return;
    }
  }
}