jdbcodbcbridge.java

来自「关于JAVA通过JDBC－ODBC桥连接ACCESS数据库的源码」· Java 代码 · 共 52 行

//package javadatabase;
import java.sql.*;
public class  JDBCODBCBridge
{
	private String dbURL;
	//private String user;
	//private String password;
	public static void main(String[] args) 
	{
		try
		{
			JDBCODBCBridge bridge=new JDBCODBCBridge();
			bridge.setURL("jdbc:odbc:checkuser");
			//bridge.setUser("");
			//bridge.setPassword("");
			Connection con=bridge.getConnection();
			System.out.println(con.getCatalog());
			con.close();
		}
		catch (Exception e)
		{
             System.out.println(e.toString());
		}
		
	}
	public Connection getConnection()
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			return DriverManager.getConnection(dbURL);
		}
		catch (Exception e)
		{
			System.out.println(e.toString());
		}
		return null;
	}
	public void setURL(String dbURL)
	{
		this.dbURL=dbURL;
	}
	/*public void setUsername(String user)
	{
		this.user=user;
	}
	public void setPassword(String password)
	{
		this.password=password;
	}*/
}