逻辑代码块需要放在Class的server static 修饰的method里。
不能直接把代码块放在Job里执行。
server static void main(Args _args)
{
UserConnection userConnection;
Statement statement;
SqlSystem sqlSystem;
str sqlStatement;
SqlStatementExecutePermission sqlPermission;
ResultSet resultSet;
sqlStatement = 'SELECT CustGroup,Name,dataAreaId FROM CustGroup';
userConnection = new UserConnection();
statement = userConnection.createStatement();
sqlPermission = new SqlStatementExecutePermission(sqlStatement);
sqlPermission.assert();
resultSet = statement.executeQuery(sqlStatement);
CodeAccessPermission::revertAssert();
while (resultSet.next())
{
info(strFmt(
"%1 - %2 - %3",
resultSet.getString(1),
resultSet.getString(2),
resultSet.getString(3)));
}
}
