dbtest4.java

来自「这是一张java应用教程的随书光盘」· Java 代码 · 共 23 行

import java.sql.*;
public class DbTest4
{public static void main(String args[]){
   try{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
	Connection conn = DriverManager.getConnection("jdbc:odbc:person", "", ""); 
	Statement stmt  = conn.createStatement();
	ResultSet rs=stmt.executeQuery("select * from [Sheet1$]");
	while(rs.next()){
		System.out.print("  编号：" + rs.getString(1));
		System.out.print("  姓名：" + rs.getString(2));
		System.out.print("  座位：" + rs.getString(3));
		System.out.print("\n");
	    }
	rs.close();
	stmt.close();
	conn.close();
    }catch(Exception e){
	e.printStackTrace();
   }
 }
}