First Step towards JDBC!

Advertisement

First Step towards JDBC!
Welcome to our JDBC Section
First Step towards JDBC
This article introduce you with JDBC and shows you how to create a database application to access the databases.
Accessing the Database from Servlet
This article shows

JDBC - Java Database Connectivity Tutorials

Java Database Connectivity or in short JDBC is a
technology that enables the java program to manipulate data stored into the
database. Here is the complete tutorial on JDBC technology.

What
is JDBC?
JDBC is Java application programming interface that allows the Java
programmers to access database management system from Java code. It was
developed by JavaSoft, a subsidiary of Sun Microsystems.

Product
Components of JDBC
JDBC is consists of four Components: The JDBC API, JDBC Driver Manager, The
JDBC Test Suite and JDBC-ODBC Bridge.

Understanding
JDBC Architecture
JDBC is an API specification developed by Sun Microsystems that defines a
uniform interface for accessing various relational databases. JDBC is a core
part of the Java platform and is included in the standard JDK distribution.

JDBC
Driver and Its Types
The JDBC DriverManager class defines objects which can connect Java
applications to a JDBC driver. DriverManager has traditionally been the
backbone of the JDBC architecture. It is quite small and simple.

JDBC
MySQL Tutorial
JDBC Tutorials with MySQL Database. MySQL is one of the widely used database
in the world.

Connecting
to a MySQL Database in Java
In this section, you will learn how to connect the MySQL database
with Java file. We need to establish a connection between MySQL and Java
files so that we can use MySQL driver for MySQL.

Creating
a Database Table
Here, providing you an example with code and it's description that helps you
to create a database table in a database through the java file.

Deleting
a Table from Database
This section describes how to delete a table from database. Java provide the
facility for deleting a specific table from a given database with the help
of some specified methods.

Retrieving
Tables from a Database
This section provides you a facility for retrieving tables from a specific
database through an example. You have to know about a database that is a
collection of data or information.

Inserting
values in MySQL database tableHere we are going to see, how we can insert values in the MySQL
database table. We know that tables store data in rows and column format.
After creating a database table, you insert the values in it.

Retrieving
All Rows from a Database Table
Here, you will learn how to retrieve all rows from a database table. You
know that table contains or stores the data in rows and columns format. If
you want to access the data from a table then you need to use some APIs
and methods.

Getting
Column Names from a database table in JavaHere, providing you an example with code that retrieves all columns name
in a specific database table. Sometimes, you need to know the number of
columns and the names of the columns of the table then you can retrieve it
with the help of this example.

Deleting
All Rows from a Database TableConsider a case where we have been given one database table, now we have
to delete all the rows from the table. This section describes for deleting
all rows from a specific database table.

Delete
a Specific Row from a Database TableConsider a case where we are creating a table and we have add some data
in it. It may happen that we might add a wrong data in a row, now we need to
delete that particular data. This can be done very easily , and in this
section we are going to do the same that is, how to delete a specific row
from a specific database table.

Join
tables in the specific databaseIn this section, we are going to consider how to join two or more tables
in a specific database. For this you need to have two or more table in the
database. If two or more tables are available in the database then Join
operation is performed otherwise not.

Join
tables with the NATURAL LEFT JOIN operationThis section describes the NATURAL LEFT JOIN operation and
how to retrieve data through it. In this operation we are going to retrieve
data according to match the field name of another tables.

Join
tables with the NATURAL RIGHT JOIN operationThis section describes the NATURAL RIGHT JOIN operation of
table in a specific database. This operation join tables on the basis of
matching fields but priority will be given to the right table field values.

Cross
Join Tables in a Specific DatabaseThis section introduces you to the cross join between two
tables. The cross join operation retrieves data between two tables as a Cartesian
product of set theory in mathematics. All data show to multiply by each
rows.

JDBC (Java Database Connectivity) -Tutorials
JDBC is essentially an Application Programming Interface (API) for executing SQL statements, and extracting the results. Using this API, we can write database clients, such as Java applets, servlets and Enterprise
JavaBeans, that connect to a relational database, such as Oracle, MySQL, Sybase, Informix,
Ingres, PostgreSQL, or any other database that implements this API, execute SQL statements, and process the results extracted from the database.

First
Step towards JDBC
This article introduce you with JDBC and shows you
how to create a database application to access the databases.

Accessing
the Database from Servlet
This article
shows you how to access database from servlets. Here I am assuming
that you are using win95/98/2000 and running Java Web Server.