Introduction to JDBC

567 views
optmiize_your_resume_1

What is JDBC?

  • JDBC stands for Java DataBase Connectivity.
  • The way every Java application connects to a database is through the JDBC API.
  • The JDBC API defines interface and classes for writing database application in Java by making database connections.

Data

  • Any information is data, Here data can be raw or processed.
  • Application data refers to a set of information that comes in the scope of the application.

Database

  • Program is to process data.
    1. From where this data comes from?
    2. Where processed data has to go?
  • Application is designed to simulate some system.
  • The system can be anything like a shopping mall, university, production house, office, etc.
  • System requires to preserve data, Likewise
    1. In offices, employee attendance records
    2. In hostels, History bookings
    3. In banks, Transaction details of financial year.
  • Database is a set of files containing application data.
  • This data needs to be inserted, deleted, updated, extracted for a valid reason.
    • You can write programs to perform all such actions.
    • Or you can use readymade database management software like Oracle or MySQL.

JDBC library

It includes APIs for each of the tasks mentioned below that are commonly associated with database usage.

  • Making a connection to a database.
  • Creating SQL or MySQL statements.
  • Executing SQL or MySQL queries in the database.
  • Viewing & Modifying the resulting records.

Applications of JDBC

JDBC is a specification that provides a complete set of interfaces that allows for portable access to an underlying database. Java can be used to write different types of executables, such as −

  • Java Applications
  • Java Applets
  • Java Servlets
  • Java ServerPages (JSPs)
  • Enterprise JavaBeans (EJBs).

20%off for Ink 280 281

You may also like

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More