-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path210206-SpringBoot-使用JdbcTemplate操作数据库.html
27 lines (26 loc) · 28.1 KB
/
210206-SpringBoot-使用JdbcTemplate操作数据库.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
<!DOCTYPE html><html lang="zh-CN"><head><meta name="generator" content="Hexo 3.9.0"><meta http-equiv="content-type" content="text/html; charset=utf-8"><meta content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0" name="viewport"><meta content="yes" name="apple-mobile-web-app-capable"><meta content="black-translucent" name="apple-mobile-web-app-status-bar-style"><meta content="telephone=no" name="format-detection"><meta name="description" content><title>SpringBoot-使用JdbcTemplate操作数据库 | zhiheng's blog</title><link rel="stylesheet" type="text/css" href="/css/style.css?v=1.0.0"><link rel="stylesheet" type="text/css" href="//cdn.jsdelivr.net/npm/normalize.css/normalize.min.css"><link rel="stylesheet" type="text/css" href="//cdn.jsdelivr.net/npm/purecss/build/pure-min.min.css"><link rel="stylesheet" type="text/css" href="//cdn.jsdelivr.net/npm/purecss/build/grids-responsive-min.css"><link rel="stylesheet" href="//cdn.jsdelivr.net/npm/[email protected]/css/font-awesome.min.css"><script type="text/javascript" src="//cdn.jsdelivr.net/npm/jquery/dist/jquery.min.js"></script><link rel="icon" mask sizes="any" href="/img/favicon.ico"><link rel="Shortcut Icon" type="image/x-icon" href="/img/favicon.ico"><link rel="apple-touch-icon" href="/apple-touch-icon.png"><link rel="apple-touch-icon-precomposed" href="/apple-touch-icon.png"><link rel="alternate" type="application/atom+xml" href="/atom.xml"><script type="text/javascript" src="//cdn.jsdelivr.net/npm/clipboard/dist/clipboard.min.js"></script><script type="text/javascript" src="//cdn.jsdelivr.net/gh/codeseven/toastr/build/toastr.min.js"></script><link rel="stylesheet" href="//cdn.jsdelivr.net/gh/codeseven/toastr/build/toastr.min.css"></head><body><div class="body_container"><div id="header"><div class="site-name"><h1 class="hidden">SpringBoot-使用JdbcTemplate操作数据库</h1><a id="logo" href="/.">zhiheng's blog</a><p class="description">喜于分享，勤于积累；欢迎关注我的微信公众号：治恒说说</p></div><div id="nav-menu"><a class="current" href="/."><i class="fa fa-home"> 首页</i></a><a href="/archives/"><i class="fa fa-archive"> 归档</i></a><a href="/about/"><i class="fa fa-user"> 关于</i></a><a href="/demo/"><i class="fa fa-square"> 有趣的代码</i></a></div></div><div class="pure-g" id="layout"><div class="pure-u-1 pure-u-md-3-4"><div class="content_container"><div class="post"><h1 class="post-title">SpringBoot-使用JdbcTemplate操作数据库</h1><div class="post-meta">2021年02月06日<span> | </span><span class="category"><a href="/categories/Spring-Boot/">Spring Boot</a></span><script src="https://busuanzi.ibruce.info/busuanzi/2.3/busuanzi.pure.mini.js" async></script><span id="busuanzi_container_page_pv"> | <span id="busuanzi_value_page_pv"></span><span> 阅读</span></span></div><div class="post-content"><p>关于 JDBC 肯定是 java 开发者的入门知识，很显然在 Spring boot 中的使用也是非常简单的，这一节先当与给大家复习了，已熟知的同学请忽略。</p>
<blockquote>
<p>Tips：示例中 MySQL 使用5.7版本，spring boot 使用 2.4.2版本</p>
</blockquote>
<h2 id="加依赖"><a href="#加依赖" class="headerlink" title="加依赖"></a>加依赖</h2><figure class="highlight xml"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br></pre></td><td class="code"><pre><span class="line"><span class="tag"><<span class="name">dependency</span>></span></span><br><span class="line"> <span class="tag"><<span class="name">groupId</span>></span>org.springframework.boot<span class="tag"></<span class="name">groupId</span>></span></span><br><span class="line"> <span class="tag"><<span class="name">artifactId</span>></span>spring-boot-starter-jdbc<span class="tag"></<span class="name">artifactId</span>></span></span><br><span class="line"><span class="tag"></<span class="name">dependency</span>></span></span><br></pre></td></tr></table></figure>
<p>请注意这里使用的包是<code>spring-boot-starter-jdbc</code>，其实在使用中你会发现会有这样一个包<code>spring-boot-starter-data-jdbc</code>，那么他们是什么区别呢？</p>
<p>区别在于，前者是 Spring支持JDBC数据库的包，使用<code>DataSourceTransactionManager</code>管理事务；后者是 Jpa 对JDBC的支持，使用<code>JpaTransactionManager</code>管理事务。至于 Jpa，后面会有相关的文章介绍。</p>
<h2 id="写配置"><a href="#写配置" class="headerlink" title="写配置"></a>写配置</h2><figure class="highlight less"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br></pre></td><td class="code"><pre><span class="line"><span class="attribute">server</span>:</span><br><span class="line"> <span class="attribute">port</span>: <span class="number">8080</span></span><br><span class="line"><span class="attribute">spring</span>:</span><br><span class="line"> <span class="attribute">application</span>:</span><br><span class="line"> <span class="attribute">name</span>: spring-boot-jdbc</span><br><span class="line"> <span class="attribute">datasource</span>:</span><br><span class="line"> <span class="attribute">driver-class-name</span>: com.mysql.jdbc.Driver</span><br><span class="line"> <span class="attribute">url</span>: <span class="attribute">jdbc</span>:<span class="attribute">mysql</span>:<span class="comment">//localhost:3306/test</span></span><br><span class="line"> <span class="attribute">username</span>: shure</span><br><span class="line"> <span class="attribute">password</span>: shure</span><br></pre></td></tr></table></figure>
<p>要想访问数据库，那肯定要配置数据库的连接信息了<br><strong>注意：</strong>mysql8.0的驱动包有所变化 <code>com.mysql.cj.jdbc.Driver</code></p>
<h2 id="加注解"><a href="#加注解" class="headerlink" title="加注解"></a>加注解</h2><p>无需注解</p>
<h2 id="编码"><a href="#编码" class="headerlink" title="编码"></a>编码</h2><p>首先在mysql数据库中建立 user 的数据表。<br><figure class="highlight sql"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br></pre></td><td class="code"><pre><span class="line"><span class="keyword">DROP</span> <span class="keyword">TABLE</span> <span class="keyword">IF</span> <span class="keyword">EXISTS</span> <span class="string">`t_user`</span>;</span><br><span class="line"><span class="keyword">CREATE</span> <span class="keyword">TABLE</span> <span class="string">`t_user`</span> (</span><br><span class="line"> <span class="string">`id`</span> <span class="built_in">int</span>(<span class="number">8</span>) <span class="keyword">unsigned</span> <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line"> <span class="string">`name`</span> <span class="built_in">varchar</span>(<span class="number">100</span>) <span class="keyword">COLLATE</span> utf8mb4_general_ci <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line"> <span class="string">`age`</span> <span class="built_in">int</span> <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line"> <span class="string">`gender`</span> <span class="built_in">varchar</span>(<span class="number">8</span>) <span class="keyword">COLLATE</span> utf8mb4_general_ci <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line"> <span class="string">`address`</span> <span class="built_in">varchar</span>(<span class="number">500</span>) <span class="keyword">COLLATE</span> utf8mb4_general_ci <span class="keyword">NOT</span> <span class="literal">NULL</span>,</span><br><span class="line"> PRIMARY <span class="keyword">KEY</span> (<span class="string">`id`</span>)</span><br><span class="line">) <span class="keyword">ENGINE</span>=<span class="keyword">InnoDB</span> <span class="keyword">DEFAULT</span> <span class="keyword">CHARSET</span>=utf8mb4 <span class="keyword">COLLATE</span>=utf8mb4_general_ci;</span><br></pre></td></tr></table></figure></p>
<p>然后，建立 user 表对应的实体类，并添加构造函数。<br><figure class="highlight arduino"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br><span class="line">11</span><br><span class="line">12</span><br><span class="line">13</span><br><span class="line">14</span><br><span class="line">15</span><br></pre></td><td class="code"><pre><span class="line">@Data</span><br><span class="line"><span class="keyword">public</span> <span class="class"><span class="keyword">class</span> <span class="title">UserEntity</span> {</span></span><br><span class="line"> <span class="keyword">private</span> Integer id;</span><br><span class="line"> <span class="keyword">private</span> <span class="keyword">String</span> name;</span><br><span class="line"> <span class="keyword">private</span> <span class="keyword">int</span> age;</span><br><span class="line"> <span class="keyword">private</span> <span class="keyword">boolean</span> gender;</span><br><span class="line"> <span class="keyword">private</span> <span class="keyword">String</span> address;</span><br><span class="line"> <span class="function"><span class="keyword">public</span> <span class="title">UserEntity</span><span class="params">()</span></span>{}</span><br><span class="line"> <span class="function"><span class="keyword">public</span> <span class="title">UserEntity</span><span class="params">(<span class="keyword">String</span> name, <span class="keyword">int</span> age, <span class="keyword">boolean</span> gender, <span class="keyword">String</span> address)</span></span>{</span><br><span class="line"> <span class="keyword">this</span>.name = name;</span><br><span class="line"> <span class="keyword">this</span>.age = age;</span><br><span class="line"> <span class="keyword">this</span>.gender = gender;</span><br><span class="line"> <span class="keyword">this</span>.address = address;</span><br><span class="line"> }</span><br><span class="line">}</span><br></pre></td></tr></table></figure></p>
<p>再然后，编写访问数据库的操作。<br><figure class="highlight livescript"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br><span class="line">11</span><br><span class="line">12</span><br><span class="line">13</span><br><span class="line">14</span><br><span class="line">15</span><br><span class="line">16</span><br><span class="line">17</span><br><span class="line">18</span><br><span class="line">19</span><br><span class="line">20</span><br><span class="line">21</span><br><span class="line">22</span><br><span class="line">23</span><br><span class="line">24</span><br><span class="line">25</span><br><span class="line">26</span><br><span class="line">27</span><br><span class="line">28</span><br><span class="line">29</span><br><span class="line">30</span><br><span class="line">31</span><br><span class="line">32</span><br><span class="line">33</span><br><span class="line">34</span><br><span class="line">35</span><br><span class="line">36</span><br><span class="line">37</span><br><span class="line">38</span><br><span class="line">39</span><br><span class="line">40</span><br><span class="line">41</span><br><span class="line">42</span><br><span class="line">43</span><br><span class="line">44</span><br><span class="line">45</span><br><span class="line">46</span><br><span class="line">47</span><br><span class="line">48</span><br><span class="line">49</span><br><span class="line">50</span><br><span class="line">51</span><br></pre></td><td class="code"><pre><span class="line">@Repository</span><br><span class="line">public <span class="class"><span class="keyword">class</span> <span class="title">UserJdbcDao</span> {</span></span><br><span class="line"> @Autowired</span><br><span class="line"> private JdbcTemplate jdbcTemplate;</span><br><span class="line"> public List<UserEntity> findAll(String name){</span><br><span class="line"> List<UserEntity> <span class="keyword">list</span> = jdbcTemplate.query<span class="function"><span class="params">(<span class="string">"SELECT * FROM t_user WHERE name = ?"</span>, (res, i) -> {</span></span></span><br><span class="line"><span class="function"><span class="params"> UserEntity user = <span class="keyword">new</span> UserEntity();</span></span></span><br><span class="line"><span class="function"><span class="params"> user.setId(res.getInt(<span class="string">"ID"</span>));</span></span></span><br><span class="line"><span class="function"><span class="params"> user.setName(res.getString(<span class="string">"NAME"</span>));</span></span></span><br><span class="line"><span class="function"><span class="params"> user.setAddress(res.getString(<span class="string">"ADDRESS"</span>));</span></span></span><br><span class="line"><span class="function"><span class="params"> user.setAge(res.getInt(<span class="string">"AGE"</span>));</span></span></span><br><span class="line"><span class="function"><span class="params"> user.setGender(res.getBoolean(<span class="string">"GENDER"</span>));</span></span></span><br><span class="line"><span class="function"><span class="params"> <span class="keyword">return</span> user;</span></span></span><br><span class="line"><span class="function"><span class="params"> }, name)</span>;</span></span><br><span class="line"><span class="function"> <span class="title">return</span> <span class="title">list</span>;</span></span><br><span class="line"><span class="function"> }</span></span><br><span class="line"><span class="function"></span></span><br><span class="line"><span class="function"> <span class="title">public</span> <span class="title">UserEntity</span> <span class="title">getUser</span><span class="params">(Integer id)</span>{</span></span><br><span class="line"><span class="function"> <span class="title">List</span><<span class="title">UserEntity</span>> <span class="title">list</span> = <span class="title">jdbcTemplate</span>.<span class="title">query</span><span class="params">(<span class="string">"SELECT * FROM t_user WHERE id = ?"</span>, (res, i) -> {</span></span></span><br><span class="line"><span class="function"><span class="params"> UserEntity user = <span class="keyword">new</span> UserEntity();</span></span></span><br><span class="line"><span class="function"><span class="params"> user.setId(res.getInt(<span class="string">"ID"</span>));</span></span></span><br><span class="line"><span class="function"><span class="params"> user.setName(res.getString(<span class="string">"NAME"</span>));</span></span></span><br><span class="line"><span class="function"><span class="params"> user.setAddress(res.getString(<span class="string">"ADDRESS"</span>));</span></span></span><br><span class="line"><span class="function"><span class="params"> user.setAge(res.getInt(<span class="string">"AGE"</span>));</span></span></span><br><span class="line"><span class="function"><span class="params"> user.setGender(res.getBoolean(<span class="string">"GENDER"</span>));</span></span></span><br><span class="line"><span class="function"><span class="params"> <span class="keyword">return</span> user;</span></span></span><br><span class="line"><span class="function"><span class="params"> }, id)</span>;</span></span><br><span class="line"><span class="function"> <span class="title">return</span> <span class="title">list</span>.<span class="title">get</span><span class="params">(<span class="number">0</span>)</span>;</span></span><br><span class="line"><span class="function"> }</span></span><br><span class="line"><span class="function"></span></span><br><span class="line"><span class="function"> <span class="title">public</span> <span class="title">Integer</span> <span class="title">save</span><span class="params">(UserEntity user)</span>{</span></span><br><span class="line"><span class="function"> <span class="title">return</span> <span class="title">jdbcTemplate</span>.<span class="title">update</span><span class="params">(<span class="string">"INSERT INTO t_user(name, age, gender, address) VALUES(?, ?, ?, ?)"</span>,</span></span></span><br><span class="line"><span class="function"><span class="params"> user.getName(),</span></span></span><br><span class="line"><span class="function"><span class="params"> user.getAge(),</span></span></span><br><span class="line"><span class="function"><span class="params"> user.isGender(),</span></span></span><br><span class="line"><span class="function"><span class="params"> user.getAddress())</span>;</span></span><br><span class="line"><span class="function"> }</span></span><br><span class="line"><span class="function"></span></span><br><span class="line"><span class="function"> <span class="title">public</span> <span class="title">void</span> <span class="title">update</span><span class="params">(UserEntity user)</span>{</span></span><br><span class="line"><span class="function"> <span class="title">jdbcTemplate</span>.<span class="title">update</span><span class="params">(<span class="string">"UPDATE t_user SET name = ?, age = ?, gender = ?, address = ? WHERE id = ?"</span>,</span></span></span><br><span class="line"><span class="function"><span class="params"> user.getName(),</span></span></span><br><span class="line"><span class="function"><span class="params"> user.getAge(),</span></span></span><br><span class="line"><span class="function"><span class="params"> user.isGender(),</span></span></span><br><span class="line"><span class="function"><span class="params"> user.getAddress(),</span></span></span><br><span class="line"><span class="function"><span class="params"> user.getId())</span>;</span></span><br><span class="line"><span class="function"> }</span></span><br><span class="line"><span class="function"></span></span><br><span class="line"><span class="function"> <span class="title">public</span> <span class="title">void</span> <span class="title">delete</span><span class="params">(Integer id)</span>{</span></span><br><span class="line"><span class="function"> <span class="title">jdbcTemplate</span>.<span class="title">update</span><span class="params">(<span class="string">"DELETE FROM t_user WHERE id = ?"</span>, id)</span>;</span></span><br><span class="line"><span class="function"> }</span></span><br><span class="line"><span class="function">}</span></span><br></pre></td></tr></table></figure></p>
<p>最后，编写单元测试用例，创建对UserService的单元测试用例，通过创建、删除和查询来验证数据库操作的正确性。</p>
<p>这样 jdbc 的基本操作就完成了，通过上面这个简单的例子，我们可以看到在Spring Boot下访问数据库的配置依然秉承了框架的初衷：简单。我们只需要在pom.xml中加入数据库依赖，再到application.properties中配置连接信息，不需要像Spring应用中创建JdbcTemplate的Bean，就可以直接在自己的对象中注入使用。</p>
<h2 id="参考与相关链接"><a href="#参考与相关链接" class="headerlink" title="参考与相关链接"></a>参考与相关链接</h2><p>示例代码：<a href="https://github.com/dddreams/learn-spring-boot/tree/master/spring-boot-jdbc" target="_blank" rel="noopener">https://github.com/dddreams/learn-spring-boot/tree/master/spring-boot-jdbc</a></p>
<p>程序员DD的博文：<a href="https://blog.didispace.com/spring-boot-learning-21-3-1/" target="_blank" rel="noopener">https://blog.didispace.com/spring-boot-learning-21-3-1/</a></p>
<p><div style="text-align:center;margin:0;" markdown="1"><img src="../img/ddAnswer.jpg" alt="ddAnswer" style="margin:0 auto;"></div></p>
<p style="text-align: center;margin:0;">更多文章请关注微信公众号： zhiheng博客</p>
<p style="text-align: center;margin:20 0;">如果文章对你有用，转发分享、赞赏才是真爱 [斜眼笑]</p></div><div class="tags"><a href="/tags/Spring-Boot/"><i class="fa fa-tag"></i>Spring Boot</a></div><div class="post-nav"><a class="pre" href="/210208-Mysql登录失败多次锁定配置.html">Mysql登录失败多次锁定配置</a><a class="next" href="/210204-Mysql密码安全策略配置.html">Mysql密码安全策略配置</a></div></div></div></div><div class="pure-u-1-4 hidden_mid_and_down"><div id="sidebar"><div class="widget"><div class="search-form"><input id="local-search-input" placeholder="Search" type="text" name="q" results="0"><div id="local-search-result"></div></div></div><div class="widget"><div class="widget-title"><i class="fa fa-wechat"> 微信公众号</i></div><div class="tagcloud"><img src="/img/zhihengss.jpg" style="width: 80%"></div></div><div class="widget"><div class="widget-title"><i class="fa fa-folder-o"> 分类</i></div><ul class="category-list"><li class="category-list-item"><a class="category-list-link" href="/categories/Github/">Github</a><span class="category-list-count">5</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/Mysql/">Mysql</a><span class="category-list-count">2</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/Python/">Python</a><span class="category-list-count">2</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/Spring-Boot/">Spring Boot</a><span class="category-list-count">6</span></li></ul></div><div class="widget"><div class="widget-title"><i class="fa fa-star-o"> 标签</i></div><div class="tagcloud"><a href="/tags/杂谈/" style="font-size: 15px;">杂谈</a> <a href="/tags/Kotlin/" style="font-size: 15px;">Kotlin</a> <a href="/tags/Google/" style="font-size: 15px;">Google</a> <a href="/tags/微信/" style="font-size: 15px;">微信</a> <a href="/tags/Photo/" style="font-size: 15px;">Photo</a> <a href="/tags/旅行/" style="font-size: 15px;">旅行</a> <a href="/tags/go/" style="font-size: 15px;">go</a> <a href="/tags/总结/" style="font-size: 15px;">总结</a> <a href="/tags/推荐/" style="font-size: 15px;">推荐</a> <a href="/tags/Spring-Boot/" style="font-size: 15px;">Spring Boot</a> <a href="/tags/Java/" style="font-size: 15px;">Java</a> <a href="/tags/运维/" style="font-size: 15px;">运维</a> <a href="/tags/Mysql/" style="font-size: 15px;">Mysql</a> <a href="/tags/Github/" style="font-size: 15px;">Github</a> <a href="/tags/教程/" style="font-size: 15px;">教程</a> <a href="/tags/软件/" style="font-size: 15px;">软件</a> <a href="/tags/Python/" style="font-size: 15px;">Python</a> <a href="/tags/Excel/" style="font-size: 15px;">Excel</a> <a href="/tags/工具/" style="font-size: 15px;">工具</a> <a href="/tags/JavaScript/" style="font-size: 15px;">JavaScript</a> <a href="/tags/Test/" style="font-size: 15px;">Test</a> <a href="/tags/Chrome/" style="font-size: 15px;">Chrome</a> <a href="/tags/Css/" style="font-size: 15px;">Css</a> <a href="/tags/Html/" style="font-size: 15px;">Html</a> <a href="/tags/设计模式/" style="font-size: 15px;">设计模式</a> <a href="/tags/Web/" style="font-size: 15px;">Web</a> <a href="/tags/React-Native/" style="font-size: 15px;">React-Native</a> <a href="/tags/ES6/" style="font-size: 15px;">ES6</a></div></div><div class="widget"><div class="widget-title"><i class="fa fa-file-o"> 最近文章</i></div><ul class="post-list"><li class="post-list-item"><a class="post-list-link" href="/211206-github精选-github加速访问神器.html">github精选-github加速访问神器</a></li><li class="post-list-item"><a class="post-list-link" href="/211204-github精选-一款高颜值的Redis客户端.html">github精选-一款高颜值的Redis客户端</a></li><li class="post-list-item"><a class="post-list-link" href="/211203-Python读取Excel中的图片（二）.html">Python读取Excel中的图片（二）</a></li><li class="post-list-item"><a class="post-list-link" href="/211124-github精选-Linux命令大全.html">github精选-Linux命令大全</a></li><li class="post-list-item"><a class="post-list-link" href="/211120-github精选-PeaZip一款好用又免费的压缩软件.html">github精选-PeaZip一款好用又免费的压缩软件</a></li><li class="post-list-item"><a class="post-list-link" href="/211116-使用Python读取Excel中的图片并对应到记录.html">使用Python读取Excel中的图片并对应到记录</a></li><li class="post-list-item"><a class="post-list-link" href="/211111-SpringRestTemplate的使用.html">Spring RestTemplate的使用</a></li><li class="post-list-item"><a class="post-list-link" href="/211108-github精选-秒杀系统设计与实现.html">github精选-秒杀系统设计与实现</a></li><li class="post-list-item"><a class="post-list-link" href="/210208-Mysql登录失败多次锁定配置.html">Mysql登录失败多次锁定配置</a></li><li class="post-list-item"><a class="post-list-link" href="/210206-SpringBoot-使用JdbcTemplate操作数据库.html">SpringBoot-使用JdbcTemplate操作数据库</a></li></ul></div><div class="widget"><div class="widget-title"><i class="fa fa-external-link"> 友情链接</i></div><ul></ul><a href="https://geektutu.com/" title="极客兔兔" target="_blank">极客兔兔</a><ul></ul><a href="https://www.itmuch.com/" title="周立的博客" target="_blank">周立的博客</a><ul></ul><a href="https://liwenzhou.com/" title="李文周的博客" target="_blank">李文周的博客</a><ul></ul><a href="https://github.com/dddreams/dddreams.github.io/issues" title="添加友链请提交Issues" target="_blank">添加友链请提交Issues</a></div></div></div><div class="pure-u-1 pure-u-md-3-4"><div id="footer">Copyright © 2021 <a href="/." rel="nofollow">zhiheng's blog.</a> Powered by<a rel="nofollow" target="_blank" href="https://hexo.io"> Hexo.</a><a rel="nofollow" target="_blank" href="https://github.com/tufu9441/maupassant-hexo"> Theme</a> by<a rel="nofollow" target="_blank" href="https://github.com/pagecho"> Cho.</a></div></div></div><a class="show" id="rocket" href="#top"></a><script type="text/javascript" src="/js/totop.js?v=1.0.0" async></script><script type="text/javascript" src="//cdn.jsdelivr.net/gh/fancyapps/fancybox/dist/jquery.fancybox.min.js" async></script><script type="text/javascript" src="/js/fancybox.js?v=1.0.0" async></script><link rel="stylesheet" type="text/css" href="//cdn.jsdelivr.net/gh/fancyapps/fancybox/dist/jquery.fancybox.min.css"><link rel="stylesheet" type="text/css" href="/css/search.css?v=1.0.0"><script type="text/javascript" src="/js/search.js?v=1.0.0"></script><script>var search_path = 'search.xml';
if (search_path.length == 0) {
search_path = 'search.xml';
}
var path = '/' + search_path;
searchFunc(path, 'local-search-input', 'local-search-result');
</script><script type="text/javascript" src="/js/copycode.js" successtext="复制成功!"></script><link rel="stylesheet" type="text/css" href="/css/copycode.css"><script type="text/javascript" src="/js/codeblock-resizer.js?v=1.0.0"></script><script type="text/javascript" src="/js/smartresize.js?v=1.0.0"></script></div></body></html>