mysql-jdo v1.0.1

mysql-jdo

A node module: MYSQL JDO provides statement to secure SQL queries in Node.js

Version: 1.0.1

Author: Benny Polak

Set database settings

Open the module file (node_modules/mysql-jdo/index.js)

var connection 	= mysql.createConnection({
	host		: 'localhost',
	user 		: 'root',
	password 	: '',
	database 	: 'yourdatabase',
	dateStrings : true
});

Initiate the module

var db = require('mysql-jdo');

Using the module

Example 1:

db.JDOQuery('SELECT token FROM users WHERE username = :username', [{username: username}], function(response){
});

Example 2:

var stmt = [
	{date: date},
	{room: room}
];

db.JDOQuery('SELECT * FROM meetings WHERE date = :date AND room = :room', stmt, function(response){
});