-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy patharticle-39594.htm
205 lines (193 loc) · 14.9 KB
/
article-39594.htm
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
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
<!DOCTYPE html>
<html xml:lang="zh-CN" lang="zh-CN">
<head>
<link rel="canonical" href="https://windowsv2ray.github.io/news/article-39594.htm" />
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Oracle模糊查询，不区分大小写</title>
<meta name="description" content="背景概述： 在该项目中，按照类别名称进行模糊查询（包括大小写），类别名称存在一、二级分类，对应字段分别为category3_name、category4_name，其中category3_id和cat" />
<link rel="icon" href="/assets/website/img/windowsv2ray/favicon.ico" type="image/x-icon"/>
<meta name="author" content="Windows V2ray分享订阅站">
<meta property="og:type" content="article" />
<meta property="og:url" content="https://windowsv2ray.github.io/news/article-39594.htm" />
<meta property="og:site_name" content="Windows V2ray分享订阅站" />
<meta property="og:title" content="Oracle模糊查询，不区分大小写" />
<meta property="og:image" content="https://windowsv2ray.github.io/uploads/20240604/5b87a6f5ce71e7182137e356b5bf19d6.webp" />
<meta property="og:release_date" content="2025-01-12T10:00:10" />
<meta property="og:updated_time" content="2025-01-12T10:00:10" />
<meta property="og:description" content="背景概述： 在该项目中，按照类别名称进行模糊查询（包括大小写），类别名称存在一、二级分类，对应字段分别为category3_name、category4_name，其中category3_id和cat" />
<meta name="applicable-device" content="pc,mobile" />
<meta name="renderer" content="webkit" />
<meta name="force-rendering" content="webkit" />
<meta http-equiv="Cache-Control" content="no-transform" />
<meta name="robots" content="max-image-preview:large" />
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="apple-mobile-web-app-status-bar-style" content="black">
<meta name="apple-mobile-web-app-title" content="Oracle模糊查询，不区分大小写">
<meta name="format-detection" content="telephone=no">
<link rel="dns-prefetch" href="https:/www.googletagmanager.com">
<link rel="dns-prefetch" href="https://www.googleadservices.com">
<link rel="dns-prefetch" href="https://www.google-analytics.com">
<link rel="dns-prefetch" href="https://pagead2.googlesyndication.com">
<link rel="dns-prefetch" href="https://cm.g.doubleclick.net">
<link rel="stylesheet" href="/assets/website/js/frontend/windowsv2ray/animate/animate.css">
<link rel="stylesheet" href="/assets/website/css/windowsv2ray/bootstrap.css">
<link rel="stylesheet" href="/assets/website/css/windowsv2ray/maicons.css">
<link rel="stylesheet" href="/assets/website/js/frontend/windowsv2ray/owl-carousel/css/owl.carousel.css">
<link rel="stylesheet" href="/assets/website/css/windowsv2ray/theme.css">
<!-- Google tag (gtag.js) -->
<script async src="https://www.googletagmanager.com/gtag/js?id=G-JN82W0GJX5"></script>
<script>
window.dataLayer = window.dataLayer || [];
function gtag(){dataLayer.push(arguments);}
gtag('js', new Date());
gtag('config', 'G-JN82W0GJX5');
</script>
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-3332997411212854"
crossorigin="anonymous"></script>
</head>
<body data-page="detail">
<!-- Back to top button -->
<div class="back-to-top"></div>
<header>
<nav class="navbar navbar-expand-lg navbar-light navbar-float">
<div class="container">
<a href="/" class="navbar-brand">
<span>Windows V2ray</span>
</a>
<button class="navbar-toggler" data-toggle="collapse" data-target="#navbarContent" aria-controls="navbarContent" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="navbar-collapse collapse" id="navbarContent">
<ul class="navbar-nav ml-lg-4 pt-3 pt-lg-0">
<li class="nav-item">
<a href="/" class="nav-link">首页</a>
</li>
<li class="nav-item">
<a href="/free-nodes/" class="nav-link">免费节点</a>
</li>
<li class="nav-item">
<a href="/paid-subscribe/" class="nav-link">推荐机场</a>
</li>
<li class="nav-item">
<a href="/client.htm" class="nav-link">客户端</a>
</li>
<li class="nav-item">
<a href="/news/" class="nav-link">新闻资讯</a>
</li>
</ul>
</div>
</div>
</nav>
<div class="container mt-5">
<div class="page-banner">
<div class="row justify-content-center align-items-center h-100">
<div class="col-md-10">
<h1 class="text-center">Oracle模糊查询，不区分大小写</h1>
<nav aria-label="Breadcrumb">
<ul class="breadcrumb justify-content-center py-0 bg-transparent">
<li class="breadcrumb-item"><a href="/">首页</a></li>
<li class="breadcrumb-item"><a href="/news/">新闻资讯</a></li>
<li class="breadcrumb-item active">正文</li>
</ul>
</nav>
</div>
</div>
</div>
</div>
</header>
<main>
<div class="page-section">
<div class="container">
<div class="row">
<div class="col-md-9">
<input type="hidden" id="share-website-info" data-name="" data-url="">
<div id="content_views" class="htmledit_views"> <h3><span style="color:#333333;"><span style="background-color:#ffffff;">背景概述：</span></span></h3> <p><span style="color:#333333;"><span style="background-color:#ffffff;">在该项目中，按照类别名称进行模糊查询（包括<span style="color:#ff0000;"><span style="color:inherit;">大小写</span></span>），类别名称存在一、二级分类，对应字段分别为category3_name、category4_name，其中category3_id和category4_id分别是类别名称3和4的id。对用户来说，在前端UI进行查询时，不确定是按照category3_name，还是按照category4_name进行查询。因此根据用户的输入，传至后台中，对用户的输入内容进行处理，即：</span></span></p> <h3>controller 中的处理</h3> <p>在 controller 接收来自前端的搜索内容。首先，利用函数 trim() 对搜索的内容前后空格处理；其次，搜索中的字母全部转为小写 toLowerCase()。</p> <pre><code class="language-java">@ResponseBody @ApiOperation(value = "查询") @PostMapping(value = "/searchByCategory") public RestfulApiResult searchByCategory(@RequestBody Map<String,String> map) { String searchContent = map.get("searchContent").trim().toLowerCase(); log.info("设备类别搜索内容：" + searchContent); List<CategoryView> categoryList = categoryService.searchByCategory(searchContent); ... /** 省略了部分代码 */ return new RestfulApiResult(200, "success", JSONObject.toJSON(categoryList)); }</code></pre> <h3>XML 中 SQL</h3> <p>xml 中的 sql，由于 controller 中使用 toLowerCase()，因此 sql 语句中，使用 lower()。如果 controller 使用 toUpperCase()，则 mapper 则使用 upper()。<strong>注意</strong>：前后要保持一致。</p> <pre><code class="language-sql">select t1.category4_id, t1.category4_name, t1.category3_id, t1.category3_name from tb_categoryview t1 join tb_select_devicesview t2 on (lower(t1.category4_name) like '%'||#{searchContent}||'%' or lower(t1.category3_name) like '%'||#{searchContent}||'%') and t1.category4_id like 'C%' and t1.category3_id = t2.category3_id and t2.category2_id in (select t3.category2_id from tb_select_devices t3) order by category4_id</code></pre> </div> <div class="clearfix"></div>
<div class="col-md-12 mt-5">
<p>上一个：<a href="/news/article-39115.htm">国考公务员报名2021（国考公务员报名入口）</a></p>
<p>下一个：<a href="/news/article-39595.htm">springboot base64_base64转码</a></p>
</div>
</div>
<div class="col-md-3">
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title">热门文章</h3>
</div>
<div class="panel-body">
<ul class="p-0 x-0" style="list-style: none;margin: 0;padding: 0;">
<li class="py-2"><a href="/free-nodes/2025-3-3-clash-windows.htm" title="「3月3日」最高速度21.4M/S，2025年Shadowrocket/Clash/V2ray/SSR每天更新免费节点订阅链接">「3月3日」最高速度21.4M/S，2025年Shadowrocket/Clash/V2ray/SSR每天更新免费节点订阅链接</a></li>
<li class="py-2"><a href="/free-nodes/2025-1-12-free-ssr-node.htm" title="「1月12日」最高速度19.3M/S，2025年SSR/Shadowrocket/Clash/V2ray每天更新免费节点订阅链接">「1月12日」最高速度19.3M/S，2025年SSR/Shadowrocket/Clash/V2ray每天更新免费节点订阅链接</a></li>
<li class="py-2"><a href="/news/article-39115.htm" title="国考公务员报名2021（国考公务员报名入口）">国考公务员报名2021（国考公务员报名入口）</a></li>
<li class="py-2"><a href="/news/article-39594.htm" title="Oracle模糊查询，不区分大小写">Oracle模糊查询，不区分大小写</a></li>
<li class="py-2"><a href="/news/article-39114.htm" title="猫咪打的三针疫苗多少钱啊图片（猫咪打的三针疫苗多少钱啊图片大全）">猫咪打的三针疫苗多少钱啊图片（猫咪打的三针疫苗多少钱啊图片大全）</a></li>
<li class="py-2"><a href="/free-nodes/2025-1-11-clash-windows.htm" title="「1月11日」最高速度22.5M/S，2025年Clash/V2ray/Shadowrocket/SSR每天更新免费节点订阅链接">「1月11日」最高速度22.5M/S，2025年Clash/V2ray/Shadowrocket/SSR每天更新免费节点订阅链接</a></li>
<li class="py-2"><a href="/news/article-38610.htm" title="狗粮加工厂利润成本分析表模板怎么写（狗粮生产成本）">狗粮加工厂利润成本分析表模板怎么写（狗粮生产成本）</a></li>
<li class="py-2"><a href="/news/article-39595.htm" title="springboot base64_base64转码">springboot base64_base64转码</a></li>
<li class="py-2"><a href="/news/article-53746.htm" title="宠物店的猫哪里进货（宠物猫进货渠道）">宠物店的猫哪里进货（宠物猫进货渠道）</a></li>
<li class="py-2"><a href="/news/article-48989.htm" title="动物疫苗可以去畜牧局批发吗现在多少钱（动物疫苗经营许可证在哪里办）">动物疫苗可以去畜牧局批发吗现在多少钱（动物疫苗经营许可证在哪里办）</a></li>
</ul>
</div>
</div>
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title">归纳</h3>
</div>
<div class="panel-body">
<ul class="p-0 x-0" style="list-style: none;margin: 0;padding: 0;">
<li class="py-2">
<h4><span class="badge" style="float: right;">12</span> <a href="/date/2025-03/" title="2025-03 归档">2025-03</a></h4>
</li>
<li class="py-2">
<h4><span class="badge" style="float: right;">84</span> <a href="/date/2025-02/" title="2025-02 归档">2025-02</a></h4>
</li>
<li class="py-2">
<h4><span class="badge" style="float: right;">83</span> <a href="/date/2025-01/" title="2025-01 归档">2025-01</a></h4>
</li>
</ul>
</div>
</div>
</div>
</div>
</div> <!-- .container -->
</div> <!-- .page-section -->
</main>
<footer class="page-footer">
<div class="container">
<div class="row">
<div class="col-sm-6 py-2">
<p id="copyright">
<p>
<a href="/">首页</a> |
<a href="/free-node/">免费节点</a> |
<a href="/news/">新闻资讯</a> |
<a href="/about-us.htm">关于我们</a> |
<a href="/disclaimer.htm">免责申明</a> |
<a href="/privacy.htm">隐私申明</a> |
<a href="/sitemap.xml">网站地图</a>
</p>
Windows V2ray分享订阅站 版权所有 Powered by WordPress
</p>
</div>
<div class="col-sm-6 py-2 text-right">
<div class="d-inline-block px-3">
<a href="#">Privacy</a>
</div>
<div class="d-inline-block px-3">
<a href="#">Contact Us</a>
</div>
</div>
</div>
</div> <!-- .container -->
</footer> <!-- .page-footer -->
<script src="/assets/website/js/frontend/windowsv2ray/jquery-3.5.1.min.js"></script>
<script src="/assets/website/js/frontend/windowsv2ray/bootstrap.bundle.min.js"></script>
<script src="/assets/website/js/frontend/windowsv2ray/wow/wow.min.js"></script>
<script src="/assets/website/js/frontend/windowsv2ray/owl-carousel/js/owl.carousel.min.js"></script>
<script src="/assets/website/js/frontend/windowsv2ray/waypoints/jquery.waypoints.min.js"></script>
<script src="/assets/website/js/frontend/windowsv2ray/animateNumber/jquery.animateNumber.min.js"></script>
<script src="/assets/website/js/frontend/windowsv2ray/theme.js"></script>
<script src="https://www.freeclashnode.com/assets/js/frontend/invite-url.js"></script>
<script src="/assets/website/js/frontend/G.js"></script>
</body>
</html>