{"id":2687,"date":"2023-09-06T18:02:48","date_gmt":"2023-09-06T10:02:48","guid":{"rendered":"https:\/\/www.tra56.com\/?p=2687"},"modified":"2023-09-06T18:02:48","modified_gmt":"2023-09-06T10:02:48","slug":"2687","status":"publish","type":"post","link":"https:\/\/www.tra56.com\/2687.html","title":{"rendered":"Python\u7edf\u8ba1\u65f6\u95f4\u5185\u7684\u5e76\u53d1\u6570\u4ee3\u7801\u5b9e\u4f8b"},"content":{"rendered":"<p style=\"margin-top: 0px; margin-bottom: 0px; padding: 3px 0px; outline: none; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, &quot;Microsoft YaHei&quot;; text-wrap: wrap; background-color: rgb(255, 255, 255);\">Python\u5b9e\u73b0\u5e76\u53d1\u7684\u624b\u6bb5\uff1a<\/p>\n<p style=\"margin-top: 0px; margin-bottom: 0px; padding: 3px 0px; outline: none; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, &quot;Microsoft YaHei&quot;; text-wrap: wrap; background-color: rgb(255, 255, 255);\">1\u3001\u64cd\u4f5c\u7cfb\u7edf\u63d0\u4f9b\uff1a\u8fdb\u7a0b\u3001\u7ebf\u7a0b\uff1b<\/p>\n<p style=\"margin-top: 0px; margin-bottom: 0px; padding: 3px 0px; outline: none; line-height: 30px; color: rgb(34, 34, 34); font-family: tahoma, arial, &quot;Microsoft YaHei&quot;; text-wrap: wrap; background-color: rgb(255, 255, 255);\">2\u3001\u7f16\u7a0b\u8bed\u8a00\u63d0\u4f9b\uff1a\u534f\u7a0b\uff1a\u7528\u6237\u7a7a\u95f4\u7684\u8c03\u5ea6\uff08py3\uff09\uff1b<\/p>\n<pre class=\"brush:python;toolbar:false\">#&nbsp;coding:utf-8\r\n\r\n#&nbsp;1.\u5bfc\u5165\u6a21\u5757\r\n#&nbsp;datatime\u6a21\u5757\u7528\u4e8e\u5b9a\u4e49\u65f6\u95f4\u53ca\u65f6\u95f4\u7684\u52a0\u51cf\u64cd\u4f5c\r\n#&nbsp;MySQLdb\u6a21\u5757\u7528\u4e8ePython2.0\u8fde\u63a5\u6570\u636e\u5e93\uff0cPython3.0\u8fde\u63a5\u6570\u636e\u5e93\u4f7f\u7528pymysql\r\n#&nbsp;xlwt\u6a21\u5757\u662fexcel\u64cd\u4f5c\u6a21\u5757\uff0c\u7528\u4e8e\u5c06\u6570\u636e\u5199\u5165excel\u4e2d\r\n\r\nimport&nbsp;datetime\r\nimport&nbsp;MySQLdb\r\nimport&nbsp;xlwt\r\n\r\n#&nbsp;2.\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u83b7\u53d6\u6570\u636e\r\n#&nbsp;MySQLdb.connect\u7528\u4e8e\u5b9a\u4e49\u8fde\u63a5\u6570\u636e\u5e93\u7684\u5c5e\u6027\r\n#&nbsp;myconn.cursor()\u5b9a\u4e49\u6e38\u6807\u5bf9\u8c61\r\n#&nbsp;query_sql\u5b9a\u4e49\u67e5\u8be2\u7684\u8bed\u53e5\r\n#&nbsp;mycursor.execute()\u6267\u884c\u67e5\u8be2\u8bed\u53e5\uff0c\u4ec5\u4ec5\u662f\u6267\u884c\u8bed\u53e5\uff0c\u4e0d\u8f93\u51fa\u7ed3\u679c\u3002\r\n#&nbsp;mycursor.fetchall()\u63d0\u53d6\u67e5\u8be2\u6570\u636e\u3002all\u5168\u90e8\u6570\u636e\uff0cone\u5355\u6761\u6570\u636e\uff0cmany\u53d6\u591a\u5c11\u6761\u6570\u636e\u3002fetchmany(10)\u53d610\u6761\u6570\u636e\u3002\r\n#&nbsp;mycursor.close()\u5173\u95ed\u6e38\u6807\r\n#&nbsp;myconn.close()\u5173\u95ed\u8fde\u63a5\r\n\r\nmyconn&nbsp;=&nbsp;MySQLdb.connect(host=&#39;1&#39;,user=&#39;wn&#39;,passwd=&#39;9eu&#39;,db=&#39;bs&#39;,charset=&#39;utf8&#39;)\r\nmycursor&nbsp;=&nbsp;myconn.cursor()\r\nquery_sql&nbsp;=&nbsp;&#39;&#39;&#39;\r\nselect&nbsp;JOIN_TIME,LEAVE_TIME&nbsp;from&nbsp;commfee&nbsp;where&nbsp;JOIN_TIME&nbsp;between&nbsp;&#39;2019-12-24&nbsp;15:00:00&#39;&nbsp;and&nbsp;&#39;2019-12-24&nbsp;15:30:00&#39;&nbsp;\r\n&#39;&#39;&#39;\r\n\r\nmycursor.execute(query_sql)\r\nsql_result&nbsp;=&nbsp;mycursor.fetchall()\r\nmycursor.close()\r\nmyconn.close()\r\n\r\n#&nbsp;3.\u5b9a\u4e49\u5168\u5c40\u53c2\u6570\r\n#&nbsp;sum1&nbsp;=&nbsp;[]\u5b9a\u4e49\u5217\u8868sum1,sum1\u7528\u4e8e\u751f\u6210\u6bd4\u8f83\u7684\u65f6\u95f4\u5217\u8868\r\n#&nbsp;sum2&nbsp;=&nbsp;[]\u5b9a\u4e49\u5217\u8868sum2,sum2\u7528\u4e8e\u751f\u6210\u5e76\u53d1\u6570\u7684\u5217\u8868\r\n\r\nsum1&nbsp;=&nbsp;[]\r\nsum2&nbsp;=&nbsp;[]\r\n\r\n#&nbsp;4.\u5b9a\u4e49\u6570\u636e\u7b5b\u9009\u51fd\u6570\r\n#&nbsp;compare_time&nbsp;\u6bd4\u8f83\u65f6\u95f4\uff0c\u6700\u5f00\u59cb\u503c\u53d6\u5f00\u59cb\u65f6\u95f4\u7684\u7b2c\u4e00\u4e2a\u503c\u3002\r\n#&nbsp;start_time&nbsp;=&nbsp;[sql_result[i][0]&nbsp;for&nbsp;i&nbsp;in&nbsp;range(0,len(sql_result))]\u5c06\u67e5\u8be2\u5230\u7684\u7ed3\u679c\u62c6\u5206\u4e3a\u4e24\u4e2a\u5217\u8868start_time\u548cend_time\u3002\r\n#&nbsp;compare_time&nbsp;&lt;&nbsp;start_time[len(sql_result)-1]\uff0ccompare_time\u65f6\u95f4\u548cstart_time\u5217\u8868\u4e2d\u7684\u65f6\u95f4\u6bd4\u8f83\r\n#&nbsp;compare_time&nbsp;+=&nbsp;datetime.timedelta(seconds=1)\uff0c\u6bcf\u6b21\u6bd4\u8f83\u540e\uff0ccompare_time\u65f6\u95f4+1\r\n#&nbsp;datetime.timedelta(seconds=1)\uff0ctimedelta(seconds=1)\u65f6\u95f4\u53d8\u53161s\r\n#&nbsp;sum1.append(compare_time),\u5c06\u5f97\u5230\u7684compare_time\u5199\u5165sum1\u5217\u8868\u4e2d\u3002\r\n\r\ndef&nbsp;query_data():\r\n&nbsp;&nbsp;compare_time&nbsp;=&nbsp;sql_result[0][0]\r\n&nbsp;&nbsp;start_time&nbsp;=&nbsp;[sql_result[i][0]&nbsp;for&nbsp;i&nbsp;in&nbsp;range(0,len(sql_result))]&nbsp;&nbsp;&nbsp;\r\n&nbsp;&nbsp;end_time&nbsp;=&nbsp;[sql_result[i][1]&nbsp;for&nbsp;i&nbsp;in&nbsp;range(0,len(sql_result))]\r\n&nbsp;&nbsp;while&nbsp;compare_time&nbsp;&lt;&nbsp;start_time[len(sql_result)-1]:\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;compare_time&nbsp;+=&nbsp;datetime.timedelta(seconds=1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;count1&nbsp;=&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;count2&nbsp;=&nbsp;0\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for&nbsp;time1&nbsp;in&nbsp;start_time:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;time1&nbsp;&lt;=&nbsp;compare_time:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;count1&nbsp;=&nbsp;count1&nbsp;+&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for&nbsp;time2&nbsp;in&nbsp;end_time:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;time2&nbsp;&lt;=&nbsp;compare_time:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;count2&nbsp;=&nbsp;count2&nbsp;-&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sum1.append(compare_time)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sum2.append(count1+count2)\r\n\r\n#&nbsp;5.\u5b9a\u4e49excel\u64cd\u4f5c\u51fd\u6570\r\n#&nbsp;xlwt.Workbook(encoding=&#39;utf-8&#39;)\u5b9a\u4e49\u7f16\u7801\u683c\u5f0f\r\n#&nbsp;wbk.add_sheet(&#39;My&nbsp;worksheet&#39;)\u5b9a\u4e49\u64cd\u4f5c\u7684sheet\u8868\r\n#&nbsp;xlwt.XFStyle()\u5b9a\u4e49\u5355\u5143\u683c\u683c\u5f0f\r\n#&nbsp;datastyle.num_format_str&nbsp;=&nbsp;&#39;yyyy-mm-dd&nbsp;hh:mm:ss&#39;\u5b9a\u4e49\u5355\u5143\u683c\u4e2d\u6570\u636e\u683c\u5f0f\r\n#&nbsp;worksheet.write(row,0,sum1[row],datastyle)&nbsp;\u6309\u5b9a\u4e49\u7684\u683c\u5f0f\u5199\u5165\u6570\u636e\r\n#&nbsp;wbk.save()\u4fdd\u5b58\u64cd\u4f5c\u7684excel\u8868\u683c\u3002\r\n\r\ndef&nbsp;re_sheet():&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n&nbsp;&nbsp;wbk&nbsp;=&nbsp;xlwt.Workbook(encoding=&#39;utf-8&#39;)\r\n&nbsp;&nbsp;worksheet&nbsp;=&nbsp;wbk.add_sheet(&#39;My&nbsp;worksheet&#39;)\r\n&nbsp;&nbsp;datastyle&nbsp;=&nbsp;xlwt.XFStyle()\r\n&nbsp;&nbsp;datastyle.num_format_str&nbsp;=&nbsp;&#39;yyyy-mm-dd&nbsp;hh:mm:ss&#39;\r\n&nbsp;&nbsp;for&nbsp;row&nbsp;in&nbsp;range(0,len(sum1)):&nbsp;&nbsp;&nbsp;&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;worksheet.write(row,0,sum1[row],datastyle)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;worksheet.write(row,1,sum2[row])&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r\n&nbsp;&nbsp;wbk.save(&#39;Concurrency.xls&#39;)&nbsp;&nbsp;\r\nquery_data()&nbsp;&nbsp;&nbsp;\r\nre_sheet()<\/pre>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Python\u5b9e\u73b0\u5e76\u53d1\u7684\u624b\u6bb5\uff1a 1\u3001\u64cd\u4f5c\u7cfb\u7edf\u63d0\u4f9b\uff1a\u8fdb\u7a0b\u3001\u7ebf\u7a0b\uff1b 2\u3001\u7f16\u7a0b\u8bed\u8a00\u63d0\u4f9b\uff1a\u534f\u7a0b\uff1a\u7528\u6237\u7a7a\u95f4\u7684\u8c03\u5ea6\uff08py3\uff09 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-2687","post","type-post","status-publish","format-standard","hentry","category-python3"],"_links":{"self":[{"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/posts\/2687"}],"collection":[{"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/comments?post=2687"}],"version-history":[{"count":1,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/posts\/2687\/revisions"}],"predecessor-version":[{"id":2688,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/posts\/2687\/revisions\/2688"}],"wp:attachment":[{"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/media?parent=2687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/categories?post=2687"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/tags?post=2687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}