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 能有什么作用呢??
解决方案 »
- TextField找不到符号-真心请教!!
- GUI组件容器刷新问题
- 虚心请教一个问题
- 页面的加了这个上传的enctype="multipart/form-data,怎么取字段的数组值,不能request.getParameterValues(""),急!!!
- 字符串查找算法,高手要来看看啊!!
- SQLServer自增长字段的问题
- 初学者问题! 请指点!1
- 插入数据出错,怎么会这样,进来帮个忙吧!
- Ant调用JAVA程序,如何让程序执行到某个阶段后进入后台执行,让Ant与该程序并行执行?
- 請問 TreeMap 排序方法
- 请高手指点JAVA I/O流和异常处理的三道习题
- 怎么做java没框架的jframe(在线等)
var xmlDoc = xmlHttp.responseXML.getElementsByTagName('item');
for(var i=0;i<xmlDoc.length;i++){
var aNode=xmlDoc.item(i);
var serviceids = aNode.getElementsByTagName( 'serviceid' );
................................
..........................................
我只能大概举个例子,应该是这样.