public void deleteOrderInfo(int orderID) throws SQLException{
        try{
            databaseConnector=myConnector.getConnection();
            stmnt=(Statement) databaseConnector.createStatement();
            SQLQuery="DELETE FROM familydoctor.order WHERE orderID="+"'"+orderID+"'";
            stmnt.executeUpdate(SQLQuery);
        }
        
        catch(SQLException e){
            System.out.println(e.getMessage());
        }
        
        finally{
            if(stmnt!=null)
                stmnt.close();
            if(databaseConnector!=null)
                databaseConnector.close();
        }
        
    }