Skip to content

Commit 1bc289c

Browse files
xuxu
authored andcommitted
complete play2
1 parent ad947eb commit 1bc289c

5 files changed

Lines changed: 529 additions & 0 deletions

File tree

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,6 @@
1+
{
2+
"cells": [],
3+
"metadata": {},
4+
"nbformat": 4,
5+
"nbformat_minor": 0
6+
}

‎BrambleXu/play2/Running_result.txt‎

Lines changed: 200 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,200 @@
1+
zVa5X6I
2+
wWRq3Md
3+
HYPrBwu
4+
WJ81dSg
5+
9qum1SH
6+
BjsDzQG
7+
mlTlnxd
8+
ccTYwGo
9+
UDxRWtb
10+
ZGGHPbX
11+
VSzuxVY
12+
7pwig4K
13+
q0hzEYY
14+
SPPd3nP
15+
RzrTEBc
16+
bRe6cxz
17+
n3sTEEX
18+
Mz8Anhk
19+
iL9AfX9
20+
eItR9is
21+
9ZCYjqT
22+
AzLXLgl
23+
o5gpCd2
24+
QQm2eA8
25+
stmJzPJ
26+
hOf4kN6
27+
FX3hSJD
28+
6ZbxgVj
29+
oBbzOsT
30+
h37SB5g
31+
ME3gPlX
32+
0eZcNqz
33+
yW6ClQ1
34+
YHFRUCO
35+
jgGQ5jj
36+
uXcZmLy
37+
qxcvNyI
38+
D8PTOnP
39+
PDuNzcn
40+
4VEjIvf
41+
0N8A1tc
42+
oRy3PfJ
43+
xAFONpv
44+
5LFU5cn
45+
Fj39jof
46+
Wpn24hk
47+
cJb1kIG
48+
W2nDn4A
49+
obMKOv4
50+
wq4vnjN
51+
yhlvuP1
52+
zbyYGXS
53+
JrocNII
54+
A445blD
55+
UtWyEsX
56+
hWL4FND
57+
ddCEGF5
58+
Coya2Pi
59+
yyRCA5n
60+
FvffdOh
61+
vugnBoS
62+
JSPPpQU
63+
vaw2qwu
64+
kLsXPPY
65+
60CYTep
66+
qgGZ0UG
67+
qcHRVzg
68+
0fHvUbP
69+
He6PuyE
70+
L1A3wPU
71+
UUWfAJf
72+
gQ3LLXG
73+
ZVImzMf
74+
97WxYRW
75+
ogdZC8n
76+
ZXbknJO
77+
jojdeR0
78+
WeJ7Q2V
79+
FvjPEMC
80+
oDKdvOU
81+
xOOgYVT
82+
YS4yfYE
83+
ynO6kvp
84+
i96tK90
85+
F0V1x6l
86+
Scy2fNj
87+
Vud83SJ
88+
6Uw2iox
89+
HlcfaMN
90+
eeBXFxr
91+
mdaW2qm
92+
7biS1Ct
93+
8NCZ9wb
94+
g2ybeAL
95+
uH1y7v4
96+
vYcGGdX
97+
cmfqmug
98+
ZsYn46K
99+
HPl0WfV
100+
6ZUParz
101+
04yqzNM
102+
P4H51wV
103+
m19yof6
104+
UZJ9DHl
105+
ZU5KQxT
106+
F3AT9Hm
107+
3C56tlw
108+
dbKnCAt
109+
UanlfgG
110+
eeWxP9u
111+
qzlYyVS
112+
ylS17QF
113+
WknIN9Z
114+
4DZ4E4z
115+
CIt30PV
116+
X7pKmau
117+
3aERTHR
118+
kv2HFHX
119+
rD5ONpK
120+
0fxHVZR
121+
pFKsTHo
122+
ytxg8JS
123+
V6LmSZz
124+
sLvxGkG
125+
Y4kO3N4
126+
INJhqPo
127+
UiYLZBm
128+
FsuNV1V
129+
vGZbyTh
130+
sMi7iu7
131+
p6x5ZkN
132+
xPYsVkH
133+
AsG4lhO
134+
Oeea0Eq
135+
5WfDYgq
136+
LmYdT1a
137+
62k2T3K
138+
3hddsZl
139+
CTdCLFg
140+
8CWfWFR
141+
vWcBtjd
142+
x4lPElC
143+
STuJ8oj
144+
MQZN3Nj
145+
xvxLuww
146+
CBvNgVV
147+
weZnd9e
148+
jmScsx8
149+
19T00Tn
150+
lZO6Pce
151+
5vv7tqT
152+
KMKB0Lu
153+
dig4KaK
154+
7rDy82m
155+
CGRlUFR
156+
EdLfDgf
157+
lzTSWoj
158+
tNh1ILF
159+
C8hQRnl
160+
ANsiZmh
161+
5f7UgiW
162+
pSBeD64
163+
vVazmIm
164+
keuJ4WB
165+
MDuI2Vr
166+
x4ajEg8
167+
A6FiNzn
168+
W9mRdXL
169+
smFAbTV
170+
TcgpNso
171+
moabigv
172+
oS4R0Uj
173+
zlbT4Eu
174+
wQp0X60
175+
8dynhzZ
176+
cQdD8Sn
177+
SWK5sDu
178+
ccupt2f
179+
q2FDR9n
180+
YDWFOgF
181+
ywe005r
182+
d69sLs8
183+
6dRwv8l
184+
hbjEyRY
185+
rajgBbK
186+
C5PxGGv
187+
p9CJVg5
188+
rBjkQQ3
189+
TvpfQVx
190+
jmEUJIY
191+
eDH2S7i
192+
uXPCTx9
193+
LRFGWmW
194+
sDvN8r4
195+
OlkjslP
196+
mSoDDUL
197+
Qs3oBpH
198+
VioYsWj
199+
pd5wtcP
200+
WBJd6Hb

‎BrambleXu/play2/play2.py‎

Lines changed: 36 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,36 @@
1+
# -*- coding:utf-8 -*-
2+
#**第 0002 题**:将 0001 题生成的 200 个激活码(或者优惠券)保存到 **MySQL** 关系型数据库中。
3+
4+
import MySQLdb
5+
6+
def store_mysql(filepath):
7+
db = MySQLdb.connect(host="localhost", user = "xu", passwd = "1234", db = "ShowMeTheCode")
8+
cursor = db.cursor()
9+
10+
#判断表是否存在
11+
cursor.execute('show tables in ShowMeTheCode;')
12+
tables = cursor.fetchall()
13+
findtables = False
14+
for table in tables:
15+
if 'code' in table:
16+
findtables = True
17+
print "the table is already exist"
18+
if not findtables:
19+
cursor.execute('''
20+
CREATE TABLE code(
21+
id INT NOT NULL AUTO_INCREMENT,
22+
code VARCHAR(10)
23+
PRIMARY KEY (id));
24+
''')
25+
26+
f = open(filepath, 'rb')
27+
for line in f.readlines():
28+
coupon = line.strip() #用strip把\n去掉
29+
cursor.execute("INSERT INTO code (code) VALUES (%s);", [coupon]) # coupon会报错,格式问题,插入数据库里的数据必须要变为list,所以用【coupon]
30+
31+
db.commit()
32+
cursor.close()
33+
db.close()
34+
35+
if __name__ == '__main__':
36+
store_mysql('Running_result.txt')

0 commit comments

Comments
 (0)