Exporting MySQL database to excel using java code

java mysql jexcelapi
Muhammad Salman Farooq picture Muhammad Salman Farooq · Sep 5, 2012 · Viewed 7.8k times · Source

I want to export my MySQL database to .xls or .txt format. How can I do it in java. What I want to do is that there is a button in my application on pressing which, my database export to excel file. Thanks.

Answer

jsj picture jsj · Sep 5, 2012

Make a system call to MySQL:

mysql -e'SELECT * FROM table'>file.csv

Related questions

Solving a "communications link failure" with JDBC and MySQL

I'm trying to connect to the local MySQL server but I keep getting an error. Here is the code. public class Connect { public static void main(String[] args) { Connection conn = null; try { String userName = "myUsername"; String password = "myPassword"; String url = "…

Read More
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

I'm working on getting my database to talk to my Java programs. Can someone give me a quick and dirty sample program using the JDBC? I'm getting a rather stupendous error: Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.…

Read More
Connect Java to a MySQL database

How do you connect to a MySQL database in Java? When I try, I get java.sql.SQLException: No suitable driver found for jdbc:mysql://database/table at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.…

Read More