public List<order> retrieveOrderData(String supName) throws SQLException{
        
        try{
            databaseConnector=myConnector.getConnection();
            stmnt=(Statement) databaseConnector.createStatement();
            
            SQLQuery="SELECT * FROM familydoctor.order WHERE supplierName="+"'"+supName+"'";
            dataSet=stmnt.executeQuery(SQLQuery);
          
            while(dataSet.next()){
                orderID=dataSet.getInt("orderID");
                supplierName=dataSet.getString("supplierName");
                orderDate=dataSet.getString("orderDate");
                orderInfo=dataSet.getString("orderInfo");
                orderAmount=dataSet.getFloat("orderAmount");
                tempOrder=new order(orderID,supName, orderDate, orderInfo, orderAmount);
                
                orderList.add(tempOrder);
                
            }
        }
        
        catch(SQLException e){
            System.out.println(e.getMessage());
        }
        
        finally{
            if(stmnt!=null)
                stmnt.close();
            if(databaseConnector!=null)
                databaseConnector.close();
        }
        
        return orderList;
    }