CsvJdbc - a JDBC driver for CSV files
CsvJdbc is a simple read-only JDBC driver that uses Comma Separated Value (CSV) files as database tables. It is ideal for writing data importing programs.
The CsvJDBC driver is used just like any other JDBC driver. This example code shows how the driver is used.
import java.sql.*;
public class DemoDriver
{
public static void main(String[] args)
{
try
{
// load the driver into memory
Class.forName("org.relique.jdbc.csv.CsvDriver");
// create a connection. The first command line parameter is assumed to
// be the directory in which the .csv files are held
Connection conn = DriverManager.getConnection("jdbc:relique:csv:" + args[0] );
// create a Statement object to execute the query with
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
while (results.next())
{
System.out.println("ID= " + results.getString("ID") + " NAME= " + results.getString("NAME"));
}
// clean up
results.close();
stmt.close();
conn.close();
}
catch(Exception e)
{
System.out.println("Oops-> " + e);
}
}
}
The driver also supports a number of parameters that change the default behaviour of the driver.
These properties are:
false; column headers are on first line).
This following example code shows how these properties are used.
...
Properties props = new java.util.Properties();
props.put("separator","|"); // separator is a bar
props.put("suppressHeaders","true"); // first line contains data
props.put("fileExtension",".txt"); // file extension is .txt
Connection conn = Drivermanager.getConnection("jdbc:relique:csv:" + args[0],props)
...
The latest version of the software can be found at http://www.sourceforge.net/projects/csvjdbc.