public class UserDTO {
    protected Account account;
    protected Long cntCom;

    public UserDTO() {}
    
    public Long getCntCom() {
        return cntCom;
    }

    public void setCntCom(Long cntCom) {
        this.cntCom = cntCom;
    }

    public Account getAccount() {
        return account;
    }

    public void setAccount(Account account) {
        this.account = account;
    }
}

    @Override
    @Transactional
    public List<UserDTO> getAllUserCntCom(Integer FirstR, Integer MaxR) {
        String sqlQuery = "select account.id_user, account.username, (select count(*) from comment where comment.id_user = account.id_user) as countCom from account";
//        Query query = sessionFactory.getCurrentSession().createQuery(sqlQuery);
//        query.setFirstResult(FirstR);
//        query.setMaxResults(MaxR);
//        
//        query.list();
        
	List list =  sessionFactory.getCurrentSession().createSQLQuery(sqlQuery).list();

	if(list.isEmpty()) {
            return null;
        }
        
        List <UserDTO> results = new ArrayList<UserDTO>();
	for(Object item : list) {
            Object[] array = (Object[]) item;

            UserDTO userDTO = new UserDTO();
            Account account = new Account();
            
            account.setId(((Number)array[0]).longValue());
            account.setUsername((String) array[1]);
            
            userDTO.setAccount(account);
            userDTO.setCntCom(((Number)array[2]).longValue());
            
            results.add(userDTO);
	}
                
        return results;
    }

            <c:forEach items="${userDTO}" var="accDTO">
                ${accDTO.account.id}, ${accDTO.account.username}, ${accDTO.cntCom} |
            </c:forEach>

List resultWithAliasedBean = s.createCriteria(Enrolment.class)
  .createAlias("student", "st").createAlias("course", "co")
  .setProjection( Projections.projectionList()
                   .add( Projections.property("st.name"), "studentName" )
                   .add( Projections.property("co.description"), "courseDescription" )
          )
          .setResultTransformer( Transformers.aliasToBean(StudentDTO.class) )
          .list();

 StudentDTO dto = (StudentDTO)resultWithAliasedBean.get(0);

List resultWithAliasedBean = s.createQuery(
  "select e.student.name as studentName," +
  "       e.course.description as courseDescription" +
  "from   Enrolment as e")
  .setResultTransformer( Transformers.aliasToBean(StudentDTO.class))
  .list();

StudentDTO dto = (StudentDTO) resultWithAliasedBean.get(0);

public class AccountCntCom {
    private Long id_user;
    private String username;

//    public AccountCntCom() { }
    
    public Long getId_user() {
        return id_user;
    }

    public void setId_user(Long id_user) {
        this.id_user = id_user;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }
}

    @Override
    @Transactional
    public List<AccountCntCom> getAllUserCntCom(Integer FirstR, Integer MaxR) {

        String sqlQuery = "select ac.id_user, ac.username from account ac";
    
        List resultWithAliasedBean = sessionFactory.getCurrentSession().createSQLQuery(sqlQuery)
            .addScalar("id_user")
            .addScalar("username")
            .setResultTransformer(Transformers.aliasToBean(AccountCntCom.class))
            .setCacheMode(CacheMode.GET)
            .list();

        return resultWithAliasedBean; 
    }

public class AccountCntCom {
    private Long id_user;
    private String username;
    protected Long cntCom;

    public AccountCntCom() { }
    
    public AccountCntCom(Long id_user, String username) {
        this.id_user = id_user;
        this.username = username;
    }
    
    public Long getId_user() {
        return id_user;
    }

    public void setId_user(Long id_user) {
        this.id_user = id_user;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }
    
    public Long getCntCom() {
        return cntCom;
    }

    public void setCntCom(Long cntCom) {
        this.cntCom = cntCom;
    }
}

    public AccountCntCom(Long id_user, String username, Long cntCom) {
        this.id_user = id_user;
        this.username = username;
        this.cntCom = cntCom;
    }