While Loop Problem

[javaguy345]

try
{
File output = new File("c:\\Temp\\", "QuestionList.txt");

BufferedWriter outFile = new BufferedWriter (
new FileWriter(output.getPath(), true));

Connection con = DriverManager.getConnection(databaseURL, "user", "password");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM APP.QUESTIONS");

while (rs.next()) //I THINK THE PROBLEM IS HERE
{
String QUESTIONNO = rs.getString("QUESTIONNO");
String QUESTION = rs.getString("QUESTION");
String ANSWER = rs.getString("ANSWER");
String ANSWERA = rs.getString("ANSWERA");
String ANSWERB = rs.getString("ANSWERB");
String ANSWERC = rs.getString("ANSWERC");
String ANSWERD = rs.getString("ANSWERD");

outFile.write(QUESTIONNO + " " + QUESTION);
outFile.newLine();
outFile.newLine();
outFile.write("(a)" + ANSWERA);
outFile.newLine();
outFile.write("(b)" + ANSWERB);
outFile.newLine();
outFile.write("(c)" + ANSWERC);
outFile.newLine();
outFile.write("(d)" + ANSWERD);
outFile.newLine();
outFile.write("----------------------------------------------");
outFile.newLine();
outFile.close();
}
JOptionPane.showMessageDialog(null, "Questions added to text file");

}catch(Exception e)
{
JOptionPane.showMessageDialog(null, "Unspecified File IO error");
}

Hey guys, I got another problem. So right now I got my data in the database and I want to be able to save that to a text file. The problem is that whenever I try to save I'm able to get the data for one row and that's it. I need to be able to get the data from the whole table. Thanks in advance.

[Zack]

Going out on a limb here, as I haven't run the code. But I'm guessing it's because you close your output file after the end of the first loop.

[Junky]

If your loop is only executing once then there is only one row in the ResultSet. Try executing your SQL outside Java to make sure the results you get are what you are expecting.

[Junky]

Going out on a limb here, as I haven't run the code. But I'm guessing it's because you close your output file after the end of the first loop.

Good point!

@OP what exactly is happening. Is your code throwing an exception? Which I imagine it would be if the stream has been closed.

[javaguy345]

Going out on a limb here, as I haven't run the code. But I'm guessing it's because you close your output file after the end of the first loop.

Haha! You're right I figured it out like 5 minutes after posting this. Cause I closed my output file outside of the loop it wasn't saving to the text file. Thanks

[Junky]

That makes no sense. If you close the stream after the loop then it most certainly will save to the file.

[Zack]

I think he meant that he closed it inside, but MEANT to close it outside. Freudian slip. Or Freudian typo. I don't know.