import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Enumeration;
import java.util.PropertyResourceBundle;

import net.gicm.ktp.DB.Concurrence;


public class testConnexion {

	/**
	 * @param args
	 * @throws ClassNotFoundException 
	 * @throws IllegalAccessException 
	 * @throws InstantiationException 
	 * @throws SQLException 
	 * @throws SQLException 
	 * @throws ClassNotFoundException 
	 * @throws IllegalAccessException 
	 * @throws InstantiationException 
	 */
	public static void main(String[] args) throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException  {
		// TODO Auto-generated method stub
		DriverManager.registerDriver((Driver)Class.forName("oracle.jdbc.driver.OracleDriver").newInstance());
			try {
				methode1();
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
			try {
				methode2();
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
			try {
				methode2();
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
			try {
				methode1();
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
				DriverManager.deregisterDriver((Driver)Class.forName("oracle.jdbc.driver.OracleDriver").newInstance());
			}

	}

	
	public static void methode1() throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException {

		Connection con = DriverManager.getConnection("jdbc:oracle:thin:@oracle-nombase:portbase:instance", "login", "pwd");
		String strSQL = "SELECT distinct(code) FROM op.devise ";
		
		
		try {
		// - Obtention d'un Statement
			java.sql.PreparedStatement pstmt = con.prepareStatement(strSQL);
			ResultSet rs = pstmt.executeQuery();
	
			while ( rs.next() ){
				System.out.println("code : " + rs.getString(1));
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();

		}
		finally {
			if(con!=null){
				con.close();
			}
		}
	}

	public static void methode2() throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException {

		Connection con = DriverManager.getConnection("jdbc:oracle:thin:@oracle-nombase:portbase:instance", "login", "MauvaisPwd");
		String strSQL = "SELECT distinct(code) FROM op.devise ";
		
		try {
			// - Obtention d'un Statement
				java.sql.PreparedStatement pstmt = con.prepareStatement(strSQL);
				ResultSet rs = pstmt.executeQuery();
		
				while ( rs.next() ){
					System.out.println("code : " + rs.getString(1));
				}
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();

			}
			finally {
				if(con!=null){
					con.close();
				}
			}

	}

}