public supplier browseSupplier(String supplierName) throws SQLException{
        supplier searchedSupplier=null;
        try{
            databaseConnector=myConnector.getConnection();
            stmnt=(Statement) databaseConnector.createStatement();
        
            SQLQuery="SELECT * FROM familydoctor.supplier WHERE Name="+"'"+supplierName+"'";
            
            System.out.println(SQLQuery);
            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");
                searchedSupplier=new supplier(name, contactDetails, phnNo, mail);
                searchedSupplier.setAmount(amount);
                
            }
            
  
        }
        
        catch(SQLException e){
            System.out.println(e.getMessage());
        }
        
        finally {
            if (stmnt != null) {
                stmnt.close();
            }
            if (databaseConnector != null) {
                databaseConnector.close();
            }
        }
        
        return searchedSupplier; //return the raws as a resultSet
    }