sqloperate.java

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

package net.aetherial.gis.database.access;

import java.sql.Statement;
import java.sql.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2004</p>
 *
 * <p>Company: </p>
 *
 * @author wangaiguo
 * @version 1.0D:\GIS\test\tc.mdb
 */
public class SQLOperate {
  private String database;
  private Connect con = null;
  private Statement sql = null;
  public SQLOperate() {
  }

  public void write(String writeString){
    try {
      sql.executeUpdate(writeString);
    }
    catch (SQLException ex) {
      this.print(ex.toString());
    }
  }
  public static void main(String[] args) {
    SQLOperate so = new SQLOperate();
    so.setDatabase("D:\\GIS\\test\\tc.mdb");
    for(int i =0;i<250;i++){
      so.write("INSERT INTO t1(a,b,c,d) VALUES('a',110,120,'b')");
    }
  }

  public void setDatabase(String database) {
    this.database = database;
    con = new Connect(database);
    sql =con.getStatement();
  }

  public String getDatabase() {
    return database;
  }
  private void print(String string){
    System.out.println(string);
  }
}