Hai to all,,

i had to tried to retrive and write a single row to a file from the database..

But dont know to write all the retrived rows to a file from the database..

how to do that...

here are my codings for writing a single row to a file...

Code:
import java.io.*;
import java.sql.*;

public class DataBase {

  public static void main(String args[]) {
String Driver;
Statement stmt; 
ResultSet rs; 

Driver = "com.mysql.jdbc.Driver";
Connection con = null;
try {
File file = new File("C:/test.txt");
BufferedWriter out = new BufferedWriter(new FileWriter(file));
Class.forName(Driver);
con = DriverManager.getConnection("jdbc:mysql://192.168.0.01/senthil","root","");
      if(!con.isCloses)
{
System.out.println("Successfully connected to MySQL DataBase \n");
               stmt = con.createStatement(); 
rs = stmt.executeQuery("SELECT * FROM employees");
InputStream data= null;
System.out.println("Display all results: "); 
               while (rs.next()) { 
                  int id = rs.getInt("Employee_Number");
	  String name = rs.getString("First_Name"); 
                  String addr = rs.getString("Second_Name");
	 data = rs.getBinaryStream(1);
                 int temp=0;
                 while( (temp = data.read()) != -1) {         
	 out.write(temp);        }                  
                System.out.println( id + name + addr);   
                   } 

                 out.flush();   
	 out.close(); 
        
	  }

    } catch(Exception e) {
      System.err.println("Exception: " + e.getMessage());
    } finally {
      try {
        if(con != null)
          con.close();
      } catch(SQLException e) {}
    }
  }
}
Can any one plzz help me soon...

thanks and regards..
senthil