Java Database connectivity ( JDBC ) released 📢in 1997 an is developed🧑💻 by oracle . We 👨👩👦👦can use JDBC for any platform🚉. It works with non-relational and relational databases🗃️. Code is easy 💡to understand. The JDBC API 💡 is a java API that can access💡 any kind of tabular📏 data, especially data is stored📏 in a relational database. JDBC helps⛑️ you to write java application. Java API is to connect🔌 and execute 🧨the query with the database. It is a specification from sun microsystems . That manage 3 programming activites🚩. That's are :
1) Connect to data source🗄️
2) Send queries🗄️
3) Update statements to the database🆕
There are 4 main components:
o JDBC API🔗
o JDBC test suit👔
o JDBC Driver Manager💼
o JDBC ODBC bridge driver🌉
JDBC API
Jdbc API provides universal 👽data access from the java programming language. Using the jdbc api you can access 🔓virtually any data source from relational database to spreadsheets📊, JDBC API provides 2 packages📦:
Java.sql
Javax.sql
JDBC test suite🧥
The JDBC test 📝suite helps you to determine that JDBC drivers will run🏃 your program. These test are not comprehensive or exhaustive💨, but they do exercise🏋 many of the important features ✨in the JDBC API.
JDBC Driver Manager
Driver 🚗manage class in the java.sql package and it extends object 🧊class. The major purpose of the driver manager is to provide the basic📌 service to manage the set🥪 of drivers that are available to use in the application 🖥.Driver manager is the responsible ⚗️for maintaining the single instance🟡 of each registered✍🏼 driver. Driver manager eliminates❌ having multiple instances of the same👭 driver.
JDBC ODBC bridge driver🌉
The JDBC ODBC bridge🌉 allow application written📝 in the java 📝programming language to use the JDBC API with many existing🖇️ ODBC drivers. The bridge is itself a driver based on JDBC technology🤖.
Top comments (0)