页面历史

function main(spreadsheetReport) {
    //执行查询
    var ret = spreadsheetReport.remoteInvoke("DataSourceService", "executeNoCacheable", "['DS.10mysql-test','select col1 from newtable']");
	//如果是变量sql1、如果是变量sql
	// var sql = "select count(*) from categories"
	//2、如果是变量sql，单引号要\\转义
	// var sql = "select 1 from categories where CategoryName = \\'调味品\\'";
	//3、如果sq里面还有变量要嵌套，并且还有单引号
	//var des = '香甜可口的果酱、调料、酱汁和调味品';
	//var sql = "select 1 from categories where CategoryName = \\'调味品\\' and Description = \\'"+ des + "\\'";
    // var ret = spreadsheetReport.remoteInvoke("DataSourceService", "executeNoCacheable", "['DS.northwind_j','"+ sql +"']");
    // logger.info(ret);
    var rets = eval('(' + ret + ')');
    logger.info("查询数据行数=" + rets.result.data.length);
    for (var i = 0; i < rets.result.data.length; i++) {
        logger.info(rets.result.data[i][0].displayValue); //显示值
        logger.info(rets.result.data[i][0].type); //类型

    }
    //执行更新
    ret = spreadsheetReport.remoteInvoke("DataSourceService", "executeUpdate", "['DS.10mysql-test','update newtable set col1 = 1231 where col1=22']");
    //logger.info(ret);
    rets = eval('(' + ret + ')');
    logger.info("更新结果=" + rets.succeeded);
}