53jdbc-2up - 53 JDBC 11 Nov 2010 CSCC09F Programming on the...

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

View Full Document Right Arrow Icon
53 JDBC 11 Nov 2010 CSCC09 Programming on the Web 1 53 JDBC Programming on the Web 1 JDBC Multi-tier application architecture; JDBC goals & architecture; JDBC components; JDBC API; transactions; prepared-statements; connection pooling CSCC09F Programming on the Web 53 JDBC Programming on the Web 4 “N-tier” DB architecture Database Server Client Application User Interface “Thin Client” Application Server b Web Server is generic b Application Server contains code specific to workflow and business processes workflow controller/ business logic Web Server
Background image of page 1

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

View Full DocumentRight Arrow Icon
53 JDBC 11 Nov 2010 CSCC09 Programming on the Web 2 53 JDBC Programming on the Web 9 JDBC b Different RDBMS systems have surprisingly little in common other than their use of SQL; each has its own unique API. b JDBC (Java Database Connectivity) provides a standard, generic SQL database access interface. b The JDBC API defines classes to represent major DB functionality, such as database connections, SQL statements, result sets, and database metadata. b JDBC allows a Java program to issue SQL statements and process the results. 53 JDBC Programming on the Web 10 JDBC Goals b DB independence: provide Java programmers with a uniform, simple interface to a wide range of relational databases. Can replace underlying database with minimal code impact. b Platform independence. b Provide a common base on which higher level tools and interfaces can be built. b Note JDBC does not attempt to standardize SQL syntax across vendor DB products, which often implement their own proprietary SQL extensions.
Background image of page 2
11 Nov 2010 CSCC09 Programming on the Web 3 53 JDBC Programming on the Web 11 JDBC Components b Database server: c The actual database engine, e.g. Oracle, Informix, Sybase, mySQL, H2, Postgresql, etc. b JDBC Driver – implements JDBC Driver API: c Translates API calls to requests against specific database. c Specific driver for each individual database vendor (provided by DB vendor or 3 rd party). c All major commercial databases are supported. c Installed on the db client (in an N-tier architecture, this would be the application server). 53 JDBC Programming on the Web 13 JDBC Application Components A JDBC application consists of: b Java client: code implementing the application that uses the DB system, written using calls to the JDBC API. b
Background image of page 3

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

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

Page1 / 12

53jdbc-2up - 53 JDBC 11 Nov 2010 CSCC09F Programming on the...

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

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