CP1222 - WEEK 3-4

Add import statements to your Java program to import required classes in your Java code.

• Import JDBC Packages

• Register JDBC Driver

• Database URL Formulation:

• Create Connection Object:

This is to create a properly formatted address that points to the database to which you wish to connect.

• Import JDBC Packages

• Register JDBC Driver

• Database URL Formulation:

• Create Connection Object:

This step causes the JVM to load the desired driver implementation into memory so it can fulfill your JDBC requests.

• Import JDBC Packages

• Register JDBC Driver

• Database URL Formulation:

• Create Connection Object:

Code a call to the DriverManager object's getConnection( ) method to establish actual database connection

• Import JDBC Packages

• Register JDBC Driver

• Database URL Formulation:

• Create Connection Object:

jdbc:sybase:Tds:hostname: port Number/databaseName

• MySQL

• ORACLE

• DB2

• Sybase

jdbc:db2:hostname:port Number/databaseName

• MySQL

• ORACLE

• DB2

• Sybase

jdbc:oracle:thin:@hostname:port Number:databaseName

• MySQL

• ORACLE

• DB2

• Sybase

jdbc:mysql://hostname/ databaseName

• MySQL

• ORACLE

• DB2

• Sybase

The most common approach to register a driver is to use Java's

• Class.forName() method

• DriverManager.registerDriver() method

approach you can use to register a driver is use the static

• Class.forName() method

• DriverManager.registerDriver() method