public int getUnreadedMessage(){
             int num=0;
             String requete = "select count(*) from message where `Read`=0 AND `Reciever`='Admin'";
             try {
             Statement statement = MyConnection.getInstance()
                   .createStatement();
            
            ResultSet resultat = statement.executeQuery(requete);
             while(resultat.next()){
                 System.out.println("here"); 
                num=resultat.getInt(1);              
             }
        } catch (SQLException ex) {
           //Logger.getLogger(PersonneDao.class.getName()).log(Level.SEVERE, null, ex);
            System.out.println("erreur lors du chargement des depots "+ex.getMessage());
        }
             return num;
        }