本文讲的是在java环境下对CSV文件进行读取操作，csv文件格式是用的比较多的，前几天在网上找到一个驱动可以把这种格式的文件当作数据库一样读取。操作步骤如下：
第一、下载驱动程序http://sourceforge.net/projects/csvjdbc
第二、把csvjdbc.jar文件放到classpath路径中去。
第三、例子如下:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class JdbcCsv {
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:F:\\aa\\");
// 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 发动机编号,零件号,零件名称,数量 from MES OEPL");

String sql;

// dump out the results
while (results.next()) {
System.out.println(" " +

"发动机编号: " + results.getString("发动机编号") + " "+
"零件号: " + results.getString("零件号") + " "+
"零件名称: " + results.getString("零件名称") + " "+
"数量: " + results.getString("数量"));

// sql = "insert into ";
// BaseDAO baseDAO = new BaseDAO();
// baseDAO.execute(sql);

}
// clean up
results.close();
stmt.close();
conn.close();
} catch (Exception e) {
System.out.println("Oops-> " + e);
}}