我有一个cronjob,需要通过condition子句从db获取一些项。在这种情况下,我需要比较一些日期的时间,它们就像数据库中的(fri-dec 18 12:36:07 eet 2020)(java.util.date)。当执行查询时,我需要从数据库中检索到比当前时间早1小时的项。
我想我的问题应该是 select * from table_name where date_column > int_variable.
问题是变量是一个从别处设置的整数。我该怎么做?我需要把变量从int改成别的吗?我以我的班级为例。在我的课堂上,我还没有上面写的示例查询。谢谢!
public class HttpSessionCleanJob extends AbstractJobPerformable<HttpSessionCleanJobModel> {
private static final Logger LOG = Logger.getLogger(HttpSessionCleanJob.class.getName());
@Resource
private ModelService modelService;
@Resource
private FlexibleSearchService flexibleSearchService;
@Override
public PerformResult perform(final HttpSessionCleanJobModel httpSessionCleanJobModel) {
LOG.info("Start cleaning StoredHttpSession items...");
final int maxJobTime = httpSessionCleanJobModel.getTime();
final String queryString = "SELECT {" + StoredHttpSessionModel.PK + "} FROM {" + StoredHttpSessionModel._TYPECODE + "}";
final Date specificTime = new Date();
final FlexibleSearchQuery query = new FlexibleSearchQuery(queryString, Collections.singletonMap("specificTime", specificTime));
final SearchResult<StoredHttpSessionModel> searchResult = flexibleSearchService.search(query);
List<StoredHttpSessionModel> assetModelList = searchResult.getResult();
for(StoredHttpSessionModel storedHttpSessionModel : assetModelList) {
LOG.info(storedHttpSessionModel.getModifiedtime());
}
LOG.info("Finished cleaning StoredHttpSession items...");
return new PerformResult(CronJobResult.SUCCESS, CronJobStatus.FINISHED);
}
}
2条答案
按热度按时间eoigrqb61#
我用以下方法解决了这个问题:
dw1jzc5e2#
您可以尝试以下方法:
结果是当前日期减去5000毫秒(5秒)。
然后:
这将检索所有
StoredHttpSessionModel
修改日期超过5秒,使代码更符合您的需要。