odbcdemo.java

来自「java课件 java课件 java课件 java课件」· Java 代码 · 共 30 行

import java.sql.*;

public class ODBCDemo{
  public static void main(String args[]){
    try{
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
     String dburl="jdbc:odbc:student";
     Connection conn = DriverManager.getConnection(dburl,"","");
     String sql = "select * from student";
     Statement stmt = conn.createStatement();
     ResultSet rst = stmt.executeQuery(sql);
     while(rst.next()){
       System.out.print(rst.getString(1));
       System.out.print("  "+rst.getString(2));
       System.out.print("  "+rst.getString(3));
       System.out.print("  "+rst.getInt(4));
       System.out.print("  "+rst.getString(5));
       System.out.println();
     }
     
     try{
       rst.close();
       stmt.close();
       conn.close();
     }catch(Exception e){}
    }catch(Exception e){
      System.out.println(e);
    }
  }
}