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());
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();
}
});
}