Comment
Srivatsan
Want to Retrieve CSV from a table using Struts2,
January 24, 2008 at 5:15 PM
January 24, 2008 at 5:15 PM
Hi,
Please help me in code, i want to get CSV using struts2 application! The thing is that i able to compile the java application but i couldnot run the file in the browser windows.Here by i attache the java file please refer it and do the needful. Bye!
package com.stocksim;
import java.sql.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.opensymphony.xwork2.ActionSupport;
public class Stock extends ActionSupport{
private HttpServletRequest request;
private static String REAL_PATH = null;
private HttpServletResponse response;
public void setServletRequest( HttpServletRequest request ) {
this.request = request;
REAL_PATH = this.request.getRealPath( "/" );
}
public void setServletResponse( HttpServletResponse response ) {
this.response = response;
}
public String execute() throws Exception{
StringBuffer sb=new StringBuffer();
try {
System.out.println("Hello World");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:College");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from stud");
ResultSetMetaData mdata=rs.getMetaData();
sb.append("StudentNumber,StudentName,StudentDegree,StudentGrade,StudentPercentage,\n");
while(rs.next()) {
sb.append(rs.getString(1)+","+rs.getString(2)+","+rs.getString(3)+","+rs.getString(4)+","+rs.getString(5)+",\n");}
System.out.println("Employ-Details" + sb.toString());
//response.setContentType("text/html");
//response.setHeader("cache-control","no-control");
response.getWriter().println(sb.toString());
stmt.close();
con.close();
}
catch( Exception e ) {
e.printStackTrace();
}
return null;
}
View All Comments | View Tutorial
Please help me in code, i want to get CSV using struts2 application! The thing is that i able to compile the java application but i couldnot run the file in the browser windows.Here by i attache the java file please refer it and do the needful. Bye!
package com.stocksim;
import java.sql.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.opensymphony.xwork2.ActionSupport;
public class Stock extends ActionSupport{
private HttpServletRequest request;
private static String REAL_PATH = null;
private HttpServletResponse response;
public void setServletRequest( HttpServletRequest request ) {
this.request = request;
REAL_PATH = this.request.getRealPath( "/" );
}
public void setServletResponse( HttpServletResponse response ) {
this.response = response;
}
public String execute() throws Exception{
StringBuffer sb=new StringBuffer();
try {
System.out.println("Hello World");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:College");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from stud");
ResultSetMetaData mdata=rs.getMetaData();
sb.append("StudentNumber,StudentName,StudentDegree,StudentGrade,StudentPercentage,\n");
while(rs.next()) {
sb.append(rs.getString(1)+","+rs.getString(2)+","+rs.getString(3)+","+rs.getString(4)+","+rs.getString(5)+",\n");}
System.out.println("Employ-Details" + sb.toString());
//response.setContentType("text/html");
//response.setHeader("cache-control","no-control");
response.getWriter().println(sb.toString());
stmt.close();
con.close();
}
catch( Exception e ) {
e.printStackTrace();
}
return null;
}
View All Comments | View Tutorial
Related Tutorial and Articles
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
