@Override
public Map<String, Object> getVenueInfo(final long venActivityId) {
return hibernateTemplate
.execute(new HibernateCallback<Map<String, Object>>() {
@SuppressWarnings("unchecked")
@Override
public Map<String, Object> doInHibernate(Session session)
throws HibernateException {
String sql = "select ve.venueId, ve.venueName, ve.venueAbout, ve.venueAddress, ve.phone, vp.pic "
+ " from ven_venue as ve left join ven_pic as vp on ve.venueID = vp.venueID where ve.venueID = ?";
List<Map<String, Object>> listMap = session.createSQLQuery(sql)
.setLong(0, venActivityId)
.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();
return listMap.size() > 0 ? listMap.get(0) : null;
}
});
}