遍历循环queryBySQL函数的使用例子

var sql="select * from tlk_签进合同 where item_合同编号='"+arr[i]+"'";
var query = queryBySQL(sql);
if(query!=null){
    for(var its = query.iterator();its.hasNext();){
        var datas=its.next();  
        temp+=datas.getItemValueAsString("项目名称")+"\n";
    }
}

注:上面看到sql是使用*,此函数只要有domainid字段和,你需要的相应字段即可.
可改为.select domainid,item_项目名称 from tlk_签进合同 were …

根据数据源进行遍历(queryByDSName)

try{
var sql = "select name,id from t_user where defaultapplication='"+getApplication()+"'";
var datas = queryByDSName("kd",sql);
if(datas!=null){
   for(var iterator = datas.iterator();iterator.hasNext();){
       var map1 = iterator.next();//取值
       var name= map1.get("name");  //自己看字段和select
       var value = map1.get("id");
    }
}
}catch(e){
}