Node.js用MariaDBへのSQL文の発行例のコード片。

mariadbfornodejs.txt

const mariadb = require('mariadb');
const pool = mariadb.createPool({
    host: "(ホスト名またはホストのIPアドレス)",
    user: "(ユーザ名)",
    password: "(パスワード)",
    database: "(データベース名)",
    connectionLimit: 5
});

const server = http.createServer
	(function (request, response) {
		var urlp = request.url;
		if (urlp.startsWith('/api/get')) {
			response.writeHead(200, {"Content-Type": "text/plain"});
			var conn = pool.getConnection()
				.then(conn => {
					conn.query("(SQL文(SELECT文))")
						.then(rows => {
							response.end(JSON.stringify(rows));
						})
						.catch(err => {
							response.end("Hello MariaDB!!\nBut there is some error(s): "+err);
						});
					conn.release();
				})
				.catch(err => {
					response.end("Hello World!!\nBut there is some error(s): "+err);
				});
		} 
    // (中略)
});
// (後略)