阅读背景:

使用java将日期和时间的csv文件加载到oracle数据库中

来源:互联网 
import java.io.FileReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

import au.com.bytecode.opencsv.CSVReader;

public class ImportingDate {

    /**
     * @param args
     */
    public static void main(String[] args) {
        // TODO Auto-generated method stub
        try{
        /* Create Connection objects */
        Class.forName("oracle.jdbc.driver.OracleDriver");
        Connection conn= DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521/xe","SYSTEM","sandp");
        /* Create the insert statement */
        String insertQuery = "Insert into date_tab(workdate) values(to_date(?,'dd/mon/yyyy hh24:mi:ss'))";
        PreparedStatement pstmt = conn.prepareStatement(insertQuery);
        CSVReader reader = new CSVReader(new FileReader("D:\datedata.csv"), ',');
        String[] nextLine;
        int i = 0;
        while((nextLine = reader.readNext()) != null)
        {
            i++;
            if (nextLine.length == 1){
                pstmt.setString(1,nextLine[0]);
                i=pstmt.executeUpdate();
            }
        }
        System.out.println("Data Successfully Uploaded");
            pstmt.close();
            conn.commit();
            conn.close();
        }

        catch(Exception e)
        {
            e.printStackTrace();
        }
    }

}
import java.io.FileReader;
import java.sql.Conn



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: