1 查找数据库里的设定是时间,内容
List list = ObjectService.planClockService.remindTime();//controller
2
public List remindTime(){
String sql = "SELECT * FROM crm_plan_clock WHERE remindTime>NOW() AND status=1 ORDER BY remindTime";
List time = Db.find(sql);
return time ;}
3 返回controller 定义两个数组
ArrayList list3 = new ArrayList();//内容的数组
ArrayList list1 = new ArrayList();//时间的数组
for (int i = 0; i < list.size(); i++) {
String content = list.get(i).getStr("content");
list3.add("\""+content+"\""); //到前端获取时 字符串需要加双引号获取数组内容
Date str = list.get(i).getDate("remindTime");
Date now;
if (i==0){ //定义时间第一个时间跟当前时间比较
now= new Date();
}else {
now=list.get(i-1).getDate("remindTime");
}
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String timeStart = sdf.format(str);
String timeEnd = sdf.format(now);
try {
long date1 = sdf.parse(timeStart).getTime();
long date2 = sdf.parse(timeEnd).getTime();
Long time = date1 - date2; list1.add(time); }
catch (ParseException e) {
e.printStackTrace(); }
}
setAttr("content", list3);
setAttr("remindTime", list1);
render("/WEB-INF/view/hxiao/index.jsp");
4 前端获取后端的数组
$(document).ready(function(){
var remindTime = ${requestScope.remindTime}; //获取后端取到的数组内容
var content = ${requestScope.content};
var i=-1; function al() {
i++;
if(i<<span se-mark="1">remindTime.length) setTimeout(function(){toastr.info(content[i]);al() },remindTime[i]); //setTimeout实现递归循环 ,到了数组里面的时间提示提醒
}
al();})
<</span>link rel="stylesheet" type="text/css" href="