ajax로 받아서 동적 테이블

controller

@SuppressWarnings("unchecked") @RequestMapping("/b2c/b2cDeleteCommission.do") //수수료 삭제     public ModelAndView b2cDeleteCommission(HttpServletRequest request, @RequestParam HashMap<String, Object>  paramMap) throws Exception{     ModelAndView mav = new ModelAndView();     HttpSession session = request.getSession(false);         HashMap<String, Object> userSessionInfo = (HashMap<String, Object>) session.getAttribute("userSsInfo");                 System.out.println("(String)paramMap.get('4')"+ (String)paramMap.get("financialCd"));     String loanCommissionCd = (String)paramMap.get("loanCommissionCd");     String dealingCompCd = (String)paramMap.get("dealingCompCd");     String financialCd = (String)paramMap.get("financialCd");          paramMap.put("userId", (String)userSessionInfo.get("LOAN_ADM_ID"));     paramMap.put("loanCorpCd", (String)userSessionInfo.get("LOAN_CORP_CD"));     paramMap.put("loanCommissionCd", loanCommissionCd);     paramMap.put("dealingCompCd", dealingCompCd);         paramMap.put("financialCd", financialCd);                  //List<HashMap<String, Object>> selectCommissionList = b2cCommissionService.selectCommissionList(paramMap);      b2cCommissionService.b2cDeleteCommission(paramMap);      b2cCommissionService.insertCommitionLog(paramMap);              mav.addObject("userInfo", userSessionInfo);     //mav.addObject("commissionList",selectCommissionList);         mav.setViewName("b2c/commission/b2cCommissionList");     return mav;     }

js

function fn_selectCommissionList(){ var startNum = $("#startNum").val();               //리스트 시작번호 var endNum = $("#endNum").val();               //리스트 끝번호 $.ajax({         type: "POST",         contentType: 'application/x-www-form-urlencoded; charset=utf-8;',          url: "/b2c/b2cSelectCommissionList.do",         dataType:"json",         data: {"startNum":startNum, "endNum":endNum},         async: false,          cache: false,         success: function(data){         var commissionList = data.commissionList;         //alert(commissionList);         if(commissionList.length > 0){         $("#hiddenDiv").hide();     startNum = Number(data.endNum) + 1;     endNum = Number(data.endNum) + 2; //보여주는 갯수만큼 설정         $("#startNum").val(startNum);         $("#endNum").val(endNum);                 $("#hiddenListDiv").show();                 if(startNum > commissionList[0].TOTAL){         $("#btnMore").hide();         }else{         $("#btnMore").show();         }                 for(var i=0;i<commissionList.length;i++){         var html = "";         html += "<tr style='border:1px solid black'>";         html += "<td style='cursor:pointer;' onclick='fn_commissionDetail(" + '"' + commissionList[i].LOAN_COMMISSION_CD + '","' +commissionList[i].DEALING_COMP_CD + '","' + commissionList[i].FINANCIAL_INSTITUTION_CD + '"' + ")'>";         html += commissionList[i].DEALING_COMP_NM + " 매매단지<br/>";         html += commissionList[i].FINANCIAL_INSTITUTION_NM + "은행<br/>";         html += "</td>";         html += "</tr>";         $("#tbodyList").append(html);         }                   }         },         error:function (){             alert("서버와 통신중 에러가 발생하였습니다.");         }     }); }

html

<table> <thead></thead> <tbody id="tbodyList"></tbody> </table>

 

sql

SELECT ROWNUM                , TOTAL   , LOAN_CORP_CD   , LOAN_COMMISSION_CD   , DEALING_COMP_CD   , DEALING_COMP_NM   , FINANCIAL_INSTITUTION_CD   , FINANCIAL_INSTITUTION_NM   , COMMISSION_1   , COMMISSION_2   , COMMISSION_3   , DEL_YN       FROM (SELECT @ROWNUM := @ROWNUM + 1 AS ROWNUM         , T.TOTAL   , LOAN_CORP_CD        , LOAN_COMMISSION_CD        , DEALING_COMP_CD        , DEALING_COMP_NM        , FINANCIAL_INSTITUTION_CD        , FINANCIAL_INSTITUTION_NM        , COMMISSION_1        , COMMISSION_2        , COMMISSION_3        , DEL_YN      FROM TB_LOAN_COMMISSION        , (SELECT @ROWNUM := 0) R        , (SELECT COUNT(*) AS TOTAL FROM TB_LOAN_COMMISSION WHERE DEL_YN = 'N') T    WHERE LOAN_CORP_CD = #{loanCorpCd}   AND DEL_YN = 'N') A    WHERE A.ROWNUM <![CDATA[>=]]> #{startNum} AND A.ROWNUM <![CDATA[<=]]> #{endNum}