package com.llgc;

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

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

public class Principale {
  public static void f() {
    Context initCtx;
    try {
      initCtx = new InitialContext();
      Context envCtx = (Context) initCtx.lookup("java:comp/env");

      // Look up our data source
      DataSource ds = (DataSource) envCtx.lookup("jdbc/UFRIMA");

      try (Connection conn = ds.getConnection(); Statement st = conn.createStatement()) {
        ResultSet rs = st.executeQuery("SELECT * FROM civilite");
        while (rs.next()) {
          System.out.print(rs.getString("LibelleLong") + "\n");
        }
      } catch (SQLException e) {
        e.printStackTrace();
      }
    } catch (NamingException e) {
      e.printStackTrace();
    }
  }
}