首先保证是否安装node-mysql 如没按装可以使用npm包管理安装node-mysql
#npm install mysql
前期工作 在mysql 创建microblog数据库 并添加user数据表 表含三个字段 uid 主键 username 字符型 password字符型
安装完成 创建db.js 代码如下
//引入mysql模块并创建连接
host:'127.0.0.1',
user:'root',
password:'zhang1229',
database:'microblog'
});
//插入数据 insert
insertData=function(sql){
//var values=['zhang','zhang1229'];
Client.query(sql,function(error,results){
if(error){
console.log('ClientReady Error:'+error.message);
Client.end();
return;
}
console.log('insert ok');
});
};
var sql="insert into user set username='xiao',password='zhang'";
insertData(sql);
//获取查询数据 select
getData=function(sql){
Client.query(sql,function(error,results,fields){if(error){
console.log('GetData Error:'+error.message);
Client.end();
return;
}
if(results.length>0)
{
console.log('name is :'+results[0]['username']);
console.log('password is :'+results[0]['password']);
}
});
};
//var sql='select * from user'
//getData(sql);
//更新数据 update
updateData=function(sql){
Client.query(sql,function(error,results){if(error){
console.log('updata Error:'+error.message);
Client.end();
return;
}
console.log('updata ok');
});
};
//var sql="update user set username='sdsd' where username='xiao'";
//updateData(sql);
//删除数据 delete
deleteData=function(sql){
Client.query(sql,function(error,results){if(error){
console.log('delete Error:'+error.message);
Client.end();
return;
}
console.log('delete ok');
});
};
//var sql="delete from user where uid=2";
//deleteData(sql);