package test.db; 

import java.io.*;
import java.sql.*;
public class DatabaseCon1  {
  public Connection con;
  public String URL = "jdbc:odbc:comistic";
  public String Message;
  public boolean connection()   {
    try{
      //加載JDBC-ODBC橋驅動程序
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch(ClassNotFoundException ex){
      Message=ex.getMessage();
      System.exit(-1);
    }
    try{
      //試圖通過JDBC-ODBC橋建立一個與comistic數據源的連接
         con = DriverManager.getConnection(URL);
       //數據庫連接成功
       return true;
    }
    catch(SQLException ex){
      Message=ex.getMessage();
      return false;
    }
  }
  //關閉數據庫連接
  public boolean close(){
    try{
           con.close();
          return true;
    }
     catch(Exception ex){
          Message=ex.getMessage();
          return false;
      }
  }
  public ResultSet exeSQL(String sqlstr)   {
  try{
      connection();
      Statement stmt=con.createStatement();
      ResultSet rs=stmt.executeQuery(sqlstr);
      return rs;
  } catch(Exception ex){
    Message=ex.getMessage();
 }
  return null;
}
 }