Hi Friend,

Try the following code:

import java.io.*;
import java.sql.*;
import java.util.*;
class StoreDataIntoFile{

    public static void main(String[] args){
        try{
            ArrayList list1=new ArrayList();
            ArrayList list2=new ArrayList();
            File file=new File("data1.txt");
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:student");
            Statement st=con.createStatement();
            ResultSet rs=st.executeQuery("select * from user");
            BufferedWriter bw = new BufferedWriter(new FileWriter(file,true));
            while(rs.next()){
               list1.add(rs.getString("name"));
               list2.add(rs.getString("address"));
            }
            for(int i=0;i<list1.size();i++){
               bw.write(list1.get(i).toString()+" "+list2.get(i).toString());
               bw.newLine();
            }
               bw.close();
        }
        catch(Exception e){
        }
    }
}

Thanks