public void writeToFile(String filePath, String tabName)
{
String LINE_SEPARATOR = "\n";
FileWriter out = null;
try {
File outputFile = new File(filePath);
if (outputFile.exists()) {
outputFile.delete();
}
out = new FileWriter(outputFile);
ResultSet rs = stmt.executeQuery();
ResultSetMetaData md = rs.getMetaData();
int cc = md.getColumnCount();
String columnNames = "";
String columnValues = "";
for (int i = 1; i <= cc; i++) {
columnNames = columnNames + "\t" + md.getColumnName(i);
}
columnNames = columnNames+LINE_SEPARATOR;
while (rs.next()) {
for (int i = 1; i <= cc; i++) {
columnValues = columnValues + "\t" + rs.getObject(i);
}
columnValues = columnValues + LINE_SEPARATOR;
}
out.write(columnNames + columnValues);
out.close();
} catch(Exception e) {
System.out.println("[Exception][CVDal.writeToFile] Exception Thrown: "+e);
e.printStackTrace();
}
}