dbconnect.java

一个jsp的课程设计：电子商务网站

/*
 * dbConnect.java
 *
 * Created on 2007年11月14日, 下午9:29
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package dbpack;
import java.sql.*;
/**
 *
 * @author weiyunbo
 */
public class dbConnect {
    
    /** Creates a new instance of dbConnect */
    public Connection con;
    public Statement sat;
    public ResultSet rs;
    public dbConnect() {
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        }catch(Exception e){
            System.out.println(e.toString());
        }
        try{
            con=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=F:/java/cuiter/web/db/shop.mdb");
            sat=con.createStatement();      
        }catch(Exception e){
            System.out.println(e.toString());
        }
    }
    public void doClose(){
        try{
            rs.close();
            sat.close();
            con.close();
        }catch(Exception e){
            System.out.println(e.toString());
        }
    }
}