Slide 7.5: Opening a connection to a database (cont.)

Opening a Connection to a Database (Cont.)

The following example shows how to open a connection to our Oracle database by using OracleDataSource.

Password (args[0])=

01// Import the following packages to use JDBC.
02import  java.sql.*;
03import  java.io.*;
04import  oracle.sql.*;
05import  oracle.jdbc.*;
06import  oracle.jdbc.pool.OracleDataSource;
07 
08class  SignIn {
09  public static void  main( String args[ ] ) throws SQLException {
10    String user     = "C##userid";
11    String password = args[0].trim( );
12    String database = "65.52.222.73:1521/cdb1";
13 
14    // Open an OracleDataSource and get a connection.
15    OracleDataSource ods = new OracleDataSource( );
16    ods.setURL     ( "jdbc:oracle:thin:@" + database );
17    ods.setUser    ( user );
18    ods.setPassword( password );
19 
20    try {
21      System.out.println( "<html><body>" );
22      System.out.println( "<font color='#3366CC' face='Helvetica'><h3>" );
23      Connection  conn = ods.getConnection( );
24      if ( conn != null ) {
25        System.out.println( "Successfully connected!" );
26        conn.close( );
27      }
28    }
29    catch( SQLException e ) {
30      System.out.println( e );
31    }
32    System.out.println( "</h3></font></body</html>" );
33  }
34}