锐客网

  1. 首页 > 睿知 > it技术 > >

js怎么连接mysql js怎么连接数据库( 三 )

IT技术数据库


*
*/exports.getEmployee = function(){
var employeeGetSql = "SELECT * FROM employee";
connection.query(employeeGetSql,callback)}/**
* 删除员工
* @param {String} name
*/exports.deleteEmployee = function(name){
var employeeDeleteSql = "DELETE employee WHERE name = ?";
var employeeDeleteSql_Params = 'Peter';
connection.query(employeeDeleteSql,employeeDeleteSql_Params,callback)
}再在根目录下新建index.js,代码如下var db = require('./model/employee_two');//增加员工var employee = {
name:'lisa',
age:22,
sex:"女",
email:'99533212@qq.com'}db.addEmployee(employee,function(err,result){
if(err) console.log("[INSERT err]-",err.message)
console.log(result);})//删除员工db.deleteEmployee('Peter',function(err,result){
if(err) console.log("[DELETE err]-",err.message)
console.log(result);})//更新员工db.updateEmployee('Tim',23,function(err,result){
if(err) console.log("[UPDATE err]-",err.message)
console.log(result);})//查询员工db.getEmployee(function(err,result){
if(err) console.log("[GET err]-",err.message)
console.log(result);})
js怎么连接mysql的介绍就聊到这里吧，感谢你花时间阅读本站内容，更多关于js怎么连接数据库、js怎么连接mysql的信息别忘了在本站进行查找喔 。

推荐阅读


上一篇：用电视怎么连机顶盒看电视，用电视怎么连机顶盒看电视节目

下一篇：陈泗旭直播b站，陈泗旭直播唱的歌