package sample;

import eg.edu.alexu.csd.oop.db.MyDatabase;

import java.sql.SQLException;

public class FunctionFacasd {
    private String query;
    private MyDatabase db =  MyDatabase.getDatabase();;

    public void setQuery(String query){
        this.query = query;
    }

    public void operate() throws SQLException {
        String newquery =  query.trim() ;
        newquery= newquery.toUpperCase();
        if(newquery.startsWith("CR")||newquery.startsWith("DR")){
            db.executeStructureQuery(query);
        }
        else if(newquery.startsWith("S")){
            db.executeQuery(query);
        }
        else if (newquery.startsWith("U")||newquery.startsWith("DE")||newquery.startsWith("I")){
            db.executeUpdateQuery(query);
        }
        else{
            throw new SQLException();
        }
    }
}