从书上抄的一个与jdbc-odbc桥接的例子
import java.sql.*;
import java.util.*;
import java.lang.*;
public class java_sql_useDBDriver
{
public static void main(String[] args)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Enumeration enum=DriverManager.getDrivers();
while(enum.hasMoreElements())
{
System.out.println(enum.nextElement());
}
}
catch(java.lang.Exception exec)
{
System.out.println("加载数据库异常");
}
try
{
String url="jdbc:odbc:mqis";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection cn=DriverManager.getConnection(url);
Statement sql=cn.createStatement();
ResultSet rs=sql.executeQuery("select * from 教师信息");
for(int j=1;j<=rs.getMetaData().getColumnCount();j++)
{
System.out.print(rs.getMetaData().getColumnName(j)+"\t");
}
System.out.println();
while(rs.next())
{
for(int j=1;j<=rs.getMetaData().getColumnCount();j++)
{
System.out.print(rs.getObject(j)+"\t");
}
System.out.println();
}
sql.close();
cn.close();
}
catch (SQLException ex)
{
ex.printStatckTrace();
}
}
}
//出错提示===============================
java_sql_useDBDriver.java:27: unreported exception java.lang.ClassNotFoundExcept
ion; must be caught or declared to be thrown
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
^
1 error