part-jdbc
v0.3.4
Published
Node Module JDBC wrapper
Downloads
9
Readme
JDBC API Wrapper for node.js
Latest Version 0.3.3
Installation
Release: npm i --save part-jdbc
نحوه ی استفاده :
//in config.js
var jinst = require('jdbc/lib/jinst');
if (!jinst.isJvmCreated()) {
jinst.addOption("-Xrs");
jinst.setupClasspath(['./ojdbc7.jar']);
}
exports.JDBCConfig = {
// Required
url: 'exampleUrl',
properties: {
user: user db,
password: 'pass db'
// Other driver supported properties can be added here as well.
}
};
Query the database.
Select statement with auto commit.
openConn(config.JDBCConfig)
.then(function (jdbc) {
var query = "select name , userName , password from myTable";
queryResult(jdbc, query )
.then(function (result) {
console.log(result);
})
.fail(function (error) {
console.log("error in result:",error);
})
.done(function () {
});
})
.fail(function (error) {
console.log("error in OpenConn:",error);
});
Select statement with manual commit.
openConn(config.JDBCConfig, false)
.then(function (jdbc) {
var query = "select name , userName , password from myTable";
queryResult(jdbc, query )
.then(function (result) {
console.log(result);
})
.fail(function (error) {
console.log("error in result:",error);
})
.done(function () {
});
})
.fail(function (error) {
console.log("error in OpenConn:",error);
});
Update statement
openConn(config.JDBCConfig)
.then(function (jdbc) {
var query =
"update myTable set name = 'vahid' , password = '123456'";
queryResultUpdate(jdbc, query)
.then(function (count) {
//count: number of updated rows
console.log(count);
})
.fail(function (error) {
console.log("error in result:",error);
closeConn(jdbc,config.JDBCConfig);
})
.done(function () {
closeConn(jdbc,config.JDBCConfig);
});
})
.fail(function (error) {
console.log("error in OpenConn:",error);
});
reqular insert statement
openConn(config.JDBCConfig)
.then(function (jdbc) {
var query =
"insert into myTable (name , password) VALUES ('vahid','123456')";
var getGeneratedKeys = false;
queryResultInsert(jdbc, query , getGeneratedKeys )
.then(function (count) {
//count:number of row inserted
console.log(count);
})
.fail(function (error) {
console.log("error in result:",error);
closeConn(jdbc,config.JDBCConfig);
})
.done(function () {
closeConn(jdbc,config.JDBCConfig);
});
})
.fail(function (error) {
console.log("error in OpenConn:",error);
});
Insert statement with generated Keys
openConn(config.JDBCConfig)
.then(function (jdbc) {
var query =
"insert into myTable (name , password) VALUES ('vahid','123456')";
var getGeneratedKeys = true;
queryResultInsert(jdbc, query , getGeneratedKeys )
.then(function (data) {
console.log(data);
/*
console.log output:
{count: count, rowId: rowIdHash}
*/
})
.fail(function (error) {
console.log("error in result:",error);
closeConn(jdbc,config.JDBCConfig);
})
.done(function () {
});
})
.fail(function (error) {
console.log("error in OpenConn:",error);
});
Table of contents
You can insert a table of contents using the marker [TOC]
:
[TOC]