Exporting data from mysql to csv file

Ads

 
 

Share on Google+Share on Google+

Prakash
Exporting data from mysql to csv file
2 Answer(s)      5 years and a month ago
Posted in : Java Beginners

Hi friends.... I want to export the data from mysql to csv file... i am having 30 columns in my database.. Eg- text1,text2,text3,....,upto text30... i want to export this data in csv file..if i export am getting the csv file with all data in one row.. but i want the csv file to be in the order like text1,text2,text3 should be in the 1st row of csv file... text4,text5,text6 should be in the 2nd row and so on.... i want csv file with 10 rows.. pls help me soon..its very urgent..

Ads
View Answers

August 31, 2012 at 12:17 PM


Here is a java example that retrieves the data from the database and save it into csv file.

import java.io.*;
import java.sql.*;

public class DatabaseToCSV { 
public static void main(String[]args){ 
  String filename = "c:\\myjdbcfile.csv";
  Connection conn = null;
  String url = "jdbc:mysql://localhost:3306/";
  String dbName = "test";
  String driver = "com.mysql.jdbc.Driver";
  String userName = "root"; 
  String password = "root";
  Statement stmt;
  try
  {

  FileWriter fw = new FileWriter(filename);

  Class.forName(driver).newInstance();
  conn = DriverManager.getConnection
   (url+dbName,userName,password);
  String query  = "select * from data";
  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(',');
  fw.append(rs.getString(5));
  fw.append(',');
  fw.append(rs.getString(6));
  fw.append(',');
  fw.append(rs.getString(7));
  fw.append(',');
  fw.append(rs.getString(8));
  fw.append(',');
  fw.append(rs.getString(9));
  fw.append(',');
  fw.append(rs.getString(10));
  fw.append('\n');
  }
  fw.flush();
  fw.close();
  conn.close();
  System.out.println("CSV File is created successfully.");
  } catch (Exception e) {
  e.printStackTrace();
  }

  }
}


August 31, 2012 at 12:30 PM


Thank you friend.. but can you give the code how to do it in jsp...


Ads









Related Tutorials/Questions & Answers:
Exporting data from mysql to csv file
Exporting data from mysql to csv file  Hi friends.... I want to export the data from mysql to csv file... i am having 30 columns in my database.. Eg... example that retrieves the data from the database and save it into csv file
Exporting data from mysql into csv using jsp
Exporting data from mysql into csv using jsp  Hi friends.... I want to export the data from mysql to csv file using... i am having 30 columns in my... in csv file..if i export, am getting the csv file with all data in one row
Advertisements
create dropdown cell in csv or excell from mysql data in php
create dropdown cell in csv or excell from mysql data in php  Hello sir i want to create drodown cell in csv from mysql data is this is possible or not? if this is posible please share answer or reference link Thanks
reading a csv file from a particular row
reading a csv file from a particular row  how to read a csv file from a particular row and storing data to sql server by using jsp servlet
Export Database table to CSV File
to retrieve data from database and save it to CSV File. The Comma-separated values... similar to text files. Exporting or writing data to csv file is exactly same... third party library. Output: Data is saved to csv file
Retrieve Data from CSV file in JSP
Retrieve Data from CSV file in JSP       CSV file : A CSV file is commonly known as a Comma... a Page ("ReadCsvFile.jsp") to retrieve the data from CSV file "
PHP code for csv file upload into mysql
PHP code for csv file upload into mysql  I want to upload a file from my pc to mysql server using upload option. while i m selecting the csv file it ll be upload the mysql database. can u send me the coding? i have tried
Data needs to be gathered in XML file from the database (MySql) using JSP
Data needs to be gathered in XML file from the database (MySql) using JSP ... data regarding particular id from the database table. Data needs to be gathered in XML file from the database (MySql) using appropriate JSP/Java Bean functions
Export data into CSV File using Servlet
Export data into CSV File using Servlet  ... to Export data into  CSV file using Servlet. We have created  file "JdbcCsvFile.java" to export data from this .java file.. Brief
php csv file uploding into mysql database table.
php csv file uploding into mysql database table.  hai friends, i... fields. i have one mysql database table with two files fields, when ever i am uploding csv file, i want to fetch the datas in corresponding fields in table. can
Wrong parameter values while exporting data from jsp to excel
Wrong parameter values while exporting data from jsp to excel   This is a jsp report. When i export the report data to an excel, the parameter...(); out.println("Data is saved in excel file."); }catch ( Exception ex ){ } %>
Mysql CSV
to import the data from text file to database in Mysql. Query for loading table data from csv file: mysql> load data infile "C:/g.csv... file into database. Mysql CSV is used to load the text file and add to the table
Export Data into CSV file uing JDBC in JSP
Export Data into CSV file uing JDBC in JSP       CSV file : A CSV file is commonly known... : 3.Create a Page ("CsvJdbcFile.jsp") to export data into  CSV
csv file download
csv file download  Hello Every one, when user clicks download button I want to retrieve data from mysql database table in csv format using java.if... the following link: JSP Retrieve data from MySQL Database
convert excel file data into different locales while converting exclile file to csv file
convert excel file data into different locales while converting exclile file to csv file   can any one provide the code for how to convert excel file data into different locales while converting exclile file to csv file
Retrieve The Data From MySql Datbase
Retrieve The Data From MySql Datbase   How to Retrieve The Data From MYSQL database TO Use Select the Emp_id Option.And Also Search Option
Expport data into CSV File using JDBC in Servlet
into CSV file using JDBC in Servlet. We have created  file "JdbcCsvFile.java" to export data from database in to CSV file. Brief... into CSV File using JDBC in Servlet   
Insert Data From File
Insert Data From File       Insert Data From File is  used to insert data from file... to insert data from file. To understand this example, we create a table 'Stu_Table
How to delete data from MySQL?
How to delete data from MySQL?  Hi, How I can conditionally delete the data from MySQL Table? Thanks   Hi, You can use the where clause to conditionally delete the data from MySQL database table. Here is some query
Retrive only requird data from a table in MYSQL databade to JSP file..on a field submit button.
Retrive only requird data from a table in MYSQL databade to JSP file..on a field submit button.  i have MYSQL DB,DB NAME:TRLIST, TABLE NAME:TR_LIST... from table TR_LIST on typing TR values in an input-text-box and by clicking<
How to save form data to a csv file using jquery or ajax
How to save form data to a csv file using jquery or ajax  Please let...=data.responseText; Now the problem is ,i should write form data to a csv file using ajax... this. i am able to read the csv file using this code if (window.XMLHttpRequest
Download CSV File from Database in JSP
Download CSV File from Database in JSP  ... file  from database. All CSV file will show as hyperlink. 2... to download CSV  file from database in JSP.  In this example, we have
store data from a variable in mysql?
store data from a variable in mysql?  sir last time asked you tell me how to retrieve data from a database mysql and store it in an int variable... of the calculation from an int variable into mysql in a new table of database. how
HTML Form data into .CSV?
HTML Form data into .CSV?  how to store data from html form to csvfile in java
Insert Data From File
Insert Data From File       Insert Data From File is  used to insert data from file... to insert data from file. To understand this example, we create a table 'Stu_Table
retrieve data from mysql database
retrieve data from mysql database  hi am not familiar in php.....even... selected value on combobox which is to be retrieve the relevant data from mysql...;/html> retcombosearch.php form is <?php mysql_connect ("localhost
Purge Data from Mysql tables
Purge Data from Mysql tables  Hi, i have to write a mysql procedure to purge data from tables. but written procedure clear entire tables data. Please give me the solution for purging data. CREATE DEFINER=`root`@`localhost
exporting data to excel sheet - JDBC
exporting data to excel sheet  Sir i have already send request about... = con.createStatement(); rs= st.executeQuery("Select * from data"); while(rs.next...; Form(){ String data[][] = {{"",""}}; String col[] = {"Name
SQL Bulk Insert csv
; SQL Bulk Insert is used to import the records from csv  file... an example from 'SQL Bulk Insert CSV'.To understand and  grasp this example... respectively.Again, we create a file abc  with extension csv contain the records
How to read data from txt file and save to database MySql - Java Beginners
How to read data from txt file and save to database MySql  Please help me again ,my problem right know is how to read data from txt file then data save to database from JButton.Please give me a tutorial and source code
Data extraction from an image file.
Data extraction from an image file.  I have made an image... data from the the image which also include deleted data.Can i used java to extract these data from the image file? Which are the libraries to be used