-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy path7.html
More file actions
78 lines (77 loc) · 27.1 KB
/
7.html
File metadata and controls
78 lines (77 loc) · 27.1 KB
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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
<!DOCTYPE html>
<html lang="en-US">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width,initial-scale=1">
<title>Mybatis按日期范围搜索 | 潘鑫博客</title>
<meta name="generator" content="VuePress 1.9.7">
<script data-ad-client="ca-pub-3196441204212737" async="true" src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<link rel="icon" href="/favicon.ico">
<link rel="manifest" href="/manifest.json">
<link rel="apple-touch-icon" href="/logo.png">
<link rel="mask-icon" href="/logo.png" color="#3178c6">
<meta name="description" content="分享、学习、coding、新技能get√">
<meta name="theme-color" content="#3178c6">
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="apple-mobile-web-app-status-bar-style" content="black">
<meta name="msapplication-TileImage" content="/logo.png">
<meta name="msapplication-TileColor" content="#000000">
<link rel="preload" href="/assets/css/0.styles.fe80f2e9.css" as="style"><link rel="preload" href="/assets/js/app.d96da9c0.js" as="script"><link rel="preload" href="/assets/js/3.a612be35.js" as="script"><link rel="preload" href="/assets/js/1.1f6fb7b3.js" as="script"><link rel="preload" href="/assets/js/22.8df3426a.js" as="script"><link rel="preload" href="/assets/js/12.cc454a87.js" as="script"><link rel="preload" href="/assets/js/9.0c525a95.js" as="script"><link rel="prefetch" href="/assets/js/10.c958f69b.js"><link rel="prefetch" href="/assets/js/100.b5ed3bfe.js"><link rel="prefetch" href="/assets/js/101.52c51b4b.js"><link rel="prefetch" href="/assets/js/102.d22424ce.js"><link rel="prefetch" href="/assets/js/103.b226b9d6.js"><link rel="prefetch" href="/assets/js/104.a6bd249e.js"><link rel="prefetch" href="/assets/js/105.ea498ed6.js"><link rel="prefetch" href="/assets/js/106.f8af64bc.js"><link rel="prefetch" href="/assets/js/107.19f199b3.js"><link rel="prefetch" href="/assets/js/108.31640d5f.js"><link rel="prefetch" href="/assets/js/109.c101c6f0.js"><link rel="prefetch" href="/assets/js/11.3da8a156.js"><link rel="prefetch" href="/assets/js/110.2e4648cd.js"><link rel="prefetch" href="/assets/js/111.44cd58c9.js"><link rel="prefetch" href="/assets/js/112.dbadc6ef.js"><link rel="prefetch" href="/assets/js/113.1c20f438.js"><link rel="prefetch" href="/assets/js/114.5959ed08.js"><link rel="prefetch" href="/assets/js/115.ff7dd286.js"><link rel="prefetch" href="/assets/js/116.21aac920.js"><link rel="prefetch" href="/assets/js/117.10db1641.js"><link rel="prefetch" href="/assets/js/118.c7acda67.js"><link rel="prefetch" href="/assets/js/119.0b864477.js"><link rel="prefetch" href="/assets/js/120.db45a311.js"><link rel="prefetch" href="/assets/js/121.26d1a503.js"><link rel="prefetch" href="/assets/js/122.becf320f.js"><link rel="prefetch" href="/assets/js/123.f91db6f9.js"><link rel="prefetch" href="/assets/js/124.bac2004d.js"><link rel="prefetch" href="/assets/js/125.58768fc4.js"><link rel="prefetch" href="/assets/js/126.bfe3818d.js"><link rel="prefetch" href="/assets/js/127.2c325e42.js"><link rel="prefetch" href="/assets/js/128.8e55b28d.js"><link rel="prefetch" href="/assets/js/129.8024b018.js"><link rel="prefetch" href="/assets/js/13.7e9c1e9f.js"><link rel="prefetch" href="/assets/js/130.8149077d.js"><link rel="prefetch" href="/assets/js/131.e5ae1b3c.js"><link rel="prefetch" href="/assets/js/132.01b158a4.js"><link rel="prefetch" href="/assets/js/133.e777b4fc.js"><link rel="prefetch" href="/assets/js/134.5a835ed1.js"><link rel="prefetch" href="/assets/js/135.503df77c.js"><link rel="prefetch" href="/assets/js/136.4adb2be9.js"><link rel="prefetch" href="/assets/js/137.02c38c68.js"><link rel="prefetch" href="/assets/js/138.1b9499aa.js"><link rel="prefetch" href="/assets/js/139.4630c335.js"><link rel="prefetch" href="/assets/js/14.e364c6ab.js"><link rel="prefetch" href="/assets/js/140.a243f39b.js"><link rel="prefetch" href="/assets/js/141.ee6987ef.js"><link rel="prefetch" href="/assets/js/142.69d4b446.js"><link rel="prefetch" href="/assets/js/143.941205be.js"><link rel="prefetch" href="/assets/js/144.dc02a8ce.js"><link rel="prefetch" href="/assets/js/145.698b5ae6.js"><link rel="prefetch" href="/assets/js/146.4178c2f5.js"><link rel="prefetch" href="/assets/js/147.8dadb591.js"><link rel="prefetch" href="/assets/js/148.10301f46.js"><link rel="prefetch" href="/assets/js/149.1bf4acb4.js"><link rel="prefetch" href="/assets/js/15.ef3cabe0.js"><link rel="prefetch" href="/assets/js/150.91c5c3af.js"><link rel="prefetch" href="/assets/js/151.f7ce9f12.js"><link rel="prefetch" href="/assets/js/152.c6437e15.js"><link rel="prefetch" href="/assets/js/153.47958e9f.js"><link rel="prefetch" href="/assets/js/154.b2287786.js"><link rel="prefetch" href="/assets/js/155.c7d3932e.js"><link rel="prefetch" href="/assets/js/156.9f1070fa.js"><link rel="prefetch" href="/assets/js/157.b0c12273.js"><link rel="prefetch" href="/assets/js/158.0e6bbe1f.js"><link rel="prefetch" href="/assets/js/159.9e359687.js"><link rel="prefetch" href="/assets/js/16.37f790c6.js"><link rel="prefetch" href="/assets/js/160.2902b74f.js"><link rel="prefetch" href="/assets/js/161.21e64635.js"><link rel="prefetch" href="/assets/js/162.6e59cfd2.js"><link rel="prefetch" href="/assets/js/163.a8bf68d3.js"><link rel="prefetch" href="/assets/js/164.4fb3cd9d.js"><link rel="prefetch" href="/assets/js/165.ee555303.js"><link rel="prefetch" href="/assets/js/166.b195e802.js"><link rel="prefetch" href="/assets/js/167.00f6b2d7.js"><link rel="prefetch" href="/assets/js/168.ab7d1eca.js"><link rel="prefetch" href="/assets/js/169.8fa6a1a5.js"><link rel="prefetch" href="/assets/js/17.3d26b29a.js"><link rel="prefetch" href="/assets/js/170.925cd001.js"><link rel="prefetch" href="/assets/js/18.e73d7140.js"><link rel="prefetch" href="/assets/js/19.8b944084.js"><link rel="prefetch" href="/assets/js/20.240aa886.js"><link rel="prefetch" href="/assets/js/21.aae8d919.js"><link rel="prefetch" href="/assets/js/23.9c26f381.js"><link rel="prefetch" href="/assets/js/24.60de9b6f.js"><link rel="prefetch" href="/assets/js/25.7cecadc7.js"><link rel="prefetch" href="/assets/js/26.917faf25.js"><link rel="prefetch" href="/assets/js/27.5b5ffdad.js"><link rel="prefetch" href="/assets/js/28.a9bdb70f.js"><link rel="prefetch" href="/assets/js/29.681f1822.js"><link rel="prefetch" href="/assets/js/30.595dd813.js"><link rel="prefetch" href="/assets/js/31.9f01f4c8.js"><link rel="prefetch" href="/assets/js/32.071d1d9e.js"><link rel="prefetch" href="/assets/js/33.4ed71779.js"><link rel="prefetch" href="/assets/js/34.a025ff41.js"><link rel="prefetch" href="/assets/js/35.d52171f1.js"><link rel="prefetch" href="/assets/js/36.ed29311f.js"><link rel="prefetch" href="/assets/js/37.e47a9d8c.js"><link rel="prefetch" href="/assets/js/38.13517280.js"><link rel="prefetch" href="/assets/js/39.4fb88582.js"><link rel="prefetch" href="/assets/js/4.fc8b0464.js"><link rel="prefetch" href="/assets/js/40.31c7d55d.js"><link rel="prefetch" href="/assets/js/41.37e4286e.js"><link rel="prefetch" href="/assets/js/42.aaa51290.js"><link rel="prefetch" href="/assets/js/43.a3aa262b.js"><link rel="prefetch" href="/assets/js/44.7d3a33e9.js"><link rel="prefetch" href="/assets/js/45.dbb244b9.js"><link rel="prefetch" href="/assets/js/46.69d01bd2.js"><link rel="prefetch" href="/assets/js/47.055c22ce.js"><link rel="prefetch" href="/assets/js/48.6942069b.js"><link rel="prefetch" href="/assets/js/49.a8b35243.js"><link rel="prefetch" href="/assets/js/5.1eb8c286.js"><link rel="prefetch" href="/assets/js/50.3eccb9bc.js"><link rel="prefetch" href="/assets/js/51.ea2a388a.js"><link rel="prefetch" href="/assets/js/52.5d3a9077.js"><link rel="prefetch" href="/assets/js/53.774c6e74.js"><link rel="prefetch" href="/assets/js/54.f8d909b1.js"><link rel="prefetch" href="/assets/js/55.93ccf864.js"><link rel="prefetch" href="/assets/js/56.4d1c0f81.js"><link rel="prefetch" href="/assets/js/57.cdd97692.js"><link rel="prefetch" href="/assets/js/58.d31d5ed4.js"><link rel="prefetch" href="/assets/js/59.4bbcca22.js"><link rel="prefetch" href="/assets/js/6.7fdbc0f3.js"><link rel="prefetch" href="/assets/js/60.e156017e.js"><link rel="prefetch" href="/assets/js/61.cfb0e0a1.js"><link rel="prefetch" href="/assets/js/62.21f5bb78.js"><link rel="prefetch" href="/assets/js/63.4a1779f7.js"><link rel="prefetch" href="/assets/js/64.dc2b22a0.js"><link rel="prefetch" href="/assets/js/65.5ab2b2aa.js"><link rel="prefetch" href="/assets/js/66.a8f1ae3c.js"><link rel="prefetch" href="/assets/js/67.2878f9bc.js"><link rel="prefetch" href="/assets/js/68.f4920217.js"><link rel="prefetch" href="/assets/js/69.bfbc7b22.js"><link rel="prefetch" href="/assets/js/7.2b4f1a1e.js"><link rel="prefetch" href="/assets/js/70.b2dfa6d3.js"><link rel="prefetch" href="/assets/js/71.712c3a8c.js"><link rel="prefetch" href="/assets/js/72.14ec689b.js"><link rel="prefetch" href="/assets/js/73.2e813dec.js"><link rel="prefetch" href="/assets/js/74.0750374d.js"><link rel="prefetch" href="/assets/js/75.cc31b6c6.js"><link rel="prefetch" href="/assets/js/76.2a83a3bc.js"><link rel="prefetch" href="/assets/js/77.642dfae4.js"><link rel="prefetch" href="/assets/js/78.46a4978f.js"><link rel="prefetch" href="/assets/js/79.c1c09197.js"><link rel="prefetch" href="/assets/js/8.d62e65f4.js"><link rel="prefetch" href="/assets/js/80.09043640.js"><link rel="prefetch" href="/assets/js/81.7f7f4cf9.js"><link rel="prefetch" href="/assets/js/82.e8d62db7.js"><link rel="prefetch" href="/assets/js/83.97036b3b.js"><link rel="prefetch" href="/assets/js/84.a2b2440c.js"><link rel="prefetch" href="/assets/js/85.b66dac9c.js"><link rel="prefetch" href="/assets/js/86.33a22381.js"><link rel="prefetch" href="/assets/js/87.2ee55a67.js"><link rel="prefetch" href="/assets/js/88.deda0c2e.js"><link rel="prefetch" href="/assets/js/89.e9f53605.js"><link rel="prefetch" href="/assets/js/90.44f510c9.js"><link rel="prefetch" href="/assets/js/91.7b4852e9.js"><link rel="prefetch" href="/assets/js/92.701b60ce.js"><link rel="prefetch" href="/assets/js/93.8e57da61.js"><link rel="prefetch" href="/assets/js/94.ec27be9d.js"><link rel="prefetch" href="/assets/js/95.478ca63a.js"><link rel="prefetch" href="/assets/js/96.cce24d9f.js"><link rel="prefetch" href="/assets/js/97.d6f559b6.js"><link rel="prefetch" href="/assets/js/98.1f12e82a.js"><link rel="prefetch" href="/assets/js/99.2162a296.js">
<link rel="stylesheet" href="/assets/css/0.styles.fe80f2e9.css">
</head>
<body>
<div id="app" data-server-rendered="true"><div class="theme-container no-sidebar" data-v-7dd95ae2><div data-v-7dd95ae2><div class="password-shadow password-wrapper-out" style="display:none;" data-v-59e6cb88 data-v-7dd95ae2 data-v-7dd95ae2><h3 class="title" data-v-59e6cb88>潘鑫博客</h3> <p class="description" data-v-59e6cb88>分享、学习、coding、新技能get√</p> <label id="box" class="inputBox" data-v-59e6cb88><input type="password" value="" data-v-59e6cb88> <span data-v-59e6cb88>Konck! Knock!</span> <button data-v-59e6cb88>OK</button></label> <div class="footer" data-v-59e6cb88><span data-v-59e6cb88><i class="iconfont reco-theme" data-v-59e6cb88></i> <a target="blank" href="https://vuepress-theme-reco.recoluan.com" data-v-59e6cb88>vuePress-theme-reco</a></span> <span data-v-59e6cb88><i class="iconfont reco-copyright" data-v-59e6cb88></i> <a data-v-59e6cb88><span data-v-59e6cb88>apan</span>
<span data-v-59e6cb88>2015 - </span>
2025
</a></span></div></div> <div class="hide" data-v-7dd95ae2><header class="navbar" data-v-7dd95ae2><div class="sidebar-button"><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" role="img" viewBox="0 0 448 512" class="icon"><path fill="currentColor" d="M436 124H12c-6.627 0-12-5.373-12-12V80c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12z"></path></svg></div> <a href="/" class="home-link router-link-active"><!----> <span class="site-name">潘鑫博客</span></a> <div class="links"><div class="color-picker"><a class="color-button"><i class="iconfont reco-color"></i></a> <div class="color-picker-menu" style="display:none;"><div class="mode-options"><h4 class="title">Choose mode</h4> <ul class="color-mode-options"><li class="dark">dark</li><li class="auto active">auto</li><li class="light">light</li></ul></div></div></div> <div class="search-box"><i class="iconfont reco-search"></i> <input aria-label="Search" autocomplete="off" spellcheck="false" value=""> <!----></div> <nav class="nav-links can-hide"><div class="nav-item"><a href="/" class="nav-link"><i class="iconfont reco-home"></i>
首页
</a></div><div class="nav-item"><a href="/tag/code/" class="nav-link"><i class="iconfont reco-api"></i>
编程
</a></div><div class="nav-item"><a href="/about/" class="nav-link"><i class="iconfont reco-account"></i>
关于
</a></div><div class="nav-item"><a href="/timeline/" class="nav-link"><i class="iconfont reco-date"></i>
TimeLine
</a></div><div class="nav-item"><div class="dropdown-wrapper"><a class="dropdown-title"><span class="title"><i class="iconfont reco-github"></i>
github
</span> <span class="arrow right"></span></a> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="https://gitee.com/pxpy/homeRepair" target="_blank" rel="noopener noreferrer" class="nav-link external"><i class="undefined"></i>
爱居网
<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li><li class="dropdown-item"><!----> <a href="https://gitee.com/pxpy/IEMS" target="_blank" rel="noopener noreferrer" class="nav-link external"><i class="undefined"></i>
智慧设备维修系统
<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li><li class="dropdown-item"><!----> <a href="https://github.com/pxpy/pxpy.github.io" target="_blank" rel="noopener noreferrer" class="nav-link external"><i class="undefined"></i>
个人博客
<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li></ul></div></div> <!----></nav></div></header> <div class="sidebar-mask" data-v-7dd95ae2></div> <aside class="sidebar" data-v-7dd95ae2><div class="personal-info-wrapper" data-v-1fad0c41 data-v-7dd95ae2><img src="/logo.png" alt="author-avatar" class="personal-img" data-v-1fad0c41> <h3 class="name" data-v-1fad0c41>
apan
</h3> <div class="num" data-v-1fad0c41><div data-v-1fad0c41><h3 data-v-1fad0c41>156</h3> <h6 data-v-1fad0c41>Articles</h6></div> <div data-v-1fad0c41><h3 data-v-1fad0c41>89</h3> <h6 data-v-1fad0c41>Tags</h6></div></div> <ul class="social-links" data-v-1fad0c41></ul> <hr data-v-1fad0c41></div> <nav class="nav-links"><div class="nav-item"><a href="/" class="nav-link"><i class="iconfont reco-home"></i>
首页
</a></div><div class="nav-item"><a href="/tag/code/" class="nav-link"><i class="iconfont reco-api"></i>
编程
</a></div><div class="nav-item"><a href="/about/" class="nav-link"><i class="iconfont reco-account"></i>
关于
</a></div><div class="nav-item"><a href="/timeline/" class="nav-link"><i class="iconfont reco-date"></i>
TimeLine
</a></div><div class="nav-item"><div class="dropdown-wrapper"><a class="dropdown-title"><span class="title"><i class="iconfont reco-github"></i>
github
</span> <span class="arrow right"></span></a> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="https://gitee.com/pxpy/homeRepair" target="_blank" rel="noopener noreferrer" class="nav-link external"><i class="undefined"></i>
爱居网
<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li><li class="dropdown-item"><!----> <a href="https://gitee.com/pxpy/IEMS" target="_blank" rel="noopener noreferrer" class="nav-link external"><i class="undefined"></i>
智慧设备维修系统
<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li><li class="dropdown-item"><!----> <a href="https://github.com/pxpy/pxpy.github.io" target="_blank" rel="noopener noreferrer" class="nav-link external"><i class="undefined"></i>
个人博客
<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li></ul></div></div> <!----></nav> <!----> </aside> <div class="password-shadow password-wrapper-in" style="display:none;" data-v-59e6cb88 data-v-7dd95ae2><h3 class="title" data-v-59e6cb88>Mybatis按日期范围搜索</h3> <!----> <label id="box" class="inputBox" data-v-59e6cb88><input type="password" value="" data-v-59e6cb88> <span data-v-59e6cb88>Konck! Knock!</span> <button data-v-59e6cb88>OK</button></label> <div class="footer" data-v-59e6cb88><span data-v-59e6cb88><i class="iconfont reco-theme" data-v-59e6cb88></i> <a target="blank" href="https://vuepress-theme-reco.recoluan.com" data-v-59e6cb88>vuePress-theme-reco</a></span> <span data-v-59e6cb88><i class="iconfont reco-copyright" data-v-59e6cb88></i> <a data-v-59e6cb88><span data-v-59e6cb88>apan</span>
<span data-v-59e6cb88>2015 - </span>
2025
</a></span></div></div> <div data-v-7dd95ae2><div data-v-7dd95ae2><main class="page" style="padding-right:0;"><section style="display:;"><div class="page-title"><h1 class="title">Mybatis按日期范围搜索</h1> <div data-v-8a445198><i class="iconfont reco-account" data-v-8a445198><span data-v-8a445198>apan</span></i> <i class="iconfont reco-date" data-v-8a445198><span data-v-8a445198>10/22/2022</span></i> <i class="iconfont reco-eye" data-v-8a445198><span id="/7.html" data-flag-title="Your Article Title" class="leancloud-visitors" data-v-8a445198><a class="leancloud-visitors-count" style="font-size:.9rem;font-weight:normal;color:#999;"></a></span></i> <i class="tags iconfont reco-tag" data-v-8a445198><span class="tag-item" data-v-8a445198>Mybatis</span><span class="tag-item" data-v-8a445198>后端</span></i></div></div> <div class="theme-reco-content content__default"><div class="adswrapper"><!----> <div style="display:none;"></div> <ins data-ad-layout="in-article" data-ad-format="fluid" data-ad-client="ca-pub-3196441204212737" data-ad-slot="7162284157" data-ad-test="" data-ad-region="" class="adsbygoogle" style="display:block;"></ins> <!----> <div style="display:none;"> (adsbygoogle = window.adsbygoogle || []).push({}); </div></div> <p>实体类的一个属性时date数组，直接使用会报错，需要写明javaType=java.util.Date, jdbcType=DATE</p> <div class="language-xml line-numbers-mode"><pre class="language-xml"><code><span class="token tag"><span class="token tag"><span class="token punctuation"><</span>select</span> <span class="token attr-name">id</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">"</span>list<span class="token punctuation">"</span></span> <span class="token attr-name">resultMap</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">"</span>BaseResultMap<span class="token punctuation">"</span></span><span class="token punctuation">></span></span>
select * from sys_notice
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>where</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>if</span> <span class="token attr-name">test</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">"</span>fromUser != null and fromUser != ''<span class="token punctuation">"</span></span><span class="token punctuation">></span></span> and from_user = #{fromUser}<span class="token tag"><span class="token tag"><span class="token punctuation"></</span>if</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>if</span> <span class="token attr-name">test</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">"</span>description != null and description != ''<span class="token punctuation">"</span></span><span class="token punctuation">></span></span>and (description like '%${description}%' or title like'%${description}%')<span class="token tag"><span class="token tag"><span class="token punctuation"></</span>if</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>if</span> <span class="token attr-name">test</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">"</span>datetimeRange != null<span class="token punctuation">"</span></span><span class="token punctuation">></span></span>and datetime between #{datetimeRange[0], javaType=java.util.Date, jdbcType=DATE} and #{datetimeRange[1],javaType=java.util.Date, jdbcType=DATE} <span class="token tag"><span class="token tag"><span class="token punctuation"></</span>if</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"></</span>where</span><span class="token punctuation">></span></span>
order by `read` asc, datetime desc
<span class="token tag"><span class="token tag"><span class="token punctuation"></</span>select</span><span class="token punctuation">></span></span>
</code></pre> <div class="line-numbers-wrapper"><span class="line-number">1</span><br><span class="line-number">2</span><br><span class="line-number">3</span><br><span class="line-number">4</span><br><span class="line-number">5</span><br><span class="line-number">6</span><br><span class="line-number">7</span><br><span class="line-number">8</span><br><span class="line-number">9</span><br></div></div><p>我的博客即将同步至腾讯云开发者社区，邀请大家一同入驻：https://cloud.tencent.com/developer/support-plan?invite_code=38dpnhkh4o8wo</p></div></section> <footer class="page-edit"><!----> <!----></footer> <!----> <div class="comments-wrapper"><!----></div></main></div> <!----></div> <ul class="sub-sidebar sub-sidebar-wrapper" style="width:0;" data-v-b57cc07c data-v-7dd95ae2></ul></div></div></div><div class="global-ui"><div class="back-to-ceiling" style="right:1rem;bottom:6rem;width:2.5rem;height:2.5rem;border-radius:.25rem;line-height:2.5rem;display:none;" data-v-c6073ba8 data-v-c6073ba8><svg t="1574745035067" viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5404" class="icon" data-v-c6073ba8><path d="M526.60727968 10.90185116a27.675 27.675 0 0 0-29.21455937 0c-131.36607665 82.28402758-218.69155461 228.01873535-218.69155402 394.07834331a462.20625001 462.20625001 0 0 0 5.36959153 69.94390903c1.00431239 6.55289093-0.34802892 13.13561351-3.76865779 18.80351572-32.63518765 54.11355614-51.75690182 118.55860487-51.7569018 187.94566865a371.06718723 371.06718723 0 0 0 11.50484808 91.98906777c6.53300375 25.50556257 41.68394495 28.14064038 52.69160883 4.22606766 17.37162448-37.73630017 42.14135425-72.50938081 72.80769204-103.21549295 2.18761121 3.04276886 4.15646224 6.24463696 6.40373557 9.22774369a1871.4375 1871.4375 0 0 0 140.04691725 5.34970492 1866.36093723 1866.36093723 0 0 0 140.04691723-5.34970492c2.24727335-2.98310674 4.21612437-6.18497483 6.3937923-9.2178004 30.66633723 30.70611158 55.4360664 65.4791928 72.80769147 103.21549355 11.00766384 23.91457269 46.15860503 21.27949489 52.69160879-4.22606768a371.15156223 371.15156223 0 0 0 11.514792-91.99901164c0-69.36717486-19.13165746-133.82216804-51.75690182-187.92578088-3.42062944-5.66790279-4.76302748-12.26056868-3.76865837-18.80351632a462.20625001 462.20625001 0 0 0 5.36959269-69.943909c-0.00994388-166.08943902-87.32547796-311.81420293-218.6915546-394.09823051zM605.93803103 357.87693858a93.93749974 93.93749974 0 1 1-187.89594924 6.1e-7 93.93749974 93.93749974 0 0 1 187.89594924-6.1e-7z" p-id="5405" data-v-c6073ba8></path><path d="M429.50777625 765.63860547C429.50777625 803.39355007 466.44236686 1000.39046097 512.00932183 1000.39046097c45.56695499 0 82.4922232-197.00623328 82.5015456-234.7518555 0-37.75494459-36.9345906-68.35043303-82.4922232-68.34111062-45.57627738-0.00932239-82.52019037 30.59548842-82.51086798 68.34111062z" p-id="5406" data-v-c6073ba8></path></svg></div><!----></div></div>
<script src="/assets/js/app.d96da9c0.js" defer></script><script src="/assets/js/3.a612be35.js" defer></script><script src="/assets/js/1.1f6fb7b3.js" defer></script><script src="/assets/js/22.8df3426a.js" defer></script><script src="/assets/js/12.cc454a87.js" defer></script><script src="/assets/js/9.0c525a95.js" defer></script>
</body>
</html>