Node.js 连接 MySQL 并进行数据库操作

最新推荐文章于 2024-09-24 18:56:41 发布

hsapphire

最新推荐文章于 2024-09-24 18:56:41 发布

阅读量80

点赞数

文章标签： MySQL JavaScript ViewUI

本文链接：https://blog.csdn.net/hsapphire/article/details/83891488

版权

Node.js是一套用来编写高性能网络服务器的JavaScript工具包

代码片段(6)

[代码] 安装 node-mysql

`1`	`$ npm` `install` `mysql`

[代码] 创建测试表

 
    1//数据库名 NodeSample 
 
  
 
CREATE TABLE `NodeSample`.`MyTable` (  
 
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,  
 
  `firstname` VARCHAR( 20 ) NOT NULL ,  
 
  `lastname` VARCHAR( 20 ) NOT NULL ,  
 
  `message` TEXT NOT NULL 
 
    8) ENGINE = MYISAM ;

[代码] 连接数据库

 
var sys = require('sys');  
 
   
 
var Client = require('mysql').Client;  
 
var client = new Client();  
 
   
 
client.user = 'someuser';  
 
client.password = 'password';  
 
   
 
client.connect(function(error, results) {  
 
  if(error) {  
 
    console.log('Connection Error: ' + error.message);  
 
    return;  
 
  }  
 
  console.log('Connected to MySQL');  
 
    15});

[代码] 打开数据库

 
ClientConnectionReady = function(client)  
 
    02{ 
 
    client.query('USE NodeSample', function(error, results) {  
 
        if(error) {  
 
            console.log('ClientConnectionReady Error: ' + error.message);  
 
            client.end();  
 
            return;  
 
        }  
 
    });  
 
    10};

[代码] 完成数据库操作程序

 
var sys = require('sys');  
 
   
 
var Client = require('mysql').Client;  
 
var client = new Client();  
 
   
 
client.user = 'someuser';  
 
client.password = 'password';  
 
   
 
console.log('Connecting to MySQL...');  
 
   
 
client.connect(function(error, results) {  
 
  if(error) {  
 
    console.log('Connection Error: ' + error.message);  
 
    return;  
 
  }  
 
  console.log('Connected to MySQL');  
 
  ClientConnectionReady(client);  
 
    18}); 
 
   
 
ClientConnectionReady = function(client)  
 
    21{ 
 
    client.query('USE NodeSample', function(error, results) {  
 
        if(error) {  
 
            console.log('ClientConnectionReady Error: ' + error.message);  
 
            client.end();  
 
            return;  
 
        }  
 
        ClientReady(client);  
 
    });  
 
    30}; 
 
   
 
ClientReady = function(client)  
 
    33{ 
 
  var values = ['Chad', 'Lung', 'Hello World'];  
 
  client.query('INSERT INTO MyTable SET firstname = ?, lastname = ? , message = ?', 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);  
 
    47} 
 
   
 
GetData = function(client)  
 
    50{ 
 
  client.query(  
 
    'SELECT * FROM MyTable',  
 
    function selectCb(error, results, fields) {  
 
      if (error) {  
 
          console.log('GetData Error: ' + error.message);  
 
          client.end();  
 
          return;  
 
      }  
 
      // Uncomment these if you want lots of feedback  
 
      //console.log('Results:');  
 
      //console.log(results);  
 
      //console.log('Field metadata:');  
 
      //console.log(fields);  
 
      //console.log(sys.inspect(results));  
 
   
 
      if(results.length > 0)  
 
      {  
 
        var firstResult = results[0];  
 
        console.log('First Name: ' + firstResult['firstname']);  
 
        console.log('Last Name: ' + firstResult['lastname']);  
 
        console.log('Message: ' + firstResult['message']);  
 
      }  
 
  });  
 
   
 
  client.end();  
 
  console.log('Connection closed');  
 
    77};