export function with netbeans from mysql to excel

Question

so i need to make a function which will take all datas from a table in my mysql. i've found the query (and it's working), but the problem is how to do it in java?

public void Print() {
    Database db = new Database();
    ResultSet rs = null;
    rs = db.getData("SELECT * FROM my_table"
            + "INTO OUTFILE 'E:\\kurtcobain.csv'"
            + "FIELDS TERMINATED BY ','"
            + "ENCLOSED BY '"'
            + "LINES TERMINATED BY '+\n+'");

i've try putting some quotation marks but still errors with "unclosed character literal" at line 7. any solutions? thanks before

redrider · Accepted Answer · 2015-07-24 09:16:13Z

1

check you codes .. there are missing (")

public void Print() {
    Database db = new Database();
    ResultSet rs = null;
    rs = db.getData("SELECT * FROM my_table"
            + "INTO OUTFILE 'E:\\kurtcobain.csv'"
            + "FIELDS TERMINATED BY ','"
            + "ENCLOSED BY '"'"
            + "LINES TERMINATED BY '+\n+'")";

answered Jul 24, 2015 at 9:16

redrider

1311 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

export function with netbeans from mysql to excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related