Session session = super.getHibernateTemplate().getSessionFactory().getCurrentSession();
StringBuilder sql = new StringBuilder().append("select * from abcdefg where id is not null ");
List<类> list = session.createSQLQuery(sql.toString()).setResultTransformer(Transformers.aliasToBean(类.class)).list();