Ajax 通過id 擷取名字 以及 所屬班級 擷取資料得jsp

來源:互聯網
上載者:User

<%@ 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>");
  }

%> 

相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.