-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathfaq.html
557 lines (515 loc) · 130 KB
/
faq.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
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
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width,initial-scale=1">
<title>FAQ | spring-boot-plus</title>
<meta name="description" content="spring-boot-plus是易于使用，快速，高效，功能丰富，开源的spring boot 脚手架。前后端分离,专注于后端服务！ 每个人都可以独立、快速、高效地开发项目！Everyone can develop projects independently, quickly and efficiently！">
<link rel="icon" href="/favicon.ico">
<script>var _hmt = _hmt || []; (function() {var hm = document.createElement("script"); hm.src = "https://hm.baidu.com/hm.js?f5cf3abbd62a6b246284fc0259a2a17d"; var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(hm, s);})();</script>
<script>console.log("%c _ _ _ _\n (_) | | | | | |\n ___ _ __ _ __ _ _ __ __ _ ______| |__ ___ ___ | |_ ______ _ __ | |_ _ ___\n / __| '_ \\| '__| | '_ \\ / _` |______| '_ \\ / _ \\ / _ \\| __|______| '_ \\| | | | / __|\n \\__ \\ |_) | | | | | | | (_| | | |_) | (_) | (_) | |_ | |_) | | |_| \\__ \\\n |___/ .__/|_| |_|_| |_|\\__, | |_.__/ \\___/ \\___/ \\__| | .__/|_|\\__,_|___/\n | | __/ | | |\n |_| |___/ |_|","color:blue");</script>
<script>console.log("%c :: Spring Boot :: (v2.2.0.RELEASE)","color:blue");console.log("%c :: Spring Boot Plus :: (v1.4.0)","color:blue");console.log("%c :: spring-boot-plus :: https://springboot.plus","color:blue");</script>
<script>console.log("%cWelcome to spring-boot-plus","color:blue");console.log("%cGITHUB：https://github.com/geekidea/spring-boot-plus","color:blue");console.log("%cGITEE：https://gitee.com/geekidea/spring-boot-plus","color:blue");console.log("%cBlog：https://geekidea.io","color:blue");console.log("%cWebsite：https://springboot.plus","color:blue");</script>
<meta name="keywords" content="spring,spring boot,springbootplus,spring-boot-plus,springboot.plus,springbootplus官网,spring boot 开源项目,java,后台脚手架">
<link rel="preload" href="/assets/css/0.styles.6625b277.css" as="style"><link rel="preload" href="/assets/js/app.db17a95a.js" as="script"><link rel="preload" href="/assets/js/2.6d1275ea.js" as="script"><link rel="preload" href="/assets/js/43.5b34dcc0.js" as="script"><link rel="prefetch" href="/assets/js/10.5be2a980.js"><link rel="prefetch" href="/assets/js/11.9362ee1a.js"><link rel="prefetch" href="/assets/js/12.e856ce33.js"><link rel="prefetch" href="/assets/js/13.8548df14.js"><link rel="prefetch" href="/assets/js/14.d421edbb.js"><link rel="prefetch" href="/assets/js/15.aa803848.js"><link rel="prefetch" href="/assets/js/16.1f82aa42.js"><link rel="prefetch" href="/assets/js/17.b76ebf7e.js"><link rel="prefetch" href="/assets/js/18.7c403e8a.js"><link rel="prefetch" href="/assets/js/19.85862406.js"><link rel="prefetch" href="/assets/js/20.50118e6e.js"><link rel="prefetch" href="/assets/js/21.6ecbad1e.js"><link rel="prefetch" href="/assets/js/22.04150677.js"><link rel="prefetch" href="/assets/js/23.31e42250.js"><link rel="prefetch" href="/assets/js/24.62d268d4.js"><link rel="prefetch" href="/assets/js/25.bc860894.js"><link rel="prefetch" href="/assets/js/26.3d26b5e3.js"><link rel="prefetch" href="/assets/js/27.8e7349c7.js"><link rel="prefetch" href="/assets/js/28.4c239e18.js"><link rel="prefetch" href="/assets/js/29.aaac18de.js"><link rel="prefetch" href="/assets/js/3.54236c22.js"><link rel="prefetch" href="/assets/js/30.9db4eedc.js"><link rel="prefetch" href="/assets/js/31.e2f591b8.js"><link rel="prefetch" href="/assets/js/32.6f75b9c1.js"><link rel="prefetch" href="/assets/js/33.fdd459fb.js"><link rel="prefetch" href="/assets/js/34.7c8a0eef.js"><link rel="prefetch" href="/assets/js/35.8ad0c5f3.js"><link rel="prefetch" href="/assets/js/36.8e373213.js"><link rel="prefetch" href="/assets/js/37.95287516.js"><link rel="prefetch" href="/assets/js/38.282f1db3.js"><link rel="prefetch" href="/assets/js/39.34f2b25f.js"><link rel="prefetch" href="/assets/js/4.337abf8d.js"><link rel="prefetch" href="/assets/js/40.ba84faba.js"><link rel="prefetch" href="/assets/js/41.6a8df5b8.js"><link rel="prefetch" href="/assets/js/42.02bc737b.js"><link rel="prefetch" href="/assets/js/44.d430d71d.js"><link rel="prefetch" href="/assets/js/45.eaa465f2.js"><link rel="prefetch" href="/assets/js/46.11cd0dc4.js"><link rel="prefetch" href="/assets/js/47.65a87e15.js"><link rel="prefetch" href="/assets/js/48.250dd2e3.js"><link rel="prefetch" href="/assets/js/49.5d4f098b.js"><link rel="prefetch" href="/assets/js/5.76db1105.js"><link rel="prefetch" href="/assets/js/50.bb697104.js"><link rel="prefetch" href="/assets/js/51.5f6f5b65.js"><link rel="prefetch" href="/assets/js/52.a73139ed.js"><link rel="prefetch" href="/assets/js/53.4d2c7093.js"><link rel="prefetch" href="/assets/js/54.23543b0e.js"><link rel="prefetch" href="/assets/js/55.5f10a002.js"><link rel="prefetch" href="/assets/js/56.90a14ce0.js"><link rel="prefetch" href="/assets/js/57.d16f247e.js"><link rel="prefetch" href="/assets/js/58.9477625f.js"><link rel="prefetch" href="/assets/js/59.b90e777a.js"><link rel="prefetch" href="/assets/js/6.7b498927.js"><link rel="prefetch" href="/assets/js/60.9ac1ad41.js"><link rel="prefetch" href="/assets/js/61.76ce5abb.js"><link rel="prefetch" href="/assets/js/7.c2acd43f.js"><link rel="prefetch" href="/assets/js/8.39f782cd.js"><link rel="prefetch" href="/assets/js/9.241eeeec.js">
<link rel="stylesheet" href="/assets/css/0.styles.6625b277.css">
</head>
<body>
<div id="app" data-server-rendered="true"><div class="theme-container"><header class="navbar"><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">spring-boot-plus</span></a> <div class="links"><div class="search-box"><input aria-label="Search" autocomplete="off" spellcheck="false" value=""> <!----></div> <nav class="nav-links can-hide"><div class="nav-item"><a href="/guide/" class="nav-link router-link-active">指南</a></div><div class="nav-item"><a href="/config/" class="nav-link">配置</a></div><div class="nav-item"><a href="https://github.com/geekidea/spring-boot-plus/blob/master/CHANGELOG.md" target="_blank" rel="noopener noreferrer" class="nav-link external">
更新日志
<svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" 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></a></div><div class="nav-item"><a href="http://geekidea.io/spring-boot-plus-apidocs/" target="_blank" rel="noopener noreferrer" class="nav-link external">
Java Api
<svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" 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></a></div><div class="nav-item"><a href="http://47.105.159.10/api/docs" target="_blank" rel="noopener noreferrer" class="nav-link external">
Swagger
<svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" 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></a></div><div class="nav-item"><a href="http://47.105.159.10/api" target="_blank" rel="noopener noreferrer" class="nav-link external">
后端演示
<svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" 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></a></div><div class="nav-item"><a href="http://47.105.159.10" target="_blank" rel="noopener noreferrer" class="nav-link external">
前端演示
<svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" 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></a></div><div class="nav-item"><div class="dropdown-wrapper"><a class="dropdown-title"><span class="title">Languages</span> <span class="arrow right"></span></a> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/guide/faq.html" class="nav-link router-link-exact-active router-link-active">简体中文</a></li><li class="dropdown-item"><!----> <a href="/en/guide/faq.html" class="nav-link">English</a></li></ul></div></div> <a href="https://github.com/geekidea/spring-boot-plus" target="_blank" rel="noopener noreferrer" class="repo-link">
GitHub
<svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" 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></a></nav></div></header> <div class="sidebar-mask"></div> <aside class="sidebar"><nav class="nav-links"><div class="nav-item"><a href="/guide/" class="nav-link router-link-active">指南</a></div><div class="nav-item"><a href="/config/" class="nav-link">配置</a></div><div class="nav-item"><a href="https://github.com/geekidea/spring-boot-plus/blob/master/CHANGELOG.md" target="_blank" rel="noopener noreferrer" class="nav-link external">
更新日志
<svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" 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></a></div><div class="nav-item"><a href="http://geekidea.io/spring-boot-plus-apidocs/" target="_blank" rel="noopener noreferrer" class="nav-link external">
Java Api
<svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" 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></a></div><div class="nav-item"><a href="http://47.105.159.10/api/docs" target="_blank" rel="noopener noreferrer" class="nav-link external">
Swagger
<svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" 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></a></div><div class="nav-item"><a href="http://47.105.159.10/api" target="_blank" rel="noopener noreferrer" class="nav-link external">
后端演示
<svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" 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></a></div><div class="nav-item"><a href="http://47.105.159.10" target="_blank" rel="noopener noreferrer" class="nav-link external">
前端演示
<svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" 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></a></div><div class="nav-item"><div class="dropdown-wrapper"><a class="dropdown-title"><span class="title">Languages</span> <span class="arrow right"></span></a> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/guide/faq.html" class="nav-link router-link-exact-active router-link-active">简体中文</a></li><li class="dropdown-item"><!----> <a href="/en/guide/faq.html" class="nav-link">English</a></li></ul></div></div> <a href="https://github.com/geekidea/spring-boot-plus" target="_blank" rel="noopener noreferrer" class="repo-link">
GitHub
<svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" 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></a></nav> <ul class="sidebar-links"><li><section class="sidebar-group depth-0"><p class="sidebar-heading"><span>快速入门</span> <!----></p> <ul class="sidebar-links sidebar-group-items"><li><a href="/guide/" class="sidebar-link">简介</a></li><li><a href="/guide/quick-start.html" class="sidebar-link">快速开始</a></li><li><a href="/guide/project-config.html" class="sidebar-link">配置文件</a></li><li><a href="/guide/tree.html" class="sidebar-link">目录结构</a></li><li><a href="/guide/deploy.html" class="sidebar-link">运维部署</a></li></ul></section></li><li><section class="sidebar-group depth-0"><p class="sidebar-heading"><span>核心功能</span> <!----></p> <ul class="sidebar-links sidebar-group-items"><li><a href="/guide/generator.html" class="sidebar-link">生成CRUD代码</a></li><li><a href="/guide/springbootadmin.html" class="sidebar-link">Spring Boot Admin</a></li><li><a href="/guide/centos-deploy.html" class="sidebar-link">CentOS发布</a></li><li><a href="/guide/upload-download-resource.html" class="sidebar-link">文件上传/下载/静态资源访问</a></li><li><a href="/guide/shiro-jwt.html" class="sidebar-link">Shiro+JWT权限管理</a></li><li><a href="/guide/rbac.html" class="sidebar-link">RBAC用户角色权限</a></li><li><a href="/guide/cors.html" class="sidebar-link">CORS跨域处理</a></li><li><a href="/guide/xss.html" class="sidebar-link">XSS跨站脚本攻击处理</a></li></ul></section></li><li><section class="sidebar-group depth-0"><p class="sidebar-heading open"><span>FAQ</span> <!----></p> <ul class="sidebar-links sidebar-group-items"><li><a href="/guide/faq.html" class="active sidebar-link">FAQ</a><ul class="sidebar-sub-headers"><li class="sidebar-sub-header"><a href="/guide/faq.html#编译错误问题" class="sidebar-link">编译错误问题</a><ul class="sidebar-sub-headers"><li class="sidebar-sub-header"><a href="/guide/faq.html#log日志编译错误" class="sidebar-link">log日志编译错误</a></li></ul></li><li class="sidebar-sub-header"><a href="/guide/faq.html#运行错误问题" class="sidebar-link">运行错误问题</a><ul class="sidebar-sub-headers"><li class="sidebar-sub-header"><a href="/guide/faq.html#mysql错误" class="sidebar-link">MySQL错误</a></li><li class="sidebar-sub-header"><a href="/guide/faq.html#redis错误" class="sidebar-link">Redis错误</a></li><li class="sidebar-sub-header"><a href="/guide/faq.html#端口已被占用" class="sidebar-link">端口已被占用</a></li><li class="sidebar-sub-header"><a href="/guide/faq.html#spring-boot-admin不能访问问题" class="sidebar-link">Spring Boot Admin不能访问问题</a></li></ul></li><li class="sidebar-sub-header"><a href="/guide/faq.html#代码生成器问题" class="sidebar-link">代码生成器问题</a></li><li class="sidebar-sub-header"><a href="/guide/faq.html#swagger问题" class="sidebar-link">Swagger问题</a><ul class="sidebar-sub-headers"><li class="sidebar-sub-header"><a href="/guide/faq.html#不能访问swagger页面" class="sidebar-link">不能访问swagger页面</a></li><li class="sidebar-sub-header"><a href="/guide/faq.html#localdatetime日期类使用问题" class="sidebar-link">LocalDateTime日期类使用问题</a></li></ul></li><li class="sidebar-sub-header"><a href="/guide/faq.html#运维部署问题" class="sidebar-link">运维部署问题</a><ul class="sidebar-sub-headers"><li class="sidebar-sub-header"><a href="/guide/faq.html#项目打包后，依赖包丢失" class="sidebar-link">项目打包后，依赖包丢失</a></li><li class="sidebar-sub-header"><a href="/guide/faq.html#could-not-find-artifact-junit-junit-jar-4-12" class="sidebar-link">Could not find artifact junit:junit:jar:4.12</a></li></ul></li><li class="sidebar-sub-header"><a href="/guide/faq.html#分页问题" class="sidebar-link">分页问题</a><ul class="sidebar-sub-headers"><li class="sidebar-sub-header"><a href="/guide/faq.html#keyword字段使用" class="sidebar-link">keyword字段使用</a></li><li class="sidebar-sub-header"><a href="/guide/faq.html#如何使用自定义查询条件" class="sidebar-link">如何使用自定义查询条件</a></li><li class="sidebar-sub-header"><a href="/guide/faq.html#如何使用排序" class="sidebar-link">如何使用排序</a></li></ul></li><li class="sidebar-sub-header"><a href="/guide/faq.html#根据实体类中的属性名称，获取表对应的列名称" class="sidebar-link">根据实体类中的属性名称，获取表对应的列名称</a></li><li class="sidebar-sub-header"><a href="/guide/faq.html#other问题" class="sidebar-link">Other问题</a></li></ul></li><li><a href="/guide/idea-spring-boot-plus.html" class="sidebar-link">IDEA导入spring-boot-plus</a></li><li><a href="/guide/eclipse-spring-boot-plus.html" class="sidebar-link">Eclipse导入spring-boot-plus</a></li><li><a href="/guide/swagger-scan-package.html" class="sidebar-link">Swagger扫描多个包</a></li><li><a href="/guide/oracle.html" class="sidebar-link">spring-boot-plus使用Oracle配置</a></li><li><a href="/guide/sqlserver.html" class="sidebar-link">spring-boot-plus使用SQLServer配置</a></li><li><a href="/guide/contact.html" class="sidebar-link">QQ技术交流群</a></li><li><a href="/guide/donate.html" class="sidebar-link">赞赏支持</a></li></ul></section></li></ul> </aside> <main class="page"> <div class="theme-default-content content__default"><h1 id="faq"><a href="#faq" aria-hidden="true" class="header-anchor">#</a> FAQ</h1> <p></p><div class="table-of-contents"><ul><li><a href="#编译错误问题">编译错误问题</a><ul><li><a href="#log日志编译错误">log日志编译错误</a></li></ul></li><li><a href="#运行错误问题">运行错误问题</a><ul><li><a href="#mysql错误">MySQL错误</a></li><li><a href="#redis错误">Redis错误</a></li><li><a href="#端口已被占用">端口已被占用</a></li><li><a href="#spring-boot-admin不能访问问题">Spring Boot Admin不能访问问题</a></li></ul></li><li><a href="#代码生成器问题">代码生成器问题</a></li><li><a href="#swagger问题">Swagger问题</a><ul><li><a href="#不能访问swagger页面">不能访问swagger页面</a></li><li><a href="#localdatetime日期类使用问题">LocalDateTime日期类使用问题</a></li></ul></li><li><a href="#运维部署问题">运维部署问题</a><ul><li><a href="#项目打包后，依赖包丢失">项目打包后，依赖包丢失</a></li><li><a href="#could-not-find-artifact-junit-junit-jar-4-12">Could not find artifact junit:junit:jar:4.12</a></li></ul></li><li><a href="#分页问题">分页问题</a><ul><li><a href="#keyword字段使用">keyword字段使用</a></li><li><a href="#如何使用自定义查询条件">如何使用自定义查询条件</a></li><li><a href="#如何使用排序">如何使用排序</a></li></ul></li><li><a href="#根据实体类中的属性名称，获取表对应的列名称">根据实体类中的属性名称，获取表对应的列名称</a></li><li><a href="#other问题">Other问题</a></li></ul></div><p></p> <h2 id="编译错误问题"><a href="#编译错误问题" aria-hidden="true" class="header-anchor">#</a> 编译错误问题</h2> <h3 id="log日志编译错误"><a href="#log日志编译错误" aria-hidden="true" class="header-anchor">#</a> log日志编译错误</h3> <div class="danger custom-block"><p class="custom-block-title">log报错</p> <ul><li>编译提示log.info等日志错误</li></ul></div> <div class="tip custom-block"><p class="custom-block-title">解决</p> <ul><li>检查是否安装lombok插件</li> <li><a href="https://springboot.plus/guide/idea-spring-boot-plus.html" target="_blank" rel="noopener noreferrer">idea安装lombok<svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" 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></a></li> <li><a href="https://springboot.plus/guide/eclipse-spring-boot-plus.html" target="_blank" rel="noopener noreferrer">eclipse安装lombok<svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" 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></a></li></ul></div> <h2 id="运行错误问题"><a href="#运行错误问题" aria-hidden="true" class="header-anchor">#</a> 运行错误问题</h2> <h3 id="mysql错误"><a href="#mysql错误" aria-hidden="true" class="header-anchor">#</a> MySQL错误</h3> <div class="language-text extra-class"><pre class="language-text"><code>2019-07-31 14:16:52.412 ERROR 14724 --- [ main] com.alibaba.druid.pool.DruidDataSource : init datasource error, url: jdbc:mysql://localhost:3306/spring_boot_plus?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&useSSL=false&allowPublicKeyRetrieval=true
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
</code></pre></div><div class="danger custom-block"><p class="custom-block-title">不能连接mysql</p> <p>com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure</p></div> <div class="tip custom-block"><p class="custom-block-title">解决</p> <ul><li>检查MySQL服务是否启动</li> <li>检查ip地址和端口号</li></ul></div> <div class="danger custom-block"><p class="custom-block-title">未知数据库</p> <p>com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'spring_boot_plus'</p></div> <div class="tip custom-block"><p class="custom-block-title">解决</p> <ul><li>检查是否新建spring_boot_plus数据库</li> <li>默认的数据库为spring_boot_plus，可在不同环境的配置文件中更改</li> <li>例如：application-local.yml中的spring.datasource.url中更改数据库名称</li></ul></div> <h3 id="redis错误"><a href="#redis错误" aria-hidden="true" class="header-anchor">#</a> Redis错误</h3> <div class="language-text extra-class"><pre class="language-text"><code>org.springframework.data.redis.connection.PoolException: Could not get a resource from the pool; nested exception is io.lettuce.core.RedisConnectionException: Unable to connect to localhost:6379
</code></pre></div><div class="danger custom-block"><p class="custom-block-title">不能连接redis</p> <p>Unable to connect to localhost:6379</p></div> <div class="tip custom-block"><p class="custom-block-title">解决</p> <ul><li>启动redis服务</li> <li>redis默认端口号：6379</li> <li>默认没有设置密码</li> <li>请根据环境情况，进行配置</li></ul></div> <h3 id="端口已被占用"><a href="#端口已被占用" aria-hidden="true" class="header-anchor">#</a> 端口已被占用</h3> <div class="danger custom-block"><p class="custom-block-title">Caused by: java.net.BindException: Address already in use: bind</p> <div class="language-text extra-class"><pre class="language-text"><code>Caused by: java.net.BindException: Address already in use: bind
at sun.nio.ch.Net.bind0(Native Method) ~[na:1.8.0_191]
at sun.nio.ch.Net.bind(Net.java:433) ~[na:1.8.0_191]
at sun.nio.ch.Net.bind(Net.java:425) ~[na:1.8.0_191]
at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:223) ~[na:1.8.0_191]
at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74) ~[na:1.8.0_191]
</code></pre></div></div> <blockquote><p>详细错误日志</p></blockquote> <div class="language-text extra-class"><pre class="language-text"><code>2019-08-02 23:23:41.350 ERROR 23380 --- [ main] org.apache.catalina.util.LifecycleBase : Failed to start component [Connector[HTTP/1.1-8888]]
org.apache.catalina.LifecycleException: Protocol handler start failed
at org.apache.catalina.connector.Connector.startInternal(Connector.java:1008) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
at org.apache.catalina.core.StandardService.addConnector(StandardService.java:227) [tomcat-embed-core-9.0.21.jar:9.0.21]
at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.addPreviouslyRemovedConnectors(TomcatWebServer.java:263) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.start(TomcatWebServer.java:195) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.startWebServer(ServletWebServerApplicationContext.java:296) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.finishRefresh(ServletWebServerApplicationContext.java:162) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:552) [spring-context-5.1.8.RELEASE.jar:5.1.8.RELEASE]
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:742) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:389) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:311) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1213) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1202) [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
at io.geekidea.springbootplus.SpringBootPlusApplication.main(SpringBootPlusApplication.java:51) [classes/:na]
Caused by: java.net.BindException: Address already in use: bind
at sun.nio.ch.Net.bind0(Native Method) ~[na:1.8.0_191]
at sun.nio.ch.Net.bind(Net.java:433) ~[na:1.8.0_191]
at sun.nio.ch.Net.bind(Net.java:425) ~[na:1.8.0_191]
at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:223) ~[na:1.8.0_191]
at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:74) ~[na:1.8.0_191]
at org.apache.tomcat.util.net.NioEndpoint.initServerSocket(NioEndpoint.java:230) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
at org.apache.tomcat.util.net.NioEndpoint.bind(NioEndpoint.java:213) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
at org.apache.tomcat.util.net.AbstractEndpoint.bindWithCleanup(AbstractEndpoint.java:1124) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
at org.apache.tomcat.util.net.AbstractEndpoint.start(AbstractEndpoint.java:1210) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
at org.apache.coyote.AbstractProtocol.start(AbstractProtocol.java:585) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
at org.apache.catalina.connector.Connector.startInternal(Connector.java:1005) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
... 14 common frames omitted
2019-08-02 23:23:41.356 INFO 23380 --- [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat]
2019-08-02 23:23:41.362 WARN 23380 --- [ main] o.a.c.loader.WebappClassLoaderBase : The web application [ROOT] appears to have started a thread named [lettuce-eventExecutorLoop-1-1] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
sun.misc.Unsafe.park(Native Method)
java.util.concurrent.locks.LockSupport.parkNanos(LockSupport.java:215)
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2078)
java.util.concurrent.LinkedBlockingQueue.poll(LinkedBlockingQueue.java:467)
io.netty.util.concurrent.SingleThreadEventExecutor.takeTask(SingleThreadEventExecutor.java:252)
io.netty.util.concurrent.DefaultEventExecutor.run(DefaultEventExecutor.java:64)
io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:906)
io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
java.lang.Thread.run(Thread.java:748)
2019-08-02 23:23:41.363 WARN 23380 --- [ main] o.a.c.loader.WebappClassLoaderBase : The web application [ROOT] appears to have started a thread named [Druid-ConnectionPool-Create-1916224178] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
sun.misc.Unsafe.park(Native Method)
java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039)
com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2672)
2019-08-02 23:23:41.364 WARN 23380 --- [ main] o.a.c.loader.WebappClassLoaderBase : The web application [ROOT] appears to have started a thread named [Druid-ConnectionPool-Destroy-1916224178] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Thread.sleep(Native Method)
com.alibaba.druid.pool.DruidDataSource$DestroyConnectionThread.run(DruidDataSource.java:2768)
2019-08-02 23:23:41.377 INFO 23380 --- [ main] ConditionEvaluationReportLoggingListener :
Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2019-08-02 23:23:41.383 ERROR 23380 --- [ main] o.s.b.d.LoggingFailureAnalysisReporter :
***************************
APPLICATION FAILED TO START
***************************
Description:
The Tomcat connector configured to listen on port 8888 failed to start. The port may already be in use or the connector may be misconfigured.
Action:
Verify the connector's configuration, identify and stop any process that's listening on port 8888, or configure this application to listen on another port.
2019-08-02 23:23:41.410 INFO 23380 --- [ main] o.s.s.c.ThreadPoolTaskScheduler : Shutting down ExecutorService 'taskScheduler'
2019-08-02 23:23:41.413 INFO 23380 --- [ main] o.s.s.c.ThreadPoolTaskScheduler : Shutting down ExecutorService
2019-08-02 23:23:41.414 INFO 23380 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Shutting down ExecutorService 'applicationTaskExecutor'
2019-08-02 23:23:41.417 INFO 23380 --- [ main] com.alibaba.druid.pool.DruidDataSource : {dataSource-1} closing ...
2019-08-02 23:23:41.421 INFO 23380 --- [ main] com.alibaba.druid.pool.DruidDataSource : {dataSource-1} closed
Process finished with exit code 1
</code></pre></div><div class="tip custom-block"><p class="custom-block-title">解决</p> <blockquote><p>修改端口： <code>application.local.yml</code>中的<code>port</code>，默认端口<code>8888</code></p></blockquote> <ul><li>或者kill掉对应端口的进程</li> <li>Mac/linux：kill端口</li> <li>Windows：找到对应的java程序，结束任务</li></ul></div> <h3 id="spring-boot-admin不能访问问题"><a href="#spring-boot-admin不能访问问题" aria-hidden="true" class="header-anchor">#</a> Spring Boot Admin不能访问问题</h3> <div class="danger custom-block"><p class="custom-block-title">你的主机中的软件中止了一个已建立的连接</p> <div class="language-text extra-class"><pre class="language-text"><code>2019-07-31 16:33:37.205 ERROR 6696 --- [ctor-http-nio-2] o.s.w.s.adapter.HttpWebHandlerAdapter : [f4aeb71d] Error [java.io.IOException: 你的主机中的软件中止了一个已建立的连接。] for HTTP GET "/applications", but ServerHttpResponse already committed (200 OK)
</code></pre></div></div> <div class="tip custom-block"><p class="custom-block-title">解决</p> <blockquote><p>8888端口：与当前项目端口一致</p></blockquote> <ul><li>yaml配置</li></ul> <div class="language-yaml extra-class"><pre class="language-yaml"><code><span class="token key atrule">spring</span><span class="token punctuation">:</span>
<span class="token key atrule">boot</span><span class="token punctuation">:</span>
<span class="token key atrule">admin</span><span class="token punctuation">:</span>
<span class="token key atrule">client</span><span class="token punctuation">:</span>
<span class="token key atrule">url</span><span class="token punctuation">:</span> <span class="token string">'http://localhost:8888'</span>
<span class="token key atrule">management</span><span class="token punctuation">:</span>
<span class="token key atrule">endpoints</span><span class="token punctuation">:</span>
<span class="token key atrule">web</span><span class="token punctuation">:</span>
<span class="token key atrule">exposure</span><span class="token punctuation">:</span>
<span class="token key atrule">include</span><span class="token punctuation">:</span> <span class="token string">"*"</span>
<span class="token key atrule">endpoint</span><span class="token punctuation">:</span>
<span class="token key atrule">health</span><span class="token punctuation">:</span>
<span class="token key atrule">show-details</span><span class="token punctuation">:</span> ALWAYS
</code></pre></div><ul><li>properties配置</li></ul> <div class="language-properties extra-class"><pre class="language-properties"><code><span class="token attr-name">spring.boot.admin.client.url</span><span class="token punctuation">=</span><span class="token attr-value">http://localhost:8888</span>
<span class="token attr-name">management.endpoints.web.exposure.include</span><span class="token punctuation">=</span><span class="token attr-value">*</span>
<span class="token attr-name">management.endpoint.health.show-details</span><span class="token punctuation">=</span><span class="token attr-value">ALWAYS</span>
</code></pre></div></div> <h2 id="代码生成器问题"><a href="#代码生成器问题" aria-hidden="true" class="header-anchor">#</a> 代码生成器问题</h2> <h2 id="swagger问题"><a href="#swagger问题" aria-hidden="true" class="header-anchor">#</a> Swagger问题</h2> <h3 id="不能访问swagger页面"><a href="#不能访问swagger页面" aria-hidden="true" class="header-anchor">#</a> 不能访问swagger页面</h3> <div class="danger custom-block"><div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span><span class="token property">"code"</span><span class="token operator">:</span><span class="token number">404</span><span class="token punctuation">,</span><span class="token property">"data"</span><span class="token operator">:</span><span class="token null keyword">null</span><span class="token punctuation">,</span><span class="token property">"msg"</span><span class="token operator">:</span><span class="token string">"你请求的路径不存在"</span><span class="token punctuation">,</span><span class="token property">"time"</span><span class="token operator">:</span><span class="token string">"2019-08-01 12:56:27"</span><span class="token punctuation">}</span>
</code></pre></div></div> <div class="tip custom-block"><p class="custom-block-title">解决</p> <ul><li>检查WebMvcConfig.java类中是否排除了swagger静态资源</li></ul> <div class="language-java extra-class"><pre class="language-java"><code><span class="token annotation punctuation">@Override</span>
<span class="token keyword">public</span> <span class="token keyword">void</span> <span class="token function">addResourceHandlers</span><span class="token punctuation">(</span><span class="token class-name">ResourceHandlerRegistry</span> registry<span class="token punctuation">)</span> <span class="token punctuation">{</span>
registry<span class="token punctuation">.</span><span class="token function">addResourceHandler</span><span class="token punctuation">(</span><span class="token string">"swagger-ui.html"</span><span class="token punctuation">)</span>
<span class="token punctuation">.</span><span class="token function">addResourceLocations</span><span class="token punctuation">(</span><span class="token string">"classpath:/META-INF/resources/"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
registry<span class="token punctuation">.</span><span class="token function">addResourceHandler</span><span class="token punctuation">(</span><span class="token string">"/webjars/**"</span><span class="token punctuation">)</span>
<span class="token punctuation">.</span><span class="token function">addResourceLocations</span><span class="token punctuation">(</span><span class="token string">"classpath:/META-INF/resources/webjars/"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
</code></pre></div></div> <h3 id="localdatetime日期类使用问题"><a href="#localdatetime日期类使用问题" aria-hidden="true" class="header-anchor">#</a> LocalDateTime日期类使用问题</h3> <div class="danger custom-block"><p>Caused by: java.sql.SQLFeatureNotSupportedException</p></div> <div class="language-text extra-class"><pre class="language-text"><code>Caused by: java.sql.SQLFeatureNotSupportedException
at com.alibaba.druid.pool.DruidPooledResultSet.getObject(DruidPooledResultSet.java:1771)
at org.apache.ibatis.type.LocalDateTimeTypeHandler.getNullableResult(LocalDateTimeTypeHandler.java:38)
at org.apache.ibatis.type.LocalDateTimeTypeHandler.getNullableResult(LocalDateTimeTypeHandler.java:28)
at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:81)
</code></pre></div><div class="language-text extra-class"><pre class="language-text"><code>org.springframework.dao.InvalidDataAccessApiUsageException: Error attempting to get column 'create_time' from result set. Cause: java.sql.SQLFeatureNotSupportedException
; null; nested exception is java.sql.SQLFeatureNotSupportedException
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:96)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy134.selectOne(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:89)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:62)
at com.sun.proxy.$Proxy139.getSysLogById(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
</code></pre></div><div class="tip custom-block"><ul><li>问题原因是JDK8的LocalDate、LocalTime、LocalDateTime日期类型，druid数据源尚不支持</li> <li><a href="https://github.com/alibaba/druid/issues/3230" target="_blank" rel="noopener noreferrer">druid issues<svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" 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></a></li></ul> <blockquote><p>目前解决办法</p></blockquote> <ul><li><ol><li>更换数据源</li></ol></li> <li><ol start="2"><li>在mybatis-plus生成代码中配置，将日期类型生成为<code>DateType.ONLY_DATE</code>，数据库中的日期类型生成为Date</li></ol></li></ul> <div class="language-java extra-class"><pre class="language-java"><code><span class="token comment">// 全局配置</span>
<span class="token class-name">GlobalConfig</span> gc <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">GlobalConfig</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
gc<span class="token punctuation">.</span><span class="token function">setDateType</span><span class="token punctuation">(</span><span class="token class-name">DateType</span><span class="token punctuation">.</span>ONLY_DATE<span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token comment">// 设置日期类型为Date</span>
</code></pre></div><p><a href="https://mybatis.plus/config/generator-config.html#datetype" target="_blank" rel="noopener noreferrer">mybatis-plus dateType配置<svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" 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></a></p></div> <h2 id="运维部署问题"><a href="#运维部署问题" aria-hidden="true" class="header-anchor">#</a> 运维部署问题</h2> <h3 id="项目打包后，依赖包丢失"><a href="#项目打包后，依赖包丢失" aria-hidden="true" class="header-anchor">#</a> 项目打包后，依赖包丢失</h3> <div class="danger custom-block"><ul><li>spring-boot-plus.jar只有100多kb</li> <li>此时依赖包未打包到主jar中，检查pom.xml配置</li></ul></div> <blockquote><p>spring-boot-plus项目中，pom.xml没有直接继承spring-boot-starter-parent</p></blockquote> <blockquote><p>而是导入spring-boot-dependencies依赖</p></blockquote> <blockquote><p>这样做的好处是，项目可以继承自己的父pom</p></blockquote> <div class="tip custom-block"><p class="custom-block-title">使用这种方式，进行打包，默认情况下，会导致依赖包丢失，需进行以下配置</p> <div class="language-xml extra-class"><pre class="language-xml"><code><span class="token tag"><span class="token tag"><span class="token punctuation"><</span>plugin</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>groupId</span><span class="token punctuation">></span></span>org.springframework.boot<span class="token tag"><span class="token tag"><span class="token punctuation"></</span>groupId</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>artifactId</span><span class="token punctuation">></span></span>spring-boot-maven-plugin<span class="token tag"><span class="token tag"><span class="token punctuation"></</span>artifactId</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>configuration</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>mainClass</span><span class="token punctuation">></span></span>io.geekidea.springbootplus.SpringBootPlusApplication<span class="token tag"><span class="token tag"><span class="token punctuation"></</span>mainClass</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"></</span>configuration</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>executions</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>execution</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>goals</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>goal</span><span class="token punctuation">></span></span>repackage<span class="token tag"><span class="token tag"><span class="token punctuation"></</span>goal</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"></</span>goals</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"></</span>execution</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"></</span>executions</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"></</span>plugin</span><span class="token punctuation">></span></span>
</code></pre></div><ul><li>mainClass：项目启动类</li> <li>repackage：重新打包</li></ul></div> <h3 id="could-not-find-artifact-junit-junit-jar-4-12"><a href="#could-not-find-artifact-junit-junit-jar-4-12" aria-hidden="true" class="header-anchor">#</a> Could not find artifact junit:junit:jar:4.12</h3> <p>::: dander Could not find artifact junit:junit:jar:4.12</p> <div class="language-text extra-class"><pre class="language-text"><code>[ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.22.2:test (default-test) on project spring-boot-plus: Execution default-test of goal org.apache.maven.plugins:maven-surefire-plugin:2.22.2:test failed: Plugin org.apache.maven.plugins:maven-surefire-plugin:2.22.2 or one of its dependencies could not be resolved: The following artifacts could not be resolved: junit:junit:jar:4.12, org.hamcrest:hamcrest-core:jar:1.3: Could not find artifact junit:junit:jar:4.12 -> [Help 1]
</code></pre></div><p>:::</p> <div class="tip custom-block"><p class="custom-block-title">解决</p> <div class="language-xml extra-class"><pre class="language-xml"><code><span class="token tag"><span class="token tag"><span class="token punctuation"><</span>dependency</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>groupId</span><span class="token punctuation">></span></span>junit<span class="token tag"><span class="token tag"><span class="token punctuation"></</span>groupId</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>artifactId</span><span class="token punctuation">></span></span>junit<span class="token tag"><span class="token tag"><span class="token punctuation"></</span>artifactId</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>version</span><span class="token punctuation">></span></span>4.12<span class="token tag"><span class="token tag"><span class="token punctuation"></</span>version</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>scope</span><span class="token punctuation">></span></span>test<span class="token tag"><span class="token tag"><span class="token punctuation"></</span>scope</span><span class="token punctuation">></span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation"></</span>dependency</span><span class="token punctuation">></span></span>
</code></pre></div></div> <h2 id="分页问题"><a href="#分页问题" aria-hidden="true" class="header-anchor">#</a> 分页问题</h2> <h3 id="keyword字段使用"><a href="#keyword字段使用" aria-hidden="true" class="header-anchor">#</a> keyword字段使用</h3> <blockquote><p>POST http://127.0.0.1:8888/sysUser/getPageList</p></blockquote> <ul><li>请求参数</li></ul> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
<span class="token property">"keyword"</span><span class="token operator">:</span> <span class="token string">"adm"</span>
<span class="token punctuation">}</span>
</code></pre></div><ul><li>SysUserQueryParam.java</li></ul> <blockquote><p>只使用keyword时，查询参数对象可为空，QueryParam.java父类中有<code>keyword</code>字段</p></blockquote> <div class="language-java extra-class"><pre class="language-java"><code><span class="token annotation punctuation">@Data</span>
<span class="token annotation punctuation">@Accessors</span><span class="token punctuation">(</span>chain <span class="token operator">=</span> <span class="token boolean">true</span><span class="token punctuation">)</span>
<span class="token annotation punctuation">@EqualsAndHashCode</span><span class="token punctuation">(</span>callSuper <span class="token operator">=</span> <span class="token boolean">true</span><span class="token punctuation">)</span>
<span class="token annotation punctuation">@ApiModel</span><span class="token punctuation">(</span>value <span class="token operator">=</span> <span class="token string">"SysUserQueryParam对象"</span><span class="token punctuation">,</span> description <span class="token operator">=</span> <span class="token string">"系统用户查询参数"</span><span class="token punctuation">)</span>
<span class="token keyword">public</span> <span class="token keyword">class</span> <span class="token class-name">SysUserQueryParam</span> <span class="token keyword">extends</span> <span class="token class-name">OrderQueryParam</span> <span class="token punctuation">{</span>
<span class="token punctuation">}</span>
</code></pre></div><ul><li>SysUserMapper.xml</li></ul> <blockquote><p>xml中使用<code>param</code>获取<code>keyword</code>，需要模糊查询的字段需要自定义</p></blockquote> <div class="language-xml extra-class"><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">=</span><span class="token punctuation">"</span>getSysUserPageList<span class="token punctuation">"</span></span> <span class="token attr-name">resultType</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>io.geekidea.springbootplus.system.vo.SysUserQueryVo<span class="token punctuation">"</span></span><span class="token punctuation">></span></span>
select
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>include</span> <span class="token attr-name">refid</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>Base_Column_List<span class="token punctuation">"</span></span><span class="token punctuation">/></span></span>
from sys_user
where deleted = 0
<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">=</span><span class="token punctuation">"</span>param.keyword != null and param.keyword != ''<span class="token punctuation">"</span></span><span class="token punctuation">></span></span>
and (
username like concat('%', #{param.keyword} ,'%') or
nickname like concat('%', #{param.keyword} ,'%')
)
<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>select</span><span class="token punctuation">></span></span>
</code></pre></div><ul><li>响应结果</li></ul> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
<span class="token property">"code"</span><span class="token operator">:</span> <span class="token number">200</span><span class="token punctuation">,</span>
<span class="token property">"msg"</span><span class="token operator">:</span> <span class="token string">"操作成功"</span><span class="token punctuation">,</span>
<span class="token property">"success"</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
<span class="token property">"data"</span><span class="token operator">:</span> <span class="token punctuation">{</span>
<span class="token property">"total"</span><span class="token operator">:</span> <span class="token string">"1"</span><span class="token punctuation">,</span>
<span class="token property">"records"</span><span class="token operator">:</span> <span class="token punctuation">[</span>
<span class="token punctuation">{</span>
<span class="token property">"id"</span><span class="token operator">:</span> <span class="token string">"1"</span><span class="token punctuation">,</span>
<span class="token property">"username"</span><span class="token operator">:</span> <span class="token string">"admin"</span><span class="token punctuation">,</span>
<span class="token property">"nickname"</span><span class="token operator">:</span> <span class="token string">"管理员"</span><span class="token punctuation">,</span>
<span class="token property">"phone"</span><span class="token operator">:</span> <span class="token string">"15888889900"</span><span class="token punctuation">,</span>
<span class="token property">"gender"</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
<span class="token property">"head"</span><span class="token operator">:</span> <span class="token string">"http://localhost:8888/api/resource/201908201013068.png"</span><span class="token punctuation">,</span>
<span class="token property">"remark"</span><span class="token operator">:</span> <span class="token string">"Administrator Account"</span><span class="token punctuation">,</span>
<span class="token property">"state"</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
<span class="token property">"departmentId"</span><span class="token operator">:</span> <span class="token string">"1"</span><span class="token punctuation">,</span>
<span class="token property">"roleId"</span><span class="token operator">:</span> <span class="token string">"1"</span><span class="token punctuation">,</span>
<span class="token property">"deleted"</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
<span class="token property">"version"</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
<span class="token property">"createTime"</span><span class="token operator">:</span> <span class="token string">"2020-02-26 00:00:00"</span><span class="token punctuation">,</span>
<span class="token property">"updateTime"</span><span class="token operator">:</span> <span class="token string">"2019-10-27 23:32:29"</span>
<span class="token punctuation">}</span>
<span class="token punctuation">]</span>
<span class="token punctuation">}</span><span class="token punctuation">,</span>
<span class="token property">"time"</span><span class="token operator">:</span> <span class="token string">"2020-03-01 21:39:09"</span>
<span class="token punctuation">}</span>
</code></pre></div><ul><li>SQL查询语句</li></ul> <div class="language-sql extra-class"><pre class="language-sql"><code><span class="token operator">=</span><span class="token operator">=</span><span class="token operator">></span> Preparing: <span class="token keyword">SELECT</span> <span class="token function">COUNT</span><span class="token punctuation">(</span><span class="token number">1</span><span class="token punctuation">)</span> <span class="token keyword">FROM</span> sys_user <span class="token keyword">WHERE</span> deleted <span class="token operator">=</span> <span class="token number">0</span> <span class="token operator">AND</span> <span class="token punctuation">(</span>username <span class="token operator">LIKE</span> concat<span class="token punctuation">(</span><span class="token string">'%'</span><span class="token punctuation">,</span> ?<span class="token punctuation">,</span> <span class="token string">'%'</span><span class="token punctuation">)</span> <span class="token operator">OR</span> nickname <span class="token operator">LIKE</span> concat<span class="token punctuation">(</span><span class="token string">'%'</span><span class="token punctuation">,</span> ?<span class="token punctuation">,</span> <span class="token string">'%'</span><span class="token punctuation">)</span><span class="token punctuation">)</span>
<span class="token operator">=</span><span class="token operator">=</span><span class="token operator">></span> Parameters: adm<span class="token punctuation">(</span>String<span class="token punctuation">)</span><span class="token punctuation">,</span> adm<span class="token punctuation">(</span>String<span class="token punctuation">)</span>
<span class="token operator"><=</span><span class="token operator">=</span> <span class="token keyword">Columns</span>: <span class="token function">COUNT</span><span class="token punctuation">(</span><span class="token number">1</span><span class="token punctuation">)</span>
<span class="token operator"><=</span><span class="token operator">=</span> <span class="token keyword">Row</span>: <span class="token number">1</span>
<span class="token operator">=</span><span class="token operator">=</span><span class="token operator">></span> Preparing: <span class="token keyword">SELECT</span> id<span class="token punctuation">,</span> username<span class="token punctuation">,</span> nickname<span class="token punctuation">,</span> phone<span class="token punctuation">,</span> gender<span class="token punctuation">,</span> head<span class="token punctuation">,</span> remark<span class="token punctuation">,</span> state<span class="token punctuation">,</span> department_id<span class="token punctuation">,</span> role_id<span class="token punctuation">,</span> deleted<span class="token punctuation">,</span> version<span class="token punctuation">,</span> create_time<span class="token punctuation">,</span> update_time <span class="token keyword">FROM</span> sys_user <span class="token keyword">WHERE</span> deleted <span class="token operator">=</span> <span class="token number">0</span> <span class="token operator">AND</span> <span class="token punctuation">(</span>username <span class="token operator">LIKE</span> concat<span class="token punctuation">(</span><span class="token string">'%'</span><span class="token punctuation">,</span> ?<span class="token punctuation">,</span> <span class="token string">'%'</span><span class="token punctuation">)</span> <span class="token operator">OR</span> nickname <span class="token operator">LIKE</span> concat<span class="token punctuation">(</span><span class="token string">'%'</span><span class="token punctuation">,</span> ?<span class="token punctuation">,</span> <span class="token string">'%'</span><span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token keyword">ORDER</span> <span class="token keyword">BY</span> create_time <span class="token keyword">DESC</span> <span class="token keyword">LIMIT</span> ?<span class="token punctuation">,</span>?
<span class="token operator">=</span><span class="token operator">=</span><span class="token operator">></span> Parameters: adm<span class="token punctuation">(</span>String<span class="token punctuation">)</span><span class="token punctuation">,</span> adm<span class="token punctuation">(</span>String<span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token number">0</span><span class="token punctuation">(</span>Long<span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token number">10</span><span class="token punctuation">(</span>Long<span class="token punctuation">)</span>
<span class="token operator"><=</span><span class="token operator">=</span> <span class="token keyword">Columns</span>: id<span class="token punctuation">,</span> username<span class="token punctuation">,</span> nickname<span class="token punctuation">,</span> phone<span class="token punctuation">,</span> gender<span class="token punctuation">,</span> head<span class="token punctuation">,</span> remark<span class="token punctuation">,</span> state<span class="token punctuation">,</span> department_id<span class="token punctuation">,</span> role_id<span class="token punctuation">,</span> deleted<span class="token punctuation">,</span> version<span class="token punctuation">,</span> create_time<span class="token punctuation">,</span> update_time
<span class="token operator"><=</span><span class="token operator">=</span> <span class="token keyword">Row</span>: <span class="token number">1</span><span class="token punctuation">,</span> admin<span class="token punctuation">,</span> 管理员<span class="token punctuation">,</span> <span class="token number">15888889900</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> http:<span class="token comment">//localhost:8888/api/resource/201908201013068.png, Administrator Account, 1, 1, 1, 0, 1, 2020-02-26 00:00:00.0, 2019-10-27 23:32:29.0</span>
<span class="token operator"><=</span><span class="token operator">=</span> Total: <span class="token number">1</span>
</code></pre></div><ul><li>重点查询条件语句</li></ul> <div class="language-sql extra-class"><pre class="language-sql"><code><span class="token keyword">where</span> deleted <span class="token operator">=</span> <span class="token number">0</span>
<span class="token operator">and</span> <span class="token punctuation">(</span>
username <span class="token operator">like</span> concat<span class="token punctuation">(</span><span class="token string">'%'</span><span class="token punctuation">,</span> ? <span class="token punctuation">,</span><span class="token string">'%'</span><span class="token punctuation">)</span> <span class="token operator">or</span>
nickname <span class="token operator">like</span> concat<span class="token punctuation">(</span><span class="token string">'%'</span><span class="token punctuation">,</span> ? <span class="token punctuation">,</span><span class="token string">'%'</span><span class="token punctuation">)</span>
<span class="token punctuation">)</span>
</code></pre></div><h3 id="如何使用自定义查询条件"><a href="#如何使用自定义查询条件" aria-hidden="true" class="header-anchor">#</a> 如何使用自定义查询条件</h3> <ul><li>SysUserQueryParam.java</li></ul> <div class="language-java extra-class"><pre class="language-java"><code><span class="token annotation punctuation">@Data</span>
<span class="token annotation punctuation">@Accessors</span><span class="token punctuation">(</span>chain <span class="token operator">=</span> <span class="token boolean">true</span><span class="token punctuation">)</span>
<span class="token annotation punctuation">@EqualsAndHashCode</span><span class="token punctuation">(</span>callSuper <span class="token operator">=</span> <span class="token boolean">true</span><span class="token punctuation">)</span>
<span class="token annotation punctuation">@ApiModel</span><span class="token punctuation">(</span>value <span class="token operator">=</span> <span class="token string">"SysUserQueryParam对象"</span><span class="token punctuation">,</span> description <span class="token operator">=</span> <span class="token string">"系统用户查询参数"</span><span class="token punctuation">)</span>
<span class="token keyword">public</span> <span class="token keyword">class</span> <span class="token class-name">SysUserQueryParam</span> <span class="token keyword">extends</span> <span class="token class-name">OrderQueryParam</span> <span class="token punctuation">{</span>
<span class="token keyword">private</span> <span class="token keyword">static</span> <span class="token keyword">final</span> <span class="token keyword">long</span> serialVersionUID <span class="token operator">=</span> <span class="token operator">-</span><span class="token number">1115907077988380787L</span><span class="token punctuation">;</span>
<span class="token annotation punctuation">@ApiModelProperty</span><span class="token punctuation">(</span><span class="token string">"用户名"</span><span class="token punctuation">)</span>
<span class="token keyword">private</span> <span class="token class-name">String</span> username<span class="token punctuation">;</span>
<span class="token annotation punctuation">@ApiModelProperty</span><span class="token punctuation">(</span><span class="token string">"昵称"</span><span class="token punctuation">)</span>
<span class="token keyword">private</span> <span class="token class-name">String</span> nickname<span class="token punctuation">;</span>
<span class="token annotation punctuation">@ApiModelProperty</span><span class="token punctuation">(</span><span class="token string">"状态，0：禁用，1：启用，2：锁定"</span><span class="token punctuation">)</span>
<span class="token keyword">private</span> <span class="token class-name">Integer</span> state<span class="token punctuation">;</span>
<span class="token annotation punctuation">@ApiModelProperty</span><span class="token punctuation">(</span><span class="token string">"创建时间开始"</span><span class="token punctuation">)</span>
<span class="token keyword">private</span> <span class="token class-name">Date</span> createTimeStart<span class="token punctuation">;</span>
<span class="token annotation punctuation">@ApiModelProperty</span><span class="token punctuation">(</span><span class="token string">"创建时间结束"</span><span class="token punctuation">)</span>
<span class="token keyword">private</span> <span class="token class-name">Date</span> createTimeEnd<span class="token punctuation">;</span>
<span class="token punctuation">}</span>
</code></pre></div><ul><li>请求参数</li></ul> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
<span class="token property">"username"</span><span class="token operator">:</span> <span class="token string">"adm"</span><span class="token punctuation">,</span>
<span class="token property">"state"</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
<span class="token property">"createTimeStart"</span><span class="token operator">:</span> <span class="token string">"2020-02-26"</span><span class="token punctuation">,</span>
<span class="token property">"createTimeEnd"</span><span class="token operator">:</span> <span class="token string">"2020-02-27"</span>
<span class="token punctuation">}</span>
</code></pre></div><ul><li>SysUserMapper.xml</li></ul> <div class="language-xml extra-class"><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">=</span><span class="token punctuation">"</span>getSysUserPageList<span class="token punctuation">"</span></span> <span class="token attr-name">resultType</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>io.geekidea.springbootplus.system.vo.SysUserQueryVo<span class="token punctuation">"</span></span><span class="token punctuation">></span></span>
select
<span class="token tag"><span class="token tag"><span class="token punctuation"><</span>include</span> <span class="token attr-name">refid</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span>Base_Column_List<span class="token punctuation">"</span></span><span class="token punctuation">/></span></span>
from sys_user
where deleted = 0
<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">=</span><span class="token punctuation">"</span>param.keyword != null and param.keyword != ''<span class="token punctuation">"</span></span><span class="token punctuation">></span></span>
and (
username like concat('%', #{param.keyword} ,'%') or
nickname like concat('%', #{param.keyword} ,'%')
)
<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">=</span><span class="token punctuation">"</span>param.username != null and param.username != ''<span class="token punctuation">"</span></span><span class="token punctuation">></span></span>
and username like concat('%', #{param.username} ,'%')
<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">=</span><span class="token punctuation">"</span>param.nickname != null and param.nickname != ''<span class="token punctuation">"</span></span><span class="token punctuation">></span></span>
and nickname like concat('%', #{param.nickname} ,'%')
<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">=</span><span class="token punctuation">"</span>param.state != null<span class="token punctuation">"</span></span><span class="token punctuation">></span></span>
and state = #{param.state}
<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">=</span><span class="token punctuation">"</span>param.createTimeStart != null<span class="token punctuation">"</span></span><span class="token punctuation">></span></span>
and date_format(create_time,'%Y-%m-%d') >= date_format(#{param.createTimeStart},'%Y-%m-%d')
<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">=</span><span class="token punctuation">"</span>param.createTimeEnd != null<span class="token punctuation">"</span></span><span class="token punctuation">></span></span>
and date_format(create_time,'%Y-%m-%d') <span class="token entity" title="<">&lt;</span>= date_format(#{param.createTimeEnd},'%Y-%m-%d')
<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>select</span><span class="token punctuation">></span></span>
</code></pre></div><ul><li>响应结果</li></ul> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
<span class="token property">"code"</span><span class="token operator">:</span> <span class="token number">200</span><span class="token punctuation">,</span>
<span class="token property">"msg"</span><span class="token operator">:</span> <span class="token string">"操作成功"</span><span class="token punctuation">,</span>
<span class="token property">"success"</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
<span class="token property">"data"</span><span class="token operator">:</span> <span class="token punctuation">{</span>
<span class="token property">"total"</span><span class="token operator">:</span> <span class="token string">"1"</span><span class="token punctuation">,</span>
<span class="token property">"records"</span><span class="token operator">:</span> <span class="token punctuation">[</span>
<span class="token punctuation">{</span>
<span class="token property">"id"</span><span class="token operator">:</span> <span class="token string">"1"</span><span class="token punctuation">,</span>
<span class="token property">"username"</span><span class="token operator">:</span> <span class="token string">"admin"</span><span class="token punctuation">,</span>
<span class="token property">"nickname"</span><span class="token operator">:</span> <span class="token string">"管理员"</span><span class="token punctuation">,</span>
<span class="token property">"phone"</span><span class="token operator">:</span> <span class="token string">"15888889900"</span><span class="token punctuation">,</span>
<span class="token property">"gender"</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
<span class="token property">"head"</span><span class="token operator">:</span> <span class="token string">"http://localhost:8888/api/resource/201908201013068.png"</span><span class="token punctuation">,</span>
<span class="token property">"remark"</span><span class="token operator">:</span> <span class="token string">"Administrator Account"</span><span class="token punctuation">,</span>
<span class="token property">"state"</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
<span class="token property">"departmentId"</span><span class="token operator">:</span> <span class="token string">"1"</span><span class="token punctuation">,</span>
<span class="token property">"roleId"</span><span class="token operator">:</span> <span class="token string">"1"</span><span class="token punctuation">,</span>
<span class="token property">"deleted"</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
<span class="token property">"version"</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
<span class="token property">"createTime"</span><span class="token operator">:</span> <span class="token string">"2020-02-26 00:00:00"</span><span class="token punctuation">,</span>
<span class="token property">"updateTime"</span><span class="token operator">:</span> <span class="token string">"2019-10-27 23:32:29"</span>
<span class="token punctuation">}</span>
<span class="token punctuation">]</span>
<span class="token punctuation">}</span><span class="token punctuation">,</span>
<span class="token property">"time"</span><span class="token operator">:</span> <span class="token string">"2020-03-01 21:43:49"</span>
<span class="token punctuation">}</span>
</code></pre></div><ul><li>SQL语句</li></ul> <div class="language-sql extra-class"><pre class="language-sql"><code><span class="token operator">=</span><span class="token operator">=</span><span class="token operator">></span> Preparing: <span class="token keyword">SELECT</span> <span class="token function">COUNT</span><span class="token punctuation">(</span><span class="token number">1</span><span class="token punctuation">)</span> <span class="token keyword">FROM</span> sys_user <span class="token keyword">WHERE</span> deleted <span class="token operator">=</span> <span class="token number">0</span> <span class="token operator">AND</span> username <span class="token operator">LIKE</span> concat<span class="token punctuation">(</span><span class="token string">'%'</span><span class="token punctuation">,</span> ?<span class="token punctuation">,</span> <span class="token string">'%'</span><span class="token punctuation">)</span> <span class="token operator">AND</span> state <span class="token operator">=</span> ? <span class="token operator">AND</span> date_format<span class="token punctuation">(</span>create_time<span class="token punctuation">,</span> <span class="token string">'%Y-%m-%d'</span><span class="token punctuation">)</span> <span class="token operator">>=</span> date_format<span class="token punctuation">(</span>?<span class="token punctuation">,</span> <span class="token string">'%Y-%m-%d'</span><span class="token punctuation">)</span> <span class="token operator">AND</span> date_format<span class="token punctuation">(</span>create_time<span class="token punctuation">,</span> <span class="token string">'%Y-%m-%d'</span><span class="token punctuation">)</span> <span class="token operator"><=</span> date_format<span class="token punctuation">(</span>?<span class="token punctuation">,</span> <span class="token string">'%Y-%m-%d'</span><span class="token punctuation">)</span>
<span class="token operator">=</span><span class="token operator">=</span><span class="token operator">></span> Parameters: adm<span class="token punctuation">(</span>String<span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">(</span><span class="token keyword">Integer</span><span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token number">2020</span><span class="token operator">-</span><span class="token number">02</span><span class="token operator">-</span><span class="token number">26</span> <span class="token number">00</span>:<span class="token number">00</span>:<span class="token number">00.0</span><span class="token punctuation">(</span><span class="token keyword">Timestamp</span><span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token number">2020</span><span class="token operator">-</span><span class="token number">02</span><span class="token operator">-</span><span class="token number">27</span> <span class="token number">00</span>:<span class="token number">00</span>:<span class="token number">00.0</span><span class="token punctuation">(</span><span class="token keyword">Timestamp</span><span class="token punctuation">)</span>
<span class="token operator"><=</span><span class="token operator">=</span> <span class="token keyword">Columns</span>: <span class="token function">COUNT</span><span class="token punctuation">(</span><span class="token number">1</span><span class="token punctuation">)</span>
<span class="token operator"><=</span><span class="token operator">=</span> <span class="token keyword">Row</span>: <span class="token number">1</span>
<span class="token operator">=</span><span class="token operator">=</span><span class="token operator">></span> Preparing: <span class="token keyword">SELECT</span> id<span class="token punctuation">,</span> username<span class="token punctuation">,</span> nickname<span class="token punctuation">,</span> phone<span class="token punctuation">,</span> gender<span class="token punctuation">,</span> head<span class="token punctuation">,</span> remark<span class="token punctuation">,</span> state<span class="token punctuation">,</span> department_id<span class="token punctuation">,</span> role_id<span class="token punctuation">,</span> deleted<span class="token punctuation">,</span> version<span class="token punctuation">,</span> create_time<span class="token punctuation">,</span> update_time <span class="token keyword">FROM</span> sys_user <span class="token keyword">WHERE</span> deleted <span class="token operator">=</span> <span class="token number">0</span> <span class="token operator">AND</span> username <span class="token operator">LIKE</span> concat<span class="token punctuation">(</span><span class="token string">'%'</span><span class="token punctuation">,</span> ?<span class="token punctuation">,</span> <span class="token string">'%'</span><span class="token punctuation">)</span> <span class="token operator">AND</span> state <span class="token operator">=</span> ? <span class="token operator">AND</span> date_format<span class="token punctuation">(</span>create_time<span class="token punctuation">,</span> <span class="token string">'%Y-%m-%d'</span><span class="token punctuation">)</span> <span class="token operator">>=</span> date_format<span class="token punctuation">(</span>?<span class="token punctuation">,</span> <span class="token string">'%Y-%m-%d'</span><span class="token punctuation">)</span> <span class="token operator">AND</span> date_format<span class="token punctuation">(</span>create_time<span class="token punctuation">,</span> <span class="token string">'%Y-%m-%d'</span><span class="token punctuation">)</span> <span class="token operator"><=</span> date_format<span class="token punctuation">(</span>?<span class="token punctuation">,</span> <span class="token string">'%Y-%m-%d'</span><span class="token punctuation">)</span> <span class="token keyword">ORDER</span> <span class="token keyword">BY</span> create_time <span class="token keyword">DESC</span> <span class="token keyword">LIMIT</span> ?<span class="token punctuation">,</span>?
<span class="token operator">=</span><span class="token operator">=</span><span class="token operator">></span> Parameters: adm<span class="token punctuation">(</span>String<span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">(</span><span class="token keyword">Integer</span><span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token number">2020</span><span class="token operator">-</span><span class="token number">02</span><span class="token operator">-</span><span class="token number">26</span> <span class="token number">00</span>:<span class="token number">00</span>:<span class="token number">00.0</span><span class="token punctuation">(</span><span class="token keyword">Timestamp</span><span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token number">2020</span><span class="token operator">-</span><span class="token number">02</span><span class="token operator">-</span><span class="token number">27</span> <span class="token number">00</span>:<span class="token number">00</span>:<span class="token number">00.0</span><span class="token punctuation">(</span><span class="token keyword">Timestamp</span><span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token number">0</span><span class="token punctuation">(</span>Long<span class="token punctuation">)</span><span class="token punctuation">,</span> <span class="token number">10</span><span class="token punctuation">(</span>Long<span class="token punctuation">)</span>
<span class="token operator"><=</span><span class="token operator">=</span> <span class="token keyword">Columns</span>: id<span class="token punctuation">,</span> username<span class="token punctuation">,</span> nickname<span class="token punctuation">,</span> phone<span class="token punctuation">,</span> gender<span class="token punctuation">,</span> head<span class="token punctuation">,</span> remark<span class="token punctuation">,</span> state<span class="token punctuation">,</span> department_id<span class="token punctuation">,</span> role_id<span class="token punctuation">,</span> deleted<span class="token punctuation">,</span> version<span class="token punctuation">,</span> create_time<span class="token punctuation">,</span> update_time
<span class="token operator"><=</span><span class="token operator">=</span> <span class="token keyword">Row</span>: <span class="token number">1</span><span class="token punctuation">,</span> admin<span class="token punctuation">,</span> 管理员<span class="token punctuation">,</span> <span class="token number">15888889900</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> http:<span class="token comment">//localhost:8888/api/resource/201908201013068.png, Administrator Account, 1, 1, 1, 0, 1, 2020-02-26 00:00:00.0, 2019-10-27 23:32:29.0</span>
<span class="token operator"><=</span><span class="token operator">=</span> Total: <span class="token number">1</span>
</code></pre></div><ul><li>重点查询条件语句</li></ul> <div class="language-sql extra-class"><pre class="language-sql"><code><span class="token keyword">where</span> deleted <span class="token operator">=</span> <span class="token number">0</span>
<span class="token operator">and</span> username <span class="token operator">like</span> concat<span class="token punctuation">(</span><span class="token string">'%'</span><span class="token punctuation">,</span> ? <span class="token punctuation">,</span><span class="token string">'%'</span><span class="token punctuation">)</span>
<span class="token operator">and</span> state <span class="token operator">=</span> ?
<span class="token operator">and</span> date_format<span class="token punctuation">(</span>create_time<span class="token punctuation">,</span><span class="token string">'%Y-%m-%d'</span><span class="token punctuation">)</span> <span class="token operator">>=</span> date_format<span class="token punctuation">(</span>?<span class="token punctuation">,</span><span class="token string">'%Y-%m-%d'</span><span class="token punctuation">)</span>
<span class="token operator">and</span> date_format<span class="token punctuation">(</span>create_time<span class="token punctuation">,</span><span class="token string">'%Y-%m-%d'</span><span class="token punctuation">)</span> <span class="token operator"><=</span> date_format<span class="token punctuation">(</span>?<span class="token punctuation">,</span><span class="token string">'%Y-%m-%d'</span><span class="token punctuation">)</span>
</code></pre></div><h3 id="如何使用排序"><a href="#如何使用排序" aria-hidden="true" class="header-anchor">#</a> 如何使用排序</h3> <blockquote><ul><li>asc:true 升序，asc:false 降序</li> <li>column：列名，目前时对应数据库列名称！！！
如需要前端传属性名称，后端获取对应的列名称，请看下面的方法！！！</li></ul></blockquote> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
<span class="token property">"orders"</span><span class="token operator">:</span> <span class="token punctuation">[</span>
<span class="token punctuation">{</span>
<span class="token property">"asc"</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
<span class="token property">"column"</span><span class="token operator">:</span> <span class="token string">"update_time"</span>
<span class="token punctuation">}</span>
<span class="token punctuation">]</span>
<span class="token punctuation">}</span>
</code></pre></div><h2 id="根据实体类中的属性名称，获取表对应的列名称"><a href="#根据实体类中的属性名称，获取表对应的列名称" aria-hidden="true" class="header-anchor">#</a> 根据实体类中的属性名称，获取表对应的列名称</h2> <blockquote><p>分页排序可使用这种方法，前端传属性名称，后端获取列名称</p></blockquote> <h4 id="baseserviceimpl-java-增加处理代码"><a href="#baseserviceimpl-java-增加处理代码" aria-hidden="true" class="header-anchor">#</a> BaseServiceImpl.java 增加处理代码</h4> <div class="language-java extra-class"><pre class="language-java"><code><span class="token comment">/**
* @author geekidea
* @date 2018-11-08
*/</span>
<span class="token keyword">public</span> <span class="token keyword">abstract</span> <span class="token keyword">class</span> <span class="token class-name">BaseServiceImpl</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">M</span> <span class="token keyword">extends</span> <span class="token class-name">BaseMapper</span><span class="token punctuation"><</span><span class="token class-name">T</span><span class="token punctuation">></span><span class="token punctuation">,</span> <span class="token class-name">T</span><span class="token punctuation">></span></span> <span class="token keyword">extends</span> <span class="token class-name">ServiceImpl</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">M</span><span class="token punctuation">,</span> <span class="token class-name">T</span><span class="token punctuation">></span></span> <span class="token keyword">implements</span> <span class="token class-name">BaseService</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">T</span><span class="token punctuation">></span></span> <span class="token punctuation">{</span>
<span class="token keyword">private</span> <span class="token class-name">Class</span><span class="token generics"><span class="token punctuation"><</span><span class="token operator">?</span><span class="token punctuation">></span></span> entityClass<span class="token punctuation">;</span>
<span class="token punctuation">{</span>
<span class="token class-name">Class</span><span class="token generics"><span class="token punctuation"><</span><span class="token operator">?</span><span class="token punctuation">></span></span> clazz <span class="token operator">=</span> <span class="token keyword">this</span><span class="token punctuation">.</span><span class="token function">getClass</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token class-name">Type</span> type <span class="token operator">=</span> clazz<span class="token punctuation">.</span><span class="token function">getGenericSuperclass</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token keyword">if</span> <span class="token punctuation">(</span>type <span class="token keyword">instanceof</span> <span class="token class-name">ParameterizedType</span><span class="token punctuation">)</span><span class="token punctuation">{</span>
<span class="token class-name">Type</span><span class="token punctuation">[</span><span class="token punctuation">]</span> p <span class="token operator">=</span> <span class="token punctuation">(</span><span class="token punctuation">(</span><span class="token class-name">ParameterizedType</span><span class="token punctuation">)</span> type<span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">getActualTypeArguments</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token comment">//取得所有泛型</span>
<span class="token keyword">this</span><span class="token punctuation">.</span>entityClass<span class="token operator">=</span> <span class="token punctuation">(</span><span class="token class-name">Class</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">T</span><span class="token punctuation">></span></span><span class="token punctuation">)</span> p<span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">]</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token punctuation">}</span>
<span class="token keyword">protected</span> <span class="token class-name">Page</span> <span class="token function">setPageParam</span><span class="token punctuation">(</span><span class="token class-name">QueryParam</span> queryParam<span class="token punctuation">)</span> <span class="token punctuation">{</span>
<span class="token keyword">return</span> <span class="token function">setPageParam</span><span class="token punctuation">(</span>queryParam<span class="token punctuation">,</span><span class="token keyword">null</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token keyword">protected</span> <span class="token class-name">Page</span> <span class="token function">setPageParam</span><span class="token punctuation">(</span><span class="token class-name">QueryParam</span> queryParam<span class="token punctuation">,</span> <span class="token class-name">OrderItem</span> defaultOrder<span class="token punctuation">)</span> <span class="token punctuation">{</span>
<span class="token class-name">Page</span> page <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">Page</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token comment">// 设置当前页码</span>
page<span class="token punctuation">.</span><span class="token function">setCurrent</span><span class="token punctuation">(</span>queryParam<span class="token punctuation">.</span><span class="token function">getCurrent</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token comment">// 设置页大小</span>
page<span class="token punctuation">.</span><span class="token function">setSize</span><span class="token punctuation">(</span>queryParam<span class="token punctuation">.</span><span class="token function">getSize</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token comment">/**
* 如果是queryParam是OrderQueryParam，并且不为空，则使用前端排序
* 否则使用默认排序
*/</span>
<span class="token keyword">if</span> <span class="token punctuation">(</span>queryParam <span class="token keyword">instanceof</span> <span class="token class-name">OrderQueryParam</span><span class="token punctuation">)</span><span class="token punctuation">{</span>
<span class="token class-name">OrderQueryParam</span> orderQueryParam <span class="token operator">=</span> <span class="token punctuation">(</span><span class="token class-name">OrderQueryParam</span><span class="token punctuation">)</span> queryParam<span class="token punctuation">;</span>
<span class="token class-name">List</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">OrderItem</span><span class="token punctuation">></span></span> orderItems <span class="token operator">=</span> orderQueryParam<span class="token punctuation">.</span><span class="token function">getOrders</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token keyword">if</span> <span class="token punctuation">(</span><span class="token class-name">CollectionUtils</span><span class="token punctuation">.</span><span class="token function">isEmpty</span><span class="token punctuation">(</span>orderItems<span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">{</span>
page<span class="token punctuation">.</span><span class="token function">setOrders</span><span class="token punctuation">(</span><span class="token class-name">Arrays</span><span class="token punctuation">.</span><span class="token function">asList</span><span class="token punctuation">(</span>defaultOrder<span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span><span class="token keyword">else</span><span class="token punctuation">{</span>
<span class="token function">convertOrderItem</span><span class="token punctuation">(</span>orderItems<span class="token punctuation">)</span><span class="token punctuation">;</span>
page<span class="token punctuation">.</span><span class="token function">setOrders</span><span class="token punctuation">(</span>orderItems<span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token punctuation">}</span><span class="token keyword">else</span><span class="token punctuation">{</span>
page<span class="token punctuation">.</span><span class="token function">setOrders</span><span class="token punctuation">(</span><span class="token class-name">Arrays</span><span class="token punctuation">.</span><span class="token function">asList</span><span class="token punctuation">(</span>defaultOrder<span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token keyword">return</span> page<span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token keyword">protected</span> <span class="token keyword">void</span> <span class="token function">convertOrderItem</span><span class="token punctuation">(</span><span class="token class-name">List</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">OrderItem</span><span class="token punctuation">></span></span> orderItems<span class="token punctuation">)</span><span class="token punctuation">{</span>
<span class="token keyword">if</span> <span class="token punctuation">(</span><span class="token class-name">CollectionUtils</span><span class="token punctuation">.</span><span class="token function">isEmpty</span><span class="token punctuation">(</span>orderItems<span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">{</span>
<span class="token keyword">return</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
orderItems<span class="token punctuation">.</span><span class="token function">forEach</span><span class="token punctuation">(</span>orderItem <span class="token operator">-></span> <span class="token punctuation">{</span>
<span class="token class-name">String</span> column <span class="token operator">=</span> orderItem<span class="token punctuation">.</span><span class="token function">getColumn</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
orderItem<span class="token punctuation">.</span><span class="token function">setColumn</span><span class="token punctuation">(</span><span class="token class-name">PropertyColumnUtil</span><span class="token punctuation">.</span><span class="token function">getColumn</span><span class="token punctuation">(</span>entityClass<span class="token punctuation">,</span>column<span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token punctuation">}</span>
</code></pre></div><ul><li>重点代码</li></ul> <blockquote><p>获取实体类泛型类型</p></blockquote> <div class="language-java extra-class"><pre class="language-java"><code>
<span class="token keyword">private</span> <span class="token class-name">Class</span><span class="token generics"><span class="token punctuation"><</span><span class="token operator">?</span><span class="token punctuation">></span></span> entityClass<span class="token punctuation">;</span>
<span class="token punctuation">{</span>
<span class="token class-name">Class</span><span class="token generics"><span class="token punctuation"><</span><span class="token operator">?</span><span class="token punctuation">></span></span> clazz <span class="token operator">=</span> <span class="token keyword">this</span><span class="token punctuation">.</span><span class="token function">getClass</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token class-name">Type</span> type <span class="token operator">=</span> clazz<span class="token punctuation">.</span><span class="token function">getGenericSuperclass</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token keyword">if</span> <span class="token punctuation">(</span>type <span class="token keyword">instanceof</span> <span class="token class-name">ParameterizedType</span><span class="token punctuation">)</span><span class="token punctuation">{</span>
<span class="token class-name">Type</span><span class="token punctuation">[</span><span class="token punctuation">]</span> p <span class="token operator">=</span> <span class="token punctuation">(</span><span class="token punctuation">(</span><span class="token class-name">ParameterizedType</span><span class="token punctuation">)</span> type<span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">getActualTypeArguments</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token comment">//取得所有泛型</span>
<span class="token keyword">this</span><span class="token punctuation">.</span>entityClass<span class="token operator">=</span> <span class="token punctuation">(</span><span class="token class-name">Class</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">T</span><span class="token punctuation">></span></span><span class="token punctuation">)</span> p<span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">]</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token punctuation">}</span>
</code></pre></div><ul><li>将属性名称转换成列名称</li></ul> <div class="language-java extra-class"><pre class="language-java"><code> <span class="token keyword">protected</span> <span class="token keyword">void</span> <span class="token function">convertOrderItem</span><span class="token punctuation">(</span><span class="token class-name">List</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">OrderItem</span><span class="token punctuation">></span></span> orderItems<span class="token punctuation">)</span><span class="token punctuation">{</span>
<span class="token keyword">if</span> <span class="token punctuation">(</span><span class="token class-name">CollectionUtils</span><span class="token punctuation">.</span><span class="token function">isEmpty</span><span class="token punctuation">(</span>orderItems<span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">{</span>
<span class="token keyword">return</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
orderItems<span class="token punctuation">.</span><span class="token function">forEach</span><span class="token punctuation">(</span>orderItem <span class="token operator">-></span> <span class="token punctuation">{</span>
<span class="token class-name">String</span> column <span class="token operator">=</span> orderItem<span class="token punctuation">.</span><span class="token function">getColumn</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
orderItem<span class="token punctuation">.</span><span class="token function">setColumn</span><span class="token punctuation">(</span><span class="token class-name">PropertyColumnUtil</span><span class="token punctuation">.</span><span class="token function">getColumn</span><span class="token punctuation">(</span>entityClass<span class="token punctuation">,</span>column<span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
</code></pre></div><h4 id="新增属性列名获取工具类"><a href="#新增属性列名获取工具类" aria-hidden="true" class="header-anchor">#</a> 新增属性列名获取工具类</h4> <div class="language-java extra-class"><pre class="language-java"><code>
<span class="token keyword">package</span> <span class="token namespace">io<span class="token punctuation">.</span>geekidea<span class="token punctuation">.</span>springbootplus<span class="token punctuation">.</span>util</span><span class="token punctuation">;</span>
<span class="token keyword">import</span> <span class="token namespace">com<span class="token punctuation">.</span>baomidou<span class="token punctuation">.</span>mybatisplus<span class="token punctuation">.</span>core<span class="token punctuation">.</span>metadata</span><span class="token punctuation">.</span><span class="token class-name">TableFieldInfo</span><span class="token punctuation">;</span>
<span class="token keyword">import</span> <span class="token namespace">com<span class="token punctuation">.</span>baomidou<span class="token punctuation">.</span>mybatisplus<span class="token punctuation">.</span>core<span class="token punctuation">.</span>metadata</span><span class="token punctuation">.</span><span class="token class-name">TableInfo</span><span class="token punctuation">;</span>
<span class="token keyword">import</span> <span class="token namespace">com<span class="token punctuation">.</span>baomidou<span class="token punctuation">.</span>mybatisplus<span class="token punctuation">.</span>core<span class="token punctuation">.</span>metadata</span><span class="token punctuation">.</span><span class="token class-name">TableInfoHelper</span><span class="token punctuation">;</span>
<span class="token keyword">import</span> <span class="token namespace">org<span class="token punctuation">.</span>apache<span class="token punctuation">.</span>commons<span class="token punctuation">.</span>collections4</span><span class="token punctuation">.</span><span class="token class-name">CollectionUtils</span><span class="token punctuation">;</span>
<span class="token keyword">import</span> <span class="token namespace">org<span class="token punctuation">.</span>apache<span class="token punctuation">.</span>commons<span class="token punctuation">.</span>collections4</span><span class="token punctuation">.</span><span class="token class-name">MapUtils</span><span class="token punctuation">;</span>
<span class="token keyword">import</span> <span class="token namespace">org<span class="token punctuation">.</span>apache<span class="token punctuation">.</span>commons<span class="token punctuation">.</span>lang3</span><span class="token punctuation">.</span><span class="token class-name">StringUtils</span><span class="token punctuation">;</span>
<span class="token keyword">import</span> <span class="token namespace">java<span class="token punctuation">.</span>util</span><span class="token punctuation">.</span><span class="token class-name">List</span><span class="token punctuation">;</span>
<span class="token keyword">import</span> <span class="token namespace">java<span class="token punctuation">.</span>util</span><span class="token punctuation">.</span><span class="token class-name">Map</span><span class="token punctuation">;</span>
<span class="token keyword">import</span> <span class="token namespace">java<span class="token punctuation">.</span>util<span class="token punctuation">.</span>concurrent</span><span class="token punctuation">.</span><span class="token class-name">ConcurrentHashMap</span><span class="token punctuation">;</span>
<span class="token keyword">import</span> <span class="token namespace">java<span class="token punctuation">.</span>util<span class="token punctuation">.</span>stream</span><span class="token punctuation">.</span><span class="token class-name">Collectors</span><span class="token punctuation">;</span>
<span class="token comment">/**
* @author geekidea
* @date 2020/3/2
**/</span>
<span class="token keyword">public</span> <span class="token keyword">class</span> <span class="token class-name">PropertyColumnUtil</span> <span class="token punctuation">{</span>
<span class="token keyword">private</span> <span class="token keyword">static</span> <span class="token class-name">Map</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">Class</span><span class="token punctuation"><</span><span class="token operator">?</span><span class="token punctuation">></span><span class="token punctuation">,</span> <span class="token class-name">Map</span><span class="token punctuation"><</span><span class="token class-name">String</span><span class="token punctuation">,</span> <span class="token class-name">String</span><span class="token punctuation">></span><span class="token punctuation">></span></span> cacheMap <span class="token operator">=</span> <span class="token keyword">new</span> <span class="token class-name">ConcurrentHashMap</span><span class="token generics"><span class="token punctuation"><</span><span class="token punctuation">></span></span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token keyword">public</span> <span class="token keyword">static</span> <span class="token class-name">Map</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">Class</span><span class="token punctuation"><</span><span class="token operator">?</span><span class="token punctuation">></span><span class="token punctuation">,</span> <span class="token class-name">Map</span><span class="token punctuation"><</span><span class="token class-name">String</span><span class="token punctuation">,</span> <span class="token class-name">String</span><span class="token punctuation">></span><span class="token punctuation">></span></span> <span class="token function">getMap</span><span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
<span class="token keyword">return</span> cacheMap<span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token comment">/**
* 根据实体class，从mybatisplus中获取对应Table的属性列名Map
*
* @param clazz
* @return
*/</span>
<span class="token keyword">private</span> <span class="token keyword">static</span> <span class="token class-name">Map</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">String</span><span class="token punctuation">,</span> <span class="token class-name">String</span><span class="token punctuation">></span></span> <span class="token function">getTableFieldMap</span><span class="token punctuation">(</span><span class="token class-name">Class</span><span class="token generics"><span class="token punctuation"><</span><span class="token operator">?</span><span class="token punctuation">></span></span> clazz<span class="token punctuation">)</span> <span class="token punctuation">{</span>
<span class="token class-name">TableInfo</span> tableInfo <span class="token operator">=</span> <span class="token class-name">TableInfoHelper</span><span class="token punctuation">.</span><span class="token function">getTableInfo</span><span class="token punctuation">(</span>clazz<span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token keyword">if</span> <span class="token punctuation">(</span>tableInfo <span class="token operator">==</span> <span class="token keyword">null</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
<span class="token keyword">return</span> <span class="token keyword">null</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token class-name">List</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">TableFieldInfo</span><span class="token punctuation">></span></span> tableFieldInfos <span class="token operator">=</span> tableInfo<span class="token punctuation">.</span><span class="token function">getFieldList</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token keyword">if</span> <span class="token punctuation">(</span><span class="token class-name">CollectionUtils</span><span class="token punctuation">.</span><span class="token function">isEmpty</span><span class="token punctuation">(</span>tableFieldInfos<span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
<span class="token keyword">return</span> <span class="token keyword">null</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token class-name">Map</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">String</span><span class="token punctuation">,</span> <span class="token class-name">String</span><span class="token punctuation">></span></span> cacheMap <span class="token operator">=</span> tableFieldInfos<span class="token punctuation">.</span><span class="token function">stream</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">.</span><span class="token function">collect</span><span class="token punctuation">(</span><span class="token class-name">Collectors</span><span class="token punctuation">.</span><span class="token function">toMap</span><span class="token punctuation">(</span><span class="token class-name">TableFieldInfo</span><span class="token operator">:</span><span class="token operator">:</span><span class="token function">getProperty</span><span class="token punctuation">,</span> <span class="token class-name">TableFieldInfo</span><span class="token operator">:</span><span class="token operator">:</span><span class="token function">getColumn</span><span class="token punctuation">)</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token keyword">return</span> cacheMap<span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token comment">/**
* 从本地缓存中获取属性列名map
*
* @param clazz
* @return
*/</span>
<span class="token keyword">public</span> <span class="token keyword">static</span> <span class="token class-name">Map</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">String</span><span class="token punctuation">,</span> <span class="token class-name">String</span><span class="token punctuation">></span></span> <span class="token function">getPropertyColumnMap</span><span class="token punctuation">(</span><span class="token class-name">Class</span><span class="token generics"><span class="token punctuation"><</span><span class="token operator">?</span><span class="token punctuation">></span></span> clazz<span class="token punctuation">)</span> <span class="token punctuation">{</span>
<span class="token class-name">Map</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">String</span><span class="token punctuation">,</span> <span class="token class-name">String</span><span class="token punctuation">></span></span> propertyColumnMap <span class="token operator">=</span> cacheMap<span class="token punctuation">.</span><span class="token function">get</span><span class="token punctuation">(</span>clazz<span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token keyword">if</span> <span class="token punctuation">(</span><span class="token class-name">MapUtils</span><span class="token punctuation">.</span><span class="token function">isEmpty</span><span class="token punctuation">(</span>propertyColumnMap<span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
<span class="token comment">// 从TableInfo中获取，并缓存到内存map中</span>
<span class="token class-name">Map</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">String</span><span class="token punctuation">,</span> <span class="token class-name">String</span><span class="token punctuation">></span></span> fieldMap <span class="token operator">=</span> <span class="token function">getTableFieldMap</span><span class="token punctuation">(</span>clazz<span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token keyword">if</span> <span class="token punctuation">(</span><span class="token class-name">MapUtils</span><span class="token punctuation">.</span><span class="token function">isEmpty</span><span class="token punctuation">(</span>fieldMap<span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
<span class="token keyword">return</span> <span class="token keyword">null</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span> <span class="token keyword">else</span> <span class="token punctuation">{</span>
cacheMap<span class="token punctuation">.</span><span class="token function">put</span><span class="token punctuation">(</span>clazz<span class="token punctuation">,</span> fieldMap<span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token keyword">return</span> fieldMap<span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token punctuation">}</span> <span class="token keyword">else</span> <span class="token punctuation">{</span>
<span class="token keyword">return</span> propertyColumnMap<span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token punctuation">}</span>
<span class="token comment">/**
* 通过实体class类型和属性名称，从缓存中获取对应的列名
*
* @param clazz
* @param property
* @return
*/</span>
<span class="token keyword">public</span> <span class="token keyword">static</span> <span class="token class-name">String</span> <span class="token function">getColumn</span><span class="token punctuation">(</span><span class="token class-name">Class</span><span class="token generics"><span class="token punctuation"><</span><span class="token operator">?</span><span class="token punctuation">></span></span> clazz<span class="token punctuation">,</span> <span class="token class-name">String</span> property<span class="token punctuation">)</span> <span class="token punctuation">{</span>
<span class="token class-name">Map</span><span class="token generics"><span class="token punctuation"><</span><span class="token class-name">String</span><span class="token punctuation">,</span> <span class="token class-name">String</span><span class="token punctuation">></span></span> propertyColumnMap <span class="token operator">=</span> <span class="token function">getPropertyColumnMap</span><span class="token punctuation">(</span>clazz<span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token keyword">if</span> <span class="token punctuation">(</span><span class="token class-name">MapUtils</span><span class="token punctuation">.</span><span class="token function">isEmpty</span><span class="token punctuation">(</span>propertyColumnMap<span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
<span class="token keyword">throw</span> <span class="token keyword">new</span> <span class="token class-name">IllegalArgumentException</span><span class="token punctuation">(</span><span class="token string">"没有找到对应的实体映射对象"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token class-name">String</span> column <span class="token operator">=</span> propertyColumnMap<span class="token punctuation">.</span><span class="token function">get</span><span class="token punctuation">(</span>property<span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token keyword">if</span> <span class="token punctuation">(</span><span class="token class-name">StringUtils</span><span class="token punctuation">.</span><span class="token function">isEmpty</span><span class="token punctuation">(</span>column<span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
<span class="token keyword">throw</span> <span class="token keyword">new</span> <span class="token class-name">IllegalArgumentException</span><span class="token punctuation">(</span><span class="token string">"没有找到对应的列"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token keyword">return</span> column<span class="token punctuation">;</span>
<span class="token punctuation">}</span>
<span class="token punctuation">}</span>
</code></pre></div><h4 id="前端排序参数"><a href="#前端排序参数" aria-hidden="true" class="header-anchor">#</a> 前端排序参数</h4> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
<span class="token property">"orders"</span><span class="token operator">:</span> <span class="token punctuation">[</span>
<span class="token punctuation">{</span>
<span class="token property">"asc"</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
<span class="token property">"column"</span><span class="token operator">:</span> <span class="token string">"updateTime"</span>
<span class="token punctuation">}</span>
<span class="token punctuation">]</span>
<span class="token punctuation">}</span>
</code></pre></div><h4 id="后台转换后"><a href="#后台转换后" aria-hidden="true" class="header-anchor">#</a> 后台转换后</h4> <div class="language-text extra-class"><pre class="language-text"><code>OrderItem(column=update_time, asc=true)
</code></pre></div><div class="language-text extra-class"><pre class="language-text"><code>ORDER BY update_time LIMIT ?,?
</code></pre></div><h2 id="other问题"><a href="#other问题" aria-hidden="true" class="header-anchor">#</a> Other问题</h2></div> <footer class="page-edit"><div class="edit-link"><a href="https://github.com/geekidea/spring-boot-plus-doc/edit/master/guide/faq.md" target="_blank" rel="noopener noreferrer">在 GitHub 上编辑此页</a> <svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" 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></div> <!----></footer> <div class="page-nav"><p class="inner"><span class="prev">
←
<a href="/guide/xss.html" class="prev">XSS跨站脚本攻击处理</a></span> <span class="next"><a href="/guide/idea-spring-boot-plus.html">IDEA导入spring-boot-plus</a>→
</span></p></div> </main></div><div class="global-ui"></div></div>
<script src="/assets/js/app.db17a95a.js" defer></script><script src="/assets/js/2.6d1275ea.js" defer></script><script src="/assets/js/43.5b34dcc0.js" defer></script>
</body>
</html>