|
Export Data into CSV file uing JDBC in JSP
CSV file : A CSV file is commonly known as a
Comma Delimited File or a Character Separated File.
Step : 1 Import the packages .
<%@ page import="java.io.*,java.sql.*"%>
Step : 1 .Create a Table "employee_details"
in the database.
Step : 2 Create a folder "csv"
in the C:\ Drive.
Step : 3.Create a Page ("CsvJdbcFile.jsp") to export data into CSV file
"myjdbcfile.csv".
<%@ page import="java.io.*,java.sql.*"%>
<html>
<body>
<%
String filename = "c:\\csv\\myjdbcfile.csv";
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";
String dbName = "user_register";
String driver = "com.mysql.jdbc.Driver";
String userName = "root";
String password = "root";
Statement stmt;
try
{
FileWriter fw = new FileWriter(filename);
fw.append("Employee Code");
fw.append(',');
fw.append("First Name");
fw.append(',');
fw.append("Last Name");
fw.append('\n');
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url+dbName,userName,password);
String query = "select * from employee_details";
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('\n');
}
fw.flush();
fw.close();
conn.close();
out.println("<b>You are Successfully Created Csv file.</b>");
} catch (Exception e) {
e.printStackTrace();
}
%>
</table>
</body>
</html>
|
Output :
After successfully created csv file message is
display.
"myjdbcfile.csv"
Download
full source code
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
