JDBC Interview Questions
A list of frequently asked jdbc interview questions with answers are given below.
Java JDBC Tutorial
Java JDBC is a java API to connect and execute query with the database. JDBC API uses jdbc drivers to connect with the database.
Why use JDBC
Before JDBC, ODBC API was the database API to connect and execute query with the database. But, ODBC API uses ODBC driver which is written in C language (i.e. platform dependent and unsecured). That is why Java has defined its own API (JDBC API) that uses JDBC drivers (written in Java language).
What is API
API (Application programming interface) is a document that contains description of all the features of a product or software. It represents classes and interfaces that software programs can follow to communicate with each other. An API can be created for applications, libraries, operating systems, etc
Topics in Java JDBC Tutorial
2) JDBC DriversIn this JDBC tutorial, we will learn 4 types of JDBC drivers, their advantages and disadvantages.3) 5 Steps to connect to the databaseIn this JDBC tutorial, we will see the 5 steps to connect to the database in java using JDBC.
4) Connectivity with Oracle using JDBCIn this JDBC tutorial, we will connect a simple java program with the oracle database.
5) Connectivity with MySQL using JDBCIn this JDBC tutorial, we will connect a simple java program with the mysql database.
6) Connectivity with Access without DSNLet's connect java application with access database with and without DSN.
7) DriverManager classIn this JDBC tutorial, we will learn what does the DriverManager class and what are its methods.
8) Connection interfaceIn this JDBC tutorial, we will learn what is Connection interface and what are its methods.
9) Statement interfaceIn this JDBC tutorial, we will learn what is Statement interface and what are its methods.
10) ResultSet interfaceIn this JDBC tutorial, we will learn what is ResultSet interface and what are its methods. Moreover, we will learn how we can make the ResultSet scrollable.
11) PreparedStatement InterfaceIn this JDBC tutorial, we will learn what is benefit of PreparedStatement over Statement interface. We will see examples to insert, update or delete records using the PreparedStatement interface.
12) ResultSetMetaData interfaceIn this JDBC tutorial, we will learn how we can get the metadata of a table.
13) DatabaseMetaData interfaceIn this JDBC tutorial, we will learn how we can get the metadata of a database.
14) Storing image in OracleLet's learn how to store image in the oracle database using JDBC.
15) Retrieving image from OracleLet's see the simple example to retrieve image from the oracle database using JDBC.
16) Storing file in OracleLet's see the simple example to store file in the oracle database using JDBC.
17) Retrieving file from OracleLet's see the simple example to retrieve file from the oracle database using JDBC.
18) CallableStatementLet's see the code to call stored procedures and functions using CallableStatement.
19) Transaction Management using JDBCLet's see the simple example to use transaction management using JDBC.
20) Batch Statement using JDBCLet's see the code to execute batch of queries.
21) JDBC RowSetLet's see the working of new JDBC RowSet interface.
0 comments:
Post a Comment