<!--

 111111111111111111111111111111111111111111111110000111111111111111111111111111111111111111111
 111111111111111111111111111111111111111111111000011111111111111111111111111111111111111111111
 111111111111111111111111111111111111111111100000011111111111111111111111111111111111111111111
 111111111111111111111111111111111111111110000001111000110000000000000001111111111111111111111
 111111111111111111111111111111110000000000000000000000000000000001111111111111111111111111111
 111111111111111111111111111111011100000000000000000000000000001111111111111111111111111111111
 111111111111111111111111111111111111100000000000000000000000000000000011111111111111111111111
 111111111111111111111111111111111000000000000000000000000000000011111111111111111111111111111
 111111111111111111111111111111110001110000000000000000000000000000011111111111111111111111111
 111111111111111111111111111110000011000000000001100000000000000000001111111111111111111111111
 111111111111111111111111111100000000000000010011110000000000000110000011111111111111111111111
 111111111111111111111111000000000000000000111011111000000000000011100001111111111111111111111
 111111111111111111111100000000000000000001111111110000000000000001111000111111111111111111111
 111111111111111111111000000001111111111111111111110000000000000000111110011111111111111111111
 111111111111111111111100000111111111111111111111000000000000000000111111111111111111111111111
 111111111111111111111111011111111111111111110000000000000000000000011111111111111111111111111
 111111111111111111111111111111000000000000000000000000000000000000011111111111111111111111111
 111111111111111111111111111111110000000000000000000000000000110000011111111111111111111111111
 111111111111111111111111111100000000000000000000000000000011110000011111111111111111111111111
 111111111111111111111111100000000000000000000000000000000111111000011111111111111111111111111
 111111111111111111111110000000000000000000000000000000111111111000011111111111111111111111111
 111111111111111111111000000000000000000000000000000011111111111000011111111111111111111111111
 111111111111111111110000000000000000000111000000111111111111111000111111111111111111111111111
 111111111111111111100000000000000001111111111111111111111111111001111111111111111111111111111
 111111111111111111000000000000000111111111111111110011111111111111111111111111111111111111111
 111111111111111110000000000000001111111111111111111110000111111111111111111111111111111111111
 111111111111111110000000000100011111111111111111111111100000111111111111111111111111111111111
 111111111111111100000000000110011111111111111111111111111000000011111111111111111111111111111
 111111111111111100000000000011101111111111110001111100001110000000111111111111111111111111111
 111111111111111100000000000001111111111111111100011111000000000000001111111111111111111111111
 111111111111111100000000000000001111111111111100000000000000000000000011111111111111111111111
 111111111111111100100000000000000000111111111000000000000000000000000000111111111111111111111
 111111111111111110011000000000000111111111000000000000000011100000000000011111111111111111111
 111111111111111111011000000000000000000000000000000000011111111111000000001111111111111111111
 111111111111111111111000000000000000000000000000000000111111111111110000000111111111111111111
 111111111111111111111000001000000000000000000110000000011101111111111000000111111111111111111
 111111111111111111111100011111000000000000011111000000000011111111111011000011111111111111111
 111111111111111111111000111111110001000000000111110000011111111111111111000011111111111111111
 111111111111111111111000111111111111111000000011111110000000011111111111100011111111111111111
 111111111111111111111100111111111111111111100000011111111111111111111111110001111111111111111

 -   ----------------------------------   神龙保佑，永无BUG   ------------------------------------   -
    Star me on Gitee - https://gitee.com/yadong.zhang/DBlog
    yadong.zhang (yadong.zhang0415#gmail.com)
    https://docs.zhyd.me
    如有问题请加QQ群(190886500)，备注：dblog
 -   ----------------------------------   神龙保佑，永无BUG   ------------------------------------   -
-->
<!DOCTYPE HTML>
<html lang="zh-CN">
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <title>sql-查询门店客户信息 | 只要肯吃苦，就有很多苦</title>
    <meta name="author" content="admin(1161122599@qq.com)">
    <meta name="keywords" content="1,只要肯吃苦，就有很多苦"/>
    <meta name="description" content="1" id="meta_description">
    <link rel="canonical" href="/article/12" />
    <link href="/img/favicon.ico" rel="shortcut icon" type="image/x-icon">
        <link href="https://cdn.bootcdn.net/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css" rel="stylesheet" type="text/css">
        <link href="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/3.3.5/css/bootstrap.min.css" rel="stylesheet">
        <link href="https://cdn.bootcdn.net/ajax/libs/jquery-confirm/3.3.2/jquery-confirm.min.css" rel="stylesheet">
        <link href="https://cdn.bootcdn.net/ajax/libs/fancybox/2.1.5/jquery.fancybox.min.css" rel="stylesheet">
        <link href="https://cdn.bootcdn.net/ajax/libs/jquery.bootstrapvalidator/0.5.3/css/bootstrapValidator.min.css" rel="stylesheet">
        <link href="https://cdn.bootcdn.net/ajax/libs/nprogress/0.2.0/nprogress.min.css" rel="stylesheet">
    <link href="/css/zhyd.core.css" rel="stylesheet" type="text/css">
    <link href="/css/zhyd.comment.css" rel="stylesheet" type="text/css">
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/social-share.js@1.0.16/dist/css/share.min.css" />

    <style type="text/css">
        
    </style>
</head>
<body>
<nav id="topmenu" class="navbar navbar-default navbar-fixed-top">
    <div class="menu-box">
        <div class="pull-left">
            <ul class="list-unstyled list-inline">
                <li><span id="currentTime"></span></li>
            </ul>
            <div class="clear"></div>
        </div>
        <div class="menu-topmenu-container pull-right">
            <ul class="list-unstyled list-inline pull-left">
                <li><a href="/about" class="menu_a" title="关于博客" data-toggle="tooltip" data-placement="bottom">关于本站</a></li>
                <li><a href="/links" class="menu_a" title="友情链接" data-toggle="tooltip" data-placement="bottom">友情链接</a></li>
            </ul>
        </div>
    </div>
</nav>
<div class="modal" id="oauth" tabindex="-1" role="dialog" aria-labelledby="oauthTitle">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                <ul class="list-inline">
                    <li><h4 class="modal-title" id="oauthTitle">登录</h4></li>
                    <li><a href="javascript:$.alert.info('没用，别点了！我就没打算开发这个功能。Just to show you~~~');"><h4 class="modal-title" id="myModalLabel">注册</h4></a></li>
                </ul>
            </div>
            <div class="modal-body">
                <div class="oauth">
                    <ul class="list-unstyled list-inline oauth-list" style="text-align: center;">
                                <li>
                                    稍等一下， 博主正在快马加鞭的配置~~
                                </li>
                    </ul>
                    <div class="oauth-line">
                        <span style="font-size: 12px">
                            Powered by <a href="https://gitee.com/fujieid/jap" target="_blank">JustAuthPlus(JAP)</a>
                        </span>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<nav id="mainmenu" class="navbar navbar-default navbar-fixed-top" role="navigation">
    <div class="menu-box">
        <div class="navbar-header">
            <span class="pull-right nav-search toggle-search" data-toggle="modal" data-target=".nav-search-box"><i class="fa fa-search"></i></span>
            <button class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
                <span class="sr-only">Toggle navigation</span>
                <span class="icon-bar"></span>
                <span class="icon-bar"></span>
                <span class="icon-bar"></span>
            </button>
            <a class="navbar-brand" href="#">
                <img alt="Brand" src="/img/favicon.ico">只要肯吃苦，就有很多苦
            </a>
        </div>
        <div id="navbar" class="navbar-collapse collapse">
            <div class="pull-left site-desc">
                <h1 class="auto-shake"><a href="" data-original-title="好好学习天天向上" data-toggle="tooltip" data-placement="bottom">只要肯吃苦，就有很多苦</a></h1>
                <p class="site-description">好好学习天天向上</p>
            </div>
            <ul class="nav navbar-nav ">
                <li>
                    <a href="/" class="menu_a"><i class="fa fa-home"></i>首页</a>
                </li>
                                <li><a href="/type/1" class="menu_a"><i class="fa fa-css3"></i>java</a></li>
                                <li><a href="/type/5" class="menu_a"><i class="fa fa-css3"></i>文档</a></li>
                                <li><a href="/type/6" class="menu_a"><i class="fa fa-css3"></i>my-son</a></li>
                                <li><a href="/type/2" class="menu_a"><i class="fa fa-coffee"></i>sql</a></li>
                                <li><a href="/type/3" class="menu_a"><i class="fa fa-folder-open-o"></i>其他文章</a></li>
                                <li><a href="/type/4" class="menu_a"><i class="fa fa-css3"></i>杂谈</a></li>
                <li><a href="/guestbook" class="menu_a"><i class="fa fa-comments-o"></i>留言板</a></li>
                <li><span class="pull-right nav-search main-search" data-toggle="modal" data-target=".nav-search-box"><i class="fa fa-search"></i></span></li>
            </ul>
        </div>
    </div>
</nav>
    <img src="" onerror="this.src='/img/default.png'" style="display: none;" id="cover-img">
<div class="container custome-container">
    <nav class="breadcrumb">
        <a class="crumbs" title="返回首页" href="" data-toggle="tooltip" data-placement="bottom"><i class="fa fa-home"></i>首页</a>
        <i class="fa fa-angle-right"></i>
        <a href="/type/2" title="点击查看该分类文章" data-toggle="tooltip" data-placement="bottom">sql</a>
        <i class="fa fa-angle-right"></i>正文
    </nav>
    <div class="row article-body">
        <div class="col-sm-8 blog-main">
            <div class="blog-body overflow-initial fade-in">
                <div class="article-flag">
                        <span class="article-blockquote article-blockquote-green"></span>
                        <span class="article-original article-original-green">
                            <a href="/article/12"><i class="fa fa-check"></i> 原创</a>
                        </span>
                    <div class="blog-info-meta pull-right">
                        <ul class="list-unstyled list-inline">
                            <li><i class="fa fa-clock-o fa-fw"></i>2024-04-29</li>
                            <li><i class="fa fa-eye fa-fw"></i><a class="pointer" data-original-title="773人浏览了该文章" data-toggle="tooltip" data-placement="bottom">浏览 (<num>773</num>)</a></li>
                            <li><a href="#comment-box" data-original-title="0人评论了该文章" data-toggle="tooltip" data-placement="bottom"><i class="fa fa-comments-o fa-fw"></i>评论 (0)</a></li>
                        </ul>
                    </div>
                </div>
                <div class="blog-info overflow-initial">
                    <h1 class="blog-info-title">
                        <strong>sql-查询门店客户信息</strong>
                    </h1>
                    <div class="blog-info-body ">
                            <div class="ob-alert">
                                <div class="title">
                                    <i class="fa fa-bullhorn fa-fw"></i>
                                    <span class="text">温馨提示：</span>
                                </div>
                                <div class="content">
                                    本文最后更新于 2024年04月29日，已超过 414 天没有更新。若文章内的图片失效（无法正常加载），请留言反馈或直接<a href="mailto:1161122599@qq.com" target="_blank" title="点击给我发邮件" rel="external nofollow"><i class="fa fa fa-envelope fa-fw"></i>联系我</a>。
                                </div>
                            </div>
                            <div class="alert alert-warning alert-dismissible fade in red" role="alert">
                                <i class="fa fa-lock fa-fw"></i> 该文章已被加密，需要 <a href="javascript:void(0)" data-toggle="modal" data-target="#oauth" rel="nofollow" title="授权登录">登录后</a> 才能查看文章详情
                            </div>
                    </div>
                    <div class="separateline"><span>正文到此结束</span></div>
                    <div id="social" style="margin-bottom: 45px;">
                        <div class="social-main">
                            <span class="like">
                                <a href="javascript:;" data-id="12" title="点赞" ><i class="fa fa-thumbs-up"></i>赞 <i class="count"> 0</i> </a>
                            </span>
                            <div class="shang-p">
                                <div class="shang-empty"><span></span></div>
                                <span class="shang-s"><a onclick="PaymentUtils.show();" style="cursor:pointer">赏</a> </span>
                            </div>
                            <div class="share-sd">
                                <span class="share-s"><a href="javascript:void(0)" id="share-s" title="分享"><i class="fa fa-share-alt"></i>分享</a></span>
                                <div id="share" style="display: none">
                                    <div class="social-share" data-initialized="true">
                                        <a href="#" class="social-share-icon icon-twitter"></a>
                                        <a href="#" class="social-share-icon icon-google"></a>
                                        <a href="#" class="social-share-icon icon-facebook"></a>
                                        <a href="#" class="social-share-icon icon-douban"></a>
                                        <a href="#" class="social-share-icon icon-qzone"></a>
                                        <a href="#" class="social-share-icon icon-wechat"></a>
                                        <a href="#" class="social-share-icon icon-qq"></a>
                                        <a href="#" class="social-share-icon icon-weibo"></a>
                                    </div>
                                </div>
                            </div>
                            <div class="clear"></div>
                        </div>
                    </div>
                    <div class="article-footer overflow-initial">所属分类：<a href="/type/2" data-original-title="点击查看sql分类的文章" data-toggle="tooltip" data-placement="bottom">sql</a></div>
                </div>
            </div>
            <div class="blog-body article-tag">
                <div class="cat">
                    <ul class="list-unstyled">
                        <li>
                            <strong>本文标签：</strong>
                                        <a href="/tag/5" class="c-label" data-original-title="其他" data-toggle="tooltip" data-placement="bottom" target="_blank">其他</a>
                        </li>
                        <li>
                            <strong>本文链接：</strong>
                            /article/12
                        </li>
                        <li>
                            <strong>版权声明：</strong>
                            本文由<a href="" target="_blank" data-original-title="只要肯吃苦，就有很多苦" data-toggle="tooltip" data-placement="bottom"><strong>admin</strong></a>原创发布，转载请遵循《<a href="https://creativecommons.org/licenses/by-nc-sa/4.0/deed.zh" target="_blank" rel="nofollow">署名-非商业性使用-相同方式共享 4.0 国际 (CC BY-NC-SA 4.0)</a>》许可协议授权
                        </li>
                    </ul>
                </div>
            </div>
            <div class="ad-mark" id="ARTICLE_BOTTOM" style="display: none"></div>
            <div class="blog-body prev-next">
                <nav class="nav-single wow" data-wow-delay="0.3s">
                        <a href="/article/11" rel="prev">
                            <span class="meta-nav" data-original-title="sql-1" data-toggle="tooltip" data-placement="bottom"><span class="post-nav"><i class="fa fa-angle-left"></i> 上一篇</span>
                                <br>sql-1
                            </span>
                        </a>
                        <a href="/article/13" rel="next">
                            <span class="meta-nav" data-original-title="导出每周数据（工单信息）" data-toggle="tooltip" data-placement="bottom"><span class="post-nav">下一篇 <i class="fa fa-angle-right"></i></span>
                                <br>导出每周数据（工单信息）
                            </span>
                        </a>
                    <div class="clear"></div>
                </nav>
            </div>
            <div class="blog-body clear overflow-initial">
                <h5 class="custom-title"><i class="fa fa-fire fa-fw icon"></i><strong>热门推荐</strong><small></small></h5>
                <ul class="list-unstyled">
                            <li class="line-li">
                                <div class="line-container">
                                    <div class="line-left">
                                            <img class="lazy-img" src="" onerror="this.src='/img/default.png'"width="50" height="50" rel="external nofollow"/>
                                    </div>
                                    <div class="line-right">
                                        <div class="text">
                                            <a href="/article/12" data-original-title="774人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                                sql-查询门店客户信息
                                            </a>
                                        </div>
                                        <div class="text">
                                            <span class="views" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章阅读次数"><i class="fa fa-eye fa-fw"></i>浏览(774)</span>
                                            <span class="comment" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章评论次数">
                                                <a href="/article/12#comment-box" rel="external nofollow">
                                                    <i class="fa fa-comments-o fa-fw"></i>评论(0)
                                                </a>
                                            </span>
                                        </div>
                                    </div>
                                </div>
                            </li>
                            <li class="line-li">
                                <div class="line-container">
                                    <div class="line-left">
                                            <img class="lazy-img" src="" onerror="this.src='/img/default.png'"width="50" height="50" rel="external nofollow"/>
                                    </div>
                                    <div class="line-right">
                                        <div class="text">
                                            <a href="/article/11" data-original-title="760人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                                sql-1
                                            </a>
                                        </div>
                                        <div class="text">
                                            <span class="views" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章阅读次数"><i class="fa fa-eye fa-fw"></i>浏览(760)</span>
                                            <span class="comment" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章评论次数">
                                                <a href="/article/11#comment-box" rel="external nofollow">
                                                    <i class="fa fa-comments-o fa-fw"></i>评论(0)
                                                </a>
                                            </span>
                                        </div>
                                    </div>
                                </div>
                            </li>
                            <li class="line-li">
                                <div class="line-container">
                                    <div class="line-left">
                                            <img class="lazy-img" src="" onerror="this.src='/img/default.png'"width="50" height="50" rel="external nofollow"/>
                                    </div>
                                    <div class="line-right">
                                        <div class="text">
                                            <a href="/article/5" data-original-title="756人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                                系统业务量增加后，canal+ES+rabbitMQ优化查询速度
                                            </a>
                                        </div>
                                        <div class="text">
                                            <span class="views" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章阅读次数"><i class="fa fa-eye fa-fw"></i>浏览(756)</span>
                                            <span class="comment" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章评论次数">
                                                <a href="/article/5#comment-box" rel="external nofollow">
                                                    <i class="fa fa-comments-o fa-fw"></i>评论(0)
                                                </a>
                                            </span>
                                        </div>
                                    </div>
                                </div>
                            </li>
                            <li class="line-li">
                                <div class="line-container">
                                    <div class="line-left">
                                            <img class="lazy-img" src="" onerror="this.src='/img/default.png'"width="50" height="50" rel="external nofollow"/>
                                    </div>
                                    <div class="line-right">
                                        <div class="text">
                                            <a href="/article/8" data-original-title="756人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                                地球上有多少种动植物
                                            </a>
                                        </div>
                                        <div class="text">
                                            <span class="views" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章阅读次数"><i class="fa fa-eye fa-fw"></i>浏览(756)</span>
                                            <span class="comment" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章评论次数">
                                                <a href="/article/8#comment-box" rel="external nofollow">
                                                    <i class="fa fa-comments-o fa-fw"></i>评论(0)
                                                </a>
                                            </span>
                                        </div>
                                    </div>
                                </div>
                            </li>
                            <li class="line-li">
                                <div class="line-container">
                                    <div class="line-left">
                                            <img class="lazy-img" src="" onerror="this.src='/img/default.png'"width="50" height="50" rel="external nofollow"/>
                                    </div>
                                    <div class="line-right">
                                        <div class="text">
                                            <a href="/article/4" data-original-title="737人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                                个人代码托管地址分享
                                            </a>
                                        </div>
                                        <div class="text">
                                            <span class="views" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章阅读次数"><i class="fa fa-eye fa-fw"></i>浏览(737)</span>
                                            <span class="comment" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章评论次数">
                                                <a href="/article/4#comment-box" rel="external nofollow">
                                                    <i class="fa fa-comments-o fa-fw"></i>评论(0)
                                                </a>
                                            </span>
                                        </div>
                                    </div>
                                </div>
                            </li>
                            <li class="line-li">
                                <div class="line-container">
                                    <div class="line-left">
                                            <img class="lazy-img" src="" onerror="this.src='/img/default.png'"width="50" height="50" rel="external nofollow"/>
                                    </div>
                                    <div class="line-right">
                                        <div class="text">
                                            <a href="/article/13" data-original-title="669人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                                导出每周数据（工单信息）
                                            </a>
                                        </div>
                                        <div class="text">
                                            <span class="views" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章阅读次数"><i class="fa fa-eye fa-fw"></i>浏览(669)</span>
                                            <span class="comment" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章评论次数">
                                                <a href="/article/13#comment-box" rel="external nofollow">
                                                    <i class="fa fa-comments-o fa-fw"></i>评论(0)
                                                </a>
                                            </span>
                                        </div>
                                    </div>
                                </div>
                            </li>
                            <li class="line-li">
                                <div class="line-container">
                                    <div class="line-left">
                                            <img class="lazy-img" src="" onerror="this.src='/img/default.png'"width="50" height="50" rel="external nofollow"/>
                                    </div>
                                    <div class="line-right">
                                        <div class="text">
                                            <a href="/article/14" data-original-title="646人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                                导出数据（线索统计数据）
                                            </a>
                                        </div>
                                        <div class="text">
                                            <span class="views" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章阅读次数"><i class="fa fa-eye fa-fw"></i>浏览(646)</span>
                                            <span class="comment" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章评论次数">
                                                <a href="/article/14#comment-box" rel="external nofollow">
                                                    <i class="fa fa-comments-o fa-fw"></i>评论(0)
                                                </a>
                                            </span>
                                        </div>
                                    </div>
                                </div>
                            </li>
                </ul>
                <div class="clear"></div>
            </div>
            <div class="blog-body clear overflow-initial">
                <h5 class="custom-title"><i class="fa fa-google-wallet fa-fw icon"></i><strong>相关文章</strong><small></small></h5>
                <ul class="list-unstyled">
                        <li class="line-li">
                            <div class="line-container">
                                <div class="line-right">
                                    <div class="text">
                                        <a href="/article/14" data-original-title="646人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                            <i class="fa fa-book fa-fw"></i>导出数据（线索统计数据）
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </li>
                        <li class="line-li">
                            <div class="line-container">
                                <div class="line-right">
                                    <div class="text">
                                        <a href="/article/13" data-original-title="669人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                            <i class="fa fa-book fa-fw"></i>导出每周数据（工单信息）
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </li>
                        <li class="line-li">
                            <div class="line-container">
                                <div class="line-right">
                                    <div class="text">
                                        <a href="/article/12" data-original-title="774人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                            <i class="fa fa-book fa-fw"></i>sql-查询门店客户信息
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </li>
                        <li class="line-li">
                            <div class="line-container">
                                <div class="line-right">
                                    <div class="text">
                                        <a href="/article/11" data-original-title="760人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                            <i class="fa fa-book fa-fw"></i>sql-1
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </li>
                </ul>
                <div class="clear"></div>
            </div>
            <div class="ad-mark" id="COMMENT_BOX_TOP" style="display: none"></div>
        </div>
<div class="col-sm-3 blog-sidebar">
        <div class="ad-mark" id="SIDEBAR_TOP" style="display: none"></div>
        <div class="sidebar-module" style="position: relative;">
            <h5 class="custom-title"><i class="fa fa-home fa-fw icon"></i><strong>关于我</strong><small></small></h5>
            <div class="widget">
                <div id="feed_widget">
                    <div class="feed-about">
                        <div class="about-main">
                            <div class="about-img"><a href="http://47.116.212.40:8082/images/20240412102232665.png" class="showImage" title="微信公众号"><img src="http://47.116.212.40:8082/images/20240412102232665.png" alt="微信公众号"></a></div>
                            <div class="about-name">只要肯吃苦，就有很多苦</div>
                            <div class="about-the">好好学习天天向上</div>
                        </div>
                        <div class="clear"></div>
                        <!-- 方案一：图标展示 -->
                        <ul class="widget-icon">
                            <li class="weixin auto-shake" data-container="body"
                                data-toggle="popover" data-trigger="hover" data-placement="bottom" data-html="true" data-content="<img src='http://47.116.212.40:8082/images/20240412102232665.png' style='width: 130px;' alt='QR Code'>">
                                <a class="tag-icon" title="微信" rel="external nofollow"><i class="fa fa-weixin"></i></a>
                            </li>
                            <li class="tqq auto-shake">
                                <a class="tag-icon" href="javascript:window.open('tencent://message/?uin=843977358&Site=www.zhunzhou.work&Menu=yes')" title="点击QQ联系我" target="blank" rel="external nofollow"><i class="fa fa-qq"></i></a>
                            </li>
                            <li class="tsina auto-shake">
                                <a class="tag-icon" href="http://weibo.com/" title="点击查看我的微博" target="_blank" rel="external nofollow"><i class="fa fa-weibo"></i></a>
                            </li>
                            <li class="github auto-shake">
                                <a class="tag-icon" href="https://github.com/" title="点击查看我的github" target="_blank" rel="external nofollow"><i class="fa fa-github"></i></a>
                            </li>
                        </ul>
                        <!-- 方案二：列表展示 -->
                    </div>
                </div>
            </div>
        </div>
    <div class="sidebar-module article-module hide" style="top: 0;">
        <h5 class="custom-title"><i class="fa fa-book fa-fw icon"></i><strong>本文目录</strong><i class="fa fa-close pull-right close-article-menu hide pointer"></i><small></small></h5>
        <div id="article-menu" style="overflow:auto">
            <ul class="list-unstyled"></ul>
        </div>
    </div>
    <div class="sidebar-module">
        <h5 class="custom-title"><i class="fa fa-tags fa-fw icon"></i><strong>标签云</strong><small></small></h5>
                    <a style="font-size: 12.86px;margin: 5px;" href="/tag/1" title="Linux" data-toggle="tooltip" data-placement="bottom">
                        Linux
                    </a>
                    <a style="font-size: 15.26px;margin: 5px;" href="/tag/2" title="Java" data-toggle="tooltip" data-placement="bottom">
                        Java
                    </a>
                    <a style="font-size: 11.79px;margin: 5px;" href="/tag/3" title="Spring" data-toggle="tooltip" data-placement="bottom">
                        Spring
                    </a>
                    <a style="font-size: 12.5px;margin: 5px;" href="/tag/4" title="Spring Boot" data-toggle="tooltip" data-placement="bottom">
                        Spring Boot
                    </a>
                    <a style="font-size: 11.98px;margin: 5px;" href="/tag/5" title="其他" data-toggle="tooltip" data-placement="bottom">
                        其他
                    </a>
    </div>
    <div class="sidebar-module">
        <ul class="nav nav-tabs sidebar-tabs" role="tablist">
            <li role="presentation" class="active"><a href="#profile" aria-controls="profile" role="tab" data-toggle="tab"><i class="fa fa-list"></i>近期文章</a></li>
            <li role="presentation"><a href="#home" aria-controls="home" role="tab" data-toggle="tab"><i class="fa fa-thumbs-o-up"></i>站长推荐</a></li>
            <li role="presentation"><a href="#messages" aria-controls="messages" role="tab" data-toggle="tab"><i class="fa fa-hand-peace-o"></i>随机文章</a></li>
        </ul>
        <div class="tab-content">
            <div role="tabpanel" class="tab-pane active" id="profile">
                <ol class="list-unstyled">
                                <li>
                                    <a href="/article/14" title="导出数据（线索统计数据）" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 导出数据（线索统计数据）
                                    </a>
                                </li>
                                <li>
                                    <a href="/article/13" title="导出每周数据（工单信息）" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 导出每周数据（工单信息）
                                    </a>
                                </li>
                                <li>
                                    <a href="/article/12" title="sql-查询门店客户信息" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> sql-查询门店客户信息
                                    </a>
                                </li>
                                <li>
                                    <a href="/article/11" title="sql-1" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> sql-1
                                    </a>
                                </li>
                                <li>
                                    <a href="/article/8" title="地球上有多少种动植物" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 地球上有多少种动植物
                                    </a>
                                </li>
                                <li>
                                    <a href="/article/5" title="系统业务量增加后，canal+ES+rabbitMQ优化查询速度" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 系统业务量增加后，canal+ES+rabbitMQ优化查询速度
                                    </a>
                                </li>
                                <li>
                                    <a href="/article/4" title="个人代码托管地址分享" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 个人代码托管地址分享
                                    </a>
                                </li>
                </ol>
            </div>
            <div role="tabpanel" class="tab-pane" id="home">
                <ol class="list-unstyled">
                            <li class="empty-list">
                                <i class="fa fa-bookmark-o fa-fw"></i> 暂无相关文章
                            </li>
                </ol>
            </div>
            <div role="tabpanel" class="tab-pane" id="messages">
                <ol class="list-unstyled">
                                <li>
                                    <a href="/article/5" title="系统业务量增加后，canal+ES+rabbitMQ优化查询速度" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 系统业务量增加后，canal+ES+rabbitMQ优化查询速度
                                    </a>
                                </li>
                                <li>
                                    <a href="/article/12" title="sql-查询门店客户信息" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> sql-查询门店客户信息
                                    </a>
                                </li>
                                <li>
                                    <a href="/article/13" title="导出每周数据（工单信息）" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 导出每周数据（工单信息）
                                    </a>
                                </li>
                                <li>
                                    <a href="/article/14" title="导出数据（线索统计数据）" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 导出数据（线索统计数据）
                                    </a>
                                </li>
                                <li>
                                    <a href="/article/8" title="地球上有多少种动植物" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 地球上有多少种动植物
                                    </a>
                                </li>
                                <li>
                                    <a href="/article/11" title="sql-1" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> sql-1
                                    </a>
                                </li>
                                <li>
                                    <a href="/article/4" title="个人代码托管地址分享" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 个人代码托管地址分享
                                    </a>
                                </li>
                </ol>
            </div>
        </div>
    </div>
    <div class="clear"></div>
    <div class="sidebar-module">
        <h5 class="custom-title"><i class="fa fa-info fa-fw icon"></i><strong>网站信息</strong><small></small></h5>
        <ul class="ul-default site-info">
                <li> <i class="fa fa-file fa-fw"></i>  文章总数：7 篇</li>
                <li> <i class="fa fa-tags fa-fw"></i> 标签总数：5 个</li>
                <li> <i class="fa fa-folder-open fa-fw"></i> 分类总数：6 个</li>
                <li> <i class="fa fa-comments fa-fw"></i> 留言数量：0 条</li>
                <li> <i class="fa fa-users fa-fw"></i> 在线人数：<span class="online">1</span>人</li>
                <li> <i class="fa fa-calendar fa-fw"></i> 运行天数：432天</li>
                <li> <i class="fa fa-pencil-square fa-fw"></i> 最后更新：2024年04月11日15点</li>
                <li> <i class="fa fa-vine fa-fw"></i>  系统版本：<a href="https://gitee.com/yadong.zhang/DBlog/releases/v2.3.4" rel="nofollow" target="_blank" style="color: #4286ca;font-weight: 600;">v2.3.4</a></li>
        </ul>
    </div>
    <div class="ad-mark" id="SIDEBAR_BOTTOM" style="display: none"></div>
</div>
    </div>
</div>
<div id="lockModal" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="mySmallModalLabel" aria-hidden="true" data-keyboard="false">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                <h4 class="modal-title" id="myModalLabel">输入密码查看文章详情</h4>
            </div>
            <div class="modal-body">
                <input type="text" name="password" id="password" class="form-control" placeholder="请输入文章密码">
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-primary" id="verifyPassword">确定</button>
            </div>
        </div>
    </div>
</div>
<div class="modal fade nav-search-box" tabindex="-1" role="dialog" aria-labelledby="navSearchModalLabel">
    <div class="modal-dialog modal-lg" role="document">
        <div class="modal-content">
            <div class="modal-header" style="padding: 5px 15px;">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close" style="margin-top: 10px;"><span aria-hidden="true">&times;</span></button>
                <h4><i class="fa fa-search"></i> 搜索文章</h4>
            </div>
            <div class="modal-body">
                <form action="/" method="post" class="form-horizontal searchForm" id="searchForm">
                    <input type="hidden" name="pageNumber" value="1">
                    <div class="input-group bottom-line">
                        <input type="text" class="form-control br-none" name="keywords" value="" required="required" placeholder="输入搜索内容">
                        <span class="input-group-btn">
                        <button class="btn btn-default br-none nav-search-btn pointer" type="submit"><i class="fa fa-search"></i> 搜索</button>
                    </span>
                    </div>
                    <div class="clear"></div>
                    <ul class="list-unstyled list-inline search-hot">
                        <li><strong style="position: relative;top: 2px;color: #999999;">热门搜索：</strong></li>
                                    <li><a class="pointer" rel="external nofollow"><span class="label label-info">Java</span></a></li>
                                    <li><a class="pointer" rel="external nofollow"><span class="label label-info">SpringBoot</span></a></li>
                    </ul>
                </form>
            </div>
        </div>
    </div>
</div>
<!--评论弹框-->
<div class="modal fade bs-example-modal-sm" id="comment-detail-modal" tabindex="-1" role="dialog" aria-labelledby="comment-detail-modal-label">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                <h4 class="modal-title" id="comment-detail-modal-label">评论信息框</h4>
                <small><i class="fa fa-lightbulb-o fa-fw"></i>可以通过QQ号实时获取昵称和头像</small>
            </div>
            <div class="modal-body">
                <form id="detail-form">
                    <input type="hidden" name="avatar">
                    <div class="form-group input-logo">
                        <input type="text" class="form-control" name="qq" placeholder="选填" value="">
                        <img class="pull-left hide" alt="">
                        <span class="fa fa-qq pull-left" aria-hidden="true">QQ</span>
                    </div>
                    <div class="form-group input-logo">
                        <input type="text" class="form-control" name="nickname" placeholder="必填" value="匿名">
                        <span class="fa fa-user pull-left" aria-hidden="true">昵称</span>
                    </div>
                    <div class="form-group input-logo">
                        <input type="text" class="form-control" name="email" placeholder="选填">
                        <span class="fa fa-envelope pull-left" aria-hidden="true">邮箱</span>
                    </div>
                    <div class="form-group input-logo">
                        <input type="text" class="form-control" name="url" placeholder="选填">
                        <span class="fa fa-globe pull-left" aria-hidden="true">网址</span>
                    </div>
                    <div class="form-group">
                        <button type="button" class="btn btn-default btn-sm" id="detail-form-btn"><i class="fa fa-smile-o"></i>提交评论</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>
<div class="modal fade" id="reward" tabindex="-1" role="dialog">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                <h4 class="modal-title">山无棱江水为竭，冬雷震震夏雨雪，才敢请君舍</h4>
            </div>
            <div class="modal-body">
                <div class="rewardType" align="center">
                    <ul class="list-unstyle list-inline">
                        <li style="margin-right: 20px;">
                            <input type="radio" name="type" id="alipay" onclick="PaymentUtils.change(0)" data-index="0" checked="checked" ><span style="margin-left: 5px;">支付宝</span>
                        </li>
                        <li style="margin-right: 20px;">
                            <input type="radio" name="type" id="wechat" onclick="PaymentUtils.change(1)" data-index="1"><span style="margin-left: 5px;">微信</span>
                        </li>
                    </ul>
                </div>
                <div id="qrcode-container" align="center" style="margin-top: 10px;"></div>
                <div style="width: 100%;color: #a3a3a3;font-size: 16px;font-family: 'Microsoft YaHei';text-align: center;">
                    转账时请备注“<strong>博客赞助</strong>”
                </div>
            </div>
        </div>
        <small class="font-bold"></small>
    </div>
    <small class="font-bold"> </small>
</div>
<div id="loading">
    <div class="filter"></div>
    <div class="loader">
        <div class="loading-1"></div>
        <div class="loading-2">Loading...</div>
    </div>
</div>
        <footer class="footer">
            <div class="container">
                <div class="row">
                    <div class="col col-xs-12 col-md-12 col-lg-12">
                        <p>
                        <ul class="list-unstyled list-inline">
                            <li>其他连接：</li>
                            <li><a href="/sitemap.html" target="_blank" title="网站地图" data-toggle="tooltip" data-placement="bottom"><i class="fa fa-map-o fa-fw"></i>网站地图</a></li>
                            <li><a href="/recommended" title="站长推荐" data-toggle="tooltip" data-placement="bottom"><i class="fa fa-thumbs-o-up fa-fw"></i>站长推荐</a></li>
                            <li><a href="/updateLog" title="更新记录" data-toggle="tooltip" data-placement="bottom"><i class="fa fa-file-o fa-fw"></i>更新记录</a></li>
                            <li><a href="/archives" title="归档目录" data-toggle="tooltip" data-placement="bottom"><i class="fa fa-folder-o fa-fw"></i>归档目录</a></li>
                            <li><a href="/disclaimer" title="免责声明" data-toggle="tooltip" data-placement="bottom"><i class="fa fa-file-o fa-fw"></i>免责声明</a></li>
                        </ul>
                        </p>
                        <p><a href="https://beian.miit.gov.cn/" target="_blank">皖ICP备2022010854号-1</a></p>
                        <p>托管于<a href="https://promotion.aliyun.com/ntms/act/ambassador/sharetouser.html?userCode=wylo59db" target="_blank" title="阿里云-为了无法计算的价值" data-toggle="tooltip" data-placement="bottom" rel="external nofollow">阿里云</a> & <a href="https://portal.qiniu.com/signup?code=3l8yx2v0f21ci" target="_blank" title="七牛云-国内领先的企业级云服务商" data-toggle="tooltip" data-placement="bottom" rel="external nofollow">七牛云</a></p>
                    </div>
                    <div class="col col-md-4"></div>
                </div>
            </div>
        </footer>
    <footer class="footer">
        <div class="container">
            <div class="row">
                <div class="col col-xs-12 col-md-12 col-lg-12">
                    <p>Copyright zhunzhou.work | Powered by <a href="https://gitee.com/yadong.zhang/DBlog" title="Study hard是一款简洁美观、自适应的Java博客系统..." data-toggle="tooltip" data-placement="right" target="_blank" style="color: #4286ca;font-weight: 600;">Study hard v2.3.4</a>  </p>

                </div>
            </div>
        </div>
    </footer>
<a class="to-top" title="点击返回顶部" data-toggle="tooltip" data-placement="bottom"></a>
    <script type="text/javascript" src="https://cdn.staticfile.org/jquery/1.11.1/jquery.min.js"></script>
    <script type="text/javascript" src="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/3.3.5/js/bootstrap.min.js"></script>
    <script type="text/javascript" src="https://cdn.staticfile.org/jquery.lazyload/1.9.1/jquery.lazyload.min.js"></script>
    <script type="text/javascript" src="https://cdn.staticfile.org/jquery-confirm/3.3.2/jquery-confirm.min.js"></script>
    <script type="text/javascript" src="https://cdn.staticfile.org/fancybox/2.1.5/jquery.fancybox.min.js"></script>
    <script type="text/javascript" src="https://cdn.staticfile.org/bootstrap-validator/0.5.3/js/bootstrapValidator.min.js"></script>
    <script type="text/javascript" src="https://cdn.staticfile.org/nprogress/0.2.0/nprogress.min.js"></script>
    <script type="text/javascript" src="https://cdn.staticfile.org/js-xss/0.3.3/xss.min.js"></script>
    <script type="text/javascript" src="https://cdn.staticfile.org/mustache.js/2.3.0/mustache.min.js"></script>
<script type="text/javascript">
    var appConfig = {
        siteName: "只要肯吃苦，就有很多苦",
        wwwPath: "",
        cmsPath: "8085",
        staticPath: "",
        lazyloadPath: "",
        fileStoragePath: "",
        wxPraiseCode: "" || "/img/default.png",
        zfbPraiseCode: "" || "/img/default.png",
        anonymous: "1",
        editorPlaceholder: "说点什么吧",
        editorAlert: "讲文明、要和谐",
        dynamicTitle: "您有一条新消息",
        bubbleWord: "",
    };

    var oauthConfig = {
        loginUserId: "",
        loginUserName: "",
        loginUserAvatar: ""
    }
</script>
<script type="text/javascript" src="/js/zhyd.core.js"></script>
<script type="text/javascript" src="/js/zhyd.comment.js"></script>
<script type="text/javascript" src="/js/zhyd.js"></script>
<script type="text/javascript" id="customJs">
    
</script>

    <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/highlight.js@9.12.0/lib/highlight.min.js"></script>
	<script type="text/javascript" src="https://cdn.jsdelivr.net/npm/simplemde@1.11.2/dist/simplemde.min.js"></script>
    <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/social-share.js@1.0.16/dist/js/social-share.min.js"></script>
    <script src="http://res.wx.qq.com/open/js/jweixin-1.6.0.js" type="text/javascript"></script>

    <script>
        var isPrivate = 'true';
        if(isPrivate || isPrivate == 'true') {
            $("#lockModal").modal('show')
        }

        $("#verifyPassword").click(function (){
            var password = $("#password").val();
            var articleId = "12";
            $.post("/api/verifyArticlePassword", {articleId : articleId, password: password}, function (json) {
                $.alert.ajaxSuccess(json);
                if(json.status === 200) {
                    $(".blog-info-body").html(json.data);
                    $("#lockModal").modal('hide')
                }
            })
        })


        $(function () {
            var url = location.href.split("#")[0];
            //当前页面的url
            var encodeUrl = encodeURIComponent(url);

            var title = "sql-查询门店客户信息";
            var desc = "1";
            var imgUrl = "";

            $.post("/api/jssdkGetSignature", {url: encodeUrl}, function (json) {
                // $.alert.ajaxSuccess(json);

                if (json.status === 200) {
                    var signature = json.data.signature;
                    var timestamp = json.data.timestamp;
                    var noncestr = json.data.noncestr;
                    var appid = json.data.appid;
                    var jsapi_ticket = json.data.ticket;

                    // alert(signature + "---" + timestamp + "---" + noncestr + "---" + appid + "---" + jsapi_ticket);
                    // console.log(signature + "---" + timestamp + "---" + noncestr + "---" + appid + "---" + jsapi_ticket)
                    wx.config({
                        debug: false, // true:开启调试模式,调用的所有 api 的返回值会在客户端 alert 出来，若要查看传入的参数，可以在 pc 端打开，参数信息会通过 log 打出，仅在 pc 端时才会打印。
                        appId: appid, // 必填，公众号的唯一标识
                        timestamp: timestamp, // 必填，生成签名的时间戳
                        nonceStr: noncestr, // 必填，生成签名的随机串
                        signature: signature,// 必填，签名
                        jsApiList: ["updateAppMessageShareData", "updateTimelineShareData"] // 必填，需要使用的 JS 接口列表
                    });

                    wx.error(function (res) {
                        // alert(JSON.stringify(res));
                        // config信息验证失败会执行 error 函数，如签名过期导致验证失败，具体错误信息可以打开 config 的debug模式查看，也可以在返回的 res 参数中查看，对于 SPA 可以在这里更新签名。
                        console.log(JSON.stringify(res))
                    });

                    var mTitle = title + '| 蜂唤信息公众号';
                    wx.ready(function () {
                        //需在用户可能点击分享按钮前就先调用 自定义“分享到朋友圈”及“分享到 QQ 空间”按钮的分享内容
                        wx.updateTimelineShareData({
                            title: mTitle, // 分享标题
                            link: url, // 分享链接，该链接域名或路径必须与当前页面对应的公众号 JS 安全域名一致
                            imgUrl: imgUrl, // 分享图标
                            success: function () {
                                // 设置成功
                            }
                        });

                    });

                    var nTitle = '您有新消息| ' + title + '| 蜂唤信息公众号';
                    wx.ready(function () {
                        //需在用户可能点击分享按钮前就先调用 自定义“分享给朋友”及“分享到QQ”按钮的分享内容
                        wx.updateAppMessageShareData({
                            title: nTitle, // 分享标题
                            desc: desc, // 分享描述
                            link: url, // 分享链接，该链接域名或路径必须与当前页面对应的公众号 JS 安全域名一致
                            imgUrl: imgUrl, // 分享图标
                            success: function () {
                                // 设置成功
                            }
                        });
                    });

                }
            })
        })
    </script>

    </body>
</html>