SAP 使用SAP HANA XS Javascript接口
创建XS Javascript文件(以为.XSJS结尾)
创建简单XS Javascript 演示
语法参考(博主只做简单演示):Tutorial: Write Server-Side JavaScript Application Code
$.response.contenType = "text/html"; $.response.contenType("Hello,World!");
- 运行结果:
- 运行结果:
使用XS Javascript 暴露HANA数据源数据演示
var body = ''; var query='SELECT * FROM \"SFLIGHT\".\"SFLIGHT\"'; $.trace.debug(query); var conn = $.db.getConnection(); var pstmt = conn.prepareStatement(query); var rs = pstmt.executeQuery(); body = "MANDT \tCARRID \tCONNID \tFLDATE \tPEICE \tCURRENCY \tPLANETYPE \tSEATSMAX \tSEATSOCC \tPAYMENTSUM \tSEATSMAX_B \tSEATSOCC_B \tSEATSMAX_F \tSEATSOCC_F \n"; while(rs.next()) { body += rs.getString(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3)+"\t"+rs.getString(4)+"\t"+rs.getString(5)+"\t"+rs.getString(6)+"\t"+rs.getString(7)+"\t"+rs.getString(8)+"\t"+rs.getString(9)+"\t"+rs.getString(10)+"\t"+rs.getString(11)+"\t"+rs.getString(12)+"\t"+rs.getString(13)+"\t"+rs.getString(14)+"\n"; } $.response.setBody(body); $.response.contentType = 'application/vnd.ms-excel; charset=utf-16le'; $.response.headers.set('Content-Disposition','attachment; filename=Excel.xls'); $.response.headers.set('access-control-allow-origin','*'); $.response.status = $.net.http.OK;
- 运行结果(HANA数据库表SFLIGHT中的数据以Excel方式导出):
- 替换代码,则内容输出至网页
- 运行结果(HANA数据库表SFLIGHT中的数据以Excel方式导出):
post SAP-Garson
原文链接:https://blog.csdn.net/qq_30797051/article/details/122696300文章来自于网络,如果侵犯了您的权益,请联系站长删除!