UDEMY 2021 - Java Database Connectivity (JDBC) Masterclass
- 1. UDEMY 2021 - Build a real world responsive website with Html 5 css 3 & JS
- 2. UDEMY 2021 - iOS 11 & Swift 4 – The Complete iOS App Development Bootcamp
- 4. UDEMY 2021 - Learn Bootstrap Web Development From Scratch
Get in to the domain of advanced java. Get a good knowledge of Java Database Connectivity (JDBC).
What you’ll learn
JDBC is used to provide Java programmers with a simple, uniform interface to a wide range of relational databases.
It is used to provide database independence. It can replace the hidden database with minimal code impact. JDBC gives a common base on which higher level tools and interfaces can be built.
The Java Database Connectivity API can access any kind of tabular data, mainly data stored in a Relational Database.
Java Database Connectivity (JDBC) works with Java on various platforms, such as Windows, Mac OS, and the various versions of UNIX.
JDBC provides a complete set of interfaces that allows for portable access to a basic database.
JDBC provides the same efficiency as ODBC which allowing Java programs to contain database independent code.
The JDBC library consists of APIs for each of the tasks commonly associated with database usage:
Making or creating a connection to a database
Creating SQL or MySQL statements
Executing that SQL or MySQL queries in the database
Viewing & Modifying the resulting records
Java Database Connectivity (JDBC) Architecture:-
The JDBC API supports two processing models namely two-tier and three-tier for database access. But in general, JDBC Architecture consists of two layers:
i) JDBC API: This provides the application to JDBC Manager Connection.
ii) JDBC Driver API: This supports the JDBC Manager to Driver Connection.
The JDBC API use a driver manager and database specific drivers to give transparent connectivity to heterogeneous databases.
The JDBC driver manager assures that the correct driver is used to access each and every data source.
The driver manager is proficient in supporting multiple concurrent drivers connected to multiple different databases.
Java Database Connectivity (JDBC) drivers are of 4 types-
1) JDBC-ODBC bridge driver
2) Native-API driver or partially-java driver
3) Network protocol driver or fully-java driver
4) Thin driver or fully-java driver
Why is JDBC Training required?
Java Database Connectivity (JDBC) is a Java API which is used to connect and execute a query to the database. It uses JDBC drivers to connect to the database.
We know that before JDBC, ODBC API was used to connect and execute a query to the database. But ODBC API uses ODBC driver which is written in C language that is platform dependent and unsecured. That is why Sun Microsystem has defined its own API (JDBC API) which uses JDBC driver written in Java language.
JDBC grants multiple implementations to exist and is used by the same application. The API gives a mechanism for dynamically loading the correct Java packages and registering them with the JDBC Driver Manager.
For creating JDBC connections, the Driver Manager is used as a connection factory.
JDBC connections support to create and execute statements.
Also, it(JDBC) allows a Java Program to issue SQL statement and process the results.
Who is the target audience?
Created by EDU CBALast updated 10/2018EnglishEnglish [Auto-generated]
Size: 10.14 GB