数据库的公告表添加两个字段starttim
(发布时间) endtim
(过期时间)注意类型是date
发布公告:
Date date = new Date();
SimpleDateFormat dateFormat= new SimpleDateFormat("yyyy-MM-dd :hh:mm:ss");
System.out.println("当前的时间:");
System.out.println(dateFormat.format(date));
Date date30=new Date(System.currentTimeMillis()+24*60*60*1000*30L);
System.out.println("三十天后时间:");
System.out.println(dateFormat.format(date30));
System.out.println(announcements);
// 将announcements中的starttim 和 endtim 分别设置为上面的值
announcements.setStarttim(dateFormat.format(date));
announcements.setEndtim(dateFormat.format(date30));
回显数据时要加判断:
QueryWrapper<Announcements> queryWrapperann=new QueryWrapper<Announcements>();
// 判断当前时间在starttim的值和endtim的值之间时显示
// 符合显示 不符合不显示
Date date = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String format = sdf.format(date);
queryWrapperann.le("starttim",format);
queryWrapperann.ge("endtim",format);
queryWrapperann.orderByDesc("id");
List<Announcements> announcementList = announcementService.list(queryWrapperann);
model.addAttribute("announcementList", announcementList);