Classe GestionBase (basic)
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class GestionBase {
Connection cnx;
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
String NomBase;
String login;
String mdp;
public GestionBase(String NomBase, String login, String mdp){
this.NomBase=NomBase;
this.login=login;
this.mdp=mdp;
}
public boolean connect(){
boolean resultat = true;
try {
Class.forName(driver);
if(login!=null){
cnx = DriverManager.getConnection(this.NomBase, login, mdp);
}else {
cnx = DriverManager.getConnection(this.NomBase);
}
} catch (ClassNotFoundException e) {
System.out.println("[ERREUR] Impossible de définir le driver de base : " +e.getMessage());
e.printStackTrace();
resultat=false;
} catch (SQLException e) {
System.out.println("[ERREUR] Probleme de connection a la base -"+NomBase+ "- : " +e.getMessage());
e.printStackTrace();
resultat=false;
}
return resultat;
}
public void deconnect(){
try {
cnx.close();
} catch (SQLException e) {
System.out.println("[ERREUR] Probleme de deconnection de la base -"+NomBase+ "- : "+e.getMessage());
e.printStackTrace();
}
}
public void requeteAvecResultat(){
Statement stmt;
ResultSet Rs;
String maReq="Select ...........................";
try {
stmt = cnx.createStatement();
Rs=stmt.executeQuery(maReq);
while(Rs.next()){
System.out.println( Rs.getString("nomTable") );
}
Rs.close();
stmt.close();
} catch (SQLException e) {
System.out.println("[ERREUR] Probleme lors de la requete : "+e.getMessage());
e.printStackTrace();
}
}
public boolean requeteSansResultat(String REQ){
boolean resultat=true;
try {
Statement stmt = cnx.createStatement();
if(stmt.execute(REQ)){
resultat=false;
System.out.println("[ERREUR] Requete refuse :");
System.out.println("\t--" + REQ + "--");
}
stmt.close();
} catch (SQLException e) {
resultat=false;
System.out.println("[ERREUR] Probleme lors de la requete : "+e.getMessage());
e.printStackTrace();
}
return resultat;
}
/**
* @param args
*/
public static void main(String[] args) {
GestionBase mabase=new GestionBase("jdbc:odbc:nomODBC","monLogin","monpassword");
if(mabase.connect()){
mabase.requeteAvecResultat();
//mabase.requeteSansResultat("delete....");
mabase.deconnect();
}
}
}