|
50 | 50 | }, |
51 | 51 | { |
52 | 52 | "cell_type": "code", |
53 | | - "execution_count": 89, |
| 53 | + "execution_count": 3, |
54 | 54 | "metadata": { |
55 | 55 | "collapsed": false |
56 | 56 | }, |
|
59 | 59 | "name": "stdout", |
60 | 60 | "output_type": "stream", |
61 | 61 | "text": [ |
62 | | - "['ABRPXUCICCEGYMCMEHLPAODDRHNYNFCVMDGBVRHAFHEQHWBGIHHCFIMMRQGYJCQNADDIIIKUSKUCGADTXCWVMIUDWJUPGNCYTFEY', 'MLRXBBKIXWPVEGEQUBXONJAPWCHRXHOHJRLUITDWKFCGHUNIQRTAUIIXFFVUQDNFNVOCEYMCYDJMBMLDARXXCQGXBEKVFCXSKRJY', 'YXQTGAEDDTGXNTJJRRVBKJQSIWNWMQPAKAAFCHAARRHMFWOLRTFDEVCDXWKSVYEUPUGWBYGDUSOHHXNDRYLRJFIHPIDLICSCCKAP', 'LNWVNEXTKCDMGVLOWNMYXMPNIABJGOLGMYUUXGDSVKAXXHDKCWLMODORWGNTNQFKFTJXOXQQXLLYQWLVSXOLIOQEFTQMHSFADJKI', 'FXTBGBLQMDNYGUWGGTAJDKMIAOSPGJIEOHHRNKFMFVFIBPFMQOSITMTASIQQPTVENWOCQTPAJHBCPRBWXEJKRVINFITGATEEYYET']\n" |
| 62 | + "['DXJWBMUBRUJJEUWVYSXIQRAEKYKLCIGWTXQOFBAWSNMCIGBTXREFRPSJFPECCHMPEHJUCDVESOBKVMWLLHJSQVPWHJYULMJUSCNT', 'WHVQISBKMRJFKDQTSBFYALTJHBIBSNKWWPYXBSICUJMLNVUUTJPNLYBFBGVXKPFBGWPBXRUYXMWASUOOPPFWPNVPBNIDKGGYXJDT', 'LKWOJKYSMKIXTCSDUKRVNSTWGKEDMDGUWUEUJUFNNTLKHKWBWGVPNYIUQILXEDGLSLOPQFRDJAKVASORDLSRTOTOPYHAUYGFSDNS', 'DYGJWXUGOXYJMSVYCFNAMOARLPWCOJXCPQADFEDDWBQXNOUJHOPECNALKDNSSBNKDYODHYPEXOPBQGPWYESQOYKEFFQYSKAULPYW', 'VJDKKBVDETJXUEASFGUPENEVCNMTKLXYSTMBNQWKIOAPFLGAKHVYGLVRULEVLBPFTJUQDMDNQJROKBEPQSOXJCUHDDIXBBSQHXIO']\n" |
63 | 63 | ] |
64 | 64 | } |
65 | 65 | ], |
|
74 | 74 | "## 测试\n", |
75 | 75 | "print gen_tickets(5, 100)" |
76 | 76 | ] |
| 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": [] |
77 | 125 | } |
78 | 126 | ], |
79 | 127 | "metadata": { |
|
0 commit comments