in java (csv into mysql) making problem in date formate

[raj.mscking@gmail.com]

Good Morning Sir!

in my java project, i converted mysql into csv file formate for date transferring purpose,

By default the csv file store date as dd/mm/yyy from yyyy/mm/dd

now i try to upload the csv into mysql.

But the exception say about the date format problem..,

This is my code

csv into mysql

private void jLabel126MouseClicked(java.awt.event.MouseEvent evt) {                                       
// TODO add your handling code here:
    Statement stmt;
    String query;
    try {
        JOptionPane.showMessageDialog(null, "You Have To Select Employee & Employee Familly Files To Compleate This Entry");
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/payslip", "root", "root");
        stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
        String dds = JOptionPane.showInputDialog(null, "Enter FileName To Load Employee Dtails", "");
        if(!dds.equals(""))
        {
        String fn = "C:/" + dds + ".csv";
        query = "LOAD DATA INFILE '" + fn + "' INTO TABLE newemp FIELDS TERMINATED BY ',' (EmployeeID,Name,"
                + DateOfBirth,"
                + "DateOfJoin,Designation,Guardian,MailID,ContactNo,TotalExperience,CompanyDetails,"
                + "IdMark,Qualification,UserName,PassWord,Photo,BasicPay,InTime,OutTime,LandLineNo,"
                + "ResignedDate,Department,Branch)";
        stmt.executeUpdate(query);
        JOptionPane.showMessageDialog(null, "Uploaded Sceeceefully");
        }
        else
        {
            JOptionPane.showMessageDialog(null,"Enter Valid File Name");
        }

    } catch (Exception r) {
        JOptionPane.showMessageDialog(null, r);//"Check Your File Please");
    }
}

i try with DATE_FORMAT(DateOfBirth, '%Y/%m/%d') too. But also making the same problem sir..,

private void jLabel126MouseClicked(java.awt.event.MouseEvent evt) {                                       
// TODO add your handling code here:
    Statement stmt;
    String query;
    try {
        JOptionPane.showMessageDialog(null, "You Have To Select Employee & Employee Familly Files To Compleate This Entry");
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/payslip", "root", "root");
        stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
        String dds = JOptionPane.showInputDialog(null, "Enter FileName To Load Employee Dtails", "");
        if(!dds.equals(""))
        {
        String fn = "C:/" + dds + ".csv";
        query = "LOAD DATA INFILE '" + fn + "' INTO TABLE newemp FIELDS TERMINATED BY ',' (EmployeeID,Name,"
                + "DATE_FORMAT(DateOfBirth, '%Y/%m/%d') as DateOfBirth,"
                + "DateOfJoin,Designation,Guardian,MailID,ContactNo,TotalExperience,CompanyDetails,"
                + "IdMark,Qualification,UserName,PassWord,Photo,BasicPay,InTime,OutTime,LandLineNo,"
                + "ResignedDate,Department,Branch)";
        stmt.executeUpdate(query);
        JOptionPane.showMessageDialog(null, "Uploaded Sceeceefully");
        }
        else
        {
            JOptionPane.showMessageDialog(null,"Enter Valid File Name");
        }

    } catch (Exception r) {
        JOptionPane.showMessageDialog(null, r);//"Check Your File Please");
    }

my csv file format is

102	selva	8/6/2012	6/2/2012	Teacher	christ	raj@gmail.com	994460858

what change i have to do with this code sir guide me please..,

Thank you..,

[Tolls]

First off, that is tab separated and yet you are telling the LOAD DATA command that your fields are comma separated, which is going to cause problems.
Next, what version of MYSQL are you using? If it's post-5.0.3 then you can use the SET command:
LOAD DATA INFILE 'yourfile.csv'
INTO TABLE your_table
(column1, @dateval1)
SET column2 = str_to_date(@dateval1, '%m/%d/%Y');
Note str_to_date...you are converting from a string to a date, not formatting an existing date.