@Test
    public void testFindAll(){
        String sql = "select * from t_user;";
        List<Object[]> user = session.createSQLQuery(sql).list();
        for(Object[] objs : user){
            System.out.println(objs[0]+"\t"+objs[1]+"\t"+objs[2]);
        }
    }

@Test
    public void testFindAll2(){
        String sql = "select * from t_user;";
        List<User> users = session.createSQLQuery(sql)
                .addEntity(User.class)
                .list();
        for(User u : users){
            System.out.println(u.getName()+"\t"+u.getAge()+"\t"+u.getId());
        }
    }

@Test
    public void testFindCount(){
        String sql = "select count(1) from t_user;";
        BigInteger count = (BigInteger) session.createSQLQuery(sql).uniqueResult();
        System.out.println(count);
    }

<sql-query name="findUser">
        select * from t_user;
    </sql-query>

@Test
    public void testFindUser(){
        List<Object[]> user = session.getNamedQuery("findUser")
                .list();
        for(Object[] objs : user){
            System.out.println(objs[0]+"\t"+objs[1]+"\t"+objs[2]);
        }
    }