csv导入mysql java_使用CSVJDBC导入CSV文件数据到MySQL中

package com.founder.demo;

import Java.sql.Connection;

import Java.sql.DriverManager;

import Java.sql.PreparedStatement;

import Java.sql.ResultSet;

import Java.sql.Statement;

public class ImportCSV {

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:H:\\PythonWorkSpace");

// create a Statement object to execute the query with   Statement stmt = conn.createStatement();

// Select the columns from csv file   ResultSet results = stmt

.executeQuery("SELECT ORDER_NO,ARTICLE_NO,CATALOG_NO,DESCRIPTION,QUANT