i'm new in databaseprogramming. I have a question about pulling things from a database.
for example i've got a few textfields wich i fill with data from a database through a resultset.
I also have a combobox where i want to pul data from another table in the database.
Do i have to make seperated statements and resultsets?? or can i use one statement and one resultset with different query''s
How can you have one ResultSet from different queries? A query will generate a ResultSet, and so I'm confused by your statement.
Statement stmt = con.createStatement()
Originally Posted by curmudgeon
Resultset rs = stmt.executeQuery("Select * from tblXXX")
Must the Statement stmt for a different query also separated declared?
I believe that you can use the same Statement, I think as long as you don't close it or the connection. What happens if you try this?
Originally Posted by takamine