What is JDBC ?

Introduction

JDBC stands for Java Database Connectivity. It is a Java API that defines how a Java program can connect and execute queries with a database. It is a part of the Java Standard Edition platform, from Oracle Corporation. JDBC API uses JDBC drivers to communicate with different types of databases. There are four types of JDBC drivers:

  • JDBC-ODBC Bridge Driver,
  • JDBC Native Driver,
  • JDBC Network Protocol Driver, and
  • JDBC Thin Driver

The most commonly used type is the Thin Driver, which is database-specific and platform-independent

The Statement interface is used to create SQL basic statements in Java it provides methods to execute queries with the database. There are different types of statements.

  • Statement
  • Prepared Statement
  • Callable Statement

For more details please read our next session.....

Comments

Post a Comment

Popular Topics

What is JSP. How to create one JSP application in Eclipse

Image
  JSP - Java Server Pages Technology   Java Server Pages (JSP) technology allows you to easily create web content that has both static and dynamic components. JSP technology makes available all the dynamic capabilities of Java Servlet technology but provides a more natural approach to creating static content. The main features of JSP technology are as follows: ·          A language for developing JSP pages, which are text-based documents that describe how to process a request and construct a response ·          An expression language for accessing server-side objects ·          Mechanisms for defining extensions to the JSP language JSP technology also contains an API that is used by developers of web containers. Using this technology developer can design UI for client (browser) as well as business logic for communicating server. A JSP file conta...
Read more

How to develop a RESTful webservice in java ?

Image
  How to create my first RESTful web service project in Eclipse ? 1)       To Create a web service project, open File menu à New à Dynamic Web Project 2)        2)        Type the name for your project as “MyFirstRESTful” and select dynamic web module version as 2.5 à Next à 3)        3)        Tick mark on “Generate web.xml deployment descriptor” à Finish   4)       4)     Expand your project and right click on webcontent folder à New  à   select JSP File option  à   Type the file name as  index.jsp   5)         5) Open index.jsp and type below code. index.jsp <%@ page language = "java" contentType = "text/html; charset=ISO-8859-1" pageEncoding = "ISO-8859-1" %> <! DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitiona...
Read more

Data Types in PL/SQL

  PL/SQL - Data Types In this chapter, we will discuss the Data Types in PL/SQL. The PL/SQL variables, constants and parameters must have a valid data type, which specifies a storage format, constraints, and a valid range of values. We will focus on the  SCALAR  and the  LOB  data types in this chapter. The other two data types will be covered in other chapters.   S.No Category & Description 1 Scalar Single values with no internal components, such as a  NUMBER, DATE,  or  BOOLEAN . 2 Large Object (LOB) Pointers to large objects that are stored separately from other data items, such as text, graphic images, video clips, and sound waveforms. 3 Composite Data items that have internal components that can be accessed individually. For example, collections and records. 4 Reference Pointers to other data items. ...
Read more

What is Hibernate in java ?

Image
Introduction to hibernate  Hibernate ORM is an object–relational mapping tool for the Java programming language. It provides a framework for mapping an object-oriented domain model to a relational database. Hibernate is a Java framework used for the development of Java application to interact with the database. It is an open source, lightweight, Object Relational Mapping tool. Hibernate implements the specifications of JPA (Java Persistence API) for data persistence.  Java Hibernate is an object-relational mapping tool allowing the mapping of object-oriented models to relational databases for  web applications  by providing a framework. Mapping of entities in a Java class to tables created in a database and mapping from Java data types to  SQL data types  is one of the primary functions of Hibernate. You can also retrieve data using Hibernate. It is the alternate for developer from manually handling the database using JDBC. Hibernate is an open-source objec...
Read more

If you have any query or suggestions, Please feel free to write us

Name

Email *

Message *