CHUAI

博客园 首页 新随笔 联系 订阅 管理

A:

<%@ page language="java" import="java.util.*" contentType="text/html; charset=UTF-8"  pageEncoding="utf-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%@ taglib prefix='sec' uri='http://www.springframework.org/security/tags'%>

B:
<div class="col-sm-5">
     <div class="form-group" style="margin-bottom:0px;">
         <label class="col-sm-3 control-label"  style="font-size:14px;">表选择</label>
             <div class="col-sm-6">
                <select class="form-control" name="csTableName1" id="csTableName1">
                   <c:forEach var="varList" items="${lists}" varStatus="vs">
                        <option value='${varList.tableName}'>${varList.tableName}</option>
                   </c:forEach>
              </select>
         </div>
     </div>
</div>

C:      
    $("#sheetTableAdd1").on("click",function(){//sheet增加
        n++;
        var tableIds = $("#csTableName1 option").map(function(){return $(this).val();}).get().join(",");
        var tableNames = $("#csTableName1 option").map(function(){return $(this).text();}).get().join(",");
        var tableIdArray= new Array();
        var tableNameArray= new Array();
        tableIdArray=tableIds.split(",");
        tableNameArray=tableNames.split(",");
        $("#xlsxDiv").append(createExcelcvsHtml(n,tableIdArray,tableNameArray));
        removeNode();
    });

D:  

function createExcelcvsHtml(n,tableIds,tableNames){

var excelcvsHtml="";

excelcvsHtml+="<select class='form-control' name='csTableName"+n+"' id='csTableName"+n+"'>";
for (i=0;i<tableIds.length ;i++){
      excelcvsHtml+="<option value='"+tableIds[i]+"'>"+tableNames[i]+"</option>";
   }        
excelcvsHtml+="</select>";

return excelcvsHtml;

}

posted on 2017-03-09 18:38  chuai  阅读(571)  评论(0)    收藏  举报