Possible Software to Be Used (Cont.)

JDBC (Java DataBase Connectivity)
It is a Java application programming interface for standard SQL access to databases.

Author:    

           
view source
print?
01import  java.sql.*;
02import  java.io.*;
03import  oracle.jdbc.*;
04import  oracle.jdbc.pool.OracleDataSource;
05 
06class  JDBC {
07 public static void  main( String args[ ] ) throws SQLException {
08  String user     = "C##user_id";
09  String password = "password";
10  String database = "20.185.147.112:1521/xe";
11  OracleDataSource ods = new OracleDataSource( );
12  ods.setURL     ( "jdbc:oracle:thin:@" + database );
13  ods.setUser    ( user );
14  ods.setPassword( password );
15  Connection conn = ods.getConnection( );
16  try {
17   Statement stmt = conn.createStatement( );
18   String query   = "SELECT UNIQUE title FROM book b, author a, written w WHERE ";
19   query         += "w.aid = a.aid AND w.ISBN = b.ISBN AND ( ";
20   for ( int i=0;  i<args.length;  i++ ) {
21     if ( i != 0 )  query += " OR ";
22     query += "a.name like '%" + args[i].trim( ) + "%'";
23   }
24   query += " )";
25   ResultSet rset = stmt.executeQuery( query );
26   while ( rset.next( ) )
27    System.out.print( rset.getString( 1 ));
28   rset.close( );
29   stmt.close( );
30  }
31  catch ( SQLException ex ) {
32   System.out.println( ex );
33  }
34  conn.close( );
35 }
36}