use PreparedStatement

[bd2019us]

Hello, Is it a good way to use PreparedStatement in line 212 and 213? Because the "executeQuery" is in a while loop and the query is compiled only once when we use "PreparedStatement" interface which can improve the performance of the application.