jdbc.rar_jdbc数据库编程

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){} } } }