前言
Node.js连接器入门
MariaDB Node.js连接器可通过Node.js存储库获得。 您可以使用npm安装它:
$ npm install mariadb
在之前使用ECMAScript:
const mariadb = require('mariadb');
const pool = mariadb.createPool({
host: '',
user:'myUser',
password: 'myPassword',
connectionLimit: 5
});
pool.getConnection()
.then(conn => {
conn.query("SELECT 1 as val")
.then((rows) => {
console.log(rows); //[ {val: 1}, meta: ... ]
//Table must have been created before
// " CREATE TABLE myTable (id int, val varchar(255)) "
return conn.query("INSERT INTO myTable value (?, ?)", [1, "mariadb"]);
})
.then((res) => {
console.log(res); // { affectedRows: 1, insertId: 1, warningStatus: 0 }
conn.end();
})
.catch(err => {
//handle error
console.log(err);
conn.end();
})
}).catch(err => {
//not connected
});
使用ECMAScript :
const mariadb = require('mariadb');
const pool = mariadb.createPool({
host: '',
user:'myUser',
password: 'myPassword',
connectionLimit: 5
});
async function asyncFunction() {
let conn;
try {
conn = await pool.getConnection();
const rows = await conn.query("SELECT 1 as val");
console.log(rows); //[ {val: 1}, meta: ... ]
const res = await conn.query("INSERT INTO myTable value (?, ?)", [1, "mariadb"]);
console.log(res); // { affectedRows: 1, insertId: 1, warningStatus: 0 }
} catch (err) {
throw err;
} finally {
if (conn) return conn.end();
}
}
MariaDB连接器可以在后端使用不同的API:Promise和Callback。 默认的API是Promise。 提供回调API是为了与mysql和mysql2 API兼容。
相关资料
MariaDB Node.js connector-MariaDB的npm官网
/package/mariadb
Non-blocking MariaDB and MySQL client for Node.js.
MariaDB and MySQL client, 100% JavaScript, with TypeScript definition, with the Promise API.
version before 2.4 is compatible with Node.js 6+ version after 2.4 is compatible with Node.js 10+
Documentation callback-api
本文同步分享在 博客“雪域迷影”(CSDN)。
如有侵权,请联系 support@ 删除。
本文参与“OSC源创计划”,欢迎正在阅读的你也加入,一起分享。