关键代码
mybatis
<select id="selectBdJobStatusByNow" parameterType="Long" resultType="java.util.HashMap">
select NOW()>start_time as startStatus,NOW()>end_time as endStatus
from bd_job
where id = #{jobId};
mysql语句
select NOW()>start_time as startStatus,NOW()>end_time as endStatus from bd_job where id = 00000000001;
执行结果
根据sql语句:
HashMap<String,Integer> jobStatus = bdJobContentAnswerService.selectBdJobStatusByNow(jobId);
if(jobStatus.get("startStatus").equals(0)){ //作业未开始
return AjaxResult.success("作业还未开始");
}else if(jobStatus.get("endStatus").equals(0)) { //作业进行中
}else if(jobStatus.get("endStatus").equals(1)){ //作业已截止
}else {
return AjaxResult.error("接口请求错误!");
}
注:说的比较乱,希望意思能理解