hibernate通过sql语句查询出的结果集封装到bean里面去

相关的语句有

 

  String sql="select t_personalbaseinfoentity.realName," +      "t_personalbaseinfoentity.mobilePhone," +      "t_personalbaseinfoentity.phone," +      "t_personalbaseinfoentity.mail," +      "t_personalbaseinfoentity.qq "+      "from t_personalbaseinfoentity";  getSession().createSQLQuery(sql).setResultTransformer(Transformers.aliasToBean(AddressBookInfo.class)).list();

其中AddressBookInfo这个bean中必须要有与查询出来的字段名相同的属性，即这里的bean里需要realName,mobilePhone,phone,mail,qq几个属性以及它们的设置器，即setter，查询结果即可返回List<AddressBookInfo>