Is it possible to leave jdbc connection open till the app closes?

Question

I want to send SQL queries from various parts of the app.

Can I just create each statements separately for all methods using single open connection?

Should I need to close after each query. And open again.

Answer 1

//You can close after finishing all query

Answer 2

you should close each connection after completing the query becz if you dont close op than you waste
Your clinet memory and unsually your app size will be increaed.

Answer 3

But, l need to use different queries for different event handlers.
I can't call all of them at once

Answer 4

Okay thanks!