excel - 用于 Excel 的开源 JDBC 驱动程序，Maven 存储库上的 CSV 文件

Question

Maven 存储库中是否有可用的开源 Excel/CSV/XML 文件 JDBC 驱动程序？ JDBC-ODBC 桥接机制非常繁琐，不能很好地支持DataSource(可选特性未实现异常)。读/写能力是必不可少的，但如果没有更好的，只读就可以了。

Answer 1

CSVJdbc 是用于读取逗号分隔值文件的 Java 数据库驱动程序。

http://csvjdbc.sourceforge.net/

Maven repo :

<dependency>
  <groupId>net.sourceforge.csvjdbc</groupId>
  <artifactId>csvjdbc</artifactId>
  <version>1.0.9</version>
</dependency>

使用示例:

import java.sql.*;

public class DemoDriver
{
  public static void main(String[] args)
  {
    try
    {
      // Load the driver.
      Class.forName("org.relique.jdbc.csv.CsvDriver");

      // Create a connection. The first command line parameter is
      // the directory containing the .csv files.
      // A single connection is thread-safe for use by several threads.
      Connection conn = DriverManager.getConnection("jdbc:relique:csv:" + args[0]);

      // Create a Statement object to execute the query with.
      // A Statement is not thread-safe.
      Statement stmt = conn.createStatement();

      // Select the ID and NAME columns from sample.csv
      ResultSet results = stmt.executeQuery("SELECT ID,NAME FROM sample");

      // Dump out the results to a CSV file with the same format
      // using CsvJdbc helper function
      boolean append = true;
      CsvDriver.writeToCsv(results, System.out, append);

      // Clean up
      conn.close();
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
  }
}