Skip to content

Commit 7930980

Browse files
committed
add 002
1 parent 1abb8c8 commit 7930980

1 file changed

Lines changed: 50 additions & 2 deletions

File tree

‎jiangqideng/000.ipynb‎

Lines changed: 50 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -50,7 +50,7 @@
5050
},
5151
{
5252
"cell_type": "code",
53-
"execution_count": 89,
53+
"execution_count": 3,
5454
"metadata": {
5555
"collapsed": false
5656
},
@@ -59,7 +59,7 @@
5959
"name": "stdout",
6060
"output_type": "stream",
6161
"text": [
62-
"['ABRPXUCICCEGYMCMEHLPAODDRHNYNFCVMDGBVRHAFHEQHWBGIHHCFIMMRQGYJCQNADDIIIKUSKUCGADTXCWVMIUDWJUPGNCYTFEY', 'MLRXBBKIXWPVEGEQUBXONJAPWCHRXHOHJRLUITDWKFCGHUNIQRTAUIIXFFVUQDNFNVOCEYMCYDJMBMLDARXXCQGXBEKVFCXSKRJY', 'YXQTGAEDDTGXNTJJRRVBKJQSIWNWMQPAKAAFCHAARRHMFWOLRTFDEVCDXWKSVYEUPUGWBYGDUSOHHXNDRYLRJFIHPIDLICSCCKAP', 'LNWVNEXTKCDMGVLOWNMYXMPNIABJGOLGMYUUXGDSVKAXXHDKCWLMODORWGNTNQFKFTJXOXQQXLLYQWLVSXOLIOQEFTQMHSFADJKI', 'FXTBGBLQMDNYGUWGGTAJDKMIAOSPGJIEOHHRNKFMFVFIBPFMQOSITMTASIQQPTVENWOCQTPAJHBCPRBWXEJKRVINFITGATEEYYET']\n"
62+
"['DXJWBMUBRUJJEUWVYSXIQRAEKYKLCIGWTXQOFBAWSNMCIGBTXREFRPSJFPECCHMPEHJUCDVESOBKVMWLLHJSQVPWHJYULMJUSCNT', 'WHVQISBKMRJFKDQTSBFYALTJHBIBSNKWWPYXBSICUJMLNVUUTJPNLYBFBGVXKPFBGWPBXRUYXMWASUOOPPFWPNVPBNIDKGGYXJDT', 'LKWOJKYSMKIXTCSDUKRVNSTWGKEDMDGUWUEUJUFNNTLKHKWBWGVPNYIUQILXEDGLSLOPQFRDJAKVASORDLSRTOTOPYHAUYGFSDNS', 'DYGJWXUGOXYJMSVYCFNAMOARLPWCOJXCPQADFEDDWBQXNOUJHOPECNALKDNSSBNKDYODHYPEXOPBQGPWYESQOYKEFFQYSKAULPYW', 'VJDKKBVDETJXUEASFGUPENEVCNMTKLXYSTMBNQWKIOAPFLGAKHVYGLVRULEVLBPFTJUQDMDNQJROKBEPQSOXJCUHDDIXBBSQHXIO']\n"
6363
]
6464
}
6565
],
@@ -74,6 +74,54 @@
7474
"## 测试\n",
7575
"print gen_tickets(5, 100)"
7676
]
77+
},
78+
{
79+
"cell_type": "markdown",
80+
"metadata": {},
81+
"source": [
82+
"### 第0002题"
83+
]
84+
},
85+
{
86+
"cell_type": "code",
87+
"execution_count": 7,
88+
"metadata": {
89+
"collapsed": false
90+
},
91+
"outputs": [],
92+
"source": [
93+
"import numpy as np, string\n",
94+
"def gen_a_ticket(tickets_len):\n",
95+
" idx = np.random.randint(0, 25, tickets_len)\n",
96+
" letters = np.array(list(string.ascii_uppercase))\n",
97+
" s = letters[idx].tostring()\n",
98+
" yield s\n",
99+
"\n",
100+
"import MySQLdb\n",
101+
"db = MySQLdb.connect(\"localhost\", \"root\", \"******\", \"database_for_python\")\n",
102+
"cursor = db.cursor()\n",
103+
"cursor.execute(\"DROP TABLE IF EXISTS python_tickets\")\n",
104+
"sql = \"\"\"CREATE TABLE python_tickets(\n",
105+
" num INT,\n",
106+
" ticket_code CHAR(100))\"\"\"\n",
107+
"cursor.execute(sql)\n",
108+
"\n",
109+
"for i in range(1, 101):\n",
110+
" ticket = gen_a_ticket(100).next()\n",
111+
" sql = \"INSERT INTO python_tickets VALUES ('%d', '%s')\" % (i, ticket)\n",
112+
" cursor.execute(sql)\n",
113+
" db.commit()\n",
114+
"db.close()"
115+
]
116+
},
117+
{
118+
"cell_type": "code",
119+
"execution_count": null,
120+
"metadata": {
121+
"collapsed": true
122+
},
123+
"outputs": [],
124+
"source": []
77125
}
78126
],
79127
"metadata": {

0 commit comments

Comments
 (0)