利用java语言将csv格式数据导入mysql数据库

import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import java.util.Properties;



class ExecuteDDL {

     

    private String driver;

    private String url;

    private String user;

    private String pass;

    Connection conn;

    Statement stmt;

    public void initParam(String paramFile) throws Exception {

        Properties props = new Properties();
        //props.load(arg0)

        props.load(new FileInputStream(paramFile));

        driver = props.getProperty("driver");

        url = props.getProperty("url");

        user = props.getProperty("user");

        pass = props.getProperty("pass");       

    }

     

    public void createTale(String sql) throws Exception{

        try {

            Class.forName(driver);

            conn = DriverManager.getConnection(url,user,pass);

            stmt = conn.createStatement();

            stmt.executeUpdate(sql);


        } 

        finally

        {

            if (stmt != null) {

                stmt.close();

            }

            if (conn != null) {

                conn.close();

            }

        }

    }

     

    /**

     * @param args

     * @throws Exception 

     */

    public static void main(String[] args) throws Exception {

        // TODO Auto-generated method stub

         

        ExecuteDDL ed = new ExecuteDDL();