一个JDBC和Accsess数据库的查询代码

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 Student"); while(rset.next()){ String ID=rset.getString("1"); String name= rset.getString("Andy"); String address = rset.getString("USA"); long capital = rset.getLong("LA"); System.out.println("1: "+ ID + ", Andy: " + name + ", USA: " + address +", LA: " + 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){} } }}