1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69
| package control;
import java.beans.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
public class ServicesBD {
static Connection connexion;
static Statement statement;
static ResultSet resultat;
static String requete = "";
public static void connecter() {
String chemin = "jdbc:oracle:thin:@127.0.0.1:1521:XE";
String root = "SYSTEM";
String password = "azerty";
try {
Class.forName ("oracle.jdbc.driver.OracleDriver").newInstance();
connexion = DriverManager.getConnection(chemin, root, password);
statement = (Statement) connexion.createStatement();
System.out.println("Connexion Etablie");
}
catch(SQLException sql_e) {
System.out.println("Impossible d'etablir la connexion");
sql_e.printStackTrace();
}
catch(ClassNotFoundException cnf_e){
System.out.println("Impossible d'etablir la connexion");
cnf_e.printStackTrace();
}
catch(IllegalAccessException ea_e) {
System.out.println("Impossible d'etablir la connexion");
ea_e.printStackTrace();
}
catch(InstantiationException ie_e) {
System.out.println("Impossible d'etablir la connexion");
ie_e.printStackTrace();
}
}
public static void consulter (String r){
requete = r;
try {
resultat = statement.executeQuery(requete);
}
catch(SQLException sql_e) {
Logger.getLogger(ServicesBD.class.getName()).log(Level.SEVERE, null, sql_e);
System.out.println("Impossible d'executer la requete, Erreur ...");
sql_e.printStackTrace();
}
}
public static void mettreAJour (String r){
requete = r;
try {
resultat = statmnt.executeUpdate(requete);
}
catch(SQLException sql_e) {
Logger.getLogger(ServicesBD.class.getName()).log(Level.SEVERE, null, sql_e);
System.out.println("Impossible de mettre à jour la base de données, Erreur ...");
sql_e.printStackTrace();
}
}
} |