<div>
PreparedStatement can only execute the query it was created for (q1), so how do you want to use the same stmt for another query (q1) ?
</div>


PreparedStatement can only execute the query it was created for (q1), so how do you want to use the same stmt for another query (q1) ?

<div>
errata --&gt; another query (q2)
</div>


<div>
<div class="content wysiwyg-content">
If I use the same statement object and resultset object with more that one query like below<br />
stmt = conn.prepareStatement(q1);<wbr /><br />
rs = stmt.executeQuery();<br />
while(rs.next){<br />
.....<br />
.......<br />
}<br />
...<br />
.....<br />
.......//do I have to close the resultSet and the statement Objects before using them again.<br />
stmt = conn.prepareStatement(q2)<br />
rs=stmt.executeQuery()<br />
.....<br />
......<br />
.......//close the same again in the same program?<br />
<br />
My Question is if I want to use the same statement object and resultSet for more than one Query in the same program, do I have to close each time before using them again. If so, do I have to close the following each and every time in the program <br />
1. ResultSet<br />
2. Statement Object<br />
3. Connection object<br />

</div>
</div>


If I use the same statement object and resultset object with more that one query like below
stmt = conn.prepareStatement(q1);
rs = stmt.executeQuery();
while(rs.next){
.....
.......
}
...
.....
.......//do I have to close the resultSet and the statement Objects before using them again.
stmt = conn.prepareStatement(q2)
rs=stmt.executeQuery()
.....
......
.......//close the same again in the same program?

My Question is if I want to use the same statement object and resultSet for more than one Query in the same program, do I have to close each time before using them again. If so, do I have to close the following each and every time in the program 
1. ResultSet
2. Statement Object
3. Connection object


JDBC related question

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.