package kerta.main;


import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import fr.eisti.sql.DatabaseConnector;

import kerta.vue.FenetrePrincipale;



public class TestConnexion {

	/**
	 * @param args
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws SQLException {
		
		DatabaseConnector.setOracleXeLocalParameters("test", "toto");
		
		Connection connection = DatabaseConnector.getConnection(); 				
				
		FenetrePrincipale fp = new FenetrePrincipale(connection);
		fp.setVisible(true);
		
		
	}

}
		
		
				
		
		//String query = "select id_node, uid_node, user_node from node";		
		
	/*	try (Statement state = connection.createStatement()) {
		
		state.executeUpdate("INSERT INTO Node (id_node, uid_node, user_node) values(5,218849,'manman66')");
	    state.executeUpdate("INSERT INTO Node (id_node, uid_node, user_node) values(6,218849,'manman66')");
		state.executeUpdate("INSERT INTO Node (id_node, uid_node, user_node) values(7,218849,'manman66')");	
		
		ResultSet result = state.executeQuery(query);		
		
		 while (result.next()) {
			int id_node = result.getInt("id_node");
			// ou par numéro de champs : nom = rs.getString(1);
			int uid_node = result.getInt("uid_node");
			// ou par numéro de champs : prenom = rs.getString(2);
			String user_node = result.getString("user_node");
			// ou par numéro de champs : age = rs.getInt(3);
			Node node = new Node(id_node, uid_node, user_node);
			// utiliser p …
			System.out.println(node.toString());
		} 
		
		 		
		}catch (SQLException e ) {
		// traiter l’exception
		} */
		
		
		/*try (Statement state = connection.createStatement()) {
			
			String query1 = "select id_way, version_way, uid_way, user_way, changeset_way from way";
			
			state.executeUpdate("INSERT INTO way (id_way, version_way, uid_way, user_way, changeset_way) values (111111,3, 2011147, 'Tamere', 478964)");
			state.executeUpdate("INSERT INTO way (id_way, version_way, uid_way, user_way, changeset_way) values (222222,1, 2011148, 'Tamerelapute', 478965)");

			ResultSet result1 = state.executeQuery(query1);
			
	
			while (result1.next()) {
								
				int id_way = result1.getInt("id_way");
				int version_way = result1.getInt("version_way");
				int uid_way = result1.getInt("uid_way");
				String user_way = result1.getString("user_way");
				String changeset_way = result1.getString("changeset_way");
				Way way = new Way(id_way, version_way, uid_way, user_way, changeset_way);
				
				// utiliser p …
				System.out.println(way.toString());
				
			} 
	
}catch (SQLException e ) {
// traiter l’exception
}*/
		
	/*	
try (Statement state = connection.createStatement()) {
			
			String query2 = "select distinct user_node, count(*) as id_node from node group by user_node";
			
			ResultSet result2 = state.executeQuery(query2);			
	
			while (result2.next()) {
								
				String name = result2.getString("user_node");
				int cpte = result2.getInt("id_node");
				Resultat res2 = new Resultat(name, cpte);
				listeRes.add(new Resultat(name, cpte));
				
				// utiliser p …
				System.out.println(res2.toString());
				
			} 
	
}catch (SQLException e ) {
// traiter l’exception
} */
		// state est automatiquement fermé si besoin (exception ou pas)
		
		
		
		//DatabaseConnector.closeConnection();