connectaccess.java

200多个自己编的java程序,大家可以学一下.

import java.net.URL;
import java.sql.*;

class ConnectAccess{
	/**
	 * Method main
	 *
	 *
	 * @param args
	 *
	 */
	public static void main(String[] args) {
		// TODO: Add your code here
		String url="jdbc:odbc:Connection";
		try{
			try{//import JDBC-ODBC DRIVERS
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				
			}
			catch(java.lang.ClassNotFoundException e)
			{
				System.out.println("can not load the Jdbc-Odbc driver");
				System.err.print("ClassNotFound:");
				System.err.print(e.getMessage());
			}
			Connection con=DriverManager.getConnection(url);
//shi yong
			DatabaseMetaData dmd=con.getMetaData();
			System.out.println("连接的数据 库:"+dmd.getURL());
			System.out.println("QU  DONG cheng xu:"+dmd.getDriverName());
			
		}
		catch(SQLException e)
		{
			System.out.println("SQLException");
			while(e!=null){
				System.out.println(e.getMessage());
				
			}


		}
	}



	
}