JDBC / Java Database Connectivity for Not Yet Techies

"Computer Careers: Making Sure Java Applications Can Use Databases"

by Richard Stooker, President Info Ring Press and author of Secrets of Changing to a Computer Career

JDBC / Java Database Connectivity is a class library or API (Application Programming Interface) for enabled Java software programs to access nearly all databases. JDBC / Java Database Connectivity is especially for relational databases but can access flat files, spreadsheets (if you think about, spreadsheets are a form of database.) and indeed any form of tabular data source.

Client/server applications written in Java use SQL (Structured Query Language) to request information or send information to the database. SQL is the industry standard language or protocol for this. A request for information to a database is a query.

JDBC / Java Database Connectivity also supports many proprietary query standards. It is contained in the java.sql and javax.sql packages.

The Driver Manager in JDBC / Java Database Connectivity tracks the drives needed to access different types of databases

There's a driver for each particular database. It is based on the X/Open SQL Call Level Interface and supports both 2-tier and 3-tier access models.

When accessing a database over the Internet, it uses a file name that conforms to the Internet addressing system and so looks like a web site url.

JDBC / Java Database Connectivity defines a set of object oriented classes for building SQL requests and a second set of classes defines the JDBC driver API.

Next: JMX Java Management Extensions

Use Your New Computer Career as a Stepping Stone to Even Greater Success

Send off for your free 7-part Techie Plus eCourse now. So that you can learn:

The 7 most important skills to even greater business achievement -- not to mention wealth and (maybe) fame
Why techies are expendable in bad times and how to protect yourself from them
Why the world's richest computer programmer has not written any code in ages
How one ex-engineer now makes $500,000 a year
The abilities most techies don't even realize they don't have -- which confines their success to their technical abilities
Why techies are expendable in bad times and how to protect yourself from them

It's fast and easy. You will receive the first part in your email box within minutes.

I respect your privacy. I will never sell, rent or trade your email address.

After you subscribe, the form will redirect you to a thank you page.

Thank you!

Rick Stooker

Permission is granted to reprint the above article in an ezine or on a website as long as it is reprinted in full, with no changes, with full credit and with this contact information and link included at the bottom. All other rights reserved.

Computer Careers (Home) Sitemap Contact Privacy

Info Ring Press

Richard Stooker

PO Box 617

130-G Ballwin Manor Dr

Ballwin, MO 63011

(636) 394-2052

rick@inforingpress.com