msacces.java

来自「this is a java source code file.. downl」· Java 代码 · 共 53 行

package inc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/*
 * MsAcces.java
 *
 * Created on April 11, 2007, 9:41 PM
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

/**
 *
 * @author mamat-dev
 */
public class MsAcces {
    
    private String odbc,user,password,database;
    private Connection con;
    private Statement st;
    int jumBaris;
    
    /** Creates a new instance of MsAcces */
    public MsAcces() {
        this.odbc = "Driver={MicroSoft Access Driver (*.mdb)}";
        this.user = "";
        this.password ="";
        this.database = "D:/My Project/Java/web perpustakaan/source java/"+
                "tugas/web/perpustakaan.mdb";
    }
    
    public void getConnection() throws SQLException, ClassNotFoundException {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        this.con = DriverManager.getConnection("jdbc:odbc:"+ this.odbc +";DBQ=" + this.database,this.user,this.password);
    }
    
    public Statement getStatement() throws SQLException{
        this.st = this.con.createStatement();
        return this.st;
    }
    
    public void closeStatement() throws SQLException{
        this.st.close();
    }
    public void closeConnection() throws SQLException{
        this.con.close();
    }
}