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 70
| package test;
import java.sql.*;
public class testsql {
private String url="jdbc:mysql://localhost/ged";
private String driver="com.mysql.jdbc.Driver";
private Connection cnx;
private Statement stat;
private ResultSet res;
public String geturl(){
return url;
}
public void seturl(String url){
this.url=url;
}
public String getdriver(){
return driver;
}
public void setdriver(String driver){
this.driver=driver;
}
public boolean connect(){
try{
Class.forName("com.mysql.jdbc.Driver");
cnx=DriverManager.getConnection("jdbc:mysql://localhost/ged","root","ensa");
stat=cnx.createStatement();
return true;
}
catch(SQLException ex){
System.out.println( ex.getMessage().toString() );
return false;
}
catch(ClassNotFoundException exc){
System.out.println(exc.getMessage().toString() );
return false;
}
}
public ResultSet requete(String query){
ResultSet resultat=null;
try{
res=stat.executeQuery(query);
return resultat;
}
catch(SQLException dd){
resultat=null;
System.out.println("Probleme au niveau de la requete :" +dd.getMessage().toString() );
return resultat;
}
}
public boolean deconnexion(){
try{
if(!(this.cnx.isClosed()))
{ this.cnx.close();}
else {System.out.println("la connexion n'est pa ouverte ");}
return true;
}
catch(SQLException ex)
{
System.out.println(ex.getMessage().toString());
return false;
}
}
} |
Partager