<!--

 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获取年月日时分秒的方法 | JimmyZ博客</title>
    <meta name="author" content="JimmyZ的个人博客(108881828@qq.com)">
    <meta name="keywords" content="SQL获取年月日时分秒的方法,JimmyZ博客"/>
    <meta name="description" content="SQL获取年月日时分秒的方法" id="meta_description">
    <link rel="canonical" href="https://www.jimmy2k.top/article/163" />
    <link href="https://www.jimmy2k.top/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="https://www.jimmy2k.top/css/zhyd.core.css" rel="stylesheet" type="text/css">
    <link href="https://www.jimmy2k.top/css/zhyd.comment.css" rel="stylesheet" type="text/css">
        <link href="https://cdn.jsdelivr.net/npm/simplemde@1.11.2/dist/simplemde.min.css" rel="stylesheet">
        <link href="https://cdn.jsdelivr.net/npm/github-markdown-css@2.10.0/github-markdown.min.css" rel="stylesheet">
        <link href="https://cdn.jsdelivr.net/npm/highlight.js@9.12.0/styles/github.min.css" rel="stylesheet">
    <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="https://www.jimmy2k.top/about" class="menu_a" title="关于博客" data-toggle="tooltip" data-placement="bottom">关于本站</a></li>
                <li><a href="https://www.jimmy2k.top/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="https://www.jimmy2k.top/img/favicon.ico">JimmyZ博客
            </a>
        </div>
        <div id="navbar" class="navbar-collapse collapse">
            <div class="pull-left site-desc">
                <h1 class="auto-shake"><a href="https://www.jimmy2k.top" data-original-title="温故知新 融汇新旧 贯通古今 回味历史" data-toggle="tooltip" data-placement="bottom">JimmyZ博客</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/4" class="menu_a"><i class="fa fa-linux"></i>Linux</a></li>
                                <li><a href="/type/6" class="menu_a"><i class="fa fa-windows"></i>Wins</a></li>
                                <li><a href="/type/7" class="menu_a"><i class="fa fa-qq"></i>Mysql</a></li>
                                <li class="dropdown">
                                    <a href="/type/1" class="menu_a">
                                        <i class="fa fa-css3"></i>编程&脚本 <span class="caret dropdown-toggle" data-toggle="dropdown" aria-expanded="false"></span>
                                    </a>
                                    <ul class="dropdown-menu" role="menu">
                                        <li><a href="/type/13" title="点击查看《IDEA》的文章">IDEA</a></li>
                                    </ul>
                                </li>
                                <li><a href="/type/2" class="menu_a"><i class="fa fa-coffee"></i>java</a></li>
                                <li class="dropdown">
                                    <a href="/type/3" class="menu_a">
                                        <i class="fa fa-flag"></i>其他 <span class="caret dropdown-toggle" data-toggle="dropdown" aria-expanded="false"></span>
                                    </a>
                                    <ul class="dropdown-menu" role="menu">
                                        <li><a href="/type/15" title="点击查看《IT知识库》的文章">IT知识库</a></li>
                                        <li><a href="/type/5" title="点击查看《日常生活》的文章">日常生活</a></li>
                                    </ul>
                                </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>
<div class="container custome-container">
    <nav class="breadcrumb">
        <a class="crumbs" title="返回首页" href="https://www.jimmy2k.top" data-toggle="tooltip" data-placement="bottom"><i class="fa fa-home"></i>首页</a>
        <i class="fa fa-angle-right"></i>
        <a href="https://www.jimmy2k.top/type/3" title="点击查看该分类文章" data-toggle="tooltip" data-placement="bottom">其他</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="https://www.jimmy2k.top/article/163"><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>2017-07-19</li>
                            <li><i class="fa fa-eye fa-fw"></i><a class="pointer" data-original-title="163人浏览了该文章" data-toggle="tooltip" data-placement="bottom">浏览 (<num>163</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 markdown-body editor-preview-active-side">
                                select w_time,replace(replace(replace(CONVERT(varchar, w_time, 120 ),'-',''),' ',''),':','')&nbsp;from web_Article&nbsp;<br />
                    </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="163" 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="https://www.jimmy2k.top/type/3" data-original-title="点击查看其他分类的文章" data-toggle="tooltip" data-placement="bottom">其他</a></div>
                </div>
            </div>
            <div class="blog-body article-tag">
                <div class="cat">
                    <ul class="list-unstyled">
                        <li>
                            <strong>本文标签：</strong>
                                    <a href="javascript:;;" class="c-label" data-original-title="暂无相关标签" data-toggle="tooltip" data-placement="bottom" target="_blank">暂无相关标签</a>
                        </li>
                        <li>
                            <strong>本文链接：</strong>
                            https://www.jimmy2k.top/article/163
                        </li>
                        <li>
                            <strong>版权声明：</strong>
                            本文由<a href="https://www.jimmy2k.top" target="_blank" data-original-title="JimmyZ博客" data-toggle="tooltip" data-placement="bottom"><strong>JimmyZ的个人博客</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="https://www.jimmy2k.top/article/161" rel="prev">
                            <span class="meta-nav" data-original-title="时间比较" data-toggle="tooltip" data-placement="bottom"><span class="post-nav"><i class="fa fa-angle-left"></i> 上一篇</span>
                                <br>时间比较
                            </span>
                        </a>
                        <a href="https://www.jimmy2k.top/article/164" rel="next">
                            <span class="meta-nav" data-original-title="让SQL查询出来的月份为两位数" data-toggle="tooltip" data-placement="bottom"><span class="post-nav">下一篇 <i class="fa fa-angle-right"></i></span>
                                <br>让SQL查询出来的月份为两位数
                            </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="http://www.jimmy2k.top/upload/20240604164239089.jpg" onerror="this.src='https://www.jimmy2k.top/img/default.png'"width="50" height="50" rel="external nofollow"/>
                                    </div>
                                    <div class="line-right">
                                        <div class="text">
                                            <a href="https://www.jimmy2k.top/article/295" data-original-title="654人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                                linux命令大全(持续更新)
                                            </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>浏览(654)</span>
                                            <span class="comment" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章评论次数">
                                                <a href="https://www.jimmy2k.top/article/295#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="http://www.jimmy2k.top/upload/20240612091010539.png" onerror="this.src='https://www.jimmy2k.top/img/default.png'"width="50" height="50" rel="external nofollow"/>
                                    </div>
                                    <div class="line-right">
                                        <div class="text">
                                            <a href="https://www.jimmy2k.top/article/297" data-original-title="636人浏览了该文章" 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>浏览(636)</span>
                                            <span class="comment" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章评论次数">
                                                <a href="https://www.jimmy2k.top/article/297#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="http://www.jimmy2k.top/upload/20240617102921712.png" onerror="this.src='https://www.jimmy2k.top/img/default.png'"width="50" height="50" rel="external nofollow"/>
                                    </div>
                                    <div class="line-right">
                                        <div class="text">
                                            <a href="https://www.jimmy2k.top/article/215" data-original-title="626人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                                企业微信API-高级功能-读取通讯录的生日字段并定时发送生日祝福语
                                            </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>浏览(626)</span>
                                            <span class="comment" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章评论次数">
                                                <a href="https://www.jimmy2k.top/article/215#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="http://www.jimmy2k.top/upload/20240617102921712.png" onerror="this.src='https://www.jimmy2k.top/img/default.png'"width="50" height="50" rel="external nofollow"/>
                                    </div>
                                    <div class="line-right">
                                        <div class="text">
                                            <a href="https://www.jimmy2k.top/article/236" data-original-title="617人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                                企业微信API-中级功能-shell命令发送信息(合同到期人员)到指定的企业微信接收人
                                            </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>浏览(617)</span>
                                            <span class="comment" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章评论次数">
                                                <a href="https://www.jimmy2k.top/article/236#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="http://www.jimmy2k.top/upload/20240612094715270.png" onerror="this.src='https://www.jimmy2k.top/img/default.png'"width="50" height="50" rel="external nofollow"/>
                                    </div>
                                    <div class="line-right">
                                        <div class="text">
                                            <a href="https://www.jimmy2k.top/article/319" data-original-title="597人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                                Mysql数据恢复-日志文件提取删除数据
                                            </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>浏览(597)</span>
                                            <span class="comment" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章评论次数">
                                                <a href="https://www.jimmy2k.top/article/319#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="http://www.jimmy2k.top/upload/20240606183652227.png" onerror="this.src='https://www.jimmy2k.top/img/default.png'"width="50" height="50" rel="external nofollow"/>
                                    </div>
                                    <div class="line-right">
                                        <div class="text">
                                            <a href="https://www.jimmy2k.top/article/331" data-original-title="586人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                                定时保存占用最多内存和CPU的进程信息
                                            </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>浏览(586)</span>
                                            <span class="comment" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章评论次数">
                                                <a href="https://www.jimmy2k.top/article/331#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="http://www.jimmy2k.top/upload/20240606183652227.png" onerror="this.src='https://www.jimmy2k.top/img/default.png'"width="50" height="50" rel="external nofollow"/>
                                    </div>
                                    <div class="line-right">
                                        <div class="text">
                                            <a href="https://www.jimmy2k.top/article/235" data-original-title="577人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                                企业微信API初级功能-shell命令通过机器人定时自动发送信息
                                            </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>浏览(577)</span>
                                            <span class="comment" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章评论次数">
                                                <a href="https://www.jimmy2k.top/article/235#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="http://www.jimmy2k.top/upload/20240612094715270.png" onerror="this.src='https://www.jimmy2k.top/img/default.png'"width="50" height="50" rel="external nofollow"/>
                                    </div>
                                    <div class="line-right">
                                        <div class="text">
                                            <a href="https://www.jimmy2k.top/article/136" data-original-title="552人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                                mysql问题汇总
                                            </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>浏览(552)</span>
                                            <span class="comment" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章评论次数">
                                                <a href="https://www.jimmy2k.top/article/136#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="http://www.jimmy2k.top/upload/20240606185642461.png" onerror="this.src='https://www.jimmy2k.top/img/default.png'"width="50" height="50" rel="external nofollow"/>
                                    </div>
                                    <div class="line-right">
                                        <div class="text">
                                            <a href="https://www.jimmy2k.top/article/6" data-original-title="499人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                                Telnet远程密码设置
                                            </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>浏览(499)</span>
                                            <span class="comment" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章评论次数">
                                                <a href="https://www.jimmy2k.top/article/6#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="http://www.jimmy2k.top/upload/20240606114915702.png" onerror="this.src='https://www.jimmy2k.top/img/default.png'"width="50" height="50" rel="external nofollow"/>
                                    </div>
                                    <div class="line-right">
                                        <div class="text">
                                            <a href="https://www.jimmy2k.top/article/367" data-original-title="459人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                                通过右键菜单获取图片的尺寸，URL，文件大小，文件类型等信息-chrome
                                            </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>浏览(459)</span>
                                            <span class="comment" title="" data-toggle="tooltip" data-placement="bottom" data-original-title="文章评论次数">
                                                <a href="https://www.jimmy2k.top/article/367#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="https://www.jimmy2k.top/article/6" data-original-title="499人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                            <i class="fa fa-book fa-fw"></i>Telnet远程密码设置
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </li>
                        <li class="line-li">
                            <div class="line-container">
                                <div class="line-right">
                                    <div class="text">
                                        <a href="https://www.jimmy2k.top/article/325" data-original-title="327人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                            <i class="fa fa-book fa-fw"></i>掌阅Ireader方言朗读还原
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </li>
                        <li class="line-li">
                            <div class="line-container">
                                <div class="line-right">
                                    <div class="text">
                                        <a href="https://www.jimmy2k.top/article/317" data-original-title="347人浏览了该文章" 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="https://www.jimmy2k.top/article/307" data-original-title="378人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                            <i class="fa fa-book fa-fw"></i>Chrome开机自启&手动更新
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </li>
                        <li class="line-li">
                            <div class="line-container">
                                <div class="line-right">
                                    <div class="text">
                                        <a href="https://www.jimmy2k.top/article/299" data-original-title="459人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                            <i class="fa fa-book fa-fw"></i>excel下拉菜单可多选
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </li>
                        <li class="line-li">
                            <div class="line-container">
                                <div class="line-right">
                                    <div class="text">
                                        <a href="https://www.jimmy2k.top/article/247" data-original-title="375人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                            <i class="fa fa-book fa-fw"></i>MAC ssh远程虚拟机时非常耗时，速度奇慢
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </li>
                        <li class="line-li">
                            <div class="line-container">
                                <div class="line-right">
                                    <div class="text">
                                        <a href="https://www.jimmy2k.top/article/282" data-original-title="328人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                            <i class="fa fa-book fa-fw"></i>alfred4 mac破解版
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </li>
                        <li class="line-li">
                            <div class="line-container">
                                <div class="line-right">
                                    <div class="text">
                                        <a href="https://www.jimmy2k.top/article/240" data-original-title="344人浏览了该文章" data-toggle="tooltip" data-placement="bottom">
                                            <i class="fa fa-book fa-fw"></i>OFFICE2016\2019提示您的许可证不是正版弹框解决
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </li>
                </ul>
                <div class="clear"></div>
            </div>
            <div class="ad-mark" id="COMMENT_BOX_TOP" style="display: none"></div>
                    <div class="blog-body clear overflow-initial expansion">
                        <div id="comment-box" data-id="163"></div>
                    </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-name">JimmyZ博客</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://www.jimmy2k.top/upload/20240615220816235.jpg' 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=108881828&Site=www.jimmy2k.top&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="https://weibo.com/7375986085" 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/jimmyzrj" 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: 13.35px;margin: 5px;" href="https://www.jimmy2k.top/tag/1" title="Linux" data-toggle="tooltip" data-placement="bottom">
                        Linux
                    </a>
                    <a style="font-size: 13.18px;margin: 5px;" href="https://www.jimmy2k.top/tag/2" title="Java" data-toggle="tooltip" data-placement="bottom">
                        Java
                    </a>
                    <a style="font-size: 13.45px;margin: 5px;" href="https://www.jimmy2k.top/tag/3" title="Spring" data-toggle="tooltip" data-placement="bottom">
                        Spring
                    </a>
                    <a style="font-size: 12.19px;margin: 5px;" href="https://www.jimmy2k.top/tag/4" title="Spring Boot" data-toggle="tooltip" data-placement="bottom">
                        Spring Boot
                    </a>
                    <a style="font-size: 15.16px;margin: 5px;" href="https://www.jimmy2k.top/tag/5" title="其他" data-toggle="tooltip" data-placement="bottom">
                        其他
                    </a>
                    <a style="font-size: 12.65px;margin: 5px;" href="https://www.jimmy2k.top/tag/7" title="Office" data-toggle="tooltip" data-placement="bottom">
                        Office
                    </a>
                    <a style="font-size: 14.3px;margin: 5px;" href="https://www.jimmy2k.top/tag/9" title="Win" data-toggle="tooltip" data-placement="bottom">
                        Win
                    </a>
                    <a style="font-size: 14.07px;margin: 5px;" href="https://www.jimmy2k.top/tag/11" title="Mysql" data-toggle="tooltip" data-placement="bottom">
                        Mysql
                    </a>
                    <a style="font-size: 10.67px;margin: 5px;" href="https://www.jimmy2k.top/tag/13" title="Mac" data-toggle="tooltip" data-placement="bottom">
                        Mac
                    </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="https://www.jimmy2k.top/article/319" title="Mysql数据恢复-日志文件提取删除数据" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> Mysql数据恢复-日志文件提取删除数据
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/297" title=" 无感发布重启服务" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i>  无感发布重启服务
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/295" title="linux命令大全(持续更新)" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> linux命令大全(持续更新)
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/331" title="定时保存占用最多内存和CPU的进程信息" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 定时保存占用最多内存和CPU的进程信息
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/136" title="mysql问题汇总" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> mysql问题汇总
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/367" title="通过右键菜单获取图片的尺寸，URL，文件大小，文件类型等信息-chrome" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 通过右键菜单获取图片的尺寸，URL，文件大小，文件类型等信息-chrome
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/215" title="企业微信API-高级功能-读取通讯录的生日字段并定时发送生日祝福语" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 企业微信API-高级功能-读取通讯录的生日字段并定时发送生日祝福语
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/236" title="企业微信API-中级功能-shell命令发送信息(合同到期人员)到指定的企业微信接收人" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 企业微信API-中级功能-shell命令发送信息(合同到期人员)到指定的企业微信接收人
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/235" title="企业微信API初级功能-shell命令通过机器人定时自动发送信息" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 企业微信API初级功能-shell命令通过机器人定时自动发送信息
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/6" title="Telnet远程密码设置" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> Telnet远程密码设置
                                    </a>
                                </li>
                </ol>
            </div>
            <div role="tabpanel" class="tab-pane" id="home">
                <ol class="list-unstyled">
                                <li>
                                    <a href="https://www.jimmy2k.top/article/319" title="Mysql数据恢复-日志文件提取删除数据" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> Mysql数据恢复-日志文件提取删除数据
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/297" title=" 无感发布重启服务" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i>  无感发布重启服务
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/295" title="linux命令大全(持续更新)" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> linux命令大全(持续更新)
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/367" title="通过右键菜单获取图片的尺寸，URL，文件大小，文件类型等信息-chrome" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 通过右键菜单获取图片的尺寸，URL，文件大小，文件类型等信息-chrome
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/215" title="企业微信API-高级功能-读取通讯录的生日字段并定时发送生日祝福语" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 企业微信API-高级功能-读取通讯录的生日字段并定时发送生日祝福语
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/236" title="企业微信API-中级功能-shell命令发送信息(合同到期人员)到指定的企业微信接收人" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 企业微信API-中级功能-shell命令发送信息(合同到期人员)到指定的企业微信接收人
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/235" title="企业微信API初级功能-shell命令通过机器人定时自动发送信息" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 企业微信API初级功能-shell命令通过机器人定时自动发送信息
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/6" title="Telnet远程密码设置" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> Telnet远程密码设置
                                    </a>
                                </li>
                </ol>
            </div>
            <div role="tabpanel" class="tab-pane" id="messages">
                <ol class="list-unstyled">
                                <li>
                                    <a href="https://www.jimmy2k.top/article/74" title="生成用户登录ID" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 生成用户登录ID
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/95" title="update login_name" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> update login_name
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/31" title="12种最常用的网页编程语言简介" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 12种最常用的网页编程语言简介
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/204" title="文件编辑" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 文件编辑
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/247" title="MAC ssh远程虚拟机时非常耗时，速度奇慢" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> MAC ssh远程虚拟机时非常耗时，速度奇慢
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/42" title="oracle 转换字符集" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> oracle 转换字符集
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/94" title="去重" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 去重
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/96" title="update 两表" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> update 两表
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/103" title="weblogic受控用户密码不正确" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> weblogic受控用户密码不正确
                                    </a>
                                </li>
                                <li>
                                    <a href="https://www.jimmy2k.top/article/39" title="4A-查询重复用户信息" data-toggle="tooltip" data-placement="bottom">
                                        <i class="fa fa-book fa-fw"></i> 4A-查询重复用户信息
                                    </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>  文章总数：296 篇</li>
                <li> <i class="fa fa-tags fa-fw"></i> 标签总数：9 个</li>
                <li> <i class="fa fa-folder-open fa-fw"></i> 分类总数：11 个</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> 运行天数：179天</li>
                <li> <i class="fa fa-pencil-square fa-fw"></i> 最后更新：2024年05月26日12点</li>
                <li> <i class="fa fa-vine fa-fw"></i>  系统版本：<a href="https://gitee.com/yadong.zhang/DBlog/releases/JimmyZ_v1.0" rel="nofollow" target="_blank" style="color: #4286ca;font-weight: 600;">JimmyZ_v1.0</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="https://www.jimmy2k.top/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="https://www.jimmy2k.top/recommended" title="站长推荐" data-toggle="tooltip" data-placement="bottom"><i class="fa fa-thumbs-o-up fa-fw"></i>站长推荐</a></li>
                            <li><a href="https://www.jimmy2k.top/updateLog" title="更新记录" data-toggle="tooltip" data-placement="bottom"><i class="fa fa-file-o fa-fw"></i>更新记录</a></li>
                            <li><a href="https://www.jimmy2k.top/archives" title="归档目录" data-toggle="tooltip" data-placement="bottom"><i class="fa fa-folder-o fa-fw"></i>归档目录</a></li>
                            <li><a href="https://www.jimmy2k.top/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://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://beian.miit.gov.cn/#/Integrated/index" target="_blank" title="查看备案信息" data-toggle="tooltip" data-placement="bottom" rel="external nofollow">粤ICP备17062899号</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 JimmyZ | Powered by <a href="https://gitee.com/yadong.zhang/DBlog" title="OneBlog是一款简洁美观、自适应的Java博客系统..." data-toggle="tooltip" data-placement="right" target="_blank" style="color: #4286ca;font-weight: 600;">OneBlog JimmyZ_v1.0</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://www.jimmy2k.top/js/bootstrap.min.js"></script>
    <script type="text/javascript" src="https://www.jimmy2k.top/js/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: "JimmyZ博客",
        wwwPath: "https://www.jimmy2k.top",
        cmsPath: "https://admin.jimmy2k.top",
        staticPath: "https://www.jimmy2k.top",
        lazyloadPath: "",
        fileStoragePath: "http://www.jimmy2k.top/",
        wxPraiseCode: "http://www.jimmy2k.top/upload/qrcode/20240618101213061.png" || "https://www.jimmy2k.top/img/default.png",
        zfbPraiseCode: "http://www.jimmy2k.top/upload/qrcode/20240618101213204.png" || "https://www.jimmy2k.top/img/default.png",
        anonymous: "1",
        editorPlaceholder: "说点什么吧",
        editorAlert: "讲文明、要和谐",
        dynamicTitle: "您有一条新消息",
        bubbleWord: "",
    };

    var oauthConfig = {
        loginUserId: "",
        loginUserName: "",
        loginUserAvatar: ""
    }
</script>
<script type="text/javascript" src="https://www.jimmy2k.top/js/zhyd.core.js"></script>
<script type="text/javascript" src="https://www.jimmy2k.top/js/zhyd.comment.js"></script>
<script type="text/javascript" src="https://www.jimmy2k.top/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 = '';
        if(isPrivate || isPrivate == 'true') {
            $("#lockModal").modal('show')
        }

        $("#verifyPassword").click(function (){
            var password = $("#password").val();
            var articleId = "163";
            $.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 = "SQL获取年月日时分秒的方法";
            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>