hibernate SQL LIST 变对象LIST

String sql = "select id,name from user";

ps:select后字段要与对象一直（as）

Query q = getSessionFactory().getCurrentSession().createSQLQuery(sql.toString())
            .addScalar("id", Hibernate.INTEGER)
            .addScalar("name", Hibernate.STRING)
            setResultTransformer(Transformers.aliasToBean(User.class));;

ps:指明目标对象及目标对象与查询字段的类型

q.setFirstResult(0);
q.setMaxResults(10);

List l = q.list();