public List<supplier> retrieveSupplierData() throws SQLException{
        
        try{
            databaseConnector=myConnector.getConnection();
            stmnt=(Statement) databaseConnector.createStatement();
            
            SQLQuery="SELECT * FROM familydoctor.supplier";
            dataSet=stmnt.executeQuery(SQLQuery);
          
            while(dataSet.next()){
                name=dataSet.getString("Name");
                contactDetails=dataSet.getString("ContactDetails");
                phnNo=dataSet.getInt("phnNo");
                mail=dataSet.getString("mail");
                amount=dataSet.getFloat("Amount");
                tempSupplier=new supplier(name, contactDetails, phnNo, mail);
                tempSupplier.setAmount(amount);
                supplierList.add(tempSupplier);
                
            }
        }
        
        catch(SQLException e){
            System.out.println(e.getMessage());
        }
        
        finally{
            if(stmnt!=null)
                stmnt.close();
            if(databaseConnector!=null)
                databaseConnector.close();
        }
        
        return supplierList;
    }