...
代码块 | ||
---|---|---|
| ||
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); } |
...