Java Tutorial/Trail: JDBC Database Access

From Wikiversity
Jump to navigation Jump to search

JDBC Database Access

[edit | edit source]

Introduction

[edit | edit source]

Database-agnostic Access Methods

[edit | edit source]

Database-specific Classes

[edit | edit source]

PostgreSQL

[edit | edit source]

The use of PostgreSQL-specific Java classes is explained in the PostgreSQL JDBC Interface online documentation. [1] [2]

Oracle

[edit | edit source]

IBM DB2

[edit | edit source]

MySQL

[edit | edit source]

Writing Functions and Triggers in Java

[edit | edit source]

PostgreSQL,[3] Oracle, DB2 and MySQL allow to write functions and triggers inside the database in the Java programming language.

References

[edit | edit source]
Wikibooks has a book on the topic of Structured Query Language.
  1. http://www.postgresql.org/docs/9.1/static/external-interfaces.html
  2. http://jdbc.postgresql.org/documentation/head/index.html
  3. http://pljava.projects.postgresql.org/
[edit | edit source]