springMVC - 页面excel 数据全量导出及按条件导出代码实战

最新推荐文章于 2024-05-16 05:55:59 发布
最新推荐文章于 2024-05-16 05:55:59 发布
阅读量1.1k 收藏
点赞数 1
分类专栏： SpringMVC 文章标签： springMVC - 页面excel 数据全量导出与按条件
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/lukabruce/article/details/80569090
版权

1、JSP部分代码：

//==========================导出excel功能==================================

        <cas:havePerm url="contPageEpt.do">
        //导出功能时间控件
        $('#eptDate').daterangepicker({
            "showDropdowns": true,
            "showCustomRangeLabel": false,
            "alwaysShowCalendars": true,
            "startDate": moment().subtract('days', 7),
            "endDate": moment().subtract('days', 1),
            "opens": "left",
            "drops": "down"
        }, function (start, end, label) {//时间改变后执行该方法
            //alert(label);
        });

        /*搜索条件导出*/
        $("#search_export").on("click", function () {
            var dateRange1 = $('#eptDate').val().replace(/\s/g, "").split("至");
            var startDate1 = dateRange1[0];
            var endDate1 = dateRange1[1];
            var srcContType = $("#srcContType").val();
            var searchKey = $("#searchKey").val();
            window.location = "<c:url value='contPageExport.do'/>" + "?startDate=" + startDate1 + "&endDate=" + endDate1 + "&srcContType=" + srcContType + "&searchKey=" + searchKey;
        })

        /*整体导出*/
        $("#export").on("click", function () {
            var dateRange1 = $('#eptDate').val().replace(/\s/g, "").split("至");
            var startDate1 = dateRange1[0];
            var endDate1 = dateRange1[1];
            var appId = $("#appId").val();
            var srcContType = $("#srcContType").val();
            window.location = "<c:url value='contPageEpt.do'/>" + "?startDate=" + startDate1 + "&endDate=" + endDate1 + "&appId=" + appId + "&srcContType=" + srcContType;
        })
        </cas:havePerm>
//=============================导出功能结束====================================

2、struts.xml 配置

<!--整体导出-->
<action name="contPageEpt" class="bigdata.action.ContPageDayAction" method="export">
</action>

<!--按搜索条件导出-->
<action name="contPageExport" class="bigdata.action.ContPageDayAction" method="searchExport">
</action>

3、action部分代码：

public void export() {
      Map<String, String> params = getParams();
      HttpServletResponse response = getResponse();
      response.setContentType("application/x-download");
      try {
         response.setHeader("Content-Disposition", "attachment; filename=" + URLEncoder.encode("内容受访明细", "UTF-8") + ".xls");
      } catch (UnsupportedEncodingException e1) {
         e1.printStackTrace();
      }
      ServletOutputStream outputStream = null;
      try {
         outputStream = response.getOutputStream();
         makeExcel(params, outputStream);
      } catch (IOException e) {
         e.printStackTrace();
      }
   }

   public void makeExcel(Map<String, String> params, ServletOutputStream outputStream) throws IOException {
      List<ContPageDay> list = this.contPageDayService.expList(params);
      HSSFWorkbook workbook = new HSSFWorkbook();
      HSSFSheet sheet = workbook.createSheet("内容受访明细");
      sheet.setColumnWidth(0, 20 * 256);
      sheet.setColumnWidth(1, 20 * 256);
      sheet.setColumnWidth(3, 20 * 256);
      sheet.setColumnWidth(4, 20 * 256);
      sheet.setColumnWidth(5, 20 * 256);
      sheet.setColumnWidth(6, 20 * 256);

      Row row;
      Cell cell;

      row = sheet.createRow(0);

      HSSFFont font = workbook.createFont();
      font.setColor(HSSFColor.RED.index);
      font.setFontHeightInPoints((short) 12);
      font.setBoldweight(HSSFFont.BOLDWEIGHT_NORMAL);

      HSSFCellStyle style1 = workbook.createCellStyle();
      style1.setFont(font);
      style1.setAlignment(HSSFCellStyle.ALIGN_CENTER);

      row.setRowStyle(style1);
      row.setHeight((short) 350);

      cell = row.createCell(0);
      cell.setCellValue("日期");
      cell.setCellStyle(style1);

      cell = row.createCell(1);
      cell.setCellValue("a名称");
      cell.setCellStyle(style1);

      cell = row.createCell(2);
      cell.setCellValue("b名称");
      cell.setCellStyle(style1);

      cell = row.createCell(3);
      cell.setCellValue("c名称");
      cell.setCellStyle(style1);

      cell = row.createCell(4);
      cell.setCellValue("PV数");
      cell.setCellStyle(style1);

      cell = row.createCell(5);
      cell.setCellValue("UV数");
      cell.setCellStyle(style1);

      cell = row.createCell(6);
      cell.setCellValue("IP数");
      cell.setCellStyle(style1);

      for (int i = 0; i < list.size(); i++) {
         row = sheet.createRow(i + 1);
         cell = row.createCell(0);
         cell.setCellValue(list.get(i).getStatDate());

         cell = row.createCell(1);
         cell.setCellValue(list.get(i).getAName());

         cell = row.createCell(2);
         cell.setCellValue(list.get(i).getBName());

         cell = row.createCell(3);
         cell.setCellValue(list.get(i).getCName());

         cell = row.createCell(4);
         cell.setCellValue(list.get(i).getPv());

         cell = row.createCell(5);
         cell.setCellValue(list.get(i).getUv());

         cell = row.createCell(6);
         cell.setCellValue(list.get(i).getIp());
      }

      workbook.write(outputStream);

      outputStream.flush();
      outputStream.close();
   }

   /*------------------------------------按搜索条件导出--start------------------------------------------------*/
   public void searchExport() {
      Map<String, String> params = getParams();
      HttpServletResponse response = getResponse();
      response.setContentType("application/x-download");
      try {
         response.setHeader("Content-Disposition", "attachment; filename=" + URLEncoder.encode("内容受访明细", "UTF-8") + ".xls");
      } catch (UnsupportedEncodingException e1) {
         e1.printStackTrace();
      }
      ServletOutputStream outputStream = null;
      try {
         outputStream = response.getOutputStream();
         searchExcel(params, outputStream);
      } catch (IOException e) {
         e.printStackTrace();
      }
   }

   public void searchExcel(Map<String, String> searchParams, ServletOutputStream outputStream) throws IOException {
      List<Map<String, Object>> list = this.contPageDayService.searchList(searchParams);
      HSSFWorkbook workbook = new HSSFWorkbook();
      HSSFSheet sheet = workbook.createSheet("内容受访明细");
      sheet.setColumnWidth(0, 20 * 256);
      sheet.setColumnWidth(1, 20 * 256);
      sheet.setColumnWidth(3, 20 * 256);
      sheet.setColumnWidth(4, 20 * 256);
      sheet.setColumnWidth(5, 20 * 256);
      sheet.setColumnWidth(6, 20 * 256);
      sheet.setColumnWidth(7, 20 * 256);
      sheet.setColumnWidth(8, 20 * 256);
      sheet.setColumnWidth(9, 20 * 256);

      Row row;
      Cell cell;

      row = sheet.createRow(0);

      HSSFFont font = workbook.createFont();
      font.setColor(HSSFColor.RED.index);
      font.setFontHeightInPoints((short) 12);
      font.setBoldweight(HSSFFont.BOLDWEIGHT_NORMAL);

      HSSFCellStyle style1 = workbook.createCellStyle();
      style1.setFont(font);
      style1.setAlignment(HSSFCellStyle.ALIGN_CENTER);

      row.setRowStyle(style1);
      row.setHeight((short) 350);

      cell = row.createCell(0);
      cell.setCellValue("日期");
      cell.setCellStyle(style1);

      cell = row.createCell(1);
      cell.setCellValue("a名称");
      cell.setCellStyle(style1);

      cell = row.createCell(2);
      cell.setCellValue("b名称");
      cell.setCellStyle(style1);

      cell = row.createCell(3);
      cell.setCellValue("c名称");
      cell.setCellStyle(style1);

      cell = row.createCell(4);
      cell.setCellValue(" Android (PV数) ");
      cell.setCellStyle(style1);

      cell = row.createCell(5);
      cell.setCellValue(" Android (UV数) ");
      cell.setCellStyle(style1);

      cell = row.createCell(6);
      cell.setCellValue(" Android (IP数) ");
      cell.setCellStyle(style1);

      cell = row.createCell(7);
      cell.setCellValue(" IOS (PV数) ");
      cell.setCellStyle(style1);

      cell = row.createCell(8);
      cell.setCellValue(" IOS (UV数) ");
      cell.setCellStyle(style1);

      cell = row.createCell(9);
      cell.setCellValue(" IOS (IP数) ");
      cell.setCellStyle(style1);

      for (int i = 0; i < list.size(); i++) {
         row = sheet.createRow(i + 1);
         cell = row.createCell(0);
         cell.setCellValue(String.valueOf(list.get(i).get("statDate")));

         cell = row.createCell(1);
         cell.setCellValue(String.valueOf(list.get(i).get("aName")));

         cell = row.createCell(2);
         cell.setCellValue(String.valueOf(list.get(i).get("bName")));

         cell = row.createCell(3);
         cell.setCellValue(String.valueOf(list.get(i).get("cName")));

         cell = row.createCell(4);
         cell.setCellValue(String.valueOf(null == list.get(i).get("apv") ? "0" : list.get(i).get("apv")));

         cell = row.createCell(5);
         cell.setCellValue(String.valueOf(null == list.get(i).get("auv") ? "0" : list.get(i).get("auv")));

         cell = row.createCell(6);
         cell.setCellValue(String.valueOf(null == list.get(i).get("aip") ? "0" : list.get(i).get("aip")));

         cell = row.createCell(7);
         cell.setCellValue(String.valueOf(null == list.get(i).get("bpv") ? "0" : list.get(i).get("bpv")));

         cell = row.createCell(8);
         cell.setCellValue(String.valueOf(null == list.get(i).get("buv") ? "0" : list.get(i).get("buv")));

         cell = row.createCell(9);
         cell.setCellValue(String.valueOf(null == list.get(i).get("bip") ? "0" : list.get(i).get("bip")));
      }

      workbook.write(outputStream);

      outputStream.flush();
      outputStream.close();
   }
/*------------------------------------按搜索条件导出--end------------------------------------------------*/

   public Map<String, String> getParams() {
      Map<String, String> map = new HashMap<String, String>();
      String appId = getRequest().getParameter("appId");
      if (StringUtils.isNotBlank(appId)) {
         map.put("appId", appId);
      }
      String clientVersion = getRequest().getParameter("clientVersion");
      if (StringUtils.isNotBlank(clientVersion)) {
         map.put("clientVersion", clientVersion);
      }
      String platform = getRequest().getParameter("platform");
      if (StringUtils.isNotBlank(platform)) {
         map.put("platform", platform);
      }
      String clientChannel = getRequest().getParameter("clientChannel");
      if (StringUtils.isNotBlank(clientChannel)) {
         map.put("clientChannel", clientChannel);
      }
      String date = getRequest().getParameter("date");
      if (StringUtils.isNotBlank(date)) {
         map.put("date", date.replaceAll("-", ""));
      }
      String searchKey = getRequest().getParameter("searchKey");
      if (StringUtils.isNotBlank(searchKey)) {
         map.put("searchKey", searchKey);
      }
      String srcContType = getRequest().getParameter("srcContType");
      if (StringUtils.isNotBlank(srcContType)) {
         map.put("srcContType", srcContType);
      }
      String startDate = getRequest().getParameter("startDate");
      if (StringUtils.isNotBlank(startDate)) {
         map.put("startDate", startDate.replaceAll("-", ""));
      }
      String endDate = getRequest().getParameter("endDate");
      if (StringUtils.isNotBlank(endDate)) {
         map.put("endDate", endDate.replaceAll("-", ""));
      }
      String menuId = getRequest().getParameter("aId");
      if (StringUtils.isNotBlank(menuId)) {
         map.put("aId", menuId);
      }
      String areaId = getRequest().getParameter("bId");
      if (StringUtils.isNotBlank(areaId)) {
         map.put("bId", areaId);
      }
      String contId = getRequest().getParameter("cId");
      if (StringUtils.isNotBlank(contId)) {
         map.put("cId", contId);
      }
      return map;
   }

4、dao代码部分：

public interface ContPageDayDao {
   public List<ContPageDay> expList(Map<String, String> params);
   public List<Map<String, Object>> searchList(Map<String, String> searchParams);
 }

5、impl接口实现代码部分：

@Override
public List<ContPageDay> expList(Map<String, String> params) {
   List<Object> sqlParams = new ArrayList<Object>();
   StringBuffer queryString = new StringBuffer("select statdate,aName,bName,cName,sum(pv) pv,sum(uv) uv,sum(ip) ip from cont_page_day where 1=1 ");

   String startDate = params.get("startDate");
   if (StringUtils.isNotBlank(startDate)) {
      queryString.append("and statdate>=? ");
      sqlParams.add(Long.valueOf(startDate));
   }

   String endDate = params.get("endDate");
   if (StringUtils.isNotBlank(endDate)) {
      queryString.append("and statdate<=? ");
      sqlParams.add(Long.valueOf(endDate));
   }

   String appId = params.get("appId");
   if (StringUtils.isNotBlank(appId)) {
      queryString.append("and (md = ? or md = ? or md = ? )");
      sqlParams.add(appId + "-1");
      sqlParams.add(appId + "-2");
      sqlParams.add(appId + "-3");
   }

   String srcContType = params.get("srcContType");
   if (StringUtils.isNotBlank(srcContType)) {
      queryString.append("and srcContType=? ");
      sqlParams.add(Integer.valueOf(srcContType));
   }

   queryString.append("group by aId,aName,bId,bName,cId,cName,statdate order by statdate desc");

   List<ContPageDay> dtos = new ArrayList<ContPageDay>();
   List<Map<String, Object>> results = query(queryString.toString(), sqlParams.toArray());

   for (Map<String, Object> result : results) {
      ContPageDay dto = new ContPageDay();
      dto.setStatDate((Long) result.get("statdate"));
      dto.setAName((String) result.get("aName"));
      dto.setBName((String) result.get("bName"));
      dto.setCName((String) result.get("cName"));
      dto.setIp(Long.valueOf(result.get("ip").toString()));
      dto.setPv(Long.valueOf(result.get("pv").toString()));
      dto.setUv(Long.valueOf(result.get("uv").toString()));
      dtos.add(dto);
   }
   return dtos;
}

/*--------------------------------------------------按条件搜索--begin---------------------------------------------------------*/
@Override
public List<Map<String, Object>> searchList(Map<String, String> searchParams) {
   List<Object> sqlParams = new ArrayList<Object>();
   StringBuffer queryString = new StringBuffer(
         "SELECT * FROM ( " +
               " SELECT " +
               "a.statDate," +
               "a.aName," +
               "a.bName," +
               "a.cName," +
               "a.aId," +
               "a.bId," +
               "a.cId," +
               "a.pv apv," +
               "a.uv auv," +
               "a.ip aip," +
               "b.pv bpv," +
               "b.uv buv," +
               "b.ip bip " +
               "FROM ( " +
               "SELECT * FROM cont_page_day " +
               "WHERE statdate BETWEEN ? AND ? " +
               "AND md = '3-1' " +
               "AND ( aName LIKE ? " +
               "OR bName LIKE ? " +
               "OR cName LIKE ?)) a " +
               "LEFT JOIN(" +
               "SELECT * FROM cont_page_day " +
               "WHERE statdate BETWEEN ? AND ? " +
               "AND md = '3-2' " +
               "AND (" +
               "aName LIKE ? " +
               "OR bName LIKE ? " +
               "OR cName LIKE ? )) b " +
               "ON a.statDate = b.statDate " +
               "AND a.aName = b.aName " +
               "AND a.bName = b.bName " +
               "AND a.cName = b.cName " +
               "AND a.aId = b.aId " +
               "AND a.bId = b.bId " +
               "AND a.cId = b.cId " +
               "UNION ALL " +
               "SELECT " +
               "e.statDate," +
               "e.aName," +
               "e.bName," +
               "e.cName," +
               "e.aId," +
               "e.bId," +
               "e.cId," +
               "e.pv bpv," +
               "e.uv buv," +
               "e.ip bip," +
               "d.pv apv," +
               "d.uv auv," +
               "d.ip aip " +
               "FROM ( SELECT * FROM cont_page_day " +
               "WHERE statdate BETWEEN ? AND ? " +
               "AND md = '3-1' " +
               "AND ( aName LIKE ? " +
               "OR bName LIKE ? " +
               "OR cName LIKE ?" +
               ")) d " +
               "RIGHT JOIN (" +
               " SELECT * FROM cont_page_day " +
               "WHERE statdate BETWEEN ? AND ? " +
               "AND md = '3-2' " +
               "AND ( aName LIKE ? " +
               "OR bName LIKE ? " +
               "OR cName LIKE ?" +
               ")) e " +
               "ON d.statdate = e.statdate " +
               "AND d.aName = e.aName " +
               "AND d.bName = e.bName " +
               "AND d.cName = e.cName " +
               "AND d.aId = e.aId " +
               "AND d.bId = e.bId " +
               "AND d.cId = e.cId " +
               "WHERE d.aName IS NULL " +
               "AND d.bName IS NULL " +
               "AND d.cName IS NULL " +
               "AND d.aId IS NULL " +
               "AND d.bId IS NULL " +
               "AND d.cId IS NULL" +
               ") f " +
               "ORDER BY " +
               "statDate ASC");

   String startDateQuery = "";
   String endDateQuery = "";
   String searchKeyQuery = "";

   String startDate = searchParams.get("startDate");
   if (StringUtils.isNotBlank(startDate)) {
      startDateQuery = startDate;
   }

   String endDate = searchParams.get("endDate");
   if (StringUtils.isNotBlank(endDate)) {
      endDateQuery = endDate;
   }

   String searchKey = searchParams.get("searchKey");
   if (StringUtils.isNotBlank(searchKey)) {
      searchKeyQuery = searchKey;
   }

   /*sql中有几个问号对应几条数据-4*5-*/
   for (int i = 0; i < 4; i++) {
      sqlParams.add(Long.valueOf(startDateQuery));
      sqlParams.add(Long.valueOf(endDateQuery));
      for (int j = 0; j < 3; j++) {
         sqlParams.add("%" + String.valueOf(searchKeyQuery) + "%");
      }
   }

   List<Map<String, Object>> results = query(queryString.toString(), sqlParams.toArray());

   return results;
}

卢子墨
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
excel vba customui基本使用方法
jzkwf705的博客
03-10 4009
cusutomui用于给写好的vba功能在选项卡里加按钮，加好按钮后再在vba里进行回调，其基本参数如下。 <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui"> <!--命名空间。xml需要区分大小写--> <ribbon startFromScratch="false"&gt...
根据查询条件导出Excel文件
tonglei111的博客
11-05 1538
一、GET方式请求 前端页面：页面要点击按钮导出函数； //导出excel function exportExcel() { window.location.href = "CenterChainTaskController/exportExcel?CENTERTASKCODE=" + $("#searchCENTERTASKCODE").val().trim...
使用SpringMVC导入导出excel
05-26
SpringMVC导出excel项目，国外网站下载下来有稍微修改，多次测试可用无bug。
最新EasyExcel导出大数据文件（100万条）_easyexcel导出百万数据(2)，2024年最新在线面试指南
2401_84186067的博客
05-16 687
/这里给id起别名innerid是为了防止数据库分不出来这两个id哪个是哪个。System.out.println(“一万条数据第”+i+“个文件的第”+j+“次写入时间：” + (t5-t4) / 1000D);System.out.println(“一万条数据第”+i+“个文件的第”+j+“次写入时间：” + (t5-t4) / 1000D);System.out.println(“一万条数据第”+i+“个文件的第”+j+“次写入时间：” + (t5-t4) / 1000D);
按条件导出excel数据
qq646748739的专栏
09-22 1943
按条件导出excel数据 写法1: proc export data=hbq.tmp_double_card_51_6(firstobs=1 obs=65486) outfile="C:\Users\EX_WLJR_HUANGBIQUAN\Downloads\二类户促动测试群购买数据采集.xls" replace; sheet='二类户促动测试客群5活动组part1'; run;
springmvc完整工程代码
12-27
完整的springmvc项目代码，简单的springmvc工程代码，项目框架。
聊聊Excel的大批量导入导出
一群专业码农的笔记本
09-05 3320
聊聊Excel的大批量导入导出，看POI和easyexcel各自如何实现
vue+springmvc导出excel数据的实现代码
08-27
Vue+SpringMVC导出Excel数据的实现代码 在本文中，我们将详细介绍如何使用Vue和SpringMVC实现导出Excel数据的功能。该功能可以帮助我们快速生成Excel报表，提高工作效率。 标题解释 本文的标题“Vue+SpringMVC导出...
Java SpringMVC框架开发之数据导出Excel文件格式实例详解
08-25
Java SpringMVC框架开发之数据导出Excel文件格式实例详解 Java SpringMVC框架开发中，数据导出Excel文件格式是非常常见的需求，特别是在大数据量的情况下，数据导出Excel文件格式可以更方便地处理和分析数据。本文...
springmvc实现导出数据信息为excle表格示例代码
08-31
在Spring MVC框架中，导出数据到Excel是常见的需求，特别是在数据分析、报表生成或数据交换的场景下。本文将详细讲解如何使用Spring MVC实现将数据信息导出为Excel表格。 首先，我们需要在项目中引入Apache POI库，...
SpringMvc导出Excel实例代码
08-31
在Web开发中，导出Excel是一项常见的需求，用于将数据以表格形式提供给用户下载。在Java领域，Spring MVC框架提供了便捷的方式来实现这一功能。本文将深入探讨如何使用Spring MVC导出Excel，以及与Struts2框架的对比...
SpringMVC ---- HelloWorld ---- 代码
09-18
SpringMVC ---- HelloWorld ---- 代码 SpringMVC ---- HelloWorld ---- 代码 SpringMVC ---- HelloWorld ---- 代码 SpringMVC ---- HelloWorld ---- 代码 SpringMVC ---- HelloWorld ---- 代码 SpringMVC ---- Hello...
定义公共函数，减少代码量，提高代码复用率
This is HuangWenJun' CSDN.
02-14 1060
写逻辑、功能交互代码时，为减少代码量，提高代码复用率，一般都会定义一个公共函数来使用。 var common = {}; //声明一个对象 common.getId = function(id){ return document.getElementById(id); }; var myId = common.getId("1"); //应用该对象下的方法 ...
Java实现读取Excel并按条件输出TXT
weixin_40165325的博客
01-19 3409
据我所知，java中能操作Excel文件的jar包有两个 Apache公司的一个API 微软的java Excel包 在这里我使用的是第二个，微软公司的java Excel包 这个包出现了一个为题，并不能顺利的输出规定的xls 会报错在测试多次无果后，我使用了按格式输出txt作为代替 当然，至少在WPS中，可以直接导入txt作为Excel。影响不大根据读取的xls文件不同，在代码中做一些相应修
tp5中订单列表多条件筛选及excel导出
tjg888888的博客
07-06 2423
视图层: &lt;div class="page-content"&gt; &lt;!-- &lt;a class="btn btn-success" href="{:url('order/addorder')}"&gt;添加商品&lt;/a&gt; --&gt; &lt;!-- /section:settings.box --&gt; &
上机实验5-SpringMVC的数据绑定和页面跳转加法器
最新发布
05-28
上机实验5-SpringMVC的数据绑定和页面跳转加法器，是一个使用SpringMVC框架实现的简单加法计算器。它可以从前端获取两个数字，然后通过SpringMVC框架中的数据绑定，将这两个数字绑定到Java对象中，进行简单的加法...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

卢子墨

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值