Page 379 - 2020학년도 MDP과제발표회 자료집 (통신과) (3)

port: "3306",
database: "sm_library"
})

var member = mysql.createConnection({ //sm_l_member 데이터 베이스 연결 객체
host: "localhost",
user: "root",
password: "root",
port: "3306",
database: "sm_l_member"
})

var register = mysql.createConnection({
host: "192.168.0.6",
user: "root",
password: "1234",
port: "3306",
database: "jbts"
})

var member_id;

var id = new Array();
var bookname;
var late, late2;
var date;
var check;
var user1 = new Array();
var user2 = new Array();
var userresult1 = new Array();
var userresult2 = new Array();
var user = new Array();
var schedule = require('node-schedule');
var rule = new schedule.RecurrenceRule();
rule.second=5;

var reset = schedule.scheduleJob(rule, function(){
console.log("\n\n 회원정보 갱신")
var registerinfo="select id from user where department='library' order by id"
register.query(registerinfo, function(err,result,field){
if(!err){
for(var i=0; i<result.length; i++){
user1[i]=result[i].id
}
var userinfo="show tables"

인천전자마이스터고등학교
- 395 - 정보통신기기과 395