jdbc.java

通过ODBC访问数据库的程序

import java.sql.*;
class jdbc {
       public static void main(String args[]) throws Exception{
       	      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       	      Connection con=DriverManager.getConnection("jdbc:odbc:test");
       	      Statement stmt=con.createStatement();
       	      ResultSet rs=stmt.executeQuery("SELECT * FROM MyTable");
       	      System.out.println("显示结果：");
       	      while(rs.next())
       	      {       	      	
       	      	int i=rs.getInt("ID");
		String studentnum=rs.getString("学号");
      	      	String name=rs.getString("姓名");
       	      	int age=rs.getInt("年龄");
       	      	System.out.println(i+" "+studentnum+" "+name+" "+age);
       	      }
               //stmt.executeUpdate("UPDATE  test  set name='xz' where id=1");
       }
}