接口实现过程: 通过前台GET方法将参数传至JSP页面,由Jsp页面封装后传参调用后台方法,然后为前台返回<Items><Item>....</Item></Items>格式xml语句(在JSP页面打印出来)
URL: localhost:8080/xxx/xxx.jsp?Action=searchGetEntList&SysID=?&StreetID=?......
//前台
if (action.contains("searchGetEntList")) {
String SysID = request.getParameter("SysID");
String StreetID = request.getParameter("StreetID");
String Key = request.getParameter("Key");
String Name = request.getParameter("Name");
out.print(service.getSearchGetEntList(SysID, StreetID, Key, Name));
}
//后台
public String getSearchGetEntList (String SysID,String StreetID,String Key,String Name) {
// TODO add the real codeString xml = "<Items>";
//查询执法人员
String sql1 = "select e.ent_serial,e.name,p.account_id from table1 t,table2 e,table3 p where 1=1 and e.subdistrict_id='"+StreetID+"' and e.name like '%"+Key+"%' and t.orgnid='"+SysID+"' and t.id=e.subdistrict_id and t.orgnid=p.orgnid and p.account_id='"+Name+"' and e.flag='2'";
//链接数据库
SimpleJDBCOperator operator = new SimpleJDBCOperator();
List<Map<String, Object>> list = operator.GetList(sql1);
if (list != null && list.size() > 0) {
for (int i = 0; i < list.size(); i++) {
Map<String, Object> map = list.get(i);
String name = map.get("NAME") == null ? "" : map.get(
"NAME").toString();
String ent_serial = map.get("ENT_SERIAL") == null ? "" : map
.get("ENT_SERIAL").toString();
xml += "<Item>";
xml += "<EntID>" + ent_serial + "</EntID>";
xml += "<EntTitle>" + name + "</EntTitle>";
xml += "</Item>";
}
}
xml += "</Items>";
return xml;
}