hibernate的一些查询方法

List<PersonLevelVO> list =getSession().createSQLQuery(sql).setResultTransformer(Transformers.aliasToBean(PersonLevelVO.class)).list();

Integer count = Integer.parseInt(getSession().createSQLQuery(sql).list().get(0).toString());

List<MenuVo>  list = getSession().createSQLQuery(sql).addEntity(MenuVo.class).list();

List<MenuVo>  list = getSession().createQuery(sql).list();

                     getSession().createQuery(DElETE).setString(0, id).executeUpdate();

SQLQuery qure = this.getSession().createSQLQuery(sql).executeUpdate();

jdbcTemplate.execute("delete from Contacts where id="+tacts.getId());

jdbcTemplate.execute(sql);

 List<Map<String, Object>>  list = jdbcTemplate.queryForList(sql)

jdbcTemplate.update(sql,changePrice.getMatterId());

public List<ChangePrice> getByMatterId(final String matterId) {
final String hql = "from ChangePrice where matterId= ? order by id asc"; 
 return this.getHibernateTemplate().executeFind(new HibernateCallback() {
 public Object doInHibernate(final Session session) throws HibernateException, SQLException {
   final org.hibernate.Query query = session.createQuery(hql);
   query.setParameter(0, matterId);
  
   return query.list();
 }
 });
}