Basic HTML version of Foils prepared May 19 99

Foil 20 JDBC 2 Tier Applet

From Overview of JDBC: Java Database Connectivity Basic Information Track Computational Science Course CPS616 -- Spring Semester 1999. by Nancy McCracken,(Sangetta Aggarwal, Meryem Ispirli, Udayan Parvate, Tom Pulikal, Chao-Wei Ou)
Implementation:
  • A new instance of the SQL driver is created.
    • Syntax: java.sql.Driver d = (java.sql.Driver)Class.forName ("oracle.jdbc.driver.OracleDriver").newInstance();
  • A connection to the Oracle server is opened by supplying the user's name, password and the machine to connect to, if more than one is available.
    • Syntax: Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@carver.npac.syr.edu:1521:europe", "username", "password");

© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Mon Jul 5 1999