Home | Add to Favorites | Ebooks Directory | News  
Java Programming
Home
Java  Article
Java Tutorial 
Java download
Books
JDBC
Java Training
Java Source  Code
Java Applet
Java Questions
Welcome to JDBC Page

JDBC ( Java Databse Connectivity) provides a database Programming API for Java Programs

Features:

             Contains set of classes and interfaces that are used to connect to a database, submit


 

SQL Queries and retrieve the result.

JDBC Driver Manager.

    The JDBC driver manager is the important one of JDBC Architecture. The function is to maintain

a list of drivers created for different databases.

The java.sql package contains classes that help in connecting to a database.

Important Explanation:

Statement                  ==This Object allows the execution of simple Queries

PreparedStatement == It allows the execution of parameterized queries.

setXXX()                     ==Sets the Value of a PreparedStatment

ResultSet                  == It Provides methods to access data from a table.

executeQuery           ==This Method executes a simple select query and returns ResultSet Object

executeUpdata        == This Method executes and SQL Insert, Update and Delete Statements.

Sample Programs for JDBC Connectivity.

1.Connnecting to Postgres

2.Connnecting to Oracle