How to export table data from a mysql database into text file using java?

[asenthil]

Hai,

i'm a beginner to java...

just now i had tried to read and write files using java...

and then i had tried to connect a database using jdbc...

now i want to export the data's from a database into a text file

using java....

Can any one plzz give me an idea for doing this process...

thanks and regards..
senthil.

[r035198x]

Hai,

i'm a beginner to java...

just now i had tried to read and write files using java...

and then i had tried to connect a database using jdbc...

now i want to export the data's from a database into a text file

using java....

Can any one plzz give me an idea for doing this process...

thanks and regards..
senthil.

Write files using BufferedWriter and FileWriter

[maeon3]

Output it to a file:

 SELECT agent_index, program_name, description 
INTO OUTFILE "/tmp/my_table_widgets.out" 
FROM my_table_widgets

Then to get it back:

 LOAD DATA LOCAL INFILE '/tmp/my_table_widgets.out'
INTO TABLE my_table_widgets
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
(agent_index, program_name, description);

Here is the java to do it:

 try {
  Class.forName(Driver);
  con = DriverManager.getConnection(connect_url);
 if(!con.isClosed()){
      stmt = con.createStatement(); 
 
    stmt.executeQuery("SELECT agent_index, program_name, description " +
"INTO OUTFILE '/tmp/my_table_widgets.out' " +
"FROM my_table_widgets ");
}
}
catch(Exception e) {
   System.err.println("Exception: " + e.getMessage());
    } 
finally {
      try {
        if(con != null)
          con.close();
      } catch(SQLException e) {}
 }
}
}