nodeJS连接MySQL数据库

nodeJS连接MySQL数据库,首先创建一个数据库及表。如下: 

create databases node;
create table test( id int AUTO_INCREMENT PRIMARY KEY , name char(50) )ENGINE=InnoDB DEFAULT CHARSET=utf8;

安装MySQL驱动: 

$ npm install mysql


下面是nodeJS代码: 

var sys = require(‘util‘); 
console.log(‘正在连接MySQL...‘); 
var client = require(‘mysql‘).createClient({‘host‘:‘localhost‘,‘port‘:3306,‘user‘:‘root‘,‘password‘:‘xxx‘});

clientConnectionReady = function(client) 
{
    client.query(‘use node‘, function(error, results) { 
        if(error) { 
            console.log(‘ClientConnectionReady Error: ‘ + error.message); 
            client.end(); 
            return; 
        }else{
 	    console.log(‘已经连接上MySQL....‘);
	} 
        clientReady(client); 
    }); 
};

clientReady = function(client) { 
    var values = [‘不错啊‘]; 
    client.query(‘insert into test set name = ?‘, values, 
        function(error, results) { 
            if(error) { 
                console.log("ClientReady Error: " + error.message); 
                client.end(); 
                return; 
            } 
            console.log(‘Inserted: ‘ + results.affectedRows + ‘ row.‘); 
            console.log(‘Id inserted: ‘ + results.insertId); 
        } 
    ); 
    getData(client); 
}

getData = function(client) { 
    client.query( 
        ‘select * from test‘, 
        function selectCb(error, results, fields) { 
           if (error) { 
                console.log(‘GetData Error: ‘ + error.message); 
                client.end(); 
                return; 
           } 

	   for(var i=0; i<results.length; i++){
		var firstResult = results[i]; 
        	console.log(‘id: ‘ + firstResult[‘id‘]+‘    name: ‘ + firstResult[‘name‘]);
	   }

    	}
    ); 
    client.end(); 
    console.log(‘关闭MySQL连接...‘); 
};



clientConnectionReady(client);

 

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。