package zcgl;
/*
 *DbConn.java:建立數據庫的連接。
 */

import java.sql.*;
import java.math.*;
public class DbCon {
   private Connection conn;
   public DbCon() {
      try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      conn = DriverManager.getConnection("jdbc:odbc:MyDatabase","","");
      }
      catch (java.sql.SQLException s) {
        System.out.println("exception: " + s.getMessage()); //getMessage() 生成消息并包括類名稱（如果存在）。
      }catch(ClassNotFoundException s){s.getMessage();}
   }
   public Connection getConnection() {
        return conn;
   }
   public ResultSet execute(String sqlstr){
       ResultSet rs=null;
    try {
        Statement smt = getConnection().createStatement();
        rs=smt.executeQuery(sqlstr);

    } catch (SQLException ex) {
    }
    return rs;
   }
}