connect.java

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

package net.aetherial.gis.database;
import java.sql.*;
import java.util.*;

public class Connect {
  Connection conn = null;
  Statement sql = null;
  ResultSet rs =null;
  String sqlString = "";
  public Connect() {
    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 ResultSet queryTable(){
    this.sqlString ="select * from gis order by id asc";
    try{
      rs = sql.executeQuery(this.sqlString);
    }catch(Exception e){
      e.printStackTrace();
    }
    return rs;
  }
  public void insertToTable(Vector name,Vector lat,Vector lon){
    try{
      for(int i =0;i<name.size();i++){
        this.sqlString = "INSERT INTO gis(name,lat,lon) VALUES('" + name.get(i) +
            "','" + lat.get(i) + "','" + lon.get(i) + "')";
        sql.executeUpdate(this.sqlString);
      }
    }catch(Exception e){
      e.printStackTrace();
    }
  }
  public void createTable(){
    this.sqlString = "Create Table gis(ID Long primary key,name varchar(20),lat varchar(30),lon varchar(30))";
    try{
      sql.execute(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[]){
    Vector name =new Vector(),lat =new Vector(),lon =new Vector();
    for(int i =0;i<1000;i++){
      name.addElement(""+i);
      lat.addElement("0.2222"+i);
      lon.addElement("0.3333"+i);
    }
    Connect c = new Connect();
    c.createTable();
    //c.insertToTable(name,lat,lon);
    c.setClose();
  }
}