- 创建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方式导出):
- 替换代码,则内容输出至网页
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXX