import java.sql.*;
import oracle.jdbc.pool.*;
import java.io.*;
import java.util.*;

public class DBAccess{

    //The Connect String
    static final String connect_string=
                    "jdbc:oracle:thin:system/db_147@//localhost:1521/XE";
    //The query we will execute
     String query = "select 'Hello JDBC: ' || sysdate from dual";
    //The Connection to the database
    private Connection conn;

    public static void main(String args[]){
        new DBAccess();
    }

    public DBAccess(){
        try{
            //Seeif we need to open the connection to the database
            if(conn==null){
                //Create a OracleDataSOurce instance and set URL
                OracleDataSource ods = new OracleDataSource();
                ods.setURL(connect_string);
                //Connect to the database
                System.out.println("Connecting to " + connect_string + "\n");
                conn=ods.getConnection();
                System.out.println("Connected\n");
            }
            //Create a statement
            Statement stmt = conn.createStatement();
            //Execute the query
            System.out.println("Executing query" + query + "\n");
            ResultSet rset = stmt.executeQuery(query);
            //Dump the result
            while(rset.next()){
                System.out.println(rset.getString (1) + "\n");
                //System.out.println(rset.getString("FName"));
                //System.out.println(rset.getString (" LName") + "\n");
            }
            //We're done
            System.out.println("done.\n");
        }
        catch(Exception e){
            System.out.println(e.getMessage() + "\n");
        }
    }

    public void addStudent(String No, String Fname, String Lname){
        try{
            Statement stmt = conn.createStatement();
            query="insert into stu values("+No+",'"+Fname+"','"+Lname+"')";
            System.out.println("Executing query" + query + "\n");
            stmt.executeQuery(query);
        }catch(Exception e){
            System.out.println(e);
        }
    }

    public Student getStudent(){
        try{
            Statement stmt = conn.createStatement();
            query="select ";
            System.out.println("Executing query" + query + "\n");
            stmt.executeQuery(query);
        }catch(Exception e){
            System.out.println(e);
        }
    }

}