data.java

来自「该程序是用java来连接ODBC数据库」· Java 代码 · 共 36 行

import java.net.URL;
import java.sql.*;
class Data
{
	public static void main(String arge[])
	{
		String i="jdbc:odbc:sqltest";


	try{
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(java.lang.ClassNotFoundException e)
		{
			System.out.println("ClassNotFoundException: ");
		}

		Connection con=DriverManager.getConnection(i,"","");
		DatabaseMetaData dma=con.getMetaData();
		System.out.println("连接到数据库:"+dma.getURL());
		System.out.println("Driver: "+dma.getDriverName());
		System.out.println("Version: "+dma.getDriverVersion());
		con.close();
	}catch(SQLException ex){
		while(ex!=null)
		{
			System.out.println("数据库异常被捕获了");
			System.out.println(ex.getSQLState());
			System.out.println(ex.getMessage()+"文件");
			System.out.println(ex.getErrorCode()+"新闻");
			ex=ex.getNextException();
		}
	}
	}
};