Programming Tutorials Browser Tutorials Articles Struts Tutorials Hibernate Tutorials

Search: 

  Tutorial: How to Use Java and JDBC

JDBC (Java Database Connectivity) is designed to allow you to use SQL to query a wide variety of different database types.

Tutorial Details:

Just as a printer driver allows developers to write applications without concern for low-level details of specific printers, JDBC is supposed to free you from low-level concerns about particular database types. It should permit you, for example, to query an Access database with exactly the same source code as with an Oracle database.
JDBC is similar to Microsoft's ODBC (Open Database Connectivity), except that it is supposed to bring the added advantage of being platform independent.

To use either JDBC or ODBC, however, you need a database driver that they can communicate with. The driver is specific to the particular type of database you're using. Most of the JDBC drivers that I've seen are generally expensive.

On the other hand, drivers for ODBC are already available. (They come with Windows NT and '95.) Since JDBC and ODBC are very similar, a set of routines were written to translate JDBC commands to ODBC, thus allowing JDBC to use ODBC drivers. These routines are called the JDBC-ODBC bridge.This bridge is free, and comes with versions of the JDK past 1.1.It is also available for JDK 1.0 users from http://splash.javasoft.com/jdbc.

To access an MS Access database from Java, you need the JDBC classes, including the JDBC-ODBC bridge, and the Microsoft Desktop Database Drivers, which come with Windows NT and 98.They are on the install disks for these systems, but aren't necessarily part of a typical install.My home machine uses 98 and had them preinstalled.When I've installed NT 4.0,they were not preinstalled, so I had to get out the install disks.)


 

Read Tutorial at: Click here to view the tutorial

Rate Tutorial:
How to Use Java and JDBC

View Tutorial:
How to Use Java and JDBC

Related Tutorials:

Displaying 1 - 50 of about 4200 Related Tutorials.

JDBC Components
of programming data from the Java. To use this, applications can execute SQL... of the Java platform, it includes the Java Standard Edition. 2. JDBC Driver... can connect Java applications to a JDBC driver. DriverManager is the very
 
JDBC, JDBC Tutorial, JDBC Tutorials
This example shows you how to use JDBC's rich data type BLOB. The BLOB type... JDBC - Java Database Connectivity Tutorials JDBC... technology. What is JDBC?   JDBC is Java application
 
JDBC Versions
JDBC Driver and Its Types JDBC Versions...; 1). The JDBC 1.0 API. 2). The JDBC 1.2 API. 3). The JDBC 2.0 Optional Package API. 4). The JDBC 2.1
 
How to use this keyword in java
This Keyword,Java This Keyword,Java 'This' Keyword,This Keyword Example in Java How to use "this" keyword in java... of the program for the illustration of how to what is this keyword and how to use
 
JDBC - Java Database Connectivity Tutorial
This example shows you how to use JDBC's rich data type BLOB. The BLOB type... JDBC - Java Database Connectivity Tutorials JDBC... technology. What is JDBC?   JDBC is Java application
 
JDBC Driver and Its Types
DriverManager class defines objects which can connect Java applications to a JDBC... the Java interfaces and classes that programmers use to connect to databases... for a particular DBMS vendor. A Java program that uses the JDBC API loads
 
First Step towards JDBC!
JDBC - Java Database Connectivity Tutorials JDBC - Java Database Connectivity Tutorials     .... What is JDBC?   JDBC is Java application programming
 
First Step towards JDBC!
are used. In the later sections we will show you how to use JDBC from your... JDBC Tutorial- JDBC Example, Java Database Connectivity Example... This article introduce you with JDBC and shows you how to create
 
Difference between JDBC 3.0 & JDBC 4.0
JDBC 4 is a major new release with a strong focus  ease-of-use... ease-of-development features in JDBC 4 In addition to ease-of-use, JDBC 4... Difference between JDBC 3.0 & JDBC 4.0
 
Introduction to the JDBC
This article introduce you with JDBC and shows you how to our search engine with database.  What is JDBC? Java Database Connectivity or JDBC for short is set of Java API's
 
What is JDBC?
; JDBC is Java application programming interface that allows the Java programmers... Connectivity in short called as JDBC. It is a java API which enables the java... that defines how a java programmer can access the   database in tabular
 
How to use KeyListener
Keylistener Java,How to use KeyListener,Java Keylistener Example How to use KeyListener     ...; Introduction  In this section, you will learn how to handle different key events
 
How to use foreach loop in velocity
How to use foreach loop in velocity How to use...;      This Example shows you how to use foreach...;#foreach($item in $list): This works like for loop in java but it has some enhanced
 
How to use 'for' loop in jsp page?
How to use 'for' loop in jsp page? How to use...;      This is detailed java code that shows how to use 'for' loop in jsp page. 'if' statement is used to test conditions
 
Features of JDBC 4.0
-of-development features in JDBC 4 In addition to ease-of-use, JDBC 4 introduces... Features of JDBC 4.0 Features of JDBC 4.0  ...;            JDBC 4
 
How to Use Java Functions In EL
How to Use Java Functions In EL How to Use Java...;       To use a Java Functions in  EL we need three things. The java class with a static method. A Tag
 
How to use 'continue' keyword in jsp page ?
java code that shows how to use 'continue' keyword in jsp page. The continue... How to use 'continue' keyword in jsp page ? How to use.... In this example, we have developed use_continue_statement.jsp page which shows the use
 
JDBC (Java Database Connectivity) -Tutorials
JDBC Tutorials, Java Database Connectivity Tutoria JDBC (Java Database Connectivity) -Tutorials    ... to JDBC Java started as an elegant and promising Web
 
How to create and use custom error page in jsp
java code how to create and use custom error page in jsp and display an error... How to create and use custom error page in jsp How to create and use custom error page in jsp    
 
How to use email validation check through java script in jsp page
How to use email validation check through java script in jsp page How to use email validation check through java script in jsp page...;   This is detailed java code that explains how to use java
 
JDBC Prepared Statement Insert
JDBC Prepared Statement Insert JDBC Prepared...;    The Tutorial illustrates a program in JDBC Prepared... to communicate between front end application in java and database in backend.2
 
JDBC vs ORM
into persistence storage for future reference. What is JDBC? JDBC stands for Java Database... JDBC vs ORM JDBC vs ORM...; In this section we will examine the differences and similarities between JDBC
 
Accessing Database from servlets through JDBC!
Accessing Database from servlets through JDBC... how to access database from servlets. Here I am assuming that you are using win95/98/2000 and running Java Web Server
 
Connecting to the Database Using JDBC and Pure Java driver
Connecting to the Database Using JDBC and Pure Java driver...() tells the Driver Manager to use MM.MySQL JDBC Driver. To obtain...; JDBC Driver
 
JDBC Example with MySQL
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... the JDBC driver, you will learn how we can create our database.   
 
Understanding the JDBC Architecture
relational databases. JDBC is a core part of the Java platform and is included.... In this driver the java statements are converted to a jdbc statements. JDBC... applications. (See Figure 2.) Type 1 JDBC Architecture Type 2 Java
 
How to use multiple declaration in jsp
How to use multiple declaration in jsp How to use...;      In the jsp code given below, you will learn how... numbers. Before running this java code create a new directory named "
 
Accessing Database from servlets through JDBC!
Installing Servlets,How to Download and Install Java Servlet,Help to Install Java Servlet Java Servlets - Downloading... of web server supports java servlets. In this article we will use Java Web
 
How to use List in velocity
How to use List in velocity How to use List in velocity           ...;   This Example shows you how to use List in velocity
 
How to use Map in velocity
How to use Map in velocity How to use Map in velocity           ...;   This Example shows you how to use map in velocity
 
What is the use of java?
What is the use of java? What is the use of java?          ... libraries such as the Java IDL API, JDBC API, Java Naming and Directory
 
How to add a column in a table
Adding New Column Servlet,How to Add New Column in Table Using Java Servlets - Online Servlet Tutorial How to add a column... it is the work of the database administrator but as a Java programmer you should
 
Product Components of JDBC
JDBC application programmming interface is a  part of the Java...; Enterprise Edition (Java EE) in itself. The JDBC API has four main interface... and Java EE platforms are included in both the packages. 2. The JDBC Driver
 
Comparing two Dates in Java with the use of before method
of comparing dates you have seen how to use after() method in java class for comparing... Comparing two Dates in Java with the use of before method, before method in java, before method Comparing two Dates in Java
 
Jdbc-Odbc Connection
in  JDBC into ODBC. For ODBC,it is a normal java application program... in explaining JDBC Odbc Connection in Java. The code include a class... Jdbc-Odbc Connection Jdbc-Odbc Connection
 
How to Java Program
How to Java Program How to Java Program... how to learn Java and become a master of the Java technologies. Java is a high...;  If you are beginner in java , want to learn and make career
 
Use of name() function in XPath
;      In the previous section of XPath in Java tutorial we have studied about how to use count() function in  XPath query... Use of name() function in XPath Use of name
 
How to use dollar sign in velocity
How to use dollar sign in velocity. How to use dollar sign in velocity       ...;       This Example shows you how
 
JDBC Connectivity Code In Java
Jdbc Connectivity Code In Java JDBC Connectivity Code In Java           ... in understanding JDBC Connectivity Code in Java. The code include a class JDBC
 
Database Engines
Java NotesDatabase Engines To use a database system from Java use the JDBC...), Java programs can use databases written in any language, so... to use Hibernate (see below). References Open Source Database Engines in Java
 
JDBC Fetch
JDBC Fetch JDBC Fetch     ... to describe you an example from Jdbc Fetch. The code illustrates a class Jdbc Fetch... you in communicating between the front end Java application and the backend.2
 
Jdbc batch
;         JDBC is simply a Java... Jdbc batch Jdbc batch     ... to interact your Java Application in your front end with the backend. The backend can
 
Update Database Table using JDBC in JSP
Update Database Table using JDBC in JSP Update Database Table using JDBC in JSP     ...;         This example shows how
 
Use of count() function in XPath
;      In the previous section of XPath in Java tutorial we have studied about how to run XPath query in java... Use of count() function in XPath Use of count
 
Jdbc connection
Jdbc connection Jdbc connection   ... we want to describe you a code that helps you in understanding a Jdbc Connection. The code include a class Jdbc Connection, Inside the main method, the list
 
Prepared Statement Set Object
the PreparedStatement and how to use with setObject method.  PreparedStatement... PreparedStatementSetObject.java C:\vinod\jdbc\jdbc\PreparedStatement>java... JDBC SetObject,Prepared Statement Example,Prepared Statement Set Object
 
Jdbc access database
;            JDBC is a Java Database Connectivity. The JDBC Connectivity provides API classes... Jdbc access database Jdbc access database
 
JDBC Functions
JDBC Functions JDBC Functions   ... want to describe you a code that helps you easy to understand Jdbc Functions. The code include a class Jdbc Functions, Inside the main method, the list
 
First Step towards JDBC
First Step towards JDBC! window.location="introduction.shtml"; We have moved to another page click here to go
 
Jdbc ConnectionUrl
Jdbc ConnectionUrl Jdbc ConnectionUrl  ...; In this Tutorial we want to describe you a code that helps you to understand Jdbc... is loaded ,you can connect  the Java front end application to the backend database
 
Site navigation
 

 

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2006. All rights reserved.