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