其實我們使用的是SAP針對SAP HANA Express Editor發佈的nodejs SDK.
npm init創建一個新的nodejs應用:
執行下列命令行,從SAP的nodejs registry下載hana client:
npm config set @sap:registry https://npm.sap.com npm install @sap/hana-client
安裝完畢:
使用require導入sap hana client,在nodejs代碼裡使用其對HANA Express發起查詢:
<code>const hanaClient = require("@sap/hana-client");
const connection = hanaClient.createConnection();
const connectionParams = {
host : "hxehost",
port : 39013,
uid : "SYSTEM",
pwd : "********",
databaseName : "HXE"
}
connection.connect(connectionParams, (err) => {
if (err) {
return console.error("Connection error", err);
}
const whereClause = process.argv[2] ? `WHERE "group" = '${process.argv[2]}'` : "";
const sql = `SELECT "name" FROM food_collection ${whereClause}`;
connection.exec(sql, (err, rows) => {
connection.disconnect();
if (err) {
return console.error('SQL execute error:', err);
}
console.log("Results:", rows);
console.log(`Query '${sql}' returned ${rows.length} items`);
});
});/<code>
執行該應用,返回從SAP HANA Express查詢的結果:
閱讀更多 汪子熙的游泳故事 的文章
關鍵字: Node.js