分類:數(shù)據(jù)庫
數(shù)據(jù)庫中: select * from dj_log where 1=1 and to_char(log_date,‘yyyy-MM-dd‘) like ‘%2005-10-18%‘
java類中,hibernate中的查詢語句即hql語句
StringBuffer sb = new StringBuffer();
sb.append("from OpLog as oplog where 1=1");
if (!"".equals(StringUtil.display(logDate))) {
sb.append(" and to_char(oplog.logDate,‘yyyy-MM-dd‘) like ‘%").append(
logDate.substring(0,10)).append("%‘");
}
聯(lián)系客服