Java Code Optimization with JDBC Implementation

Some of the key points must be followed at the time of JDBC implementation to improve performance of code:

1. Try to have only one db connection in complete class to execute multiple queries instead getting multiple connection.

2. Cache static data of db (using custom java APIs) once at the time of initialization of class, and use this cache to fetch data whenever it is needed instead of fetching static data from DB again and again using query execution.   

3. Do the query optimization measuring with 'explain plan' in oracle.