-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdb.js
More file actions
73 lines (71 loc) · 1.95 KB
/
Copy pathdb.js
File metadata and controls
73 lines (71 loc) · 1.95 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
var dba = require('mysql');
function dbopen(){
var dd=dba.createConnection({
host:'localhost',
user:'root',
password:'',
database:'server'
})
return dd;
}
exports.db1=function(){
dbopen();
}
exports.db2=function(reqest,response){
var qq,id,task,times,notes;
//get reqest.query.cu
//post reqest.body.id
qq = reqest.body.qq;
id = reqest.body.id;
task = reqest.body.task;
times = reqest.body.times;
notes = reqest.body.notes;
//qq = reqest.query.qq;
//id = reqest.query.id;
//task = reqest.query.task;
if(qq == 'add'){
var insert='insert into tasklist values(?,?,?,?)';
dbopen().query(insert,[id,task,times,notes],function(er,results){
if(er){
console.log(er);
}
var cc =JSON.stringify(results);
console.log(results);
response.write(cc);
response.end();
})
}else if(qq=='delete'){
var deletedb='delete from tasklist where id=?';
dbopen().query(deletedb,[id],function(er,results){
if(er){
console.log(er);
}
var cc =JSON.stringify(results);
response.write(cc);
response.end();
})
}else if(qq == 'setOne'){
var select='select * from tasklist where id=?';
dbopen().query(select,[id],function(er,results){
if(er){
console.log(er);
}
var cc =JSON.stringify(results);
response.write(cc);
response.end();
})
}else{
var select='select * from tasklist';
dbopen().query(select,function(er,results){
if(er){
console.log(er);
}
var cc =JSON.stringify(results);
response.write(cc);
response.end();
})
}
}
exports.db3=function(){
dbopen().end();
}