node下的MYSQL的模糊查询百度资料比较少,google了下才找到方法
let mysql = require('mysql');
let config = {
host: 'localhost',
user: 'root',
password: 'root',
database: 'xxx',
port: 3306
}
let sql = "SELECT * FROM product"
if(req.body.name){
// 模糊查询两种方法直接在SQL语句后加 mysql.escape("%"+req.body.name+"%")
// sql += " WHERE product_name LIKE "+mysql.escape("%"+req.body.name+"%")
sql += " WHERE product_name LIKE ?"
}
sql+= ' limit ? offset ?';
let param = [ "%"+req.body.name+"%",pageNum, (page - 1) * pageNum ]
pool.getConnection(function(err,conn){
conn.query(sql,param,function(err,result){
if(err){
console.log("查询失败")
console.log(err)
} else {
conn.release();
console.log(result)
}
})
}