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 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87
| import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Vector;
import javax.swing.JOptionPane;
import Structure.StructureMehari;
import Structure.StructureMehariuser;
import auditorg_int.rbt;
public class Manip_Data_Base {
//emplacement de la base
final String NOM_BDD ="bd/annuaire.mdb";
//nom d'utilisateur
final String NOM_USER="";
//mot de passe
final String MP_USER="";
//chaine de connexion
String DBurl="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+NOM_BDD;
Connection con;
public Manip_Data_Base() {
Connection();
}
//permet d'effectuer une connection à la base
public boolean Connection() {
try{
System.out.println("1");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("2");
con = (Connection) DriverManager.getConnection(DBurl,NOM_USER,MP_USER);
System.out.println("3");
return true;
}catch(Exception e){
JOptionPane.showMessageDialog(null,"Impossible de charger le pilote");
}
return false;
}
//remplissage de la table de l'administrateur
public Vector<StructureMehari> Remplir(){
Vector<StructureMehari> v = new Vector<StructureMehari>();
try {
Statement stmnt = con.createStatement();
ResultSet res = stmnt.executeQuery("select Question , coef from Mehari");
while(res.next()){
v.add(new StructureMehari(res.getString(1),res.getInt(2)));
}
} catch (Exception e) {
e.printStackTrace();
}
return v;
}
//remplissage du tableau du client
public Vector<StructureMehariuser> Rempliruser(){
rbt r=new rbt();
Vector<StructureMehariuser> v = new Vector<StructureMehariuser>();
try {
Statement stmnt = con.createStatement();
ResultSet res = stmnt.executeQuery("select Question from Mehari");
while(res.next()){
v.add(new StructureMehariuser(res.getString(1),r));
}
} catch (Exception e) {
e.printStackTrace();
}
return v;
}
//lancer une requète
public boolean LancerRequete(String req){
try {
Statement stmnt = con.createStatement();
stmnt.executeUpdate(req);
return true;
} catch (Exception e) {
e.printStackTrace();
}
return false;
}
} |
Partager