node-qsb.insertExampleUsingQsb.js

//node-qsb를 사용한 데이터베이스 쿼리문 관리
var qsb = require('node-qsb');
var mysql = require('../config/mysql.js')

var params = { 
    cols : ['email', 'passwd', 'uName', 'stdNum', 'major', 'phone', 'emailNotify', 'tIdx'],
    vals : [req.email, req.sha2passwd, req.uName, req.stdNum, req.major, req.phone, req.emailNotify, '5'],
}   
var usingQsbQs = new qsb()
    .insert("users")
    .values(params.cols, params.vals)
    .build();
    
mysql.execute(qs.returnString(), function(err, res) {
  ////
});