UIS Home   Search the UIS Website   A-Z index
UIS Homepage

Information Technology Services University of Illinois Springfield

JDBC

JDBC™ technology is an API that lets you access virtually any tabular data source from the JavaTM programming language. It provides cross-DBMS connectivity to a wide range of SQL databases, and now, with the new JDBC API, it also provides access to other tabular data sources, such as spreadsheets or flat files.

The JDBC API allows developers to take advantage of the Java platform’s “Write Once, Run AnywhereTM” capabilities for industrial strength, cross-platform applications that require access to enterprise data. With a JDBC technology-enabled driver, a developer can easily connect all corporate data even in a heterogeneous environment.

Example JDBC Strings to use on UISACAD

ORACLE

DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
Connection myConn =
DriverManager.getConnection(“jdbc:oracle:oci8:@oracle.uis.edu”, “oracle_username”, “oracle_password”);

MYSQL

Class.forName(“org.gjt.mm.mysql.Driver”);
Connection myConn = DriverManager.getConnection(“jdbc:mysql:///mysql_database?user=mysql_username&password=mysql_password”);

Information on this page was obtained from Sun’s Java webSite.

[ return to top]

Text Only Options

Top of page


Text Only Options

Open the original version of this page.

Usablenet Assistive is a UsableNet product. Usablenet Assistive Main Page.