Skip to Main Content

Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to add header and fooder in text file

833473Mar 21 2011 — edited Mar 22 2011
Hi,

i have created simple application for generate report from database into text file.

But i need to add header and fooder in text file. I dont know is there any API for adding these.

Can anyone help me to create header and fooder in text file.

the below text are needs to be print in the header
---------------------------------------------------------------------
name of the table :
Recorder type :
file creation time:

the below text are needs to be print in the footer
---------------------------------------------------------------------
Recorder Number:
Record Type;

the actual code is
                       pst = con.prepareStatement("select REQUEST, DOMAIN_NAME, TRUNC(DATE_OF_CONFIGURATION) AS dateofConfig  FROM employee where id=300");
            			rs = pst.executeQuery();
 
                        while (rs.next()) { 
                        	request = rs.getString("REQUEST"); 
                                domain_name = rs.getString("DOMAIN_NAME"); 
                                dateofconfig = rs.getString("dateofConfig"); 
                                
                                System.out.println(request + " " + domain_name + " " + dateofconfig);
                               data.add(request + " " + domain_name + " " + dateofconfig); 
                        } 
                        System.out.println("before calling method");
                        writeToFile(data, "c:/Employee.txt"); 
                        System.out.println("file created successfull");
                        rs.close(); 
                        pst.close(); 
 
       private static void writeToFile(List list, String path) { 
                BufferedWriter out = null; 
                try { 
                        File file = new File(path); 
                        out = new BufferedWriter(new FileWriter(file, true)); 
                        for (Object obj : list) { 
                            String s=  obj.toString();  
                        	out.write(s); 
                                out.newLine(); 
 
                        } 
                        out.close(); 
                } catch (IOException e) { 
                } 
        } 
}
Thanks
Jasmin

Edited by: user13836688 on Mar 21, 2011 4:06 AM

Edited by: user13836688 on Mar 21, 2011 4:07 AM

Edited by: user13836688 on Mar 21, 2011 4:08 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2011
Added on Mar 21 2011
3 comments
921 views