qsdqsdqsdqs

import java.sql.*;

public class BDDconnect {

	public static void main(String[] args)throws Exception {

		Class.forName("oracle.jdbc.driver.OracleDriver");
		System.out.println("Pilote chargé");
		System.out.println();

		String url = "jdbc:oracle:thin:mvanzal/The619619@oracle.iut-orsay.fr:1521:etudom";
		Connection maConnexion = DriverManager.getConnection(url);

		Statement monInstruction = maConnexion.createStatement();
		ResultSet monResultat = monInstruction
				.executeQuery("SELECT numFilm, titre FROM ENS2004.Film WHERE rownum<=10");

		// 1

		System.out.println("Question 1");
		System.out.println();

		String T;
		int nF;
		while (monResultat.next()) {
			nF = monResultat.getInt("numFilm");
			T = monResultat.getString("titre");
			System.out.println(nF + "\t" + T);
		}

		System.out.println();

		// 2

		System.out.println("Question 2");
		System.out.println();

		ResultSetMetaData metadata = monResultat.getMetaData();

		for (int i = 0; i < metadata.getColumnCount(); i++) {
			int index = i + 1;
			int typeSQL = metadata.getColumnType(index);
			String nomTypeSQL = metadata.getColumnTypeName(index);
			String typeJava = metadata.getColumnClassName(index);
			System.out.println("INFORMATIONS SUR LA COLONNE D'INDEX " + index);
			System.out.println("Type SQL dans java.sql.Types : " + typeSQL);
			System.out.println("Nom du type SQL : " + nomTypeSQL);
			System.out.println("Classe java correspondante : " + typeJava);
		}

		System.out.println();

		// 3

		System.out.println("Question 3");
		System.out.println();

		PreparedStatement nbrFilms = maConnexion.prepareStatement("SELECT COUNT(*) FROM ENS2004.FILM WHERE realisateur = ?");

		System.out.format("%-11s\t%-8s\n","NumIndividu","COUNT(*)");
		System.out.format("%-11s\t%-8s\n","-----------","--------");

		for(int i = 2000; i <= 2003; i++)
		{
			nbrFilms.setInt(1,i);
			ResultSet monResultat3 = nbrFilms.executeQuery();
			monResultat3.next();
			System.out.format("|%-11d|\t|%-8d|\n",i,monResultat3.getInt(1));
		}


		System.out.println();

		// 4

		System.out.println("Question 4");
		System.out.println();


		int real;
		real = 1500;

		CallableStatement nbrfilm = maConnexion.prepareCall(" ? = call.nbreFilms(?)");

		nbrfilm.setInt(2, real);
		nbrfilm.registerOutParameter(1,  java.sql.Types.VARCHAR);
		nbrfilm.execute();

		System.out.println("Le réalisateur " + real + " à réalisé : " + nbrfilm.getInt(1));

		nbrFilms.close();
		System.out.println();

		// 6

		System.out.println("Question 6");
		System.out.println();

		String nomTable = "ENS2004.Exemplaire";

		ResultSet monResultat2 = monInstruction.executeQuery("SELECT * FROM " + nomTable);


		ResultSetMetaData metadata2 = monResultat2.getMetaData();
		System.out.println("Index" + "\t" + "Name" + "\t\t" + "Null" + "\t\t" + "Type");
		System.out.println("-----" + "\t" + "-------------" + "\t" + "--------" + "\t" + "------------");

		for (int i = 0; i < metadata.getColumnCount(); i++) {
			int index = i + 1;
			int typeSQL = metadata.getColumnType(index);
			String nomCol = metadata.getColumnName(index);
			String nomTypeSQL = metadata.getColumnTypeName(index);
			int isNull = metadata.isNullable(index);
			String txtNull = "";
			if(isNull == 0)
				txtNull = "NOT NULL";

			//System.out.println(index + "\t" + nomTypeSQL + "\t\t" + txtNull + "\t\t" + typeSQL);
			String type = nomTypeSQL + "(" + typeSQL + ")";
			System.out.format("%-5d\t%-13s\t%-8s\t%-12s\n", index, nomCol, txtNull, type);
		}
		System.out.println();
		maConnexion.close();
	}

}