鏈枃浠嬬粛鐐硅禐+鍏虫敞+鏀惰棌=瀛︿範浜嗐€傝櫧鐒舵垜浠笉浼氱洿鎺ヤ娇鐢ㄥ師鐢熺殑NodeJS鏂瑰紡鏉ュ紑鍙戝悗鍙帮紝浣嗘槸浜嗚ВSQL娉ㄥ叆杩樻槸寰堟湁蹇呰鐨勩€傛湰鏂囦娇鐢∟odeJS+MySQL鏉ヨ瑙QL娉ㄥ叆銆係QL娉ㄥ叆鏀诲嚮鏄竴绉嶉潪甯稿彜鑰佺殑鏀诲嚮鏂瑰紡锛屼粠web2.0璇炵敓寮€濮嬪氨鏈塖QL娉ㄥ叆鏀诲嚮銆傞€氬父鍑虹幇鍦ㄨ緭鍏ユ銆佹枃鏈绛夊墠绔粍浠朵腑銆傚湪杈撳叆鍐呭涓姞鍏QL璇彞锛屼竴璧蜂紶缁欏悗鍙般€傚悗鍙颁竴涓嶅皬蹇冿紝灏变細鎶婂墠绔紶杩囨潵鐨凷QL璇彞鎷兼帴鎴愯嚜宸辩殑SQL璇彞锛屾渶鍚庢嫾鎺ユ垚涓€娈垫敾鍑讳唬鐮併€傛墍浠ヤ竴瀹氳鏈洦缁哥吉锛屽惁鍒欏彲鑳戒細鍑虹幇鏁版嵁娉勯湶锛岀敋鑷虫湁琚垹搴撶殑鍙兘銆係QL娉ㄥ叆婕旂ず浠ョ櫥褰曚负渚嬨€傛垜鍦∕ySQL涓坊鍔犱簡涓€寮爑sers琛紝閲岄潰瀛樻斁鐨勬槸鐢ㄦ埛鍚嶅拰瀵嗙爜銆傚湪users琛ㄤ腑锛屾垜鏂板缓浜嗕竴鏉℃暟鎹細insertintousers(username,password,realname)values('leihou','123','Leihou');鏁版嵁鐨勫惈涔夋槸锛歶sername:'leihou'password:'123'realname:'杩呴浄鐚?姝ゆ椂鎴戝湪NodeJS鍚庡彴鍒涘缓浜嗕竴涓櫥褰曟柟娉昪onstmysql=require('mysql')//鍒涘缓涓€涓猚onnectionobjectconstcon=mysql.createConnection({host:'localhost',//鍦板潃user:'root',//杩炴帴鏁版嵁搴撶殑鐢ㄦ埛瀵嗙爜锛?123456',//杩炴帴鏁版嵁搴撶鍙ｇ殑瀵嗙爜锛?3306',//榛樿绔彛database:'testdb'//鏁版嵁搴撳悕})//寮€濮嬭繛鎺on.connect()//鎵цsql鍑芥暟functionexec(sql){constpromise=newPromise((resolve,reject)=>{con.query(sql,(err,result)=>{if(err){reject(err)return}resolve(result)})})returnpromise}//鐧诲綍鏂规硶constlogin=(username,password)=>{constsql=`selectusername,realnamefromuserswhereusername='${username}'andpassword='${password}';`console.log(sql)returnexec(sql).then(rows=>{returnrows[0]||{}})}浠ヤ笂灏辨槸鐧诲綍鏂规硶銆傛渶鍚庯紝鍙互閫氳繃銆奛odeJS http璇锋眰銆嬩腑鎻愬埌鐨勬柟娉曚负鍓嶇鍒涘缓涓€涓帴鍙ｃ€傜敱浜庣晫闈㈤儴鍒嗕笉鏄湰鏂囩殑閲嶇偣锛岃繖閲屾墦绠楃暐杩囷紙鍋锋噿锛夈€傝繖鏃跺€欏啀鍒涘缓涓€涓狧TML椤甸潰锛屽ぇ鑷寸敓鎴愬唴瀹癸紝鐒跺悗鐢ˋjax杩炴帴鍚庡彴銆傚伔鎳掔殑璇濆彲浠ョ洿鎺ョ敤postman娴嬭瘯銆傛寜鐓т笂闈㈢殑鐧诲綍鏂瑰紡锛屽湪鍓嶇杈撳叆濡備笅鍐呭灏卞彲浠ョ煡閬撳彲浠ョ櫥褰曟垚鍔熶簡銆?鍓嶅悗鏈夌┖鏍笺€傚瘑鐮佸彲浠ラ殢鎰忚緭鍏ャ€傛渶鍚庢嫾鎺ョ殑SQL璇彞鏄痵electusername,realnamefromuserswhereusername='leihou'--'andpassword='aslkfjsaf';娉ㄦ剰鎴戞槸闅忎究杈撳叆鐨勫瘑鐮併€傚湪MySQL涓紝--浠ｈ〃娉ㄩ噴銆傛墍浠ヤ笂闈㈢殑璇彞灏卞彉鎴愪簡鏌ヨ鐢ㄦ埛鍚嶄负leihou鐨勬暟鎹€傚瘑鐮佽嚜鐒剁粫杩囦簡銆備笂闈㈣緭鍏ョ殑鐢ㄦ埛鍚嶅唴瀹圭粫杩囦簡鐧诲綍锛屾硠闇蹭簡淇℃伅銆備絾鏄鏋滃埆浜鸿鍒犻櫎浣犵殑琛紝鍚庢灉灏卞緢涓ラ噸浜嗐€備緥濡傚湪鐢ㄦ埛鍚嶈緭鍏ユ涓緭鍏ワ細leihou'锛涗粠鐢ㄦ埛涓垹闄わ紱-銆傚彧闇€鍒犻櫎鐢ㄦ埛琛ㄣ€傞槻姝QL娉ㄥ叆鏀诲嚮鐨勬柟娉曞お鑰佷簡锛屾湁鍗佸嚑骞寸殑鍘嗗彶浜嗐€傛墍浠ュ熀鏈殑搴斿鏂规硶宸茬粡鎴愮啛銆傛瘮濡傚鍓嶇浼犳潵鐨勫瓧绗︿覆杩涜杞爜銆備娇鐢∟odeJS涓嬭浇鐨凪ySQL渚濊禆鍖呬腑鎻愪緵浜嗚鏂规硶锛歟scape銆?/鐪佺暐閮ㄥ垎浠ｇ爜constmysql=require('mysql')//鐪佺暐杩炴帴瀵硅薄鐨勫垱寤?/鐪佺暐杩炴帴鐨勫紑濮?/缁熶竴鎵цsql鍑芥暟constescape=mysql.escapeconstlogin=(username,password)=>{username=escape(username)password=escape(password)constsql=`selectusername,realnamefromuserswhereusername=${username}andpassword=${password};`console.log(sql)杩斿洖exec(sql)銆倀hen(rows=>{returnrows[0]||{}})}escape鏂规硶杩囨护鍚庣殑瀛楃涓蹭細琚浆涔夈€傛鏃跺鏋滆緭鍏ョ敤鎴峰悕leihou'--锛屽悗鍙版帶鍒跺彴浼氭墦鍗板涓嬪唴瀹癸細selectusername,realnamefromuserswhereusername='leihou\'--'andpassword='123345';鍙互鐪嬪埌leihou'鍚庨潰鐨勫崟寮曞彿琚浆涔変簡銆備互涓婂氨鏄疢ySQL濡備綍闃叉SQL娉ㄥ叆鏀诲嚮銆傛帹鑽愰槄璇火煈嶃€奛odeJS http璇锋眰銆嬸煈嶃€奛odeJS 5鍒嗛挓 杩炴帴MySQL 澧炲垹鏀规煡銆嬸煈嶃€奛odeJS Stream鍏ラ棬銆嬸煈嶃€奛odeJS 鎿嶄綔cookie銆嬸煈嶃€奛odeJS 5鍒嗛挓 杩炴帴 Redis 璇诲啓鎿嶄綔銆嬸煈嶃€奛odeJS 璇诲啓鏂囦欢銆嬬偣璧?鍏虫敞+鏀惰棌=瀛︿範浜?/p>
