File tree Expand file tree Collapse file tree
Expand file tree Collapse file tree File renamed without changes.
Original file line number Diff line number Diff line change 88
99
1010def get_code ():
11- f = open ('ActvationCode .txt' , 'w' )
11+ f = open ('ActivationCode .txt' , 'w' )
1212 char_seq = 'abcdefghijklmnopqrstuvwxyz0123456789'
1313 for i in range (200 ):
1414 code = ''
Original file line number Diff line number Diff line change 1+ jasayyhci
2+ xx1ia7v1b
3+ zy546onps
4+ vetsatr2w
5+ x6f4y3468
6+ 3g1pw108k
7+ wuyrji08q
8+ rzlzxs4xg
9+ bmir749bu
10+ v7inkwzoi
11+ 68z0kq6ur
12+ pypmiu5og
13+ jidqni4fz
14+ c6b29b9kb
15+ r9znbbbmj
16+ 331l6y08b
17+ m4nas4he4
18+ l4a42ypad
19+ xfc8h6wvo
20+ t4khbx7j1
21+ 9hxvrrsah
22+ imbmie4ky
23+ e0actu2xz
24+ 3u3amqtu0
25+ lcovbjpm3
26+ ds8zbk5jh
27+ o9y9s74ac
28+ jdldifamh
29+ nw15e3qf4
30+ w71kk7i6a
31+ iasy74ovn
32+ 42v6hkfvp
33+ xtnwhy7mg
34+ id3z7ved4
35+ jr97n77ue
36+ 3mjujcppy
37+ 0tvfnt287
38+ llxys3ki8
39+ umldlkaxz
40+ 8cc8tjlq7
41+ 6y43a71ov
42+ 2wbx19xmq
43+ 3ypbwgy1h
44+ zazhe7d5r
45+ p5endwk3e
46+ wrczjq0cu
47+ 41cuvr7z7
48+ u6dek96c9
49+ ek9cb76q3
50+ u7yybk8hv
51+ 6fksdba4l
52+ 9rehlyiua
53+ oh2mxkspj
54+ j32ik9hiu
55+ o4k7m9md3
56+ 5slv1d2gd
57+ 7gh1z7o0b
58+ 1l82vu6nz
59+ jntsvp6hs
60+ k5pfdggxp
61+ zyo25p2qs
62+ joayw5bea
63+ 0mm39197z
64+ 0lha1urmm
65+ 6m2k243cs
66+ zk80uvofv
67+ d9yzqmwf4
68+ j8klfjxhx
69+ uey550hc1
70+ xgvplru0h
71+ 53ccnuxym
72+ 5pg6a5zgj
73+ wljjnwwtq
74+ dg9eo40wk
75+ 3xolm3tox
76+ 7rvurzud3
77+ 3ebemea0y
78+ 9c7orc1qs
79+ pw6jn47yy
80+ pre1ixi35
81+ ph8et0vh0
82+ z2oh67j2b
83+ os2trzxuo
84+ h6njf1llw
85+ qm6q1erka
86+ 345k0m9s9
87+ 72xtf32fu
88+ zhrybh3ck
89+ wj7jx3oxi
90+ 0rirzl6oe
91+ 1d4a20r2g
92+ tnx7a3ekm
93+ o2xzp9hes
94+ fny6pazna
95+ scy17wh0h
96+ o3g4ptomq
97+ 5w855mrna
98+ h9f1dryt4
99+ 67b4z8hwk
100+ nsqicfb7k
101+ wurfj1qti
102+ ikn04uuza
103+ 3d5n4jf2a
104+ 79b0uji60
105+ pcf9exi5g
106+ tx90dwi6w
107+ u0qfcw2hb
108+ ds88iqnsw
109+ 2ia1s623p
110+ 1bcru8hig
111+ 5sshn4khr
112+ 9ivzpka1m
113+ n3vxc9j7v
114+ t6evn0x15
115+ xtb7ejk2x
116+ jzowhvmfn
117+ 1a15ifimy
118+ 16f5wk3wg
119+ 8phllmc2g
120+ algx3osnk
121+ eejbrwtjf
122+ svjuctaix
123+ nmzhv1che
124+ 9phravp6a
125+ pjo3236az
126+ zdtch5wvm
127+ olwpmadwq
128+ oosxw38lq
129+ ccf5ha2f6
130+ 9u6tmxhsg
131+ 8uwbf2jsj
132+ fxuevlu97
133+ pd1aeo1wn
134+ p731m62yt
135+ d84boj36g
136+ 1z4t8492r
137+ ft2qi59n7
138+ d807oy13b
139+ ks2jzdn6l
140+ zdarbnlqw
141+ lq7o5ai9d
142+ k1sfr0g68
143+ tonfk9tz9
144+ ydii8sjta
145+ g9jn7bfb8
146+ h93ujq3te
147+ 75lj46n1u
148+ kxcoj73gs
149+ 370yg3fp2
150+ bjzq7a451
151+ db5ykml2w
152+ d2qflgw4k
153+ hes8v3asn
154+ ebt0ic9iy
155+ o4l215p31
156+ 0a4kc2zld
157+ ez8bjzy5v
158+ 3b1g5d8oi
159+ oobggx057
160+ p203tasho
161+ 7u6j7m5qw
162+ stbnkwu33
163+ sgpf6xiyk
164+ 6gd0v5rdt
165+ rd3ypbfb0
166+ mn3qtqtsg
167+ e2pu7kgne
168+ zup3mcpin
169+ ocvd586pd
170+ 77ali7nip
171+ s4qv5kfz7
172+ xtr9fulx1
173+ sc2kcve4j
174+ l4jdugez4
175+ 80s0mwdnz
176+ o57vts6gw
177+ unqar6rwq
178+ 3xl01wlpi
179+ 6uolx1fu2
180+ 2x7cveh1t
181+ 1qdhuzz8l
182+ b26tsrqyq
183+ ebbkqoj7d
184+ gaf1kxh2r
185+ y6sugvmhc
186+ 7k3igekka
187+ pnnyrx5up
188+ 9jeetttms
189+ ui6bdn6rj
190+ i0r72zw85
191+ 6bylsgtzc
192+ s5su7plet
193+ c6ke4pl9g
194+ rbprh6m6l
195+ a8ew2e39q
196+ bpz51z3bz
197+ vyum7atru
198+ dcksu3tb1
199+ j0jyyczuq
200+ 21va9yfqs
Original file line number Diff line number Diff line change 1+ # -*- coding: utf-8 -*-
2+ """
3+ 第 0002 题:将 0001 题生成的 200 个激活码(或者优惠券)保存到 MySQL 关系型数据库中。
4+ """
5+ import pymysql
6+ __author__ = 'Chris5641'
7+
8+
9+ def code2sql ():
10+ f = open ('ActivationCode.txt' , 'r' )
11+ conn = pymysql .connect (user = 'root' , passwd = 'password' )
12+ cursor = conn .cursor ()
13+ cursor .execute ('create database if not exists accode' )
14+ cursor .execute ('use accode' )
15+ cursor .execute ('create table accode(id int auto_increment primary key, code varchar(10))' )
16+ for line in f .readlines ():
17+ cursor .execute ('insert into accode (code) values (%s)' , [line .strip ()])
18+ conn .commit ()
19+ f .close ()
20+ cursor .close ()
21+ conn .close ()
22+
23+
24+ if __name__ == '__main__' :
25+ code2sql ()
You can’t perform that action at this time.
0 commit comments