connect2db.java

JAVA环境下连数据的的简单示例代码（ACCESS）

/*
 * Created on 2007-6-28
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package com.ai.get24;
import java.sql.*;
/**
 * @author Vincent.Zhang
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class Connect2DB implements IfConnect2DB {

	public Connection conn;
	public Statement stmt;
	
	public Connect2DB(){
		CreateConnection();
	}
	
	public Statement CreateConnection(){
	    try{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		String dburl ="jdbc:odbc:AI1";
		conn=DriverManager.getConnection(dburl);
		stmt=conn.createStatement();
	    }catch(Exception e){
	    	System.out.print(e);
	    }
	    return stmt;
	}
	
	public void CloseConnection(){
		try{
		stmt.close();
		conn.close();
		}catch(Exception e){
		System.out.print(e);
	    }
	}
}