Introduction to JDBC

Click to rate this post!
[Total: 0 Average: 0]

JDBC API is nothing but a java API (Application Programming Interface) it can able to access a tabular data and stored a data in relational database. Generally an API is in the form of interfaces and collection of classes. It is used for developing java program which can communicate with data base server

An API is classified in to two types

  • Public API: An API is released by an organization and implementation of that API is given by any organization.
  •  Proprietary API: It is based on that organization which is released and implementation           process through that organization only.

Introduction to JDBC

The java application connectivity to data source and source to JDBC API and finally stored in database like My SQL, Oracle, ODBC etc. During application development if we are changing the data base from oracle to My SQL. We cannot use OCI call the function and instead.

JAVA Tutorial Video

 

What is JDBC?

JDBC is a standard API used for developing java program which can communicate with a data base server.  An application is said to be business or enterprise if it is computerizing day to day activities of an organization. The business applications are the enterprise application will be generating huge amount of data.

  • File systems
  • Data base server

To overcome the drawbacks of the file systems then we use data base server for storing the data. The data base server software will be installed every developer as per part of oracle data base we are provided with client program called SQL Plus which we can communicate with data base server.

 JDBC Components:

  • Driver Manager: In a java application with better data base server using as communication protocol. A class can manage a drivers which Matches connection requests. The driver will able to catch the sub protocol under JDBC will be used a database Connection.
  • Driver: The communications with a database server is with an interface You will interrelate openly with a Driver objects very infrequently with put using of Driver Manager objects, which manages objects, It hides the details related  with Driver objects.
  • Statement: Objects can be used produced from this interface to put forward the        SQL statements to a database and Some resultant interfaces receive parameters in addition to execute a stored procedures.
  • Result Set: In this result set objects are hold a data to retrieve from database after execute an SQL query using Statement objects then it acts as an iterator to move its data.
  • SQL Exception: It handles an error which occurs in a database applications.

Get more Tutorials from onlineitguru trainers after completion of java online training

Subscribe
to our newsletter

Drop Us A Query

Trending Courses
  • Microsoft Azure Architect Technologies(AZ-300) | ITGuru
    Microsoft Azure Architect Technologies(AZ-300)
  • Azure is a great Microsoft Cloud Computing platform in providing various cloud services through online. ITGuru Certified Azure Architect certification course gives you the practical knowledge on Azure Cloud platform through real-world use cases from live experts

  • ServiceNow Admin Training | ITGuru
    ServiceNow Admin Training
  • Getting knowledge of cloud platforms like ServiceNow is essential in today’s world for the smooth running of projects in cloud platform. Turn your dream to the reality of becoming the Certified ServiceNow Administrator through ServiceNow Administration online certification Course with practical examples by live industry experts through online at ITGuru with real-world use cases.

  • Workday Financials Training | ITGuru
    Workday Financials Training
  • knowing the basics on any platform like Workday is not enough to sustain the IT industry. Hence it is essential to go beyond on Workday basics like Workday Financials training which lets you know the application of Financials management in real -world use cases from ITGuru Live Experts in a practical way.

  • Workday Training
  • An organization is considered as the best one when it offers the best benefits to the employee. Moreover, the greater the employee benefits, the greater the contribution to the organization. ITGuru let you know the practical workday Human Resource Management(HRM) features with live examples by experts

  • Python Online Course | ITGuru
    Python Online Course
  • Turn your dream into reality by ITGuru live experts with real-world use cases through practical knowledge on python online course and become the certified associate in python programming and become a master in python programming

  • Python Programming | ITGuru
    Python Programming
  • Python is the trending programming language in the IT industry. Mastering in python programming gives you more value among the people in the IT industry. Hence start today to learn python programming online by live experts with real-time uses cases at ITGuru


100% Secure Payments. All major credit & debit cards accepted.

Call Now Button