{"inframe":false,"title":"运行 SQL 语句","hidden":false,"roles":{"dev":1},"children":[{"configs":{"serverScript":"//可以使用app.run运行所有sql语句，包括dql, ddl, dml以及对过程和函数的访问等\n//使用app.run系统会自动释放用到的connection, statement和resultSet\n//具体使用说明请参考app.run方法和query控件\nvar affectedCount = app.run('update WB_MISC set INT_FIELD=35 where 1=0');\nvar text = [],\n  result = app.run('select * from WB_MISC');\nwhile (result.next()) {\n  text.push(result.getString('STRING_FIELD'));\n}\napp.send(text.join(',')); //发送到客户端","itemId":"module"},"children":[],"expanded":false,"type":"module"}],"pageLink":"","iconCls":""}