邏輯代碼塊需要放在Class的server static 修飾的method里。
不能直接把代碼塊放在Job里執(zhí)行。
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)));
}
}