JDBC Wrapper for node.js
0.0.8
Please visit node-jdbc for information on installing with npm.
var jdbc = new ( require('jdbc') );
var config = {
libpath: __dirname + 'path/to/jdbc.jar',
drivername: 'com.java.driverclass',
url: 'url/to/database'
};
jdbc.initialize(config, function(err, res) {
if (err) {
console.log(err);
}
});
var genericQueryHandler = function(err, results) {
if (err) {
console.log(err);
} else if (results) {
console.log(results);
}
jdbc.close(function(err) {
if(err) {
console.log(err);
} else {
console.log("Connection closed successfully!");
}
});
};
jdbc.open(function(err, conn) {
if (conn) {
// SELECT statements are called with executeQuery
jdbc.executeQuery("SELECT * FROM table", genericQueryHandler);
// Table modifying statements (UPDATE/INSERT/DELETE/etc) are called with executeUpdate
jdbc.executeUpdate("UPDATE table SET column = value", genericQueryHandler);
// Use non-generic callbacks to handle queries individually and/or to nest queries
jdbc.executeUpdate("INSERT INTO table VALUES (value)", function(err, results) {
if(results > some_arbitrary_value) {
jdbc.executeQuery("SELECT * FROM table where column = value", genericQueryHandler);
}
});
}
});
- see above example for config object
- callback(error)
- opens a new connection
- callback(error)
- closes any existing connection
- callback(error)
- SELECT commands.
- callback(error, rset)
- table modifying commands (INSERT, UPDATE, DELETE, etc).
- callback(error, num_rows)
- where @num_rows is the number of rows modified