81,122
社区成员




String hql = "from TservercameraUtil where cameraname like '类型%'"";
Session session = getHibernateTemplate().getSessionFactory().openSession(); // Spring
Transaction tx = session.beginTransaction();
Query qry = session.createQuery(sql);
List returnList = qry.list();
tx.commit();
session.close();
//试试:
List params = new ArrayList();
String hql = " from TservercameraUtil where cameraname like ? " ;
params.add( " '% " + form.get( " zdmlmc " ).toString() + " %' " );
Object[] objs = params.toArray();
Session session = getHibernateTemplate().getSessionFactory().openSession();
Transaction tx = session.beginTransaction();
Query qry = session.createQuery(sql);
if (objs == null ) // 判断是否确认参数名称
{
if (objs.length > 0 )
for ( int i = 0 ; i < objs.length; i ++ )
qry.setParameter(i, objs[i]);
}
List returnList = qry.list();
tx.commit();
session.close();