连接数据库报错？

Question

 Connection exConn=DriverManager.getConnection("sun.jdbc.odbc:Classify","admin","sa");改成
 Connection exConn=DriverManager.getConnection
("jdbc:odbc:Classify","admin","sa");
试试还有你在ODBC的DNS里面有没有配置好呢？

Answer 1

DNS设置好的。
代码也修改过了。报错：
 E:\Study\java\Test>java Db
java.sql.SQLException: No suitable driver//import java.io.*;
import java.lang.*;
import java.sql.*;
public class Db
{
  public static void main(String args[])
  {      int i;
      String ID,field1,field2;      try
      {        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection exConn=DriverManager.getConnection("jdbc.odbc:Classify","admin","sa");
        Statement exStmt=exConn.createStatement();
        ResultSet exRs=exStmt.executeQuery("select * from table1");        while (exRs.next())
        {
          ID=String.valueOf(exRs.getInt("ID"));
          field1=String.valueOf(exRs.getInt("field1"));
          field2=String.valueOf(exRs.getInt("field2"));
          System.out.println(ID+"ff"+field1+field2);
        }
      }
      catch(java.lang.ClassNotFoundException e){System.out.println(e.toString());}
      catch(java.sql.SQLException e){System.out.println(e.toString());}  }
}

Answer 2

跟你说要把jdbc.odbc:Classify改成jdbc:odbc:Classify干吗不听？是冒号，不是点号！！！

Answer 3

 Connection exConn=DriverManager.getConnection("jdbc.odbc:Classify","admin","sa");应该是 jdbc:odbc:Classify
是冒号！！！