|
方法： public Page getHotStudioList(String interval, Integer pageNo, Integer pageSize) { Page page = null; if("week".equals(interval)){ Calendar calendar = Calendar.getInstance(); calendar.add(Calendar.WEEK_OF_MONTH, -1); page = getPagedNamedQuery("sdStudio::getHotStudioListV2::query", pageNo, pageSize,calendar.getTime()); }else if("month".equals(interval)){ Calendar calendar = Calendar.getInstance(); calendar.add(Calendar.MONTH, -1); page = getPagedNamedQuery("sdStudio::getHotStudioListV2::query", pageNo, pageSize,calendar.getTime()); }else{ page = getPagedNamedQuery("sdStudio::getNewest2StudioListV2::query", pageNo, pageSize); } return page; } 具體的sql： SELECT * FROM sd_studio s WHERE s.DELETE_FLAG = 0 AND s.FORBIDDEN_FLAG = 1 AND s.CRE_TIME > ? ORDER BY s.FANS_CNT DESC, s.CRE_TIME DESC |
|
|
