首页 > 安全资讯 >

NodeJS与Mysql的交互

13-08-18

把Mysql Module装到NodeJS中Js代码$npm install Mysql  JS脚本 mysqlTest.jsJs代码// mysqlTest.js//加载mysql Modulevar Client = require('mysql').Client, client = new Client(),  ...

把Mysql Module装到NodeJS中

Js代码  
$npm install Mysql  
  JS脚本 mysqlTest.js

Js代码 

// mysqlTest.js 
//加载mysql Module 
var Client = require('mysql').Client, 
    client = new Client(), 
   
  //要创建的数据库名 
    TEST_DATABASE = 'nodejs_mysql_test', 
    //要创建的表名 
    TEST_TABLE = 'test'; 
 
//用户名 
client.user = 'root'; 
//密码 
client.password = 'root'; 
//创建连接 
client.connect(); 
 
client.query('CREATE DATABASE '+TEST_DATABASE, function(err) { 
  if (err && err.number != Client.ERROR_DB_CREATE_EXISTS) { 
    throw err; 
  } 
}); 
 
// If no callback is provided, any errors will be emitted as `'error'` 
// events by the client 
client.query('USE '+TEST_DATABASE); 
client.query( 
  'CREATE TABLE '+TEST_TABLE+ 
  '(id INT(11) AUTO_INCREMENT, '+ 
  'title VARCHAR(255), '+ 
  'text TEXT, '+ 
  'created DATETIME, '+ 
  'PRIMARY KEY (id))' 
); 
 
client.query( 
  'INSERT INTO '+TEST_TABLE+' '+ 
  'SET title = ?, text = ?, created = ?', 
  ['super cool', 'this is a nice text', '2010-08-16 10:00:23'] 
); 
 
var query = client.query( 
  'INSERT INTO '+TEST_TABLE+' '+ 
  'SET title = ?, text = ?, created = ?', 
  ['another entry', 'because 2 entries make a better test', '2010-08-16 12:42:15'] 
); 
 
client.query( 
  'SELECT * FROM '+TEST_TABLE, 
  function selectCb(err, results, fields) { 
    if (err) { 
      throw err; 
    } 
 
    console.log(results); 
    console.log(fields); 
    client.end(); 
  } 
); 

相关文章
最新文章
热点推荐