JDBC(Java Database Connectivity) provides a standard Java API (Application Programming Interface) for accessing different database systems. JDBC provides a simple, database-independent set of APIs. Using the same APIs we can access a number of database systems in Java. Components of JDBC 1) Driver For connecting to the database we need…
Basics We will see how to execute a simple SQL SELECT query in Java using JDBC Statement. Step 1 – Load Driver Class For connecting to the database we need to have a suitable Driver class loaded. This Driver class helps us to get the Connection to the corresponding database.…
Sometimes we need to execute multiple update/insert queries on our DB. The performance of these queries can be critical for our application. We will see how we can improve performance of multiple update/insert queries on oracle. Create Index on the column/columns used in the WHERE clause for update queries. This…