JDBC_ODBC.rar_access jdbc

/** *2007-4-20 *下午12:12:49 */ /** * @author linden * */ import java.sql.*; public class JDBC_ODBC{ public static void main(String args[]){ String drv = "sun.jdbc.odbc.JdbcOdbcDriver"; try{ Class.forName(drv); Connection con = DriverManager.getConnection("jdbc:odbc:test", "", ""); DatabaseMetaData dmd = con.getMetaData(); if (dmd == null) { System.out.println ("No DBMeta available"); } else { System.out.println ("DB Name:\t" + dmd.getDatabaseProductName()); System.out.println ("DB Version:\t" + dmd.getDatabaseProductVersion()); System.out.println ("DB Driver Name:\t" + dmd.getDriverName()); System.out.println ("Driver Version:\t" + dmd.getDriverVersion()); } Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select * from [Sheet1$]"); System.out.println("ExCEL表记录内容："); System.out.println("\t姓 名\t性别\t年龄\t月 薪\t职 务" ); while(rs.next()){ System.out.print("\t" + rs.getString(1)); System.out.print("\t" + rs.getString(2)); System.out.print("\t" + rs.getInt(3)); System.out.print("\t" + rs.getString(4)); System.out.print("\t" + rs.getString(5)); System.out.println(); } con.close(); }catch(Exception e){ e.printStackTrace(); } } }