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
| /*package donnees;*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Collection;
import java.util.HashMap;
import java.util.Map;
import java.util.Set;
import java.util.StringTokenizer;
import org.cvisproject.cint.eda.sdk.gis.coordinatesystem.positionning.RAWPosition;
import org.cvisproject.cint.eda.sdk.gis.interfaces.IRoadElement;
import org.cvisproject.cint.eda.sdk.gis.interfaces.IMapArea;
import org.cvisproject.cint.eda.sdk.gis.interfaces.position.IRAWPosition;
import org.cvisproject.cint.eda.sdk.gis.mapformat.MapArea;
import org.cvisproject.cint.eda.sdk.gis.mapformat.RoadElement;
import org.cvisproject.cint.eda.sdk.gis.mapformat.RoadNode;
import org.cvisproject.cint.eda.sdk.logger.Logger;
import java.io.*;
import java.net.*;
public class basededonnees {
protected IRAWPosition m_BeginPos, m_EndPos;
protected HashMap<String, IRoadElement> m_Elements;
protected HashMap<String, IRoadElement> m_Elements_bis;
//ouverture de la base de données
static final private String driver = "com.mysql.jdbc.Driver";
static final private String url_db = "jdbc:mysql://localhost/balicosal";
Connection con=null;
Statement s = null;
int i=0;
//fin
public basededonnees() {
//ouverture de base
ConnectBase();
m_BeginPos = null;
m_EndPos = null;
m_Elements = new HashMap<String, IRoadElement>();
m_Elements_bis = new HashMap<String, IRoadElement>();
}
public void ConnectBase() {
try {
/** Etape 1: charger le pilote */
Class.forName(driver);
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
/** Etape 2: Etablissement de la connexion à la base de données */
con = DriverManager.getConnection(url_db, user, passwd);
/** Etape 3: produire le Statement */
s = con.createStatement();
System.out.println("driver load successfully");
} catch (Exception e) {
System.out.println("echec pilote : " + e);
System.exit(1);
}
}
public void DeConnectBase() {
try {
con.close();
} catch (Exception e) {
}
}
} |
Partager