Monday, June 2, 2008

Java > Write SQLString+Params to file


String fileName = "C:\\New Folder\\TestQuery";

public static void writeSqlToFile(String query, boolean appendFlag, String absoluteFileNameWithNoExtension) {

try {
File file = new File(absoluteFileNameWithNoExtension+".txt");

if (!file.exists()) {
file.createNewFile();
}
// appendFlag [true = append, false = not append].
FileWriter fstream = new FileWriter(file,appendFlag);
BufferedWriter bw = new BufferedWriter(fstream);

bw.write("SQL = ");
bw.write(query);
bw.newLine();
//bw.write("Query parameters = "+Arrays.toString(param.toArray()));

//Close the output stream
bw.close();

} catch (Exception e) {
e.printStackTrace();

}

}

No comments: