JDBC-ODBC的EXCEL读取错误_jmp 报打开文件时出错-CSDN博客

本文链接：https://blog.csdn.net/basin_yi/article/details/1844892

package et;

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

public class tbasin {

public static void main(String []args){
  Connection c = null;
  Statement stmnt = null;
  try{
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   c = DriverManager.getConnection("jdbc:odbc:basin"," " ," " );
   stmnt = c.createStatement();
   String query = "SELECT * FROM [2007年9月4日渝中区分局民警名册$]";
   ResultSet rs = stmnt.executeQuery(query);
   System.out.println( "查得匹配记录为:" );
   ResultSetMetaData rsmd=rs.getMetaData();
   int x=rsmd.getColumnCount();

   while(rs.next())
    {
     for (int i=1;i<x;i++) {
     if(i>1)
      System.out.print(", ");
         String columnValue = rs.getString(i);
         System.out.print(columnValue);

       }
     System.out.println();
    }

  }
  catch(Exception e) {System.err.println(e);}
  finally{
   try{

    c.close();
    stmnt.close();

   }
   catch(Exception e){
    System.err.println(e);
   }
  }
}
}