public class GetGanshuList extends BaseServlet{
private static final String pgId = "GetGanshuList";
public static String GetGanshuListMain(String searchKey){
StringBuilder strSql = new StringBuilder();
StringBuilder rtnXml = new StringBuilder();
try {
strSql.append(" select ");
strSql.append(" ydbgansyu.szcode, ");
strSql.append(" coalesce(trim(mnametbl.szname),'') as szname, ");
strSql.append(" coalesce(trim(ydbgansyu.szgansyuname),'') as szgansyuname, ");
//strSql.append(" coalesce(trim(ydbgansyu.szgansyukana),'') as szgansyukana, ");
strSql.append(" ydbgansyu.szbunruicode ");
//strSql.append(" ydbgansyu.dninsertdate, ");
//strSql.append(" ydbgansyu.szinsertman, ");
//strSql.append(" ydbgansyu.szprogramnm, ");
//strSql.append(" ydbgansyu.dnupdatedate, ");
//strSql.append(" ydbgansyu.szupdateman, ");
//strSql.append(" ydbgansyu.szupdateprogramnm, ");
//strSql.append(" ydbgansyu.szfiller ");
strSql.append(" from ");
strSql.append(" ydbgansyu, ");
strSql.append(" mnametbl ");
strSql.append(" where ");
strSql.append(" ydbgansyu.szbunruicode = mnametbl.szcode ");
strSql.append(" and ");
strSql.append(" mnametbl.szkubun = '85' ");
if(searchKey != ""){
strSql.append(" and ydbgansyu.szgansyukana LIKE '%' || ? || '%' ");
//System.out.println("&&&&&&&&&&&&" + searchKey + "&&&&&&&&&&&&&&&");
}
strSql.append(" order by ");
strSql.append(" ydbgansyu.szbunruicode ");
ArrayList<String> stmList = new ArrayList<String>();
if(searchKey != ""){
stmList.add(searchKey);
}
//System.out.println(strSql);
rtnXml = CreateXml.GetDataXml(pgId, strSql, stmList);
//System.out.println(rtnXml.toString());
} catch (Exception e) {
// TODO: handle exception
rtnXml.delete(0, rtnXml.length());
rtnXml.append(Common.XMLDataError(pgId, e.toString()));
}
return rtnXml.toString();
}
rtnXml是一个描写XML文件的String,请问象这样的函数,返回描写XML的String 能有什么作用呢??
private static final String pgId = "GetGanshuList";
public static String GetGanshuListMain(String searchKey){
StringBuilder strSql = new StringBuilder();
StringBuilder rtnXml = new StringBuilder();
try {
strSql.append(" select ");
strSql.append(" ydbgansyu.szcode, ");
strSql.append(" coalesce(trim(mnametbl.szname),'') as szname, ");
strSql.append(" coalesce(trim(ydbgansyu.szgansyuname),'') as szgansyuname, ");
//strSql.append(" coalesce(trim(ydbgansyu.szgansyukana),'') as szgansyukana, ");
strSql.append(" ydbgansyu.szbunruicode ");
//strSql.append(" ydbgansyu.dninsertdate, ");
//strSql.append(" ydbgansyu.szinsertman, ");
//strSql.append(" ydbgansyu.szprogramnm, ");
//strSql.append(" ydbgansyu.dnupdatedate, ");
//strSql.append(" ydbgansyu.szupdateman, ");
//strSql.append(" ydbgansyu.szupdateprogramnm, ");
//strSql.append(" ydbgansyu.szfiller ");
strSql.append(" from ");
strSql.append(" ydbgansyu, ");
strSql.append(" mnametbl ");
strSql.append(" where ");
strSql.append(" ydbgansyu.szbunruicode = mnametbl.szcode ");
strSql.append(" and ");
strSql.append(" mnametbl.szkubun = '85' ");
if(searchKey != ""){
strSql.append(" and ydbgansyu.szgansyukana LIKE '%' || ? || '%' ");
//System.out.println("&&&&&&&&&&&&" + searchKey + "&&&&&&&&&&&&&&&");
}
strSql.append(" order by ");
strSql.append(" ydbgansyu.szbunruicode ");
ArrayList<String> stmList = new ArrayList<String>();
if(searchKey != ""){
stmList.add(searchKey);
}
//System.out.println(strSql);
rtnXml = CreateXml.GetDataXml(pgId, strSql, stmList);
//System.out.println(rtnXml.toString());
} catch (Exception e) {
// TODO: handle exception
rtnXml.delete(0, rtnXml.length());
rtnXml.append(Common.XMLDataError(pgId, e.toString()));
}
return rtnXml.toString();
}
rtnXml是一个描写XML文件的String,请问象这样的函数,返回描写XML的String 能有什么作用呢??
var xmlDoc = xmlHttp.responseXML.getElementsByTagName('item');
for(var i=0;i<xmlDoc.length;i++){
var aNode=xmlDoc.item(i);
var serviceids = aNode.getElementsByTagName( 'serviceid' );
................................
..........................................
我只能大概举个例子,应该是这样.