Export CSV query results on the JSP page

I have found one for many websites and it is easy to use:

 

String queryresult = ...;
Response. setcontenttype ("application/CSV ");
Response. setheader ("content-disposition", "inline; filename =" result.csv "");
Printwriter out = new printwriter (New outputstreamwriter (
Response. getoutputstream (), "UTF-8 "));
Out. Print (queryresult );
Out. Close ();

But I encountered a real problem when I was doing it myself, because I had time to export the results, and its format was 07:00:00. If I opened it with notepad, it would certainly be okay, however, if you use Excel to open the file, the time period will change to ###, because the Excel time format is 07:00:00. Therefore, the string must be pre-processed before export.

 

Private Static final dateformat formatvls = new simpledateformat ("yyyy-mm-dd hh: mm ");
Private Static final dateformat formatcsv = new simpledateformat ("DD/MM/YYYY hh: mm ");

Private string converttimeforcsv (string input) throws vlsexception ...{
Try ...{
Return formatcsv. Format (formatvls. parse (input ));
} Catch (parseexception e )...{
// Todo auto-generated Catch Block
Throw new vlsexception (vlsconstants. error_format );
}
}