jdbc - CNT 4714: Enterprise Computing Spring 2011...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
CNT 4714: JDBC Page 1 Dr. Mark Llewellyn © CNT 4714: Enterprise Computing Spring 2011 Introduction To JDBC Department of Electrical Engineering and Computer Science University of Central Florida Instructor : Dr. Mark Llewellyn markl@cs.ucf.edu HEC 236, 4078-823-2790 http://www.cs.ucf.edu/courses/cnt4714/spr2011
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
CNT 4714: JDBC Page 2 Dr. Mark Llewellyn © Introduction to JDBC JDBC was originally an acronym for Java Data Base Connectivity. Sun marketing now states this is no longer an acronym but the official name. JDBC is made up of about two dozen Java classes in the package java.sql . These classes provide access to relational data stored in a database or other table-oriented forms (like Excel, etc.). JDBC allows the programmer to use modern database features such as simultaneous connections to several databases, transaction management, precompiled statements with bind variables, calls to stored procedures, and access to metadata in the database dictionary. JDBC supports both static and dynamic SQL statements. The evolution of JDBC is shown on the next slide.
Background image of page 2
CNT 4714: JDBC Page 3 Dr. Mark Llewellyn © Evolution of JDBC JDBC Version Bundled with Package Name Contents JDBC 1.0 (previously called 1.2) JDK 1.1 java.sql Basic Java client to database connectivity. JDBC 2.0 core API JDK 1.2 and later java.sql Added features such as scrollable result sets, batch updates, new data types for SQL-3, and programmable updates using the result set. JDBC 2.0 optional API J2EE and later javax.sql Can be downloaded from www.java.sun.com/products/jdbc/ . Contains database server-side functionality. Prepares the ground for the use of database-aware Java beans. JDBC 2.1 optional API Not bundled javax.sql Incremental improvement and additions over the 2.0 API. JDBC 3.0 core API JDK 1.4 and later java.sql Adds support for connection pooling, statement pooling, and a migration path to the Connector Architecture.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
CNT 4714: JDBC Page 4 Dr. Mark Llewellyn © Connecting To A Database A database works in the classic client/server fashion. There is one database and many clients talk to it. (Larger applications may have multiple databases, but they can be considered independently for our purposes.) As we’ve seen in the earlier sections of notes dealing with networking, the clients are typically remote systems communicating over TCP/IP networks. In a 2-tier system, the clients talk directly to the database while in a 3-tier system, the clients talk to a business logic server which in turn talks to the database. The business logic server would also contain server-side JDBC functionality.
Background image of page 4
CNT 4714: JDBC Page 5 Dr. Mark Llewellyn © Connecting To A Database (cont.) A JDBC driver is typically available from the database vendor of the database to which you wish to connect.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/14/2011 for the course CNT 4714 taught by Professor Llewellyn during the Spring '10 term at University of Central Florida.

Page1 / 65

jdbc - CNT 4714: Enterprise Computing Spring 2011...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online