connecttracks.java

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

package net.aetherial.gis.database;

import java.sql.*;
import java.util.*;
import net.aetherial.gis.excel.*;

public class ConnectTracks {
  Connection conn = null;
  Statement sql = null;
 // ResultSet rs = null;
  String sqlString = "";
  public String tracksName = "";
  public Vector name = null, lat = null, lon = null;
  public ConnectTracks() {
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      conn = DriverManager.getConnection("jdbc:odbc:GIS", "admin", "0000");
      sql = conn.createStatement();
      System.out.println("Connection ok!");
    }
    catch (Exception e) {
      System.out.println("Connection error:" + e);
    }
  }

  public void insertToTable(Vector name, Vector lat, Vector lon,
                            Vector trackName) {
    try {
      for (int i = 0; i < name.size(); i++) {
        this.sqlString = "INSERT INTO tracks(name,lat,lon,track_name) VALUES('" +
            name.get(i) +
            "','" + lat.get(i) + "','" + lon.get(i) + "','" + trackName.get(i) +
            "')";
        sql.executeUpdate(this.sqlString);
      }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  public void insertToTable(String name, String lat, String lon,
                            int trackName) {
    try {
      this.sqlString = "INSERT INTO tracks(name,lat,lon,track_ID) VALUES('" +
          name +
          "','" + lat + "','" + lon + "'," + trackName + ")";
      sql.executeUpdate(this.sqlString);
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  public void setClose() {
    try {
      this.conn.close();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }


  public static void main(String args[]) {
    Connect c = new Connect();
    ConnectTracks ct = new ConnectTracks();
    ResultSet rs = c.queryTable();
    int tracksName = 1;
    String name ="",lat ="",lon = "";
    try {
      while (rs.next()) {
        name = rs.getString("name");
        lat = rs.getString("lat");
        lon = rs.getString("lon");
        if ((lat.equals("999.9"))&&(lon.equals("999.9"))) {
          tracksName++;
        }else{
          ct.insertToTable(name,lat,lon,tracksName);
        }
      }
      c.setClose();
      ct.setClose();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }
}