81,094
社区成员
发帖
与我相关
我的任务
分享
@SuppressWarnings("unchecked")
public List findCreateSqlMap(final String sql,final Map parameter) {
List<Map> list = getHibernateTemplate().executeFind(new HibernateCallback(){
public Object doInHibernate(Session session) throws HibernateException, SQLException {
SQLQuery query = session.createSQLQuery(sql);
query.setProperties(parameter).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
return (List<Map>)query.list();
}});
return list;
}
@SuppressWarnings("unchecked")
public List<Map> findCreateSqlMap(final String sql,final Object[] parameter) {
List<Map> list = getHibernateTemplate().executeFind(new HibernateCallback(){
public Object doInHibernate(Session session) throws HibernateException, SQLException {
SQLQuery query = session.createSQLQuery(sql);
for(int i=0;i<parameter.length;i++){
query.setParameter(i, parameter[i]);
}
query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
return (List<Map>)query.list();
}});
return list;
}
getHibernateTemplate().execute(new HibernateCallback(){
public Object doInHibernate(Session session) throws HibernateException, SQLException {
// TODO Auto-generated method stub
SQLQuery query = session.createSQLQuery("call 过程");
query.setParameter(0, "参数");
//..............多个略
return query.executeUpdate();
}});