List<Object[]> list = hibernateEntityDao.getHibernateTemplate().execute(new HibernateCallback() {
@Override
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
String sql="select * from tb_mall tm left join tb_shopcart ts on tm.id=ts.mallid where ts.buyusid="+usid;
SQLQuery query = session.createSQLQuery(sql);
return query.list();
}
});
//List list=hibernateEntityDao.getHibernateTemplate().find(sql);
//list.get(0).get("mallid");
System.out.println(list);
for (Object[] object : list) {
List ss = new ArrayList();
Collections.addAll(ss, object);
ss.get(0);
System.out.println(ss);
}
@Override
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
String sql="select * from tb_mall tm left join tb_shopcart ts on tm.id=ts.mallid where ts.buyusid="+usid;
SQLQuery query = session.createSQLQuery(sql);
return query.list();
}
});
//List list=hibernateEntityDao.getHibernateTemplate().find(sql);
//list.get(0).get("mallid");
System.out.println(list);
for (Object[] object : list) {
List ss = new ArrayList();
Collections.addAll(ss, object);
ss.get(0);
System.out.println(ss);
}