Get the number of rows in my table as an Integer

I want to create a method to return the number of rows in my table called "album", in an integer.

private static int getnbofalbum() {
		int nbofalbum;
		String jpql = "select count(*) from Album";
		Query query = entityManager.createQuery(jpql);
		nbofalbum = query.getSingleResult();
		System.out.println("nbofalbum :" + nbofalbum);
		return nbofalbum;
	}

this is what I would in a way have, but query.getSingleResult() gives back an object, even if my query should give back a number, what can I do to get the number of rows in a simple way ?

you should declare nbofalbum as Long, cause count(*) return a Long , and u cant just cast Long into int