import java.sql.*;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.SQLException;



public class Bdd{
	Connection conn;
	public void connection(){
		try{
		    Class.forName("org.postgresql.Driver");
		    String url = "jdbc:postgresql://localhost:5432/postgres";
		    conn = DriverManager.getConnection(url, "postgres" , "lexbuf");
		}
		catch(Exception e) {
		    e.printStackTrace();
		}
	}
	
	public ResultSet requete(String r){
		try{
			Statement st = conn.createStatement();
			return st.executeQuery(r);
		}
		catch(Exception e) {
		    e.printStackTrace();
		    return null;
		}
	}
	
	public void remplirpourlestests(){
		requete("\i bdd.sql");
	}
/*	public void afficher(ResultSet rs){
		try{
			ResultSetMetaData metadata = rs.getMetaData();
			int cols = metadata.getColumnCount();
			for(int i = 1 ; i <= cols ; i++){
				System.out.print(metadata.getColumnName(i)+"("+metadata.getColumnTypeName(i)+")"+"\t|");
			}
			System.out.println();
			while(rs.next()){
				for(int i = 1 ; i <= cols ; i++){
					if(rs.getObject(i)!=null)
					System.out.print((rs.getObject(i)).toString()+"\t\t\t\t|");
				}
				System.out.println();
			}
		}
		catch(Exception e){
			e.printStackTrace();
		}
	}
	
    public static void main(String [] args){
    	try{
    		Bdd a = new Bdd();
    		a.connection();
    		//ResultSet rs = a.requete("select * from personne");
	    	//a.afficher(rs);
	    }
		catch(Exception e) {
		    e.printStackTrace();
		}
    }
    */
}