在myapps的平台,调用queryByDSName(),实际上底层是调用
function queryByDSName(dsName,sql){
var process = createProcess("cn.myapps.core.dynaform.dts.datasource.ejb.DataSourceProcess");
return process.queryDataSourceSQL(dsName,sql,getApplication());
}
如果你是需要在jsp中查询数据,之后遍历,可以试试参考一下的方法
<%
DataSourceProcessBean bean = new DataSourceProcessBean();
String applicationid = "11e4-a82f-5ee0afbe-9eb9-b7c5c8e327bc";
Collection<Map> aa = (Collection<Map>)bean.queryDataSourceSQL("obpm_oa","select * from tlk_xxxxx",applicationid);
String html = "<ul id='ulList'>";
for(Iterator<Map> iter = aa.iterator();iter.hasNext();){
Map m = iter.next();
String title = (String)m.get("item_name");
html += "<li class='left_icon' type='"+title+"' ><a href='#'>";
html += title;
/* String create = (String)m.get("item_title"); */
html += "</a></li>";
}
html += "</ul>";
out.println(html);
%>
|