I am trying to create a loop where a user enters a number. The number being entered is supposed to execute a database query and then the user is able to enter another number and execute another query until the number 0 is entered. I am having trouble since I have an error saying ResultSet cannot be resolved and resultset cannot be resolved to a variable. Is anyone able to help me figure out what is causing this to happen? I am not sure what the problem is.
https://pastebin.com/PurybXUJ