/* * Copyright (c) 2001, Mohamed Lokbani. * All Rights Reserved. */ import java.sql.*; import java.io.*; import java.util.*; /** * Ce programme crée des tables dans la base de donnée oracle. * Ce programme doit être exécuté après celui de l'exo -1-. * * Vous devez compléter les champs: * moncompte = votre compte usager * monpasse = votre mot de passe oracle * ou bien modifier le code et introduire ces paramètres sur la ligne * de commande. * * * @version 1.1 2001/12/09 * @since 1.0 * @author Mohamed Lokbani * */ public class insert_agence { public static final String TableSejour = "Sejour"; public static final String TableClient = "Client"; public static final String TableActivite = "Activite"; public static final String TableStation = "Station"; public static final String mondriver = "oracle.jdbc.driver.OracleDriver"; public static final String monurl = "jdbc:oracle:thin:@titan:1521:a99"; public static final String moncompte = "xxxx"; public static final String monpasse = "xxxx"; static public void CloseConnection(Connection c) throws SQLException { c.close(); } static public void insertData(Statement s) throws SQLException { String insertString = "INSERT INTO " + TableStation + " (NomStation, Capacite, Lieu, Region, tarif)" + " VALUES ('Venusa',350,'Guadeloupe','Antilles',1200)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableStation + "(NomStation, Capacite, Lieu, Region, tarif)" + " VALUES ('Farniente',200,'Seychelles','Ocean Indien',1500)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableStation + " (NomStation, Capacite, Lieu, Region, tarif)" + " VALUES ('Santalba',150,'Martinique','Antilles',2000)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableStation + " (NomStation, Capacite, Lieu, Region, tarif)" + " VALUES ('Passac',400,'Alpes','Europe',1000)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableActivite + " (NomStation, Libelle, prix)" + " VALUES('Venusa','Voile',150)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableActivite + " (NomStation, Libelle, prix)" + " VALUES('Venusa','Plongee',120)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableActivite + " (NomStation, Libelle, prix)" + " VALUES('Farniente','Plongee',130)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableActivite + " (NomStation, Libelle, prix)" + " VALUES('Passac','Ski',200)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableActivite + " (NomStation, Libelle, prix)" + " VALUES('Passac','Piscine',20)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableActivite + " (NomStation, Libelle, prix)" + " VALUES('Santalba','Kayac',50)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableClient + " (id, nom, prenom, ville, region, solde)" + " VALUES(10,'Fogg','Phileas','Londres','Europe',12465)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableClient + " (id, nom, prenom, ville, region, solde)" + " VALUES(20,'Pascal','Blaise','Paris','Europe',6763)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableClient + " (id, nom, prenom, ville, region, solde)" + " VALUES(30,'Kerouac','Jack','New York','Amerique',9812)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableSejour + " (idClient, station, debut, nbPlaces)" + " VALUES(20,'Venusa',19980803,4)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableSejour + " (idClient, station, debut, nbPlaces)" + " VALUES(10,'Passac',19980701,2)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableSejour + " (idClient, station, debut, nbPlaces)" + " VALUES(30,'Santalba',19960814,5)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableSejour + " (idClient, station, debut, nbPlaces)" + " VALUES(20,'Santalba',19980803,4)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableSejour + " (idClient, station, debut, nbPlaces)" + " VALUES(30,'Passac',19980815,3)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableSejour + " (idClient, station, debut, nbPlaces)" + " VALUES(30,'Venusa',19980803,3)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableSejour + " (idClient, station, debut, nbPlaces)" + " VALUES(30,'Farniente',19990624,5)"; s.executeUpdate(insertString); insertString = "INSERT INTO " + TableSejour + " (idClient, station, debut, nbPlaces)" + " VALUES(10,'Farniente',19980905,3)"; s.executeUpdate(insertString); } public static void main(String args[]) throws SQLException, Exception { Connection c = null ; try { Class.forName(mondriver).newInstance(); c = DriverManager.getConnection(monurl,moncompte,monpasse); } catch (ClassNotFoundException ex){ System.out.println(ex); } Statement s = c.createStatement() ; c.setAutoCommit(false) ; insertData(s); c.commit() ; c.setAutoCommit(true) ; CloseConnection(c); } }