SAP HANA XS 的xsjs举例

SAPmatinal

已于 2023-02-03 13:58:58 修改

阅读量2.6k

点赞数

分类专栏： HANA进阶学习文章标签： hana ui5 HANA XS

于 2017-01-11 17:45:35 首次发布

本文链接：https://blog.csdn.net/sapmatinal/article/details/54345969

版权

HANA进阶学习专栏收录该内容

194 篇文章 46 订阅

订阅专栏

    function doImport() {
    var data = '', conn = $.db.getConnection(), pstmt;  

    if($.request.body){
        data = $.request.body.asString();     
    }

    var conn = $.db.getConnection();
    var pstmt = conn.prepareStatement( 'INSERT INTO "TEST"."UPLOAD" (ID, MIMETYPE, DATA) VALUES(?,?,?)' );

    pstmt.setInteger(1,1);
    pstmt.setString(2,"text/plain");
    pstmt.setString(3,data);

    pstmt.execute();
    pstmt.close();

    conn.commit();
    conn.close();

    doResponse(200,'');

    $.response.contentType = 'text/plain';
    $.response.setBody('Upload ok');
    $.response.status = 200;
}