import java.sql.*;

public class Test {

	
	public static void main(String[] args) {
		
		Connection con = Connexion.getInstance();
		ResultSet result = null;
		
		try {
			Statement stmt = con.createStatement();
			result = stmt.executeQuery("select* from tab_patient;");
			while(result.next()) {
				String nomPat = result.getString("Nom");
				
				System.out.println(nomPat);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		
		Connexion.closeCon();

	}

}