import java.sql.*;
import oracle.sqlj.runtime.*;
import sqlj.runtime.*;
import sqlj.runtime.ref.*;
import java.util.Scanner;

public class Employee_Info {
    public static void main(String[] args) {
        Scanner in = new Scanner(System.in);
        try{
            DefaultContext cntxt = Oracle.getConnection(
                "jdbc:oracle:thin:@192.168.4.108:1522:company",
                "username", "password");
            DefaultContext.setDefaultContext(cntxt) ;
            String ssn="", fname="", minit="", lname="", address="";
            double salary=0;
            System.out.println("Enter a Ssn: ");
            ssn = in.nextLine();

            #sql { select Fname, Minit, Lname, Address, Salary
                into :fname, :minit, :lname, :address, :salary
                from EMPLOYEE where Ssn = :ssn} ;

            System.out.println(fname + " " + minit + " " +
                               lname + " " + address + " " + salary);
        }catch (Exception e) {
            System.out.println(e);
        }
    }
}