Ajax 通过id 获取名字以及所属班级获取数据得jsp

最新推荐文章于 2023-03-07 10:33:15 发布

最新推荐文章于 2023-03-07 10:33:15 发布 · 211 阅读

文章标签：

#java

本文档展示了如何使用Java Web技术通过用户ID查询柜员及其所属银行的信息，并将查询结果以XML格式返回。该过程涉及从数据库中读取数据并将其转换为指定格式。

<%@ page contentType="text/html;charset=gb2312" %>

<%@ page import="java.util.List" %>
<%@ page import="java.util.Map" %>
<%@ page import="com.yc.ycportal.blockimp.service.CommonService" %>

response.setContentType("text/xml");

String userId = request.getParameter("userId");
//Create the response XML
if (userId != null && !"".equals(userId.trim())) {
List gyList = CommonService.getInstance().getDynamicTable("select * from dic_counter where counter_id='" + userId + "'");

if (gyList != null && gyList.size() == 1) {
Map gyMap = (Map) gyList.get(0);
String gyName = (String) gyMap.get("COUNTER_NAME");//柜员姓名
String organId = (String) gyMap.get("ORGAN_ID");//柜员所属行号

List organList = CommonService.getInstance().getDynamicTable("select * from dic_organ where organ_id='31" + organId + "'");
if( organList != null && organList.size() == 1) {
Map organMap = (Map) organList.get(0);
String organName = (String) organMap.get("ORGAN_NAME");//获取柜员所属行名

//组织需要返回的xml

StringBuffer xml = new StringBuffer("<?xml version=/"1.0/" encoding=/"gb2312/" ?><result><queryResult>success</queryResult><name>").append(gyName).append("</name><bank_id>").append(organId).append("</bank_id><bank_name>").append(organName).append("</bank_name></result>");

//Send the response back to the browser
response.getWriter().write(xml.toString());
}else{
response.getWriter().write("<result><queryResult>failed</queryResult></result>");
}
}else{
response.getWriter().write("<result><queryResult>failed</queryResult></result>");
}
}else{
response.getWriter().write("<result><queryResult>failed</queryResult></result>");
}