参考博客:
http://www.jb51.net/article/110541.htm
http://blog.csdn.net/wxwzy738/article/details/25158787
我这边项目的需求是:每天晚上1点删除数据库表t_tempclob中的所有记录;
代码:
Controller:
@Controller
public class AjaxFileDownload {
private static Logger logger = Logger.getLogger(AjaxFileDownload.class);
@Autowired
private ProductService productService;
@Autowired
private TempClobService tcService;
/**
* 定时任务,每天晚上1点删除数据表t_tempClob中的所有记录
*/
@Scheduled(cron= "0 0 1 * * ?")
public void deleteAllTempClob(){
int count = tcService.deleteAllTempClob();
System.err.println("---->>deleteAllTempClob删除数据库记录数:" + count);
}
}
Service:
View Code
Mapper接口:
View Code
Mapper.xml:
View Code
spring-mvc.xml中关于task的配置:
开启5个线程
cron表达式详解、举例子:
https://www.cnblogs.com/javahr/p/8318728.html
cron表达式说明:
参考博客:http://www.jb51.net/article/110541.htm