Skip to content

Commit fc03c37

Browse files
committed
add no.2
1 parent c99df75 commit fc03c37

5 files changed

Lines changed: 239 additions & 0 deletions

File tree

File renamed without changes.
File renamed without changes.

lwh/2/active_code.txt

Lines changed: 200 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,200 @@
1+
RXUadiI0zOKmg5Ww
2+
z4qo5vaXKGM8uFsB
3+
TU3PdPnSAKtUcXwl
4+
dy2nuUEjRczyXC0a
5+
Xn8MFsTBRCbcG45E
6+
7DmryUic3pOs1DFu
7+
REINIyXEsovPrJ2G
8+
OKTYjXVpTljHanCO
9+
SzsuRGUmL6sEXBA1
10+
FrKGmMjKQGt0ImDV
11+
BLYXVaqENcuJXfUh
12+
ydsilfQorQtLKJs4
13+
abX1AUFy61k0gPZh
14+
xjEyzBwwu9AXrAaU
15+
wuJXMMscjhUpjOu1
16+
fbVRxeWbpilOQEQ2
17+
gKnLlSMvzFup2ubi
18+
mcU54YoHxGZ3gbRy
19+
izdNk0U2nlAqN5HT
20+
zGx1bP240lai9qMG
21+
3Nqa5IB5dzuPWfBA
22+
jAtgS3XXojFlWI5j
23+
L8rb8ODGhGO03D7x
24+
1SZ5ouRlwulVMcVd
25+
jGr71Sx2eU1BTzvq
26+
sB24ocOCXxuUwvJg
27+
RHesYESjimTftYZA
28+
gJvEvwB7nlRnsmcQ
29+
hVa1H4Ig9VfzBmRz
30+
bEGSjiMZMWpeRyhy
31+
3mFUtX6T3q6qJmN1
32+
jfKbj7WEu7LuBjw8
33+
07qBOuEyTvsoeC7o
34+
JCAGJusp8qdr7NzD
35+
5vrE1vhHIJ4rqLcU
36+
PquV3EUuOWDTy4pX
37+
ZEEcNm4o7JXQuRZn
38+
xDGpAt5uUHbi3HLN
39+
7KtkUMfREmSdTebQ
40+
4CTfOxmFFT7VX6Ha
41+
hWFdJW034cEKX8nT
42+
vgaQuZgmOWeBdBHr
43+
iZsJpE4eSh7ZqgYq
44+
bX3Wf9ya2AYB0Ek5
45+
7dAQNjyHPJ3BKTmt
46+
yCCVEeAAXwmPjj7x
47+
zt4Y1ptPZmFMEQ7Y
48+
TNXXk5PE2dKJTKwY
49+
qClONH4dhtpblVxO
50+
BcOxR9eik1YcKAIt
51+
IxVcoCfhx5U1KhJL
52+
e6LgwfakF5sIo3Wn
53+
rBz6ifzKMmLjRqnr
54+
7sG7zoOEjwiPVwMN
55+
2SpgY4eExdqyFma9
56+
seIIcsNT0deljKcF
57+
jUY48NLHJWn5mjSm
58+
epNdFfnUy3K9tddV
59+
FLKdZilBUpYloqLH
60+
b4flf5wi6a4joQwA
61+
1hJ2tGTJwlvgjebQ
62+
KW0W8x23QRAQMC3K
63+
tvOBXdSFbujyiLnl
64+
9SygR3CYo4ReQ1x4
65+
rTcggxAwbuu7waNy
66+
ql4gqiS3kJuNexrl
67+
ZpmKF1VYeIbvrAwE
68+
NhW0mMDUX9j1QkOR
69+
VHKBmzABwLwH1c8Y
70+
238sBuP3YIJJIUn6
71+
EyLVxAOASe5PWDsi
72+
BDxWOvKpe3FRHfXZ
73+
qkqz0lD4ogDgG6HB
74+
I8M1aVJCRc2452OG
75+
JWl7JmPKK9sq8v2r
76+
bdXCjhrHUSNXsNPJ
77+
sEcmFMdcvz57wBkr
78+
OYouRL6AD21NncGn
79+
aNRk1zxXhrr30fAm
80+
g40yzH8LHOOymofr
81+
oPw8MO6iNamJ1bYK
82+
QfnffjYdbE8BKCqF
83+
mbEKxuHBNHHloDy0
84+
oeVHq1yblfNbDlm2
85+
S5O9WOvWHMUU0ymx
86+
eiwlpN9GuRGmpbn0
87+
TMGHVairDKmSGbCk
88+
kiOC0MLXtctQxLe5
89+
rfoaB5W9YxwMzNki
90+
FWIoPqzYBkxWUA5n
91+
HoCqNcTtQEtjAUMP
92+
Gy6nVQJmgsgv9hGc
93+
PBTm3QAQ6jNFkvUZ
94+
j3yRTRrcFGUgDwow
95+
bPF8g0RHaN47Q4dN
96+
NzM9WIrXiDbi5IXD
97+
w54j8L5ngiakgayX
98+
hkd4g0UkVhmNnyR6
99+
iEz5VpcVi1mpS1gq
100+
KWkIIA97y42V5cnx
101+
5LZGIXk2odGvSTE1
102+
s1NdaGmS5YB8VJEL
103+
272uuYgOloY7hJ8t
104+
oc0hco4FYw75n4US
105+
DzmWY32kG7JaFG3R
106+
UIaLpcjN9yA12Uo5
107+
8RYmqxQ8IxUU0aGz
108+
D5Td2B7lEEUDYsUw
109+
vJ0rZHnIlI6sHDo5
110+
MYLBHHfax5MvUf96
111+
CQisO7bfEUwpr2Qy
112+
dyLBeumYaTAGHFyM
113+
wvFS79uJMwWSUgHv
114+
KkwuShhSHkzKy6op
115+
O72zwUdEuetJnnQ6
116+
Qj7r8dbBf1fKV55k
117+
T7K47FF9KcrEYcI7
118+
N79n066wlGUsxanD
119+
XPrc3XrLHA23mmmb
120+
sANdjXf4gD5tJvWF
121+
ARJPiZz9HmQbtqOW
122+
7WAr9oIw9sebBNWj
123+
UmKbDJ9Z3XDB0uxa
124+
XbqEHERAPrrM42ud
125+
iRMKgFM0gqr9G8Rt
126+
WfdEyO5sGxXKiYND
127+
3hPPrf7M3UPk3Pis
128+
PiL0B8e9ZtKPRsuj
129+
YuQXWQTw24RlfOUw
130+
nG8kOk3G6VWM3XcX
131+
0XblQUEM8uCl8ljl
132+
VY2AKbDNFTXT2Vpj
133+
BZkiI7LxBsSPp9wI
134+
WuCVLSQqpj2jBA74
135+
I6ASBeIdmYPxg7Zx
136+
OIAeCY1FHbOdJHnk
137+
h3r45aQva46D0MkG
138+
BlHBdOq3KqcokYnp
139+
X4mFpYkR7LgyBdf9
140+
r04TZnPIpXlrYajl
141+
Zoa59BtKi0C7N3vQ
142+
PAUVrdCcV46DMcTa
143+
XzkP2UjLVPd6UdeH
144+
tFuOwhfZAminRknq
145+
LLRXDREtywZ9oL2l
146+
1Bt1hjCu87iRvjVO
147+
843udSQ5CYhxzpY3
148+
zm78Qr1fm6YbD5Pc
149+
nkKKOAThEvmvMDck
150+
daNI9lwDGwWPXgDh
151+
3AD5vzwEgCh62OGG
152+
g0WACS40VWUhhO3n
153+
8DSPNQnnPpExp5ae
154+
1qDbOw7VXQu6sJyx
155+
IHeAepe22BqzyRYI
156+
Pyc8MoGTBonXrsig
157+
caIx6iJTzzrwRh76
158+
TuCiIBooXAtxGA1s
159+
d5vL89dwRziYYkOC
160+
Th7QNxgmuAHgdxjY
161+
Qde8adGqOCJLStgi
162+
X4YVCKnkpIglPXNH
163+
DJaSfz6ZZ5AexZrh
164+
p0suRQkjR2gPB50J
165+
Xu7zNDMf8LTXgUfP
166+
iO7lZE1d5u9C4agr
167+
ZScUrgefG4mhv7sn
168+
cxKn0LeiJmTmOncc
169+
MlHM9bSCqbLeYQyl
170+
hnNxbuM0iFXasDNU
171+
U9TDcgewoYmCuL8Z
172+
NiWuD6W6yo5naWVa
173+
6xB2tyGaP9XD1Reu
174+
MyMQgM3LVp3OOZbH
175+
GNReq9Tsm9yEkjnH
176+
wv0m9rGnQlTzWBsz
177+
VXdYlEkAdRsw74Q6
178+
KYvyofRRw4HdHdGa
179+
feOc882CM6u3Vmb9
180+
bHfFtp2xlqR9ov7Z
181+
I9WJT51PDOho07f2
182+
mbfys9pZlaBa71fn
183+
Z7B8uUPNGUolHgve
184+
CyGhoq3E5eaLuYd8
185+
Sp4zPGY0Zb4ce2kX
186+
dawy36RyxYpGlDTG
187+
gJlcfSukZBZZbOji
188+
DM5lIjwwSR5Ixta0
189+
HQIN6iSuBBu95Cy1
190+
c3JKxSbY0vqx4SEC
191+
9H4DXpc17vFjPCeE
192+
c48hIoAA5E5lVScv
193+
gadG0fAunAWg3C4I
194+
jr9kg1rr4rGPAT5i
195+
aLipX2YqYy8FyImJ
196+
GP87sr1igGhbAVnB
197+
Oghe3rzJSi4N9bCh
198+
j0pl6r1H8LD89zpg
199+
g9G0cNNlbgRRiuRM
200+
jqyltqFWJLEe0Gez

lwh/2/pymysql.py

Lines changed: 39 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,39 @@
1+
# -*- coding: utf-8 -*-
2+
3+
#!/usr/bin/python
4+
# -*- coding: UTF-8 -*-
5+
6+
import pymysql
7+
8+
9+
# 打开数据库连接
10+
db = pymysql.connect("localhost", "root", "", "")
11+
12+
# 使用cursor()方法获取操作游标
13+
cursor = db.cursor()
14+
15+
# 使用execute方法执行SQL语句
16+
cursor.execute("CREATE DATABASE IF NOT EXISTS pymysql;")
17+
cursor.execute("USE pymysql;")
18+
cursor.execute(
19+
"CREATE TABLE IF NOT EXISTS active_code(code VARCHAR(255));")
20+
21+
with open("active_code.txt", "r") as f:
22+
while True:
23+
s = f.readline().strip()
24+
# print(s)
25+
if s == "":
26+
break
27+
cursor.execute("INSERT INTO active_code (code) values(%s)", [s])
28+
29+
db.commit()
30+
#cursor.execute("USE pymsql")
31+
cursor.execute("SELECT * FROM active_code")
32+
33+
# 使用 fetchone() 方法获取一条数据库。
34+
#data = cursor.fetchone()
35+
36+
#print("Database version : %s " % data)
37+
38+
# 关闭数据库连接
39+
db.close()

0 commit comments

Comments
 (0)