使用Java读取Excel文件内容

            }
        }
        catch( Exception e ) {
            System.err.println( e );
        }
        finally {
            try {
                stmnt.close();
                c.close();
            }
            catch( Exception e ) {
                System.err.println( e );
            }
        }
    }
}
 在此程序中，主函数main() 建立了一个数据表的连接，并取出符合条件的记录。

（译者注：另外，我这里还有一段程序，是读取所有记录的程序，仅作参考）：

import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.DriverManager;

public class ExcelReader {

    public static void main(String[] args){
        Connection connection = null;

        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection( "jdbc:odbc:Book1","","" );
            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery( "SELECT * FROM [Sheet1$]" );

            ResultSetMetaData rsmd = rs.getMetaData();
            int numberOfColumns = rsmd.getColumnCount();

            while (rs.next()) {
                for (int i = 1; i <= numberOfColumns; i++) {
                    if(i>1)  //用逗号分隔各列
      System.out.print(", ");
                    String columnValue = rs.getString(i);
                    System.out.print(columnValue);

共3页  1 2 3