database.java

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

package net.aetherial.gis.define.database;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2004</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Database {

  private static Connection conn = null;

  public Database() {
  }
  /**
   * 得到连接对象
   */
  public  static Connection getConnection(){
    return conn;
  }

  public  static void connectTo(String databaseName) throws Exception {
      Class.forName("org.hsqldb.jdbcDriver");
      conn = DriverManager.getConnection("jdbc:hsqldb:db/"
                                         + databaseName, // filenames
                                         "sa", // username
                                         ""); // password
  }

  public static  void shutdown() throws SQLException {
    Statement st = conn.createStatement();
    st.execute("SHUTDOWN");
    conn.close();
  }
}