如何在MySQL中使用XML类型

avatar
作者
筋斗云
阅读量:2

在 MySQL 中,您可以使用 XML 数据类型来存储和操作 XML 文档

  1. 创建包含 XML 列的表:
CREATE TABLE example_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    xml_data XML
);
  1. 向表中插入 XML 数据:
INSERT INTO example_table (xml_data) VALUES ('
   
     Gambardella, Matthew
     XML Developer\'</span>s Guide<span class="hljs-operator"><</span><span class="hljs-operator">/</span>title<span class="hljs-operator">></span>
      <span class="hljs-operator"><</span>genre<span class="hljs-operator">></span>Computer<span class="hljs-operator"><</span><span class="hljs-operator">/</span>genre<span class="hljs-operator">></span>
     <span class="hljs-operator"><</span>price<span class="hljs-operator">></span><span class="hljs-number">44.95</span><span class="hljs-operator"><</span><span class="hljs-operator">/</span>price<span class="hljs-operator">></span>
     <span class="hljs-operator"><</span>publish_date<span class="hljs-operator">></span><span class="hljs-number">2000</span><span class="hljs-number">-10</span><span class="hljs-number">-01</span><span class="hljs-operator"><</span><span class="hljs-operator">/</span>publish_date<span class="hljs-operator">></span>
     <span class="hljs-operator"><</span>description<span class="hljs-operator">></span>An <span class="hljs-keyword">in</span><span class="hljs-operator">-</span>depth look <span class="hljs-keyword">at</span> creating applications <span class="hljs-keyword">with</span> XML.<span class="hljs-operator"><</span><span class="hljs-operator">/</span>description<span class="hljs-operator">></span>
   <span class="hljs-operator"><</span><span class="hljs-operator">/</span>book<span class="hljs-operator">></span>
<span class="hljs-operator"><</span><span class="hljs-operator">/</span>catalog<span class="hljs-operator">></span><span class="hljs-string">');
</span></code></pre>
<ol start="3">
<li>查询 XML 数据:</li>
</ol>
<p>使用 XPath 表达式查询 XML 数据。例如,要获取所有 book 元素的 author 子元素,可以使用以下查询:</p>
<pre class="hljs"><code><span class="hljs-keyword">SELECT</span> ExtractValue(xml_data, <span class="hljs-string">'/catalog/book/author'</span>) <span class="hljs-keyword">AS</span> author <span class="hljs-keyword">FROM</span> example_table;
</code></pre>
<ol start="4">
<li>更新 XML 数据:</li>
</ol>
<p>使用 XML 函数 <code>UpdateXML()</code> 更新 XML 数据。例如,要将 id 为 bk101 的 book 元素的 genre 更改为 “Programming”,可以使用以下查询:</p>
<pre class="hljs"><code><span class="hljs-keyword">UPDATE</span> example_table <span class="hljs-keyword">SET</span> xml_data <span class="hljs-operator">=</span> UpdateXML(xml_data, <span class="hljs-string">'/catalog/book[@id="bk101"]/genre/text()'</span>, <span class="hljs-string">'Programming'</span>) <span class="hljs-keyword">WHERE</span> id <span class="hljs-operator">=</span> <span class="hljs-number">1</span>;
</code></pre>
<ol start="5">
<li>删除 XML 数据:</li>
</ol>
<p>要删除 XML 数据,请使用 <code>DELETE</code> 语句。例如,要删除表中的所有记录,可以使用以下查询:</p>
<pre class="hljs"><code><span class="hljs-keyword">DELETE</span> <span class="hljs-keyword">FROM</span> example_table;
</code></pre>
<p>注意:在使用 XML 数据类型时,请确保您的 MySQL 版本支持该功能。从 MySQL 5.7.8 开始,已弃用对 XML 数据类型的支持。相反,您可以使用字符串数据类型(如 TEXT 或 LONGTEXT)存储 XML 数据,并使用内置的 XML 函数进行操作。</p>

        </p>                            <!-- S 正文锚点 -->
                            <p>以上就是关于“如何在MySQL中使用XML类型”的相关介绍,<a href="https://www.jindouyun.cn/">筋斗云</a>是国内较早的云主机应用的服务商,拥有10余年行业经验,提供丰富的云服务器、租用服务器等相关产品服务。云服务器资源弹性伸缩,主机vCPU、内存性能强悍、超高I/O速度、故障秒级恢复;电子化备案,提交快速,专业团队7×24小时服务支持!</p>
                            <p>简单好用、高性价比云服务器租用链接:<a href="https://www.jindouyun.cn/product/cvm" class="c-primary">https://www.jindouyun.cn/product/cvm</a></p>
                        </div>
                        <!-- E 正文锚点 -->
                        <!-- E 正文 -->
                    </article>
                    <!-- S 声明 -->
                    <div class="notice-info notice-info--light-yellow">
                        <div class="notice-info-thumb">
                            <svg class="crumina-icon">
                                <use xlink:href="#icon-info"></use>
                            </svg>
                        </div>
                        <p>
                            <span class="weight-bold">声明:</span> 本网站发布的内容(图片、视频和文字)以原创、转载和分享网络内容为主,如果涉及侵权请尽快告知,我们将会在第一时间删除。文章观点不代表本网站立场,如需处理请联系客服。
                        </p>
                    </div>
                    <!-- E 声明 -->
                    <!-- S 相关文章 -->
                    <div class="presentation-block presentation-block--light-blue">
                        <h6 class="fs-14">相关文章</h6>
                        <ol class="ordered-list--with-border pl-0">
                                                        <li>
                                <a href="/news/industry/302399.html">如何在云服务器上下载文件夹...</a>
                            </li>
                                                        <li>
                                <a href="/news/industry/302374.html">使用终端连接云服务器</a>
                            </li>
                                                        <li>
                                <a href="/news/industry/302236.html">云服务器在哪里看云盘使用量...</a>
                            </li>
                                                        <li>
                                <a href="/news/industry/302178.html">如何在云服务器上搭建桌面文...</a>
                            </li>
                                                        <li>
                                <a href="/news/industry/302091.html">云服务器使用流程和费用</a>
                            </li>
                                                        <li>
                                <a href="/news/industry/301964.html">使用云服务器怎么上传文件到...</a>
                            </li>
                                                    </ol>
                    </div>
                    <!-- E 相关文章 -->
                    <ul class="crumina-module crumina-articles-list mt-5">
                        <!-- S 上一篇下一篇 -->

                        <!-- 上一篇 -->
                                                <li>
                            <svg class="crumina-icon icon-article">
                                <use xlink:href="#icon-article"></use>
                            </svg>
                            <div class="read-more--with-arrow">
                                上一篇:
                            </div>
                            <a class="read-more--with-arrow" href="/news/product/269332.html" title="MySQL XML类型数据查询方法">
                                MySQL XML类型数据查询方法                                <svg class="crumina-icon" width="15px" height="9px">
                                    <path fill-rule="evenodd" d="M9.427,0.139 C9.236,-0.041 8.919,-0.041 8.722,0.139 C8.531,0.313 8.531,0.602 8.722,0.775 L12.299,4.035 L0.494,4.035 C0.218,4.035 -0.000,4.234 -0.000,4.484 C-0.000,4.737 0.218,4.941 0.494,4.941 L12.299,4.941 L8.722,8.196 C8.531,8.376 8.531,8.665 8.722,8.839 C8.919,9.018 9.237,9.018 9.427,8.839 L13.852,4.807 C14.049,4.633 14.049,4.344 13.852,4.171 L9.427,0.139 Z" />
                                </svg>
                            </a>
                        </li>
                        
                        <!-- 下一篇 -->
                                                <li>
                            <svg class="crumina-icon icon-article">
                                <use xlink:href="#icon-article"></use>
                            </svg>
                            <div class="read-more--with-arrow">
                                下一篇:
                            </div>
                            <a class="read-more--with-arrow" href="/news/product/269338.html" title="MySQL中XML类型数据存储">
                                MySQL中XML类型数据存储                                <svg class="crumina-icon" width="15px" height="9px">
                                    <path fill-rule="evenodd" d="M9.427,0.139 C9.236,-0.041 8.919,-0.041 8.722,0.139 C8.531,0.313 8.531,0.602 8.722,0.775 L12.299,4.035 L0.494,4.035 C0.218,4.035 -0.000,4.234 -0.000,4.484 C-0.000,4.737 0.218,4.941 0.494,4.941 L12.299,4.941 L8.722,8.196 C8.531,8.376 8.531,8.665 8.722,8.839 C8.919,9.018 9.237,9.018 9.427,8.839 L13.852,4.807 C14.049,4.633 14.049,4.344 13.852,4.171 L9.427,0.139 Z" />
                                </svg>
                            </a>
                        </li>
                                                <!-- E 上一篇下一篇 -->
                    </ul>

                </div>
                <div class="col-lg-4 col-md-4 col-sm-12 col-xs-12">
                    <aside aria-label="sidebar" class="sidebar sidebar-right">
                        <div class="widget w-search widget-sidebar">
                            <h6 class="widget-title">您在找什么?</h6>
                            <form action="/index.php" method="get" id="search_form">
                                <input type="hidden" name="s" value="news">
                                <input type="hidden" name="c" value="search">
                                <div class="input--with-icon input--icon-right">
                                    <input class="input--grey input--squared" name="keyword" type="search" value="" placeholder="输入关键词搜索文章" />
                                    <svg class="crumina-icon">
                                        <use xlink:href="#icon-search"></use>
                                    </svg>
                                </div>
                            </form>
                        </div>
                        <!-- S 分类列表 -->
                        <div class="widget widget_links widget-sidebar">
                            <h6 class="widget-title">分类列表</h6>
                            <ul>
                                                                <li>
                                    <a href="/news/notice">
                                        官方公告                                        <svg class="crumina-icon">
                                            <use xlink:href="#icon-triangle-arrow"></use>
                                        </svg>
                                    </a>
                                </li>
                                                                <li>
                                    <a href="/news/company">
                                        企业动态                                        <svg class="crumina-icon">
                                            <use xlink:href="#icon-triangle-arrow"></use>
                                        </svg>
                                    </a>
                                </li>
                                                                <li>
                                    <a href="/news/product">
                                        产品动态                                        <svg class="crumina-icon">
                                            <use xlink:href="#icon-triangle-arrow"></use>
                                        </svg>
                                    </a>
                                </li>
                                                                <li>
                                    <a href="/news/tech">
                                        运维文库                                        <svg class="crumina-icon">
                                            <use xlink:href="#icon-triangle-arrow"></use>
                                        </svg>
                                    </a>
                                </li>
                                                                <li>
                                    <a href="/news/industry">
                                        行业观察                                        <svg class="crumina-icon">
                                            <use xlink:href="#icon-triangle-arrow"></use>
                                        </svg>
                                    </a>
                                </li>
                                                                <li>
                                    <a href="/news/security">
                                        安全资讯                                        <svg class="crumina-icon">
                                            <use xlink:href="#icon-triangle-arrow"></use>
                                        </svg>
                                    </a>
                                </li>
                                                            </ul>
                        </div>
                        <!-- E 分类列表 -->
                        <!-- S 热门资讯 -->
                        <div class="widget w-latest-posts widget-sidebar">
                            <h6 class="widget-title">热门资讯</h6>
                                                        <article class="entry latest-posts-item">
                                <time class="post-date published" datetime="2026-04-24 20:32:21"> 发表于
                                    2026-04-24 20:32:21                                </time>
                                <a href="/news/product/203.html" class="post-title h6" title="香港服务器带宽优化:分析CN2...">香港服务器带宽优化:分析CN2...</a>
                            </article>
                                                        <article class="entry latest-posts-item">
                                <time class="post-date published" datetime="2026-04-24 20:36:44"> 发表于
                                    2026-04-24 20:36:44                                </time>
                                <a href="/news/product/266.html" class="post-title h6" title="香港服务器300M带宽下载速度...">香港服务器300M带宽下载速度...</a>
                            </article>
                                                        <article class="entry latest-posts-item">
                                <time class="post-date published" datetime="2026-04-24 21:08:54"> 发表于
                                    2026-04-24 21:08:54                                </time>
                                <a href="/news/product/402.html" class="post-title h6" title="日本十大服务器排名及其特点分析">日本十大服务器排名及其特点分析</a>
                            </article>
                                                        <article class="entry latest-posts-item">
                                <time class="post-date published" datetime="2026-04-24 21:12:51"> 发表于
                                    2026-04-24 21:12:51                                </time>
                                <a href="/news/product/465.html" class="post-title h6" title="小型办公局域网企业组网拓扑图设...">小型办公局域网企业组网拓扑图设...</a>
                            </article>
                                                        <article class="entry latest-posts-item">
                                <time class="post-date published" datetime="2026-04-24 20:34:16"> 发表于
                                    2026-04-24 20:34:16                                </time>
                                <a href="/news/product/234.html" class="post-title h6" title="如何通过优化香港Linux服务...">如何通过优化香港Linux服务...</a>
                            </article>
                                                        <article class="entry latest-posts-item">
                                <time class="post-date published" datetime="2026-04-24 21:09:41"> 发表于
                                    2026-04-24 21:09:41                                </time>
                                <a href="/news/product/416.html" class="post-title h6" title="高效监控与日志管理:使用pro...">高效监控与日志管理:使用pro...</a>
                            </article>
                                                        <article class="entry latest-posts-item">
                                <time class="post-date published" datetime="2026-04-24 21:09:08"> 发表于
                                    2026-04-24 21:09:08                                </time>
                                <a href="/news/product/406.html" class="post-title h6" title="从单处理器到多处理器系统的服务...">从单处理器到多处理器系统的服务...</a>
                            </article>
                                                        <article class="entry latest-posts-item">
                                <time class="post-date published" datetime="2026-04-24 21:07:56"> 发表于
                                    2026-04-24 21:07:56                                </time>
                                <a href="/news/product/383.html" class="post-title h6" title="台湾云服务器服务器:高性价比的...">台湾云服务器服务器:高性价比的...</a>
                            </article>
                                                        <article class="entry latest-posts-item">
                                <time class="post-date published" datetime="2026-04-24 20:36:57"> 发表于
                                    2026-04-24 20:36:57                                </time>
                                <a href="/news/product/270.html" class="post-title h6" title="香港服务器存储性能下降:SSD...">香港服务器存储性能下降:SSD...</a>
                            </article>
                                                        <article class="entry latest-posts-item">
                                <time class="post-date published" datetime="2026-04-24 21:12:43"> 发表于
                                    2026-04-24 21:12:43                                </time>
                                <a href="/news/product/463.html" class="post-title h6" title="顺利完成服务器迁移,全面保障您...">顺利完成服务器迁移,全面保障您...</a>
                            </article>
                                                        <a href="https://www.jindouyun.cn/news/product" class="crumina-button button--grey button--xs button--uppercase">阅读所有</a>
                        </div>
                        <!-- E 热门资讯 -->
                        <!-- S 社交网络 -->
                        <div class="widget w-socials widget-sidebar">
    <h6 class="widget-title">社交网络</h6>
    <h6 class="fs-16">可以通过以下关注我们:</h6>
    <ul class="socials socials--rounded">
        <li>
            <a href="https://work.weixin.qq.com/kfid/kfca41cc3efa97534e4" target="_blank">
                <img class="crumina-icon" loading="lazy"
                     src="/static/hostsite/img/theme-content/social-icons/weixin.png"
                     alt="weixin"/>
            </a>
        </li>
        <li>
            <a href="http://wpa.qq.com/msgrd?v=3&uin=6008873&site=qq&menu=yes" target="_blank">
                <img class="crumina-icon" loading="lazy"
                     src="/static/hostsite/img/theme-content/social-icons/qq.png" alt="qq"/>
            </a>
        </li>
        <li>
            <a href="http://weibo.com/" target="_blank">
                <img class="crumina-icon" loading="lazy"
                     src="/static/hostsite/img/theme-content/social-icons/weibo.png" alt="weibo"/>
            </a>
        </li>
        <li>
            <a href="mailto:10000@jindouyun.cn" target="_blank">
                <img class="crumina-icon" loading="lazy"
                     src="/static/hostsite/img/theme-content/social-icons/email.png" alt="email"/>
            </a>
        </li>
    </ul>
</div>                        <!-- E 社交网络 -->
                        <!-- S 公司简介 -->
                        <div class="widget w-about widget-sidebar">
    <h6 class="widget-title"> 关于筋斗云</h6>
    <p>
        江门筋斗云计算有限公司成立于2013年6月,注册资金1080万,广东省互联网企业10强。旗下云计算品牌——筋斗云,始终致力于为政府机构、企业组织和个人开发者提供稳定、安全、可靠、高性价比的云计算产品与服务。    </p>
    <a class="read-more--with-arrow" href="https://www.jindouyun.cn/about">
        阅读更多
        <svg class="crumina-icon" width="15px" height="9px">
            <path fill-rule="evenodd"
                  d="M9.427,0.139 C9.236,-0.041 8.919,-0.041 8.722,0.139 C8.531,0.313 8.531,0.602 8.722,0.775 L12.299,4.035 L0.494,4.035 C0.218,4.035 -0.000,4.234 -0.000,4.484 C-0.000,4.737 0.218,4.941 0.494,4.941 L12.299,4.941 L8.722,8.196 C8.531,8.376 8.531,8.665 8.722,8.839 C8.919,9.018 9.237,9.018 9.427,8.839 L13.852,4.807 C14.049,4.633 14.049,4.344 13.852,4.171 L9.427,0.139 Z"/>
        </svg>
    </a>
</div>                        <!-- E 公司简介 -->
                        <!-- S 热门标签 -->
                        <div class="widget w-popular-tags widget-sidebar">
                            <h6 class="widget-title">热门标签</h6>
                            <ul class="tags-list mt-5">
                                                                <li><a title="关于“何在”的内容" href="/search/news/keyword-%E4%BD%95%E5%9C%A8.html">何在</a></li>
                                                                <li><a title="关于“MySQL”的内容" href="/search/news/keyword-MySQL.html">MySQL</a></li>
                                                                <li><a title="关于“使用”的内容" href="/search/news/keyword-%E4%BD%BF%E7%94%A8.html">使用</a></li>
                                                                <li><a title="关于“XML”的内容" href="/search/news/keyword-XML.html">XML</a></li>
                                                                <li><a title="关于“类型”的内容" href="/search/news/keyword-%E7%B1%BB%E5%9E%8B.html">类型</a></li>
                                                            </ul>
                        </div>
                        <!-- E 热门标签 -->
                        <!-- S 最新活动 -->
                        <article class="entry post post-standard has-post-thumbnail advertising" data-mh="blog-item">
    <div class="post-category-wrap">
        <a href="/activity/2026pro" class="post-category">最新活动</a>
    </div>
    <div class="post-thumb">
        <img loading="lazy" src="/static/hostsite/img/demo-content/blog/blog3.png" alt="Activity">
    </div>
    <div class="post-content">
        <a href="/activity/2026pro" class="post-title h6">弹性云服务器 <span
                class="c-blue">低至¥1.3元/日</span>*</a>
        <a href="/activity/2026pro"
           class="crumina-button button--primary button--l">马上抢购</a>
    </div>
</article>
                        <!-- E 最新活动 -->
                    </aside>
                </div>
            </div>
        </div>
    </section>
</div>

<!-- Footer -->
<footer id="site-footer" class="footer footer--dark footer--with-decoration">
    <div class="footer-content">
        <div class="container">
            <div class="row justify-content-between">
                <div class="col-lg-2 col-md-6 col-sm-12 col-xs-12 mb-4 mb-lg-0">
                    <div class="widget widget_links">
                        <h5 class="widget-title">
                            产品
                        </h5>
                        <ul>
                            <li>
                                <a href="https://www.jindouyun.cn/product/cvm">
                                    弹性云服务器
                                    <svg class="crumina-icon">
                                        <use xlink:href="#icon-triangle-arrow"></use>
                                    </svg>
                                </a>
                            </li>
                            <li>
                                <a href="https://www.jindouyun.cn/product/lighthouse">
                                    轻量应用服务器
                                    <svg class="crumina-icon">
                                        <use xlink:href="#icon-triangle-arrow"></use>
                                    </svg>
                                </a>
                            </li>
                            <li>
                                <a href="https://www.jindouyun.cn/product/cloudmoblie">
                                    云手机
                                    <svg class="crumina-icon">
                                        <use xlink:href="#icon-triangle-arrow"></use>
                                    </svg>
                                </a>
                            </li>
                            <li>
                                <a href="https://www.jindouyun.cn/product/dedicated">
                                    独立物理服务器
                                    <svg class="crumina-icon">
                                        <use xlink:href="#icon-triangle-arrow"></use>
                                    </svg>
                                </a>
                            </li>
                            <li>
                                <a href="https://www.jindouyun.cn/product/vhost">
                                    云虚拟主机
                                    <svg class="crumina-icon">
                                        <use xlink:href="#icon-triangle-arrow"></use>
                                    </svg>
                                </a>
                            </li>
                        </ul>
                    </div>
                </div>
                <div class="col-lg-2 col-md-6 col-sm-12 col-xs-12 mb-4 mb-lg-0">
                    <div class="widget widget_links">
                        <h5 class="widget-title">
                            支持
                        </h5>
                        <ul>
                            <li>
                                <a href="https://www.jindouyun.cn/index.php?s=help">
                                    文档
                                    <svg class="crumina-icon">
                                        <use xlink:href="#icon-triangle-arrow"></use>
                                    </svg>
                                </a>
                            </li>
                            <li>
                                <a href="https://www.jindouyun.cn/support">
                                    支持中心
                                    <svg class="crumina-icon">
                                        <use xlink:href="#icon-triangle-arrow"></use>
                                    </svg>
                                </a>
                            </li>
                            <li>
                                <a href="https://www.jindouyun.cn/faqs">
                                    常见问答
                                    <svg class="crumina-icon">
                                        <use xlink:href="#icon-triangle-arrow"></use>
                                    </svg>
                                </a>
                            </li>
                            <li>
                                <a href="https://portal.jindouyun.cn/plugin/27/ticket.htm">
                                    工单
                                    <svg class="crumina-icon">
                                        <use xlink:href="#icon-triangle-arrow"></use>
                                    </svg>
                                </a>
                            </li>
                        </ul>
                    </div>
                </div>
                <div class="col-lg-2 col-md-6 col-sm-12 col-xs-12 mb-4 mb-lg-0">
                    <div class="widget widget_links">
                        <h5 class="widget-title">
                            其它
                        </h5>
                        <ul>
                            <li>
                                <a href="https://www.jindouyun.cn/tos">
                                    服务条款
                                    <svg class="crumina-icon">
                                        <use xlink:href="#icon-triangle-arrow"></use>
                                    </svg>
                                </a>
                            </li>
                            <li>
                                <a href="https://www.jindouyun.cn/privacy">
                                    隐私政策
                                    <svg class="crumina-icon">
                                        <use xlink:href="#icon-triangle-arrow"></use>
                                    </svg>
                                </a>
                            </li>
                            <li>
                                <a href="https://www.jindouyun.cn/aup">
                                    可接受使用政策
                                    <svg class="crumina-icon">
                                        <use xlink:href="#icon-triangle-arrow"></use>
                                    </svg>
                                </a>
                            </li>
                            <li>
                                <a href="https://www.jindouyun.cn/links">
                                    友情链接
                                    <svg class="crumina-icon">
                                        <use xlink:href="#icon-triangle-arrow"></use>
                                    </svg>
                                </a>
                            </li>
                            <li>
                                <a href="https://panel.jindouyun.cn">
                                    独立面板
                                    <svg class="crumina-icon">
                                        <use xlink:href="#icon-triangle-arrow"></use>
                                    </svg>
                                </a>
                            </li>
                        </ul>
                    </div>
                </div>
                <div class="col-lg-3 col-md-6 col-sm-12 col-xs-12 mb-0 mb-lg-0">
                    <div class="widget w-info">
                        <a href="https://www.jindouyun.cn/" class="site-logo">
                            <img loading="lazy" src="https://www.jindouyun.cn/uploadfile/202604/9228129288afce116871b30d66c1ab39.svg" alt="jindouyun logo" width="185">
                        </a>
                        <p>
                            我们提供全球数据中心基础服务、弹性云服务器、轻量应用服务器、裸金属服务器、云虚拟主机等业务。                        </p>
                        <ul class="socials">
                            <li>
                                <a href="https://work.weixin.qq.com/kfid/kfca41cc3efa97534e4" target="_blank">
                                    <img class="crumina-icon " loading="lazy" src="/static/hostsite/img/theme-content/social-icons/weixin.png" alt="weixin">
                                </a>
                            </li>
                            <li>
                                <a href="http://wpa.qq.com/msgrd?v=3&uin=6008873&site=qq&menu=yes" target="_blank">
                                    <img class="crumina-icon " loading="lazy" src="/static/hostsite/img/theme-content/social-icons/qq.png" alt="qq">
                                </a>
                            </li>
                            <li>
                                <a href="http://weibo.com/" target="_blank">
                                    <img class="crumina-icon " loading="lazy" src="/static/hostsite/img/theme-content/social-icons/weibo.png" alt="weibo">
                                </a>
                            </li>
                            <li>
                                <a href="mailto:10000@jindouyun.cn" target="_blank">
                                    <img class="crumina-icon " loading="lazy" src="/static/hostsite/img/theme-content/social-icons/email.png" alt="email">
                                </a>
                            </li>
                        </ul>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="footer-subscribe-panel">
        <div class="container">
            <div class="row align-items-center">
                <div class="col-lg-3 col-md-4 col-sm-12 col-xs-12 mb-4 mb-lg-0">
                    <h5 class="footer-subscribe-panel-title text-white">帮助与文档</h5>
                </div>
                <div class="col-lg-3 col-md-4 col-sm-12 col-xs-12 mb-4 mb-lg-0">
                    <span class="footer-subscribe-panel-subtitle">筋斗云-简单好用的服务器</span>
                </div>
                <div class="col-lg-6 col-md-4 col-sm-12 col-xs-12 mb-0 mb-lg-0">
                    <form class="footer-subscribe-form" action="/index.php" method="get" id="search_form">
                        <input type="hidden" name="s" value="help">
                        <input type="hidden" name="c" value="search">
                        <div class="input-btn--inline">
                            <input class="input--dark" name="keyword" type="search" value="" placeholder="请输入您要搜索的关键词,例:云服务器">
                            <button type="submit" class="crumina-button button--lime button--l">搜索</button>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
    <div class="sub-footer bg-black">
        <div class="container">
            <div class="row">
                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 text-center mb-0 mb-lg-0">
                    <div class="copyright">
                        <span>
                            Copyright © 2013 -
                            <script>
                                document.write(new Date().getFullYear())
                            </script>
                            <a href="https://www.jindouyun.cn/">jindouyun.cn</a>. All Rights Reserved. 筋斗云 版权所有 |
                            <a href="https://beian.miit.gov.cn/">粤ICP备13013545号</a> | 增值电信业务经营许可证:
                            <a href="https://beian.miit.gov.cn/#/Integrated/index" target="_blank">粤B1-20215235</a> |
                            <a href="http://www.beian.gov.cn/portal/registerSystemInfo?recordcode=44070302000974" target="_blank"><img src="https://cloudcache.jindouyun.cn/img/iconfont/eed02831a0e201b8d794c8282c40cf2e.png" style="width: 14px; margin-right: 5px; vertical-align:-2px; object-fit: contain;" alt="公网安备">粤公网安备 44070302000974号</a>
                            <br>
                            <a href="https://www.12377.cn/" target="_blank"><img src="https://cloudcache.jindouyun.cn/img/iconfont/report.28ceedbb6ba0e0cd37525ba48e3a39b6.png" style="width: 16px; margin-right: 5px; vertical-align:-2px; object-fit: contain;" alt="违法和不良信息举报中心">违法和不良信息举报中心</a>   24 小时违法和不良信息举报热线:4006783389,举报邮箱:jubao@jindouyun.cn
                            <br>
                            <img loading="lazy" src="https://cloudcache.jindouyun.cn/img/iconfont/ipv6.svg" alt="ipv6">
                        </span>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <a class="back-to-top" href="#">
        <svg class="crumina-icon">
            <use xlink:href="#icon-to-top"></use>
        </svg>
    </a>
    <div class="livechat-girl animated">
    <img class="girl" src="/static/hostsite/img/demo-content/images/livechat.svg">
    <div class="livechat-hint rd-notice-tooltip rd-notice-type-success rd-notice-position-left single-line show_hint">
        <div class="rd-notice-content">
            嘿,我是微信客服!        </div>
    </div>
    <div class="animated-circles">
        <div class="circle c-1">
        </div>
        <div class="circle c-2">
        </div>
        <div class="circle c-3">
        </div>
    </div>
</div>
</footer>
<!-- ... end Footer -->
<script src="/static/hostsite/js/jquery.min.js"></script>
<script src="/static/hostsite/js/Bootstrap/bootstrap.bundle.min.js"></script>
<script src="/static/hostsite/js/js-plugins/navigation.min.js"></script>
<script src="/static/hostsite/js/js-plugins/select2.min.js"></script>
<script src="/static/hostsite/js/js-plugins/material.min.js"></script>
<script src="/static/hostsite/js/js-plugins/swiper.min.js"></script>
<script src="/static/hostsite/js/js-plugins/jquery-countTo.min.js"></script>
<script src="/static/hostsite/js/js-plugins/waypoints.min.js"></script>
<script src="/static/hostsite/js/js-plugins/leaflet.min.js"></script>
<script src="/static/hostsite/js/js-plugins/MarkerClusterGroup.min.js"></script>
<script src="/static/hostsite/js/js-plugins/jquery.magnific-popup.min.js"></script>
<script src="/static/hostsite/js/js-plugins/TimeCircles.min.js"></script>
<script src="/static/hostsite/js/js-plugins/smooth-scroll.min.js"></script>
<script src="/static/hostsite/js/js-plugins/jquery.matchHeight.min.js"></script>
<script src="/static/hostsite/js/js-plugins/imagesLoaded.min.js"></script>
<script src="/static/hostsite/js/js-plugins/isotope.pkgd.min.js"></script>
<script src="/static/hostsite/js/js-plugins/ajax-pagination.min.js"></script>
<script src="/static/hostsite/js/js-plugins/Chart.min.js"></script>
<script src="/static/hostsite/js/js-plugins/chartjs-plugin-deferred.min.js"></script>
<script src="/static/hostsite/js/main.js"></script>
<script src="/static/hostsite/js/js-plugins/leaflet-init.js"></script>
<!-- jQuery-scripts for Modules (Send Message) -->
<script src="/static/hostsite/modules/forms/src/js/jquery.validate.min.js"></script>
<script src="/static/hostsite/modules/forms/src/js/sweetalert2.all.js"></script>
<script src="/static/hostsite/modules/forms/src/js/scripts.js"></script>
<!-- SVG icons loader -->
<script src="/static/hostsite/js/svg-loader.js"></script>
<!-- /SVG icons loader -->
<!-- 系统关键js -->
<script type="text/javascript">
    var is_mobile_cms = '';
</script>
<script src="/api/language/zh-cn/lang.js" type="text/javascript"></script>
<script src="/static/assets/js/cms.js" type="text/javascript"></script>
<!-- 系统关键js结束 -->
<!-- livechat -->
<script src="/static/hostsite/js/livechat/livechat.js"></script>
<!-- /livechat -->
<!-- 网站统计代码  -->
<script>var _hmt=_hmt||[];(function(){var hm=document.createElement("script");hm.src="https://hm.baidu.com/hm.js?54fd2183a5418380846b60c34c73d18d";var s=document.getElementsByTagName("script")[0];s.parentNode.insertBefore(hm,s)})()</script><!-- /网站统计代码  -->
</body>

</html>