JDBC Connection...

[onlysumitg]

Hello All

For a Database application should i use a single Connection/Statement object for all database operation or should i create new Connection/Statement object for each database query ?

thanks in Advance
Sumit

[RamyaSivakanth]

Hi,
You can use a method for creating the connection as well as for statement object.U can resuse it .After using ,make sure to close statement,ResultSet and connection to avoid memory leaks.
-Regards
Ramya

[onlysumitg]

thanks for your reply....

i wanna know should i call that method again and again to create Connection/Statement objects ... of should i call that once when user login and close that Connection when log off...?

[RamyaSivakanth]

Ur code flow will be like this.Connection should not be created and closed multiple times.Declare the Connection object globally open once and close once.

1. Open the Connection for ex: using openConnection() method

2. Do database operations

3. Close the connection for ex: using closeConnection() method