Connexion java oracle
cs_emiliebella
Messages postés
2
Date d'inscription
jeudi 22 novembre 2007
Statut
Membre
Dernière intervention
22 mai 2008
-
29 avril 2008 à 13:09
cs_kazer04 Messages postés 182 Date d'inscription jeudi 14 juillet 2005 Statut Membre Dernière intervention 14 mars 2011 - 29 avril 2008 à 16:38
cs_kazer04 Messages postés 182 Date d'inscription jeudi 14 juillet 2005 Statut Membre Dernière intervention 14 mars 2011 - 29 avril 2008 à 16:38
1 réponse
cs_kazer04
Messages postés
182
Date d'inscription
jeudi 14 juillet 2005
Statut
Membre
Dernière intervention
14 mars 2011
29 avril 2008 à 16:38
29 avril 2008 à 16:38
voila une classe qui te permet dete connecet a plusieur DB
Mysql,Oracle ...
/*
* jconndb.java
*
* Created on 1 janvier 1999, 01:18
*
* To change this template, choose Tools | Template Manager
* and open the template in the editor.
*/
package iutacad;
/**
*
* @author Thierry Bekola
*/
import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.lang.String;
/**
* Titre :
* Description :
* Copyright : Copyright (c) 2007
* Société :
* @author
* @version 1.0
*/
public class jconndb {
private String Host;
private String User;
private String Password;
private String Database;
private String DatabaseSID;
private String Driver;
private Connection StringConnexion;
private String UrlConnexion;
private ResultSet resultat;
protected String message;
private int port;
public jconndb() {
this.Driver = null;
this.Database =null;
this.StringConnexion = null;
this.UrlConnexion =null;
}
public void set_param_connexion(){
/*
relatif a la connexion par defautl
*/
this.Host ="localhost"; //hote
this.Password ="";//password
this.User ="root";//username
this.Database ="konkerordb"; //nomdab pour mysql
this.DatabaseSID ="iutacad"; //Sid pour Oracle
this.port =3306;
}
public Connection get_StringConnexion(){
return this.StringConnexion;
}
//accesseur des propriete privee
public void set_port(int myport){
this.port = myport;
String matsrt = new String("toto");
// matsrt.e
}
public void set_host(String Myhost){
this.Host = Myhost;
}
public void set_user(String Myuser){
this.User = Myuser;
}
public void set_password(String Mypassword){
this.Password = Mypassword;
}
public void set_database(String Mydatabase){
this.Database = Mydatabase;
}
public void set_databaseSID(String MydatabaseSID){
this.DatabaseSID = MydatabaseSID;
}
public void set_driver(String Mydriver){
this.Driver = Mydriver;
}
public String get_message(){
return this.message;
}
public ResultSet get_resultat(){
return this.resultat;
}
// pilote JDBC Mysql
public String get_mysql_driver_JDBC(){
this.UrlConnexion ="jdbc:mysql://"+this.Host+"/"+
this.Database+"?user="+this.User+
"&password="+this.Password;
return "com.mysql.jdbc.Driver";
}
// pilote JDBC Oracle
public String get_oracle_driver_JDBC(){
this.UrlConnexion ="jdbc:oracle:thin:@"+ this.Host+":"+this.port+":"+this.DatabaseSID;
return "oracle.jdbc.driver.OracleDriver";
}
//pilote ODBC_JDBC
public String get_driver_ODBC_JDBC(){
this.UrlConnexion ="jdbc:odbc:"+this.Database;
return "sun.jdbc.odbc.JdbcOdbcDriver";
}
//pilote odbc postgrelsql
public String get_driver_ODBC_JDBC_Postgrel(){
return "postgrelsql.Driver";
}
//chargement du pilotes
public void LoadDriver()
{
try{
Class.forName(this.Driver).newInstance();
this.message = "Chargement Reussi";
System.out.println("Chargement Reussi");
}catch(Exception ex){
System.out.println(ex.getMessage());
this.message = ex.getMessage();
// JOptionPane.showMessageDialog(null,"Impossible de charger le driver","Kadresse Warning !",JOptionPane.ERROR_MESSAGE );
// System.exit(0);
}
}
public void OpenConnexion(){
try{
if(this.Driver.equals("oracle.jdbc.driver.OracleDriver")){
this.StringConnexion = DriverManager.getConnection(this.UrlConnexion,this.User,this.Password);
}
else{
this.StringConnexion = DriverManager.getConnection(this.UrlConnexion);
}
System.out.println("Connexion reussi");
this.message = "Connexion reussi";
}catch(Exception ex){
// JOptionPane.showMessageDialog(null,"Impossible de se Connecter au serveur","Kadresse Warning !",JOptionPane.ERROR_MESSAGE );
System.out.println(ex.getMessage());
this.message =ex.getMessage();
// System.exit(0);
}
}
//fermeture de la connexion
public void CloseConnexion()
{
try{
this.resultat.close();
System.out.println("Connexion fermer");
}catch(Exception MysqlEx){
System.out.println("Impossible de fermer");
// JOptionPane.showMessageDialog(null,"Impossible de fermer","Kadresse Warning !",JOptionPane.ERROR_MESSAGE );
}
}
public void set_Request(String MyRequest)
{
String Request = new String(MyRequest);
try{
Statement stmt = this.StringConnexion.createStatement();
this.resultat = stmt.executeQuery(Request);
}catch(Exception ex){
System.out.println( ex.getMessage());
}
}
}
pour l utiliser tu dev une classse classe herite de cette classe
ex
public class userb extends jconndb {
public userb() {
this.set_param_connexion();
this.set_driver(this.get_oracle_driver_JDBC());//chargement du pilote por oracle
this.LoadDriver();
this.OpenConnexion();
this.CloseConnexion();
}
}
Mysql,Oracle ...
/*
* jconndb.java
*
* Created on 1 janvier 1999, 01:18
*
* To change this template, choose Tools | Template Manager
* and open the template in the editor.
*/
package iutacad;
/**
*
* @author Thierry Bekola
*/
import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.lang.String;
/**
* Titre :
* Description :
* Copyright : Copyright (c) 2007
* Société :
* @author
* @version 1.0
*/
public class jconndb {
private String Host;
private String User;
private String Password;
private String Database;
private String DatabaseSID;
private String Driver;
private Connection StringConnexion;
private String UrlConnexion;
private ResultSet resultat;
protected String message;
private int port;
public jconndb() {
this.Driver = null;
this.Database =null;
this.StringConnexion = null;
this.UrlConnexion =null;
}
public void set_param_connexion(){
/*
relatif a la connexion par defautl
*/
this.Host ="localhost"; //hote
this.Password ="";//password
this.User ="root";//username
this.Database ="konkerordb"; //nomdab pour mysql
this.DatabaseSID ="iutacad"; //Sid pour Oracle
this.port =3306;
}
public Connection get_StringConnexion(){
return this.StringConnexion;
}
//accesseur des propriete privee
public void set_port(int myport){
this.port = myport;
String matsrt = new String("toto");
// matsrt.e
}
public void set_host(String Myhost){
this.Host = Myhost;
}
public void set_user(String Myuser){
this.User = Myuser;
}
public void set_password(String Mypassword){
this.Password = Mypassword;
}
public void set_database(String Mydatabase){
this.Database = Mydatabase;
}
public void set_databaseSID(String MydatabaseSID){
this.DatabaseSID = MydatabaseSID;
}
public void set_driver(String Mydriver){
this.Driver = Mydriver;
}
public String get_message(){
return this.message;
}
public ResultSet get_resultat(){
return this.resultat;
}
// pilote JDBC Mysql
public String get_mysql_driver_JDBC(){
this.UrlConnexion ="jdbc:mysql://"+this.Host+"/"+
this.Database+"?user="+this.User+
"&password="+this.Password;
return "com.mysql.jdbc.Driver";
}
// pilote JDBC Oracle
public String get_oracle_driver_JDBC(){
this.UrlConnexion ="jdbc:oracle:thin:@"+ this.Host+":"+this.port+":"+this.DatabaseSID;
return "oracle.jdbc.driver.OracleDriver";
}
//pilote ODBC_JDBC
public String get_driver_ODBC_JDBC(){
this.UrlConnexion ="jdbc:odbc:"+this.Database;
return "sun.jdbc.odbc.JdbcOdbcDriver";
}
//pilote odbc postgrelsql
public String get_driver_ODBC_JDBC_Postgrel(){
return "postgrelsql.Driver";
}
//chargement du pilotes
public void LoadDriver()
{
try{
Class.forName(this.Driver).newInstance();
this.message = "Chargement Reussi";
System.out.println("Chargement Reussi");
}catch(Exception ex){
System.out.println(ex.getMessage());
this.message = ex.getMessage();
// JOptionPane.showMessageDialog(null,"Impossible de charger le driver","Kadresse Warning !",JOptionPane.ERROR_MESSAGE );
// System.exit(0);
}
}
public void OpenConnexion(){
try{
if(this.Driver.equals("oracle.jdbc.driver.OracleDriver")){
this.StringConnexion = DriverManager.getConnection(this.UrlConnexion,this.User,this.Password);
}
else{
this.StringConnexion = DriverManager.getConnection(this.UrlConnexion);
}
System.out.println("Connexion reussi");
this.message = "Connexion reussi";
}catch(Exception ex){
// JOptionPane.showMessageDialog(null,"Impossible de se Connecter au serveur","Kadresse Warning !",JOptionPane.ERROR_MESSAGE );
System.out.println(ex.getMessage());
this.message =ex.getMessage();
// System.exit(0);
}
}
//fermeture de la connexion
public void CloseConnexion()
{
try{
this.resultat.close();
System.out.println("Connexion fermer");
}catch(Exception MysqlEx){
System.out.println("Impossible de fermer");
// JOptionPane.showMessageDialog(null,"Impossible de fermer","Kadresse Warning !",JOptionPane.ERROR_MESSAGE );
}
}
public void set_Request(String MyRequest)
{
String Request = new String(MyRequest);
try{
Statement stmt = this.StringConnexion.createStatement();
this.resultat = stmt.executeQuery(Request);
}catch(Exception ex){
System.out.println( ex.getMessage());
}
}
}
pour l utiliser tu dev une classse classe herite de cette classe
ex
public class userb extends jconndb {
public userb() {
this.set_param_connexion();
this.set_driver(this.get_oracle_driver_JDBC());//chargement du pilote por oracle
this.LoadDriver();
this.OpenConnexion();
this.CloseConnexion();
}
}
