ArrayList to File

This code deals with how to write data from an ArrayList to a file.ArrayList is populated from a table in datqabase.Then array list is iterated and the values are printed on text file.

CandidateClass.java


package encapsulation;

import java.io.BufferedWriter;

import java.io.DataOutputStream;

import java.io.File;

import java.io.FileOutputStream;

import java.io.FileWriter;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.util.ArrayList;

import java.util.Iterator;

import encapsulation.BusinessClasses;

public class CandidateClass {

public static void main(String[] args)

{

BusinessClasses bc=new BusinessClasses();

ArrayList ae=((ArrayList)bc.candidateDetails());

File f1=new File("cand_list.txt");

try

{

f1.createNewFile();

FileWriter fstream = new FileWriter("cand_list.txt");

BufferedWriter out = new BufferedWriter(fstream);

PrintWriter pw =new PrintWriter(out);

Iterator it=ae.iterator();

int i=0;

while(it.hasNext())

{

String element = (String)it.next();

out.write(" ");

out.write(element);

i++;

if(i%2==0){

pw.println();

}

}

out.close();

}

catch (IOException e) {

System.out.println("Problem writing to file.");

System.err.println("IOException: " + e.getMessage());

}

}

}

//BusinessClasse.java

package encapsulation;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

public class BusinessClasses {

public static Connection getConnection() {

Connection conn=null;

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

String url = "jdbc:oracle:thin:@10.2.0.114:1521:ORCL";

conn = DriverManager.getConnection(url,"AYUSHMAR1024062011","AYUSHMAR1024062011");

} catch (Exception e) {

e.printStackTrace();

}

return conn;

}

public List candidateDetails() {

Statement st=null;

Connection con=null;

ResultSet rs=null;

List ae=new ArrayList();

try{

con=getConnection();

st=con.createStatement();

String sql="select CANDIDATE_ID,CANDIDATE_NAME from AYUSH_CANDIDATE_MST";

rs=st.executeQuery(sql);

ResultSetMetaData metaData = rs.getMetaData();

int columnCount = metaData.getColumnCount();

while(rs.next()){

for(int i=1;i<=columnCount;i++)

{

ae.add(rs.getString(i));

}

}

}

catch(SQLException se)

{

se.printStackTrace();

}

return ae;

}

}