功能: 取前一百条记录.
query.setFirstResult(0);//从第0条记录开始
query.setMaxResults(100);//每一页的记录个数100条
b.两个时间段的查询
SimpleDateFormat sdf= new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//时间格式设置
try{
Session ssn = HibernateSessionFactory.currentSession();
String sql = "select v.dcSrcId, count(v.dcSrcId) FROM VoteactivityMo v where 1=1 ";
if(date1!=null&&!date1.trim().equals("")){
sql = sql + " and v.ddRecvTime >= :date1";
}
if(date2!=null&&!date2.trim().equals("")){
sql = sql + " and v.ddRecvTime <= :date2";
}
sql = sql+" and v.dnType=:type " + " group by v.dcSrcId order by count(v.dcSrcId) desc";
Query query = ssn.createQuery(sql);
query.setInteger("type",type);
if(date1!=null&&!date1.trim().equals("")){ //date1.trim()去掉字段左右两边的空格
String tempStr = date1.trim()+" 00:00:00";
tempStr = tempStr.substring(0,19);
Date date = sdf.parse(tempStr);
query.setTimestamp("date1", date);
}
if(date2!=null&&!date2.trim().equals("")){
String tempStr = date2.trim() + " 00:00:00";
tempStr = tempStr.substring(0,19);
Date date = sdf.parse(tempStr);
query.setTimestamp("date2", date);
}
query.setInteger("type", type);
query.setFirstResult((pageNum - 1) * pageSize);// 从第(pageNum-1)*pageSize显示
query.setMaxResults(pageSize);// 每页筛选出pageSize条记录
List list = query.list();
功能: 取前一百条记录.
最新推荐文章于 2022-12-06 09:34:02 发布