views:

285

answers:

4
 SimpleDateFormat formatter = new SimpleDateFormat("ddMMyyyy_HHmmSS");
 String strCurrDate = formatter.format(new java.util.Date());
 String strfileNm = "Cust_Advice_" + strCurrDate + ".txt";
 String strFileGenLoc = strFileLocation + "/" + strfileNm;
 String strQuery="select name, age, data from basetable";
 try {

     stmt = conn.createStatement();
     System.out.println("Query is -> " + strQuery);
     rs = stmt.executeQuery(strQuery);

     File f = new File(strFileGenLoc);
     OutputStream os = (OutputStream)new FileOutputStream(f);
     String encoding = "UTF8";
     OutputStreamWriter osw = new OutputStreamWriter(os, encoding);
     BufferedWriter bw = new BufferedWriter(osw);

     while (rs.next() ) {

         bw.write(rs.getString(1)==null? "":rs.getString(1));
         bw.write("  ");
         bw.write(rs.getString(2)==null? "":rs.getString(2));
         bw.write("  ");

     }
     bw.flush();
     bw.close();
 } catch (Exception e) {
     System.out.println(
         "Exception occured while getting resultset by the query");
     e.printStackTrace();
 } finally {
     try {
         if (conn != null) {
             System.out.println("Closing the connection" + conn);
             conn.close();
         }
     } catch (SQLException e) {
         System.out.println(
             "Exception occured while closing the connection");
         e.printStackTrace();
      }
    }
         return objArrayListValue;
  }

i need "one tab space" in between each column(while writing to text file). like

   manu 25 data1
   manc 35 data3

in my code i use bw.write(" ") for creating space between each column. how to use "one tab space" in that place instead of giving "space".

+4  A: 

You can use \t to create a tab in a file.

tmeisenh
if i use this java code in unix. this "\t" makes any problem
Manu
what does "any problem" mean? If you are having a problem and you would like help solving it, please describe the problem.
matt b
@Manu: Which problems? `\t` should be pretty standard throughout the OS'.
Felix Kling
+1  A: 

Use "\t". That's the tab space character.

You can find a list of many of the Java escape characters here: http://java.sun.com/docs/books/tutorial/java/data/characters.html

Jacinda S
if i use this java code in unix. this "\t" makes any problem
Manu
+1  A: 

use \t instead of space.

bw.write("\t"); 
Veer
if i use this java code in unix. this "\t" makes any problem
Manu
try it first and if you encounter any problem report it here
Veer
A: 

you cannot use \t ie. bw.write("\t").. it will show error..

jack