搭建简易的物联网服务端和客户端-第四次增补（二十六）

var flag,j;
var c = schedule.scheduleJob('40 * * * * *', function() {
    conn.query('select * from autofood', function(err, rows, fields) {
        var i = rows.length;
        var tem = rows[i - 1].type;
        console.log("flag:" + flag);
        if (tem !== flag) {
            j.cancel() //删除原来定时
            theSelect(tem) //进行新的定时
        }
    })
})

function theSelect(x) {
    switch (x) {
        case 1:
            flag = 1
            console.log("type1");
            j = schedule.scheduleJob('12 * * * ', function() {
                var post = { status: 1 };
                conn.query('INSERT INTO status SET ?', post, function(error, result, fields) {
                    if (error) throw error;
                });
            });
            break;
        .....
        default:
            console.log("error");
            break;
    }
}