Skip to content

存储100亿密码rockyou2024

本文将介绍如何使用Mysql技术存储100亿密码。

1. 准备工作rockyou2024.txt

https://github.com/hkphh/rockyou2024.txt

2.文件拆分

shell
split -b 100m rockyou2024.txt pass.sp.

文件太大按照大小拆分的。

建议按照行拆分,按照大小拆分效果不好,文件末位那个密码可能会丢。

100m差不多500w-1000w个密码。

拆分后统计文件数量

shell
ls | grep "pass*" | wc -l
shell
1488

3. 创建数据库表

数据表

sql
CREATE TABLE pass_dict_${num}
        (
            c_pass VARCHAR(300) NOT NULL COMMENT '密码'
                COMMENT '密码表'
        )
            charset = utf8mb4

元数据存储

sql
create table pass_dict_meta
(
    i_id         int          not null auto_increment comment '主键',
    c_file_name  varchar(100) not null comment '文件名',
    c_table_name varchar(100) not null comment '表名',
    c_table_num varchar(100) not null comment '表名',
    i_file_size  int          not null comment '文件大小',
    i_file_line  int          not null comment '文件行数',
    primary key (i_id),
    index idx_pass_dict_meta (c_file_name)
        comment '密码表元数据'
) engine = innodb
  default charset = utf8mb4
  row_format = compressed;

4. 解析清理批量导入数据

java
                try {
                    passwordList = Files.readAllLines(Paths.get(filePath), StandardCharsets.UTF_8);
                    passwordList = passwordList.stream()
                            .filter(Objects::nonNull).map(String::trim)
                            .filter(s -> !s.isEmpty())
                            .filter(s -> s.length() < 100)
                            .collect(Collectors.toList());
                    List<List<String>> pageList = PageUtils.page(passwordList, batchSize);
                    for (List<String> page : pageList) {
                        passwordMapper.insert(String.valueOf(i), page);
                        log.info("num:{} page:{}", i, page.size());
                    }
                    //插入元数据
                    PassMeta item = new PassMeta();
                    item.setCfilename(fileName);
                    item.setCtablename("pass_dict_" + i);
                    item.setCtablenum(String.valueOf(i));
                    item.setIfileline(passwordList.size());
                    item.setIfilesize((int) new File(filePath).length());
                    passwordMapper.deleteMeta(item);
                    passwordMapper.insertMeta(item);
                } catch (IOException e) {
                    log.error("读取文件失败:{}", e.getMessage());
                }

5.数据质量评价

1.数据质量很差,乱码数据有不少。

2.很多密码都是乱码级别,没有价值

3.数据前面,密码长度过长的太多,增加过滤条件 length < 20 之后数据大批量基本就没了

4.导入到700个的时候我的硬盘不够用了,这时候公共导入了小于20位的密码数量是

text
38.80788031 亿

5.一些基本的统计信息如下

i_idc_file_namec_table_namec_table_numi_file_sizei_file_line
2pass.sp.aapass_dict_001048576005255807
3pass.sp.abpass_dict_111048576005365983
16pass.sp.adpass_dict_33104857600403234
17pass.sp.aepass_dict_4410485760019
18pass.sp.afpass_dict_5510485760014
19pass.sp.agpass_dict_6610485760017
20pass.sp.ahpass_dict_7710485760018
21pass.sp.aipass_dict_8810485760014
22pass.sp.ajpass_dict_9910485760013
23pass.sp.akpass_dict_101010485760023
24pass.sp.alpass_dict_111110485760018
25pass.sp.ampass_dict_121210485760019
26pass.sp.anpass_dict_131310485760012
27pass.sp.aopass_dict_141410485760021
28pass.sp.appass_dict_151510485760059
29pass.sp.aqpass_dict_161610485760039
30pass.sp.arpass_dict_171710485760028
31pass.sp.aspass_dict_181810485760029
32pass.sp.atpass_dict_191910485760029
33pass.sp.aupass_dict_202010485760024
34pass.sp.avpass_dict_212110485760024
35pass.sp.awpass_dict_222210485760023
36pass.sp.axpass_dict_232310485760018
37pass.sp.aypass_dict_242410485760018
38pass.sp.azpass_dict_252510485760018
39pass.sp.bapass_dict_262610485760012
40pass.sp.bbpass_dict_272710485760026
41pass.sp.bcpass_dict_282810485760019
42pass.sp.bdpass_dict_292910485760018
43pass.sp.bepass_dict_303010485760021
44pass.sp.bfpass_dict_313110485760016
45pass.sp.bgpass_dict_32321048576007
46pass.sp.bhpass_dict_333310485760016
47pass.sp.bipass_dict_343410485760045
48pass.sp.bjpass_dict_353510485760039
49pass.sp.bkpass_dict_363610485760051
50pass.sp.blpass_dict_373710485760052
51pass.sp.bmpass_dict_383810485760042
52pass.sp.bnpass_dict_393910485760042
53pass.sp.bopass_dict_404010485760037
54pass.sp.bppass_dict_414110485760056
55pass.sp.bqpass_dict_424210485760050
56pass.sp.brpass_dict_434310485760052
57pass.sp.bspass_dict_444410485760051
58pass.sp.btpass_dict_454510485760035
59pass.sp.bupass_dict_4646104857600113
60pass.sp.bvpass_dict_474710485760040
61pass.sp.bwpass_dict_484810485760040
62pass.sp.bxpass_dict_494910485760032
63pass.sp.bypass_dict_505010485760028
64pass.sp.bzpass_dict_515110485760033
65pass.sp.capass_dict_525210485760033
66pass.sp.cbpass_dict_535310485760024
67pass.sp.ccpass_dict_545410485760023
68pass.sp.cdpass_dict_555510485760025
69pass.sp.cepass_dict_565610485760024
70pass.sp.cfpass_dict_575710485760029
71pass.sp.cgpass_dict_585810485760029
72pass.sp.chpass_dict_595910485760047
73pass.sp.cipass_dict_606010485760034
74pass.sp.cjpass_dict_616110485760033
75pass.sp.ckpass_dict_626210485760018
76pass.sp.clpass_dict_636310485760025
77pass.sp.cmpass_dict_646410485760026
78pass.sp.cnpass_dict_656510485760034
79pass.sp.copass_dict_666610485760033
80pass.sp.cppass_dict_676710485760032
81pass.sp.cqpass_dict_686810485760048
82pass.sp.crpass_dict_696910485760025
83pass.sp.cspass_dict_707010485760032
84pass.sp.ctpass_dict_717110485760027
85pass.sp.cupass_dict_727210485760030
86pass.sp.cvpass_dict_737310485760037
87pass.sp.cwpass_dict_747410485760026
88pass.sp.cxpass_dict_757510485760027
89pass.sp.cypass_dict_767610485760033
90pass.sp.czpass_dict_777710485760020
91pass.sp.dapass_dict_787810485760031
92pass.sp.dbpass_dict_797910485760028
93pass.sp.dcpass_dict_808010485760034
94pass.sp.ddpass_dict_818110485760022
95pass.sp.depass_dict_8282104857600115
96pass.sp.dfpass_dict_838310485760043
97pass.sp.dgpass_dict_84841048576005962
98pass.sp.dhpass_dict_858510485760097
99pass.sp.dipass_dict_8686104857600467
100pass.sp.djpass_dict_8787104857600351
101pass.sp.dkpass_dict_8888104857600374
102pass.sp.dlpass_dict_89891048576001498904
103pass.sp.dmpass_dict_90901048576001053617
104pass.sp.dnpass_dict_91911048576005299
105pass.sp.dopass_dict_92921048576005092
106pass.sp.dppass_dict_9393104857600184581
107pass.sp.dqpass_dict_9494104857600468881
108pass.sp.drpass_dict_95951048576006108521
109pass.sp.dspass_dict_96961048576008810142
110pass.sp.dtpass_dict_97971048576008808034
111pass.sp.dupass_dict_98981048576007262502
112pass.sp.dvpass_dict_99991048576008284883
113pass.sp.dwpass_dict_1001001048576008785372
114pass.sp.dxpass_dict_1011011048576008142635
115pass.sp.dypass_dict_1021021048576005271093
116pass.sp.dzpass_dict_1031031048576004156567
117pass.sp.eapass_dict_1041041048576005616139
118pass.sp.ebpass_dict_1051051048576006692817
119pass.sp.ecpass_dict_1061061048576006695932
120pass.sp.edpass_dict_1071071048576004023015
121pass.sp.eepass_dict_1081081048576006655581
122pass.sp.efpass_dict_1091091048576005803607
123pass.sp.egpass_dict_1101101048576003763111
124pass.sp.ehpass_dict_1111111048576007277639
125pass.sp.eipass_dict_1121121048576005338003
126pass.sp.ejpass_dict_1131131048576003703031
127pass.sp.ekpass_dict_1141141048576006192012
128pass.sp.elpass_dict_1151151048576004027928
130pass.sp.empass_dict_1161161048576005318800
131pass.sp.enpass_dict_1171171048576006276625
132pass.sp.eopass_dict_1181181048576003583039
133pass.sp.eppass_dict_1191191048576007322325
134pass.sp.eqpass_dict_1201201048576008756054
135pass.sp.erpass_dict_1211211048576009184587
136pass.sp.espass_dict_1221221048576008971913
137pass.sp.etpass_dict_1231231048576008948389
138pass.sp.eupass_dict_1241241048576008966410
139pass.sp.evpass_dict_1251251048576009221779
140pass.sp.ewpass_dict_1261261048576008953273
141pass.sp.expass_dict_1271271048576008241948
142pass.sp.eypass_dict_1281281048576008944836
143pass.sp.ezpass_dict_1291291048576009217862
144pass.sp.fapass_dict_1301301048576008968022
145pass.sp.fbpass_dict_1311311048576004672967
146pass.sp.fcpass_dict_1321321048576005936090
147pass.sp.fdpass_dict_1331331048576006946285
148pass.sp.fepass_dict_1341341048576008702287
149pass.sp.ffpass_dict_1351351048576008701983
150pass.sp.fgpass_dict_1361361048576008702950
151pass.sp.fhpass_dict_1371371048576008717792
152pass.sp.fipass_dict_1381381048576008702880
153pass.sp.fjpass_dict_1391391048576008703417
154pass.sp.fkpass_dict_1401401048576008702351
155pass.sp.flpass_dict_1411411048576008702544
156pass.sp.fmpass_dict_1421421048576008701007
157pass.sp.fnpass_dict_1431431048576008702799
158pass.sp.fopass_dict_1441441048576008718637
159pass.sp.fppass_dict_1451451048576003252084
161pass.sp.fqpass_dict_1461461048576006036550
162pass.sp.frpass_dict_1471471048576005509184
163pass.sp.fspass_dict_1481481048576003851571
164pass.sp.ftpass_dict_1491491048576005939160
165pass.sp.fupass_dict_1501501048576005604486
166pass.sp.fvpass_dict_1511511048576003326069
167pass.sp.fwpass_dict_1521521048576004517783
168pass.sp.fxpass_dict_153153104857600531276
169pass.sp.fypass_dict_154154104857600351845
170pass.sp.fzpass_dict_155155104857600544314
171pass.sp.gapass_dict_156156104857600479351
172pass.sp.gbpass_dict_157157104857600502154
173pass.sp.gcpass_dict_158158104857600455146
174pass.sp.gdpass_dict_159159104857600303076
175pass.sp.gepass_dict_1601601048576007647902
176pass.sp.gfpass_dict_16116110485760042972
177pass.sp.ggpass_dict_16216210485760031340
178pass.sp.ghpass_dict_16316310485760027955
179pass.sp.gipass_dict_1641641048576006097
180pass.sp.gjpass_dict_1651651048576007157617
181pass.sp.gkpass_dict_1661661048576006617321
182pass.sp.glpass_dict_1671671048576006207043
183pass.sp.gmpass_dict_1681681048576003712266
184pass.sp.gnpass_dict_1691691048576007563848
185pass.sp.gopass_dict_1701701048576006658614
186pass.sp.gppass_dict_1711711048576006550871
187pass.sp.gqpass_dict_1721721048576003979156
188pass.sp.grpass_dict_1731731048576007324746
189pass.sp.gspass_dict_1741741048576007526204
190pass.sp.gtpass_dict_1751751048576007066676
191pass.sp.gupass_dict_1761761048576005965055
192pass.sp.gvpass_dict_1771771048576005109113
193pass.sp.gwpass_dict_1781781048576006657951
194pass.sp.gxpass_dict_1791791048576006741235
195pass.sp.gypass_dict_1801801048576006717773
196pass.sp.gzpass_dict_1811811048576004414124
197pass.sp.hapass_dict_1821821048576006364676
198pass.sp.hbpass_dict_1831831048576006152540
199pass.sp.hcpass_dict_1841841048576003935681
200pass.sp.hdpass_dict_1851851048576006701109
201pass.sp.hepass_dict_1861861048576006138410
202pass.sp.hfpass_dict_1871871048576005317567
203pass.sp.hgpass_dict_1881881048576005336192
204pass.sp.hhpass_dict_1891891048576005764572
205pass.sp.hipass_dict_1901901048576005600082
206pass.sp.hjpass_dict_1911911048576004048486
207pass.sp.hkpass_dict_1921921048576005951047
208pass.sp.hlpass_dict_1931931048576005727426
209pass.sp.hmpass_dict_1941941048576003747126
210pass.sp.hnpass_dict_1951951048576006338946
211pass.sp.hopass_dict_1961961048576005853985
212pass.sp.hppass_dict_1971971048576004115918
213pass.sp.hqpass_dict_1981981048576006277510
214pass.sp.hrpass_dict_1991991048576006674263
215pass.sp.hspass_dict_2002001048576007557569
216pass.sp.htpass_dict_2012011048576007805765
217pass.sp.hupass_dict_2022021048576007858991
218pass.sp.hvpass_dict_2032031048576006022569
219pass.sp.hwpass_dict_2042041048576005578118
220pass.sp.hxpass_dict_2052051048576003038906
221pass.sp.hypass_dict_2062061048576001976321
222pass.sp.hzpass_dict_207207104857600603115
223pass.sp.iapass_dict_2082081048576001028714
224pass.sp.ibpass_dict_2092091048576001000517
225pass.sp.icpass_dict_2102101048576001169910
226pass.sp.idpass_dict_211211104857600482487
227pass.sp.iepass_dict_2122121048576001240672
228pass.sp.ifpass_dict_2132131048576005823747
229pass.sp.igpass_dict_2142141048576009409925
230pass.sp.ihpass_dict_2152151048576008338827
231pass.sp.iipass_dict_2162161048576007574945
232pass.sp.ijpass_dict_2172171048576006416263
233pass.sp.ikpass_dict_2182181048576005734756
234pass.sp.ilpass_dict_2192191048576004133989
235pass.sp.impass_dict_2202201048576006651947
236pass.sp.inpass_dict_2212211048576005778309
237pass.sp.iopass_dict_2222221048576003633796
238pass.sp.ippass_dict_2232231048576006896690
239pass.sp.iqpass_dict_2242241048576005709294
240pass.sp.irpass_dict_2252251048576003668896
241pass.sp.ispass_dict_2262261048576006658649
242pass.sp.itpass_dict_2272271048576005857448
243pass.sp.iupass_dict_2282281048576003681861
244pass.sp.ivpass_dict_2292291048576006469395
245pass.sp.iwpass_dict_2302301048576005783290
246pass.sp.ixpass_dict_2312311048576003775098
247pass.sp.iypass_dict_2322321048576006130950
248pass.sp.izpass_dict_2332331048576005454936
249pass.sp.japass_dict_2342341048576003322148
250pass.sp.jbpass_dict_2352351048576006439808
251pass.sp.jcpass_dict_2362361048576005415298
252pass.sp.jdpass_dict_2372371048576003655392
253pass.sp.jepass_dict_2382381048576005965599
254pass.sp.jfpass_dict_2392391048576005475698
255pass.sp.jgpass_dict_2402401048576004022831
256pass.sp.jhpass_dict_2412411048576005686219
257pass.sp.jipass_dict_2422421048576005280803
258pass.sp.jjpass_dict_2432431048576004281331
259pass.sp.jkpass_dict_2442441048576005471452
260pass.sp.jlpass_dict_2452451048576004267515
261pass.sp.jmpass_dict_2462461048576005648594
262pass.sp.jnpass_dict_247247104857600664760
263pass.sp.jopass_dict_2482481048576001044800
264pass.sp.jppass_dict_249249104857600957664
265pass.sp.jqpass_dict_250250104857600884572
266pass.sp.jrpass_dict_251251104857600452385
267pass.sp.jspass_dict_252252104857600837000
268pass.sp.jtpass_dict_2532531048576001017526
269pass.sp.jupass_dict_2542541048576001189924
270pass.sp.jvpass_dict_2552551048576009293625
271pass.sp.jwpass_dict_2562561048576007606633
272pass.sp.jxpass_dict_2572571048576005413855
273pass.sp.jypass_dict_2582581048576004013964
274pass.sp.jzpass_dict_2592591048576005831808
275pass.sp.kapass_dict_2602601048576005583970
276pass.sp.kbpass_dict_2612611048576003380948
277pass.sp.kcpass_dict_2622621048576006207925
278pass.sp.kdpass_dict_2632631048576005608458
279pass.sp.kepass_dict_2642641048576003590573
280pass.sp.kfpass_dict_2652651048576005825283
281pass.sp.kgpass_dict_2662661048576004067602
282pass.sp.khpass_dict_2672671048576004850297
283pass.sp.kipass_dict_2682681048576005965511
284pass.sp.kjpass_dict_2692691048576003466397
285pass.sp.kkpass_dict_2702701048576005616861
286pass.sp.klpass_dict_2712711048576005176962
287pass.sp.kmpass_dict_2722721048576004271395
288pass.sp.knpass_dict_2732731048576005904798
289pass.sp.kopass_dict_2742741048576003560428
290pass.sp.kppass_dict_2752751048576006086211
291pass.sp.kqpass_dict_2762761048576005986487
292pass.sp.krpass_dict_2772771048576003727689
293pass.sp.kspass_dict_2782781048576005923794
294pass.sp.ktpass_dict_2792791048576005031184
295pass.sp.kupass_dict_2802801048576004584483
296pass.sp.kvpass_dict_2812811048576005896864
297pass.sp.kwpass_dict_2822821048576003606380
298pass.sp.kxpass_dict_2832831048576004867666
299pass.sp.kypass_dict_284284104857600828310
300pass.sp.kzpass_dict_2852851048576001004064
301pass.sp.lapass_dict_286286104857600771499
302pass.sp.lbpass_dict_287287104857600974311
303pass.sp.lcpass_dict_288288104857600745952
304pass.sp.ldpass_dict_289289104857600748758
305pass.sp.lepass_dict_2902901048576001394053
306pass.sp.lfpass_dict_2912911048576003321915
307pass.sp.lgpass_dict_2922921048576009551110
308pass.sp.lhpass_dict_2932931048576006440662
309pass.sp.lipass_dict_2942941048576005873597
310pass.sp.ljpass_dict_2952951048576003701466
311pass.sp.lkpass_dict_2962961048576006141265
312pass.sp.llpass_dict_2972971048576005490953
313pass.sp.lmpass_dict_2982981048576004176563
314pass.sp.lnpass_dict_2992991048576006041354
315pass.sp.lopass_dict_3003001048576004436778
316pass.sp.lppass_dict_3013011048576005684187
317pass.sp.lqpass_dict_3023021048576005952124
318pass.sp.lrpass_dict_3033031048576003734398
319pass.sp.lspass_dict_3043041048576006307706
320pass.sp.ltpass_dict_3053051048576006042612
321pass.sp.lupass_dict_3063061048576003767316
322pass.sp.lvpass_dict_3073071048576006242185
323pass.sp.lwpass_dict_3083081048576006452430
324pass.sp.lxpass_dict_3093091048576003996535
325pass.sp.lypass_dict_3103101048576006066294
326pass.sp.lzpass_dict_3113111048576005506270
327pass.sp.mapass_dict_3123121048576004534326
328pass.sp.mbpass_dict_3133131048576006060090
329pass.sp.mcpass_dict_3143141048576003940596
330pass.sp.mdpass_dict_3153151048576006038073
331pass.sp.mepass_dict_3163161048576006277001
332pass.sp.mfpass_dict_3173171048576003763804
333pass.sp.mgpass_dict_3183181048576006435336
334pass.sp.mhpass_dict_3193191048576006250725
335pass.sp.mipass_dict_3203201048576003210866
336pass.sp.mjpass_dict_3213211048576003618218
337pass.sp.mkpass_dict_3223221048576001256690
338pass.sp.mlpass_dict_323323104857600584287
339pass.sp.mmpass_dict_324324104857600933338
340pass.sp.mnpass_dict_325325104857600904759
341pass.sp.mopass_dict_3263261048576001045459
342pass.sp.mppass_dict_327327104857600426871
343pass.sp.mqpass_dict_3283281048576001118615
344pass.sp.mrpass_dict_3293291048576005987005
345pass.sp.mspass_dict_3303301048576009050261
346pass.sp.mtpass_dict_3313311048576008373711
347pass.sp.mupass_dict_3323321048576006354409
348pass.sp.mvpass_dict_3333331048576006219067
349pass.sp.mwpass_dict_3343341048576004096144
350pass.sp.mxpass_dict_3353351048576006551681
351pass.sp.mypass_dict_3363361048576006348329
352pass.sp.mzpass_dict_3373371048576004116695
353pass.sp.napass_dict_3383381048576006315407
354pass.sp.nbpass_dict_3393391048576006086887
355pass.sp.ncpass_dict_3403401048576004282131
356pass.sp.ndpass_dict_3413411048576006452102
357pass.sp.nepass_dict_3423421048576005147219
358pass.sp.nfpass_dict_3433431048576005092436
359pass.sp.ngpass_dict_3443441048576006587088
360pass.sp.nhpass_dict_3453451048576004602507
361pass.sp.nipass_dict_3463461048576005520429
362pass.sp.njpass_dict_3473471048576006641209
363pass.sp.nkpass_dict_3483481048576004626849
364pass.sp.nlpass_dict_3493491048576005476941
365pass.sp.nmpass_dict_3503501048576006345181
366pass.sp.nnpass_dict_3513511048576003674185
367pass.sp.nopass_dict_3523521048576006452251
368pass.sp.nppass_dict_3533531048576006507647
369pass.sp.nqpass_dict_3543541048576003929487
370pass.sp.nrpass_dict_3553551048576006794572
371pass.sp.nspass_dict_3563561048576006601716
372pass.sp.ntpass_dict_3573571048576003991030
373pass.sp.nupass_dict_3583581048576006877103
374pass.sp.nvpass_dict_3593591048576006760742
375pass.sp.nwpass_dict_3603601048576004531493
376pass.sp.nxpass_dict_3613611048576005630138
377pass.sp.nypass_dict_362362104857600720213
378pass.sp.nzpass_dict_3633631048576001754018
379pass.sp.oapass_dict_3643641048576001850233
380pass.sp.obpass_dict_365365104857600563631
381pass.sp.ocpass_dict_3663661048576001331195
382pass.sp.odpass_dict_3673671048576001222262
383pass.sp.oepass_dict_3683681048576001494912
384pass.sp.ofpass_dict_369369104857600356243
385pass.sp.ogpass_dict_3703701048576007014170
386pass.sp.ohpass_dict_3713711048576008926845
387pass.sp.oipass_dict_3723721048576008499082
388pass.sp.ojpass_dict_3733731048576005295454
389pass.sp.okpass_dict_3743741048576003068359
390pass.sp.olpass_dict_3753751048576004926036
391pass.sp.ompass_dict_3763761048576004178647
392pass.sp.onpass_dict_3773771048576003921045
393pass.sp.oopass_dict_3783781048576004791777
394pass.sp.oppass_dict_3793791048576003217637
395pass.sp.oqpass_dict_3803801048576004805554
396pass.sp.orpass_dict_3813811048576003095749
397pass.sp.ospass_dict_3823821048576005080524
398pass.sp.otpass_dict_3833831048576002992412
399pass.sp.oupass_dict_3843841048576005229893
400pass.sp.ovpass_dict_3853851048576004481911
401pass.sp.owpass_dict_3863861048576003739784
402pass.sp.oxpass_dict_3873871048576005433462
403pass.sp.oypass_dict_3883881048576003312934
404pass.sp.ozpass_dict_3893891048576004712170
405pass.sp.papass_dict_3903901048576003566045
406pass.sp.pbpass_dict_3913911048576005166504
407pass.sp.pcpass_dict_3923921048576004593021
408pass.sp.pdpass_dict_3933931048576003586894
409pass.sp.pepass_dict_3943941048576004762983
410pass.sp.pfpass_dict_3953951048576003094316
411pass.sp.pgpass_dict_3963961048576003903840
412pass.sp.phpass_dict_3973971048576001609115
413pass.sp.pipass_dict_398398104857600448638
414pass.sp.pjpass_dict_3993991048576001611251
415pass.sp.pkpass_dict_4004001048576001254034
416pass.sp.plpass_dict_401401104857600746629
417pass.sp.pmpass_dict_402402104857600752421
418pass.sp.pnpass_dict_4034031048576001116130
419pass.sp.popass_dict_4044041048576003218729
420pass.sp.pppass_dict_4054051048576008731734
421pass.sp.pqpass_dict_4064061048576007995500
422pass.sp.prpass_dict_4074071048576004858254
423pass.sp.pspass_dict_4084081048576003095451
424pass.sp.ptpass_dict_4094091048576005312875
425pass.sp.pupass_dict_4104101048576004123812
426pass.sp.pvpass_dict_4114111048576004070989
427pass.sp.pwpass_dict_4124121048576004800928
428pass.sp.pxpass_dict_4134131048576003108738
429pass.sp.pypass_dict_4144141048576004788308
430pass.sp.pzpass_dict_4154151048576003343875
431pass.sp.qapass_dict_4164161048576004859977
432pass.sp.qbpass_dict_4174171048576003101096
433pass.sp.qcpass_dict_4184181048576005340573
434pass.sp.qdpass_dict_4194191048576004516677
435pass.sp.qepass_dict_4204201048576003577504
436pass.sp.qfpass_dict_4214211048576005083567
437pass.sp.qgpass_dict_4224221048576003230986
438pass.sp.qhpass_dict_4234231048576004869410
439pass.sp.qipass_dict_4244241048576003919590
440pass.sp.qjpass_dict_4254251048576004801309
441pass.sp.qkpass_dict_4264261048576005159356
442pass.sp.qlpass_dict_4274271048576003897796
443pass.sp.qmpass_dict_4284281048576004955351
444pass.sp.qnpass_dict_4294291048576003047436
445pass.sp.qopass_dict_4304301048576004938430
446pass.sp.qppass_dict_431431104857600766469
447pass.sp.qqpass_dict_4324321048576001505893
448pass.sp.qrpass_dict_4334331048576001734967
449pass.sp.qspass_dict_4344341048576001270231
450pass.sp.qtpass_dict_435435104857600409915
451pass.sp.qupass_dict_4364361048576001096046
452pass.sp.qvpass_dict_4374371048576001407748
453pass.sp.qwpass_dict_438438104857600782133
454pass.sp.qxpass_dict_4394391048576008865226
455pass.sp.qypass_dict_4404401048576008806482
456pass.sp.qzpass_dict_4414411048576005791176
457pass.sp.rapass_dict_4424421048576005211427
458pass.sp.rbpass_dict_4434431048576003598574
459pass.sp.rcpass_dict_4444441048576004776738
460pass.sp.rdpass_dict_4454451048576003273880
461pass.sp.repass_dict_4464461048576004885942
462pass.sp.rfpass_dict_4474471048576003559498
463pass.sp.rgpass_dict_4484481048576004562708
464pass.sp.rhpass_dict_4494491048576004439148
465pass.sp.ripass_dict_4504501048576003571890
466pass.sp.rjpass_dict_4514511048576004786717
467pass.sp.rkpass_dict_4524521048576003397764
468pass.sp.rlpass_dict_4534531048576004830698
469pass.sp.rmpass_dict_4544541048576003135254
470pass.sp.rnpass_dict_4554551048576005313184
471pass.sp.ropass_dict_4564561048576004053114
472pass.sp.rppass_dict_4574571048576004103971
473pass.sp.rqpass_dict_4584581048576005011970
474pass.sp.rrpass_dict_4594591048576003435730
475pass.sp.rspass_dict_4604601048576004849512
476pass.sp.rtpass_dict_4614611048576003153077
477pass.sp.rupass_dict_4624621048576006745231
478pass.sp.rvpass_dict_4634631048576005297199
479pass.sp.rwpass_dict_4644641048576003173279
480pass.sp.rxpass_dict_4654651048576005253939
481pass.sp.rypass_dict_466466104857600749976
482pass.sp.rzpass_dict_4674671048576001536370
483pass.sp.sapass_dict_4684681048576001733592
484pass.sp.sbpass_dict_4694691048576001245794
485pass.sp.scpass_dict_470470104857600377421
486pass.sp.sdpass_dict_4714711048576001064433
487pass.sp.sepass_dict_4724721048576001439345
488pass.sp.sfpass_dict_473473104857600620576
489pass.sp.sgpass_dict_4744741048576008966351
490pass.sp.shpass_dict_4754751048576008778851
491pass.sp.sipass_dict_4764761048576005987377
492pass.sp.sjpass_dict_4774771048576005046417
493pass.sp.skpass_dict_4784781048576003492231
494pass.sp.slpass_dict_4794791048576004956165
495pass.sp.smpass_dict_4804801048576003412211
496pass.sp.snpass_dict_4814811048576004954118
497pass.sp.sopass_dict_4824821048576003755392
498pass.sp.sppass_dict_4834831048576004438974
499pass.sp.sqpass_dict_4844841048576004583744
500pass.sp.srpass_dict_4854851048576003537357
501pass.sp.sspass_dict_4864861048576004734927
502pass.sp.stpass_dict_4874871048576003384657
503pass.sp.supass_dict_4884881048576004866369
504pass.sp.svpass_dict_4894891048576003045043
505pass.sp.swpass_dict_4904901048576005180411
506pass.sp.sxpass_dict_4914911048576003882438
507pass.sp.sypass_dict_4924921048576004237211
508pass.sp.szpass_dict_4934931048576005214286
509pass.sp.tapass_dict_4944941048576003337531
510pass.sp.tbpass_dict_4954951048576005202104
511pass.sp.tcpass_dict_4964961048576003723033
512pass.sp.tdpass_dict_4974971048576005221829
513pass.sp.tepass_dict_4984981048576005342930
514pass.sp.tfpass_dict_4994991048576003527063
515pass.sp.tgpass_dict_5005001048576002715850
516pass.sp.thpass_dict_5015011048576001582631
517pass.sp.tipass_dict_502502104857600866812
518pass.sp.tjpass_dict_5035031048576001295279
519pass.sp.tkpass_dict_5045041048576001063929
520pass.sp.tlpass_dict_5055051048576001146412
521pass.sp.tmpass_dict_506506104857600357544
522pass.sp.tnpass_dict_5075071048576001063843
523pass.sp.topass_dict_5085081048576005120636
524pass.sp.tppass_dict_5095091048576008795318
525pass.sp.tqpass_dict_5105101048576009276416
526pass.sp.trpass_dict_5115111048576009113758
527pass.sp.tspass_dict_5125121048576009567797
528pass.sp.ttpass_dict_5135131048576005621954
529pass.sp.tupass_dict_5145141048576005628589
530pass.sp.tvpass_dict_5155151048576006340272
531pass.sp.twpass_dict_5165161048576003135550
532pass.sp.txpass_dict_5175171048576003229469
533pass.sp.typass_dict_5185181048576007173079
534pass.sp.tzpass_dict_5195191048576006165456
535pass.sp.uapass_dict_5205201048576004585494
536pass.sp.ubpass_dict_5215211048576009038033
537pass.sp.ucpass_dict_52252210485760010088268
538pass.sp.udpass_dict_5235231048576008651614
539pass.sp.uepass_dict_5245241048576008954144
540pass.sp.ufpass_dict_5255251048576009118674
541pass.sp.ugpass_dict_5265261048576009220058
542pass.sp.uhpass_dict_5275271048576008339496
543pass.sp.uipass_dict_5285281048576008479781
544pass.sp.ujpass_dict_5295291048576008995165
545pass.sp.ukpass_dict_5305301048576008327084
546pass.sp.ulpass_dict_5315311048576008452070
547pass.sp.umpass_dict_5325321048576008743274
548pass.sp.unpass_dict_5335331048576008844125
549pass.sp.uopass_dict_5345341048576008965936
550pass.sp.uppass_dict_5355351048576008963795
551pass.sp.uqpass_dict_5365361048576006478526
552pass.sp.urpass_dict_5375371048576009127348
553pass.sp.uspass_dict_5385381048576008349888
554pass.sp.utpass_dict_5395391048576008934814
555pass.sp.uupass_dict_5405401048576008850399
556pass.sp.uvpass_dict_5415411048576009145619
557pass.sp.uwpass_dict_5425421048576008914377
558pass.sp.uxpass_dict_5435431048576009096438
559pass.sp.uypass_dict_5445441048576008837448
560pass.sp.uzpass_dict_5455451048576008597521
561pass.sp.vapass_dict_5465461048576009290280
562pass.sp.vbpass_dict_5475471048576008433108
563pass.sp.vcpass_dict_5485481048576008724969
564pass.sp.vdpass_dict_5495491048576008879727
565pass.sp.vepass_dict_5505501048576008649366
566pass.sp.vfpass_dict_5515511048576008959861
567pass.sp.vgpass_dict_5525521048576008757669
568pass.sp.vhpass_dict_5535531048576008873993
569pass.sp.vipass_dict_5545541048576008298996
570pass.sp.vjpass_dict_5555551048576008564972
571pass.sp.vkpass_dict_5565561048576008595769
572pass.sp.vlpass_dict_5575571048576008016212
573pass.sp.vmpass_dict_5585581048576001965407
574pass.sp.vnpass_dict_5595591048576009003292
575pass.sp.vopass_dict_5605601048576008170178
576pass.sp.vppass_dict_5615611048576008786423
577pass.sp.vqpass_dict_5625621048576008818251
578pass.sp.vrpass_dict_5635631048576009210514
579pass.sp.vspass_dict_5645641048576008639260
580pass.sp.vtpass_dict_5655651048576008797790
581pass.sp.vupass_dict_5665661048576008942284
582pass.sp.vvpass_dict_5675671048576008302457
583pass.sp.vwpass_dict_5685681048576008278852
584pass.sp.vxpass_dict_5695691048576008594746
585pass.sp.vypass_dict_5705701048576008739217
586pass.sp.vzpass_dict_5715711048576007540063
587pass.sp.wapass_dict_5725721048576008224345
588pass.sp.wbpass_dict_5735731048576008682682
589pass.sp.wcpass_dict_5745741048576008970313
590pass.sp.wdpass_dict_5755751048576006310165
591pass.sp.wepass_dict_5765761048576008692554
592pass.sp.wfpass_dict_5775771048576008928602
593pass.sp.wgpass_dict_5785781048576009254864
594pass.sp.whpass_dict_5795791048576009549303
595pass.sp.wipass_dict_5805801048576008435125
596pass.sp.wjpass_dict_5815811048576008998063
597pass.sp.wkpass_dict_5825821048576008325679
598pass.sp.wlpass_dict_5835831048576008707410
599pass.sp.wmpass_dict_5845841048576008628160
600pass.sp.wnpass_dict_5855851048576008928152
601pass.sp.wopass_dict_5865861048576008883674
602pass.sp.wppass_dict_5875871048576009228561
603pass.sp.wqpass_dict_5885881048576006954532
604pass.sp.wrpass_dict_589589104857600347591
605pass.sp.wspass_dict_5905901048576003
606pass.sp.wtpass_dict_5915911048576001
607pass.sp.wupass_dict_592592104857600337857
608pass.sp.wvpass_dict_5935931048576008285440
609pass.sp.wwpass_dict_5945941048576009229560
610pass.sp.wxpass_dict_5955951048576009173271
611pass.sp.wypass_dict_5965961048576009305692
612pass.sp.wzpass_dict_5975971048576008826583
613pass.sp.xapass_dict_5985981048576008792926
614pass.sp.xbpass_dict_5995991048576009009865
615pass.sp.xcpass_dict_6006001048576008796541
616pass.sp.xdpass_dict_6016011048576006216278
617pass.sp.xepass_dict_6026021048576008051643
618pass.sp.xfpass_dict_6036031048576009047002
619pass.sp.xgpass_dict_6046041048576008919322
620pass.sp.xhpass_dict_6056051048576008948738
621pass.sp.xipass_dict_6066061048576008757772
622pass.sp.xjpass_dict_6076071048576008807461
623pass.sp.xkpass_dict_6086081048576008436304
624pass.sp.xlpass_dict_6096091048576008858618
625pass.sp.xmpass_dict_6106101048576009185166
626pass.sp.xnpass_dict_6116111048576009213666
627pass.sp.xopass_dict_6126121048576009182268
628pass.sp.xppass_dict_6136131048576008945407
629pass.sp.xqpass_dict_6146141048576008594277
630pass.sp.xrpass_dict_6156151048576008670335
631pass.sp.xspass_dict_6166161048576008843172
632pass.sp.xtpass_dict_6176171048576008670917
633pass.sp.xupass_dict_6186181048576008725916
634pass.sp.xvpass_dict_6196191048576009130112
635pass.sp.xwpass_dict_6206201048576009227741
636pass.sp.xxpass_dict_6216211048576009238858
637pass.sp.xypass_dict_6226221048576008904597
638pass.sp.xzpass_dict_6236231048576008800477
639pass.sp.yapass_dict_6246241048576008694176
640pass.sp.ybpass_dict_6256251048576008833188
641pass.sp.ycpass_dict_6266261048576008906379
642pass.sp.ydpass_dict_6276271048576008927995
643pass.sp.yepass_dict_6286281048576008794100
644pass.sp.yfpass_dict_6296291048576009120641
645pass.sp.ygpass_dict_6306301048576009238217
646pass.sp.yhpass_dict_6316311048576008266573
647pass.sp.yipass_dict_6326321048576008250577
648pass.sp.yjpass_dict_6336331048576008937668
649pass.sp.ykpass_dict_6346341048576009369343
650pass.sp.ylpass_dict_6356351048576009153649
651pass.sp.ympass_dict_6366361048576009385560
652pass.sp.ynpass_dict_6376371048576008998560
653pass.sp.yopass_dict_6386381048576008847628
654pass.sp.yppass_dict_6396391048576009172469
655pass.sp.yqpass_dict_6406401048576008831493
656pass.sp.yrpass_dict_6416411048576009024358
657pass.sp.yspass_dict_6426421048576009496027
658pass.sp.ytpass_dict_6436431048576009448258
659pass.sp.yupass_dict_6446441048576009346630
660pass.sp.yvpass_dict_6456451048576008838990
661pass.sp.ywpass_dict_6466461048576009041671
662pass.sp.yxpass_dict_6476471048576009028318
663pass.sp.yypass_dict_6486481048576008934736
664pass.sp.yzpass_dict_6496491048576008429926
665pass.sp.zaaapass_dict_6506501048576008625670
666pass.sp.zaabpass_dict_6516511048576008967734
667pass.sp.zaacpass_dict_6526521048576009489441
668pass.sp.zaadpass_dict_6536531048576009286635
669pass.sp.zaaepass_dict_6546541048576009335448
670pass.sp.zaafpass_dict_6556551048576008849567
671pass.sp.zaagpass_dict_6566561048576008905481
672pass.sp.zaahpass_dict_6576571048576009048682
673pass.sp.zaaipass_dict_6586581048576008657705
674pass.sp.zaajpass_dict_6596591048576008970613
675pass.sp.zaakpass_dict_6606601048576008789391
676pass.sp.zaalpass_dict_6616611048576009092287
677pass.sp.zaampass_dict_6626621048576008924173
678pass.sp.zaanpass_dict_6636631048576008940724
679pass.sp.zaaopass_dict_6646641048576009229496
680pass.sp.zaappass_dict_6656651048576009065471
681pass.sp.zaaqpass_dict_6666661048576009326091
682pass.sp.zaarpass_dict_6676671048576009124316
683pass.sp.zaaspass_dict_6686681048576008692728
684pass.sp.zaatpass_dict_6696691048576008483052
685pass.sp.zaaupass_dict_6706701048576008086660
686pass.sp.zaavpass_dict_6716711048576008740061
687pass.sp.zaawpass_dict_6726721048576008740839
688pass.sp.zaaxpass_dict_6736731048576008567735
689pass.sp.zaaypass_dict_6746741048576008412576
690pass.sp.zaazpass_dict_6756751048576008752144
691pass.sp.zabapass_dict_6766761048576008798467
692pass.sp.zabbpass_dict_6776771048576008846263
693pass.sp.zabcpass_dict_6786781048576009171877
694pass.sp.zabdpass_dict_6796791048576009023592
695pass.sp.zabepass_dict_6806801048576009211385
696pass.sp.zabfpass_dict_6816811048576009128204
697pass.sp.zabgpass_dict_6826821048576008488231
698pass.sp.zabhpass_dict_6836831048576008740730
699pass.sp.zabipass_dict_6846841048576008699778
700pass.sp.zabjpass_dict_6856851048576008724170
701pass.sp.zabkpass_dict_6866861048576009142787
702pass.sp.zablpass_dict_6876871048576009144872
703pass.sp.zabmpass_dict_6886881048576008992635
704pass.sp.zabnpass_dict_6896891048576008855435
705pass.sp.zabopass_dict_6906901048576008724006
706pass.sp.zabppass_dict_6916911048576009073492
707pass.sp.zabqpass_dict_6926921048576009122540
708pass.sp.zabrpass_dict_6936931048576008835587
709pass.sp.zabspass_dict_6946941048576008840656
710pass.sp.zabtpass_dict_6956951048576008573633
711pass.sp.zabupass_dict_6966961048576008788926
712pass.sp.zabvpass_dict_6976971048576008420284
713pass.sp.zabwpass_dict_6986981048576008737214
714pass.sp.zabxpass_dict_6996991048576008365588
715pass.sp.zabypass_dict_7007001048576008157473
716pass.sp.zabzpass_dict_7017011048576008419370
717pass.sp.zacapass_dict_7027021048576008880122
718pass.sp.zacbpass_dict_7037031048576008137254
719pass.sp.zaccpass_dict_7047041048576009173934
720pass.sp.zacdpass_dict_7057051048576009180108
721pass.sp.zacepass_dict_7067061048576009376151
722pass.sp.zacfpass_dict_7077071048576009268740
723pass.sp.zacgpass_dict_7087081048576008985446
724pass.sp.zachpass_dict_7097091048576008819447
725pass.sp.zacipass_dict_7107101048576008433627
726pass.sp.zacjpass_dict_7117111048576008767279
727pass.sp.zackpass_dict_7127121048576008848105
728pass.sp.zaclpass_dict_7137131048576008657530
729pass.sp.zacmpass_dict_7147141048576008990626
730pass.sp.zacnpass_dict_7157151048576009070604
731pass.sp.zacopass_dict_7167161048576009105724
732pass.sp.zacppass_dict_7177171048576009139805
733pass.sp.zacqpass_dict_7187181048576009284457
734pass.sp.zacrpass_dict_7197191048576008848514
735pass.sp.zacspass_dict_7207201048576008869349
736pass.sp.zactpass_dict_7217211048576009076214
737pass.sp.zacupass_dict_7227221048576008764744
738pass.sp.zacvpass_dict_7237231048576008338245
739pass.sp.zacwpass_dict_7247241048576008430080
740pass.sp.zacxpass_dict_7257251048576008827238
741pass.sp.zacypass_dict_7267261048576008645509
742pass.sp.zaczpass_dict_7277271048576008620034
743pass.sp.zadapass_dict_7287281048576008837416
744pass.sp.zadbpass_dict_7297291048576008386557
745pass.sp.zadcpass_dict_7307301048576008279586
746pass.sp.zaddpass_dict_7317311048576008096509
747pass.sp.zadepass_dict_7327321048576007731318
748pass.sp.zadfpass_dict_7337331048576008386956
749pass.sp.zadgpass_dict_7347341048576009186395
750pass.sp.zadhpass_dict_7357351048576008639091
751pass.sp.zadipass_dict_7367361048576008940738

6.代码简单实现一个密码泄漏检测

java
 @Test
    public void tryFindPass() {
        String passStr = "";
        List<String> res = new ArrayList<>();
        List<PassMeta> metaList = passwordMapper.getMetaList();
        for (PassMeta p : metaList) {
            res.addAll(passwordMapper.getPasswordList(p.getCtablenum(), passStr));
        }
        if (!res.isEmpty()) {
            log.error("密码已经泄漏");
            System.out.println(res);
        } else {
            log.info("密码没有泄漏!");
        }
    }