Java code for file writer using select query

The code here is useful for writing of file using select query separated with any delimiter.

public static void generateFile(String generatedFile, String delimiter, String sqlQuery) throws Exception {

System.out.println("generatedFile :"+generatedFile);

Statement st = getDBConnection().createStatement();

ResultSet rs = st.executeQuery(sqlQuery);

File file = new File(generatedFile);

file.createNewFile();

PrintWriter writer = new PrintWriter(file) ;

ResultSetMetaData meta = rs.getMetaData() ;

int numberOfColumns = meta.getColumnCount() ;

String dataHeaders = meta.getColumnName(1) ;

//If you don't want column heading simply comment this IF condition

  if(numberOfColumns>0 ){

for (int i = 2 ; i < numberOfColumns + 1 ; i ++ ) {

dataHeaders += delimiter + meta.getColumnName(i) ;

}

writer.println(dataHeaders) ;

}

 

while (rs.next()) {

String row = rs.getString(1) ;

for (int i = 2 ; i < numberOfColumns + 1 ; i ++ ) {

row += delimiter + rs.getString(i) ;

}

writer.println(row) ;

}

writer.close();

}