jdbc1.java

java数据库编程

import java.sql.*;
public class JDBC1{
  public static void main(String[] args){
    Connection connect=null;
    Statement st=null;
    ResultSet rset=null;
    try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }catch(ClassNotFoundException ce){
      System.out.println(ce);  
    }
    try{
      connect = DriverManager.getConnection("jdbc:odbc:Test");
      st = connect.createStatement();
      rset= st.executeQuery("Select * from 脚惑沥焊");
      while(rset.next()){
        String ID=rset.getString("林刮殿废锅龋");
        String name= rset.getString("捞抚");
        String address = rset.getString("林家");
        long capital = rset.getLong("磊夯陛");
         
        System.out.println("林刮殿废锅龋: "+ ID
                          + ", 捞抚: " + name 
                          + ", 林家: " + address
                          +", 磊夯陛: " + capital);
      }
    }catch(SQLException se){
      System.out.println(se);
    }finally{
      try{
        if(rset!=null)rset.close();
        if(st!=null)st.close();
        if(connect!=null)connect.close();
      }catch(SQLException se){}
    } 
  }
}