How to export a table from mysql using java

This will help:

public class DatabaseToCSV {
    public static void main(String[] args) {
        String filename =
            "C:\\Documents and Settings\\admin\\My Documents\\NetBeansProjects\\AutomateExcelDatabase\\myjdbcfile.csv";
        try {
            FileWriter fw = new FileWriter(filename);
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            Connection conn = DriverManager.getConnection(
                "jdbc:mysql://192.168.0.189:3306/ArchiveIndexer"
                , "username"
                , "password"
            );
            String query = "select * from D_Centre";
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery(query);
            while (rs.next()) {
                fw.append(rs.getString(1));
                fw.append(',');
                fw.append(rs.getString(2));
                fw.append(',');
                fw.append(rs.getString(3));
                fw.append(',');
                fw.append(rs.getString(4));
                fw.append('\n');
            }
            fw.flush();
            fw.close();
            conn.close();
            System.out.println("CSV File is created successfully.");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

this might help u : Export database to csv file

Example below exports data from MySQL Select query to CSV file.

testtable structure
CREATE TABLE testtable
(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
text varchar(45) NOT NULL,
price integer not null);

Application takes path of output file as an argument.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class automateExport {
 public static void main(String[] args) {
    DBase db = new DBase();
    Connection conn = db.connect(
            "jdbc:mysql://localhost:3306/test","root","caspian");

    if (args.length != 1) {
        System.out.println(
                "Usage: java automateExport [outputfile path] ");
        return;
    }
    db.exportData(conn,args[0]);
}

}

class DBase {
public DBase() {
}

public Connection connect(String db_connect_str, 
        String db_userid, String db_password) {
    Connection conn;
    try {
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        conn = DriverManager.getConnection(db_connect_str,
                db_userid, db_password);

    } catch(Exception e) {
        e.printStackTrace();
        conn = null;
    }
    return conn;
}

public void exportData(Connection conn,String filename) {
    Statement stmt;
    String query;
    try {
        stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                ResultSet.CONCUR_UPDATABLE);

        //For comma separated file
        query = "SELECT id,text,price into OUTFILE  '"+filename+
                "' FIELDS TERMINATED BY ',' FROM testtable t";
        stmt.executeQuery(query);

    } catch(Exception e) {
        e.printStackTrace();
        stmt = null;
    }
}

};

The error means that you are using executeUpdate() when you should be using executeQuery()

executeUpdate() is for executing updates (duh)

executeQuery() is for searching the database and returning a ResultSet

Hope this helps