mydbconnection.java

一个学校当中的教务管理系统

/*
 * MyDbConnection.java
 *
 * Created on 2007年7月27日, 下午9:57
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package dbclass;
import java.sql.*;
/**
 *
 * @author 徐翘
 */
public class MyDbConnection {
    
    /** Creates a new instance of MyDbConnection */
    
         protected Connection conn;             
         
        public MyDbConnection() throws SQLException, ClassNotFoundException 
        {   
            Class.forName("jdbc.odbc.JdbcOdbcDriver");
            conn =     DriverManager.getConnection("jdbc:odbc:教务","","");
        }
            
        public void makeConnection() throws SQLException
        {           
            conn =     DriverManager.getConnection("jdbc:odbc:教务.mdb","","");
        }
         public void close() throws SQLException
         {
                if(conn != null && !conn.isClosed())
                        conn.close();
         }
}