功能描述

读取某个表中到当前时间为一周的记录

语句

废话不说，直接上语句：

     Date currentTime=new Date();
     Date sevenAgo=new Date();
     sevenAgo.setDate(currentTime.getDate()-30);
     SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
      String dateString = formatter.format(sevenAgo);
      java.sql.Timestamp WeekAgo = java.sql.Timestamp.valueOf(dateString); //转化为可以比较的格式
    
    
     hql="select lv from LogView lv,EvaluativeScore es where lv.id.operaType in (22,81,31,32,33,34,35,36,37,38,39,311,321,331,341,351,361,371,381,391,412) and lv.id.sourceType=1 and lv.id.id=es.koId and es.userId="+userId+" and lv.id.time>='"+WeekAgo+"' order by lv.id.time desc";//+" and datediff(day,lv.id.time,getdate()) < 30";
   

PS：一定要记得单引号（上例中hql语句中的WeekAgo包在单引号中），不然会报错。