import java.sql.*;
import java.util.*;
import java.io.*;
public class P10
{
public static void main (String [] args)
{
String file = args[0];

try
{

BufferedReader input = new BufferedReader(new FileReader(file)); 
 
String line = input.readLine(); 
 
StringTokenizer tk = new StringTokenizer(line); 
String username = tk.nextToken();
String password = tk.nextToken();  

String dburl = new String
("jdbc:oracle:thin:@reason.levels.unisa.edu.au:1000:UNISACIS");
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con =
DriverManager.getConnection(dburl,username,password);
Statement stmt = con.createStatement();
ResultSet r = stmt.executeQuery(args[1]);
ResultSetMetaData meta = r.getMetaData();
int ncols = meta.getColumnCount();
for (int col=1; col<=ncols; col++)
System.out.print(meta.getColumnName(col) +" - ");
System.out.println("");

while (r.next())
{
for (int col=1; col<=ncols; col++)
System.out.print(r.getString(col) +" - ");
System.out.println("");
}
System.out.println("End SQL");
stmt.close();
}
// On IO exception, display system error message
catch (IOException e)
{
System.out.println(e.getMessage());
}
// On SQL exception, display SQL error message
catch (SQLException e)
{
System.out.println(e.getMessage());
}
// On ClassNotFound exception, display error message
catch (ClassNotFoundException e)
{
System.out.println(e.getMessage());
}
}
}

D:\Work>java P10 cred.txt "select * from emp"
D:\Work>java P10 cred.txt "select * from emp e,dept d where d.deptno = e.deptno"
EMPNO - ENAME - JOB - MGR - HIREDATE - SAL - COMM - DEPTNO - DEPTNO - DNAME - LOC -
7369 - SMITH - CLERK - 7902 - 1980-12-17 00:00:00.0 - 800 - null - 20 - 20 - RESEARCH - DALLAS -
7499 - ALLEN - SALESMAN - 7698 - 1981-02-20 00:00:00.0 - 1600 - 300 - 30 - 30 -SALES - CHICAGO -
7521 - WARD - SALESMAN - 7698 - 1981-02-22 00:00:00.0 - 1250 - 500 - 30 - 30 - SALES - CHICAGO -
7566 - JONES - MANAGER - 7839 - 1981-04-02 00:00:00.0 - 2975 - null - 20 - 20 - RESEARCH - DALLAS -
7654 - MARTIN - SALESMAN - 7698 - 1981-09-28 00:00:00.0 - 1250 - 1400 - 30 - 30 - SALES - CHICAGO -
7698 - BLAKE - MANAGER - 7839 - 1981-05-01 00:00:00.0 - 2850 - null - 30 - 30 - SALES - CHICAGO -
7782 - CLARK - MANAGER - 7839 - 1981-06-09 00:00:00.0 - 2450 - null - 10 - 10 - ACCOUNTING - NEW YORK -
7788 - SCOTT - ANALYST - 7566 - 1982-12-09 00:00:00.0 - 3000 - null - 20 - 20 - RESEARCH - DALLAS -
7839 - KING - PRESIDENT - null - 1981-11-17 00:00:00.0 - 5000 - null - 10 - 10 - ACCOUNTING - NEW YORK -
7844 - TURNER - SALESMAN - 7698 - 1981-09-08 00:00:00.0 - 1500 - 0 - 30 - 30 - SALES - CHICAGO -
7876 - ADAMS - CLERK - 7788 - 1983-01-12 00:00:00.0 - 1100 - null - 20 - 20 - RESEARCH - DALLAS -
7900 - JAMES - CLERK - 7698 - 1981-12-03 00:00:00.0 - 950 - null - 30 - 30 - SALES - CHICAGO -
7902 - FORD - ANALYST - 7566 - 1981-12-03 00:00:00.0 - 3000 - null - 20 - 20 - RESEARCH - DALLAS -
7934 - MILLER - CLERK - 7782 - 1982-01-23 00:00:00.0 - 1300 - null - 10 - 10 - ACCOUNTING - NEW YORK -
End SQL