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
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
Connection myConn =
DriverManager.getConnection(“jdbc:oracle:oci8:@oracle.uis.edu”, “oracle_username”, “oracle_password”);
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.