純粹記錄一下最基礎寫法,幾乎沒有寫什么邏輯,寫法也并不是很完善(因為我自己也剛剛摸索出來這么寫可以…= =!) ? ?望高手指教 ? 也希望能夠幫到比我還新的新手….
//1.insert操作
let insertSql = ‘insert into User(username,password,name,gender,age) values (?,?,?,?,?)’;
let insertParams = [username, password, name, gender, age];
mysqlConnection.query(insertSql, insertParams, function (error, results, fields) {
if (error) ?throw error;
return results;
});
//2.select操作(我自己測試的時候發現,字符串類型的列,要給參數額外增加引號,否則會被當做數字類型或列名來進行處理)
let selectSql = ‘select id from User where username = ”.concat(username, ” and password = ”, password, ”’);
mysqlConnection.query(selectSql, function (error, results, fields) {
if(error) throw error;
return results;
});
//3.delete操作
let deleteSql = ‘delete from user where id = ”.concat(id, ”’);
mysqlConnection.query(deleteSql, function (error, results, fields) {
if (error) throw error;
return results;
});
//4.update操作
let updateSql = ‘update User set age = 30 where id = ”.concat(id, ”’);
mysqlConnection.query(updateSql, function (error, results, fields) {
if (error) throw error;
return results;
});
? 版權聲明
文章版權歸作者所有，未經允許請勿轉載。
THE END
