// export CLASSPATH=$CLASSPATH:~/lib/jdbc/lib/classes111.zip import java.sql.*; public class TableBD { public static Connection etablirConnexion(String pilote, String url, String uid, String mdp) { Connection connexion = null; try { Class.forName(pilote); } catch(Exception e){ System.out.println("Impossible de charger le pilote"); return null; } try { connexion = DriverManager.getConnection(url, uid, mdp); System.out.println("Connexion etablie."); } catch(SQLException e){ System.out.println("Impossible d'etablir la connexion"); return null; } return connexion; } public static void fermerConnexion(Connection c) { try { c.close(); System.out.println("Connexion terminee"); } catch(SQLException e){ System.out.println("Impossible de fermer la connexion... Tant pis"); return; } } public static void creerTable(Connection c, String table, String champs) { try { Statement s = c.createStatement(); s.execute("create table " + table + "(" + champs + ")"); System.out.println("Creation reussie"); } catch(SQLException e){ System.out.println("Impossible de creer la table"); System.out.println("create table " + table + "(" + champs + ")"); return; } } public static void detruireTable(Connection c, String table) { try { Statement s = c.createStatement(); s.execute("drop table " + table); System.out.println("Destruction reussie"); } catch(SQLException e){ System.out.println("Impossible de detruire la table"); return; } } public static int modifierTable(Connection c, String requete) { try { Statement s = c.createStatement(); int res = s.executeUpdate(requete); System.out.println("Modification reussie de "+res+" lignes."); return res; } catch(SQLException e){ System.out.println("Impossible de modifier la table"); return 0; } } public static void afficherTable(Connection c, String table) { try { Statement s = c.createStatement(); ResultSet res = s.executeQuery("select * from "+table); while(res.next()){ System.out.println(res.getInt(1)+ res.getString(2)+ res.getString(3)+ res.getString(4)); } } catch(SQLException e){ System.out.println("Impossible d'afficher le contenu de la table"); return; } } static public void main(String args[]) { Connection connexion = null; if (args.length != 1) { System.out.println("Syntaxe : java TableBD MotdePasse"); return; } connexion = TableBD.etablirConnexion("oracle.jdbc.driver.OracleDriver", "jdbc:oracle:thin:@jaguar.emi:1521:bdiup3", "griffaul", args[0]); TableBD.detruireTable(connexion, "ANNUAIRE"); TableBD.creerTable(connexion, "ANNUAIRE", "ident int primary key,"+ "Nom char(20),"+ "Prenom char(20),"+ "Telephone char(14)"); TableBD.modifierTable(connexion, "Insert into ANNUAIRE values (1,'A','a','05')"); TableBD.modifierTable(connexion, "Insert into ANNUAIRE values (2,'B','b','05')"); TableBD.afficherTable(connexion, "ANNUAIRE"); TableBD.fermerConnexion(connexion); } }