connect.java

基于Java的地图数据管理软件。使用MySQL数据库管理系统。

package net.aetherial.gis.database.access;

import java.sql.*;

public class Connect {
  Connection conn = null;
  Statement sql = null;
  public Connect() {
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      conn = DriverManager.getConnection("jdbc:odbc:gisnew", "", "");
      //con = DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=C:/data/Access/test1.mdb","dba","sql");

      sql = conn.createStatement();
      System.out.println("Connection ok!");
    }
    catch (Exception e) {
      System.out.println("Connection error:" + e);
    }
  }
  public Connect(String odbcName,String user,String password) {
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      conn = DriverManager.getConnection("jdbc:odbc:"+odbcName,user,password);
      sql = conn.createStatement();
      System.out.println("Connection ok!");
    }
    catch (Exception e) {
      System.out.println("Connection error:" + e);
    }
  }
  public Connect(String databasePath) {
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      conn = DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=" + databasePath,"","");
      sql = conn.createStatement();
      System.out.println("Connection ok!");
    }
    catch (Exception e) {
      System.out.println("Connection error:" + e);
    }
  }

  public Statement getStatement(){
    return sql;
  }
  public void setConnClose(){
    try{
      conn.close();
    }catch(Exception e){
      e.printStackTrace();
    }
  }
}