package edu.uic.ids401.util;

import java.io.File;
import java.io.FileNotFoundException;
import java.sql.ResultSet;
import java.util.Scanner;

public class DBaseMain {


    public static void main(String[] args) {

        String userName=null;
        String password=null;
        String dbmsServer=null;
        String dbmsType=null;
        String dbScheme=null;


        Scanner keyboard=new Scanner(System.in);
        System.out.println("What is your username?");
        userName= keyboard.next();
        System.out.println("What is your password?");
        password= keyboard.next();
        System.out.println("What is the dbmsServer name");
        dbmsServer= keyboard.next();
        System.out.println("What is your dbmsType");
        dbmsType= keyboard.next();
        System.out.println("What is your dbscheme");
        dbScheme= keyboard.next();
        System.out.print("Enter file name:");
        String fileName=keyboard.next();
        Scanner inputStream=null;

    String url = "jdbc:"+dbmsType+"://"+dbmsServer+":3306"+"/"+dbScheme;
DBase dbase= new DBase("com.mysql.jdbc.Driver",url,userName,password);
ResultSet rs=null;
rs = dbase.executeSQLdmlQuery(keyboard.nextLine());


try
{
    inputStream=new Scanner(new File(fileName));

}

catch(FileNotFoundException e)
{
    System.out.println("Error opening the file"+ fileName);
    System.exit(0);
}

while(inputStream.hasNextLine())
{
String line=inputStream.nextLine();
System.out.println(line);
}
inputStream.close();
}