Java树结构

今天在项目中，运用到了Java树结构，是在一个查询中，选择树结构例如图片

该结构采用了前段的最新的知识，通过xml结构的数据库，后端Spring的映射实现的。

代码示例：

数据库：

<!-- 取得税种分布 -->

    <select id="getTaxTypeDistribution" resultType="ElectronicTax">

        <if test="taxtypeCode != null and taxtypeCode !='' ">

            SELECT aa.taxtype_code, SUM( aa.amount ) amount, d.label AS taxtype_name

            FROM (

        </if>

        SELECT e.taxtype_code, SUM( e.amount ) amount, e.taxtype_name FROM(

        SELECT

        e.taxtype_code, e.amount, e.taxtype_name

        FROM ${jdbc.prefix}sys_electronic_tax_done e

        INNER JOIN ${jdbc.prefix}sys_company c ON c.id=e.company_id

        WHERE 1

        <if test="cp != null and cp.isEmphases!=null">

            and c.is_emphases=#{cp.isEmphases}

        </if>

        <if test="cp != null and cp.isSmall!=null">

            and c.is_small=#{cp.isSmall}

        </if>

        <if test="currentMonth != null and currentMonth !='' ">

            AND e.accounting REGEXP #{currentMonth}

        </if>

        <if test="startAmount != null and startAmount !='' ">

                <![CDATA[AND e.amount>=#{startAmount}]]>

        </if>

        <if test="startTime!=null and lastTime!=null">

                <![CDATA[AND e.accounting >= #{startTime} AND e.accounting <= #{lastTime}]]>

        </if>

        <if test="lastAmount != null and lastAmount !='' ">

                <![CDATA[AND e.amount<=#{lastAmount}]]>

        </if>

        <if test="taxpayerSn!=null and taxpayerSn!=''">

            AND e.taxpayer_sn=#{taxpayerSn}

        </if>

        <if test="taxtypeCode != null and taxtypeCode !='' ">

            AND e.taxtype_code REGEXP CONCAT('^(', #{taxtypeCode}, ')')

        </if>

        ) e GROUP BY e.taxtype_code

        <if test="taxtypeCode != null and taxtypeCode !='' ">

            )aa INNER JOIN ${jdbc.prefix}sys_dict d ON aa.taxtype_code REGEXP

            CONCAT('^', d.`value`) WHERE `value` REGEXP CONCAT('^(',

            #{taxtypeCode}, ')$') AND d.type='taxtype_code' GROUP BY `value`

        </if>

        ORDER BY amount DESC

    </select>

后台action层：

/**

     * 企业税种分布统计

     *

     * @return

     */

    @RequiresPermissions("analysis:analysis:getCompanyTaxTwelveTotal")

    @RequestMapping(value = "/analysis/analysis/companyTaxTypeDistribution")

    public String companyTaxTypeDistribution()

    {

        List<String> yearMonthList = companyService.getYearMonth();

        Page<ElectronicTax> page = new Page<ElectronicTax>(request, response);

        page.setPageSize(10);

        el.setCurrentMonth(null);

        el.setStartTime(yearMonthList.get(11) + "-01");

        el.setLastTime(yearMonthList.get(0) + "-01");

        List<ElectronicTax> taxList = companyService.getElectronicTaxDao().getTaxTypeDistribution(el);

        page = companyService.getTaxTypeDistribution(page, el);

        model.addAttribute("taxList", taxList);

        model.addAttribute("page", page);

        model.addAttribute("yearMonthList", yearMonthList);

        return "addons/analysis/analysis/companyTaxTypeList";

    }

前台页面：

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>

<%@ page import="org.apache.shiro.web.filter.authc.FormAuthenticationFilter"%>

<%@ include file="../../../admin/defaults/include/header.jsp" %>

  <body>

  <script type="text/javascript" src="${ctxStatic}/js/gvChart/jsapi.js"></script>

  <script type="text/javascript" src="${ctxStatic}/js/gvChart/format+zh_CN,default,corechart.I.js"></script>

  <script type="text/javascript" src="${ctxStatic}/js/gvChart/jquery.gvChart-1.0.1.min.js"></script>

  <script type="text/javascript" src="${ctxStatic}/js/gvChart/jquery.ba-resize.min.js"></script>

  <%@ include file="../../../admin/defaults/include/treetable.jsp" %>

  <script type="text/javascript">

        gvChartInit();

        $(document).ready(function(){

            $('#myTable5').gvChart({

                chartType: 'PieChart',

                gvSettings: {

                            vAxis: {title: 'No of players'},

                            hAxis: {title: 'Month'},

                            width: 710,

                            height: 400

                            }

            });

            $("#treeTable").treeTable({expandLevel : 3}).show();

            $('#guosScjydzxzqhszDm').attr('name','company.guosScjydzxzqhszDm');

        });

        function updateSort() {

            loading('正在提交，请稍等...');

            $("#form_menu").attr("action", "${ctx}/sys/menu/updateSort");

            $("#form_menu").submit();

        }

    </script>

    <div id="append_parent"></div>

    <div id="ajaxwaitid"></div>

    <link href="${ctxStatic}${fns:getConfig('adminThems')}/css/font/font-awesome/css/font-awesome.min.css" rel="stylesheet" />

    <!--[if IE 7]>

      <link rel="stylesheet" href="${ctxStatic}${fns:getConfig('adminThems')}/css/font/font-awesome/css/font-awesome-ie7.min.css">

    <![endif]-->

    <div class="page" style="overflow:auto;">

      <div class="fixed-bar">

        <div class="item-title">

          <h3>分析</h3>

          <ul class="tab-base">

            <!-- <li><a href="./amountFilter<c:if test="${el.cp.isEmphases=='Y' }">?el.cp.isEmphases=Y</c:if><c:if test="${el.cp.isSmall=='Y' }">?el.cp.isSmall=Y</c:if>"><span>所有记录</span></a></li> -->

            <li><a href="./taxTypeDistribution<c:if test="${el.cp.isEmphases=='Y' }">?el.cp.isEmphases=Y</c:if><c:if test="${el.cp.isSmall=='Y' }">?el.cp.isSmall=Y</c:if>" class="current"><span>税种分布</span></a></li>

            <li><a href="./twelveTaxType<c:if test="${el.cp.isEmphases=='Y' }">?el.cp.isEmphases=Y</c:if><c:if test="${el.cp.isSmall=='Y' }">?el.cp.isSmall=Y</c:if>"><span>走势图</span></a></li>

            <li><a href="./columnTaxType<c:if test="${el.cp.isEmphases=='Y' }">?el.cp.isEmphases=Y</c:if><c:if test="${el.cp.isSmall=='Y' }">?el.cp.isSmall=Y</c:if>"><span>柱状图</span></a></li>

          </ul>

        </div>

      </div>

      <div class="fixed-empty"></div>

      <form id="searchForm" action="" method="post" class="breadcrumb form-search">

           <input id="pageNo" name="pageNo" type="hidden" value="${page.pageNo}"/>

        <input id="pageSize" name="pageSize" type="hidden" value="${page.pageSize}"/>

        <table class="tb-type1 noborder search">

          <tbody>

            <tr>

                <th>时间跨度：</th>

                <td>

                    <select name="el.startTime">

                    <c:forEach items="${yearMonthList}" var="value">

                        <option  value="${value }"${fn:indexOf(el.startTime, value)!=-1?' selected':'' }>${value }</option>

                    </c:forEach>

                    </select>

                    -

                    <select name="el.lastTime">

                    <c:forEach items="${yearMonthList}" var="value">

                        <option  value="${value }"${fn:indexOf(el.lastTime, value)!=-1?' selected':'' }>${value }</option>

                    </c:forEach>

                    </select>

                </td>

                  <th>金额：</th>

                  <td>

                <input name="el.startAmount" placeholder="金额下限" value="${el.startAmount }" maxlength="50" class="input-medium"/> -

                <input name="el.lastAmount" placeholder="金额上限" value="${el.lastAmount }" maxlength="50" class="input-medium"/>

                </td>

                <th>税种：</th>

                <td>

                    <sys:dicttreeselect id="taxtypeCode" name="el.taxtypeCode" value="${el.taxtypeCode}" labelName="el.taxtypeName" labelValue="${el.taxtypeName }"

                    title="税种" url="/sys/dict/treeData?type=taxtype_code" cssStyle="width:170px;" cssClass="required txt" notAllowSelectParent="false" notAllowSelectRoot="falsse" checked="true" isChild="true" />

                </td>

                <td><a href="javascript:void(0);" id="ncsubmit" class="btn-search " title="查询" onclick="$('#searchForm').submit();">&nbsp;</a></td>

                  <td class="w120">&nbsp;</td>

            </tr>

          </tbody>

        </table>

      </form>

      <sys:message content="${message}"/>

      <table class="table tb-type2" id="contentTable" style="width:400px; float:left;">

          <thead>

              <tr>

                <th>税种</th>

                <th>金额</th>

            </tr>

          </thead>

          <tbody>

            <c:forEach items="${page.list}" var="el">

            <tr>

                <td>${el.taxtypeName}</td>

                <td><fmt:formatNumber value="${el.amount}" pattern="￥#,#00.00#"/></td>

            </tr>

            </c:forEach>

          </tbody>

          <tfoot>

            <tr class="tfoot">

              <td colspan="5">

                  <div class="pagination">

                  ${page }

                </div>

              </td>

            </tr>

          </tfoot>

        </table>

        <div style="float:left;">

            <table id='myTable5'>

                <caption></caption>

                <thead>

                    <tr>

                        <th></th>

<c:forEach items="${taxList }" var="item">

                        <th>${item.taxtypeName }</th>

</c:forEach>

                    </tr>

                </thead>

                    <tbody>

                    <tr>

                        <th>${el.currentMonth }</th>

<c:forEach items="${taxList }" var="item">

                        <td>${item.amount }</td>

</c:forEach>

                    </tr>

                </tbody>

            </table>

        </div>

    </div>

  </body>

</html>

巴特西

Java树结构

最新文章

热门文章