情境：需要將數(shù)據(jù)庫(kù)中倆個(gè)字段拼接起來(lái)然后用傳入的參數(shù)進(jìn)行模糊查詢.
用HQL解決如下：
1 From ns.project.persistence.model.TZhidao as tz
2 where status = '1'
3 /~title: and tz.title || ':' || tz.description like '%'||{title}||'%' ~/
4 /~sortColumn: ORDER BY tz.[sortColumn] [sortDirection] ~/
posted on 2009-06-03 17:22
teok 閱讀(1278)
評(píng)論(2) 編輯 收藏