{"rsdb":{"rid":"352301","subhead":"","postdate":"0","aid":"250028","fid":"87","uid":"1","topic":"1","content":"<div id=\"cnblogs_post_body\" class=\"blogpost-body cnblogs-markdown\"> \n <h2 id=\"pymysql\u5b89\u88c5\">pymysql\u5b89\u88c5<\/h2> \n <p><code>pip install pymysql<\/code><\/p> \n <h2 id=\"\u94fe\u63a5\u6570\u636e\u5e93\u6267\u884csql\u5173\u95ed\u8fde\u63a5\">\u94fe\u63a5\u6570\u636e\u5e93\u3001\u6267\u884csql\u3001\u5173\u95ed\u8fde\u63a5<\/h2> \n <pre><code>import pymysql\nuser = input('\u8bf7\u8f93\u5165\u7528\u6237\u540d\u8bf7\u8f93\u5165\u5bc6\u7801:').strip()\npwd= input(&quot;\u8bf7\u8f93\u5165\u5bc6\u7801:&quot;).strip()\n\n# \u5efa\u7acb\u8fde\u63a5\nconn = pymysql.connect(\n    host = '192.168.1.1',\n    port = '3306',\n    user = 'root',\n    password = '123',\n    db = 'myTestDB',\n    charset = 'utf8',\n)\n\n# \u83b7\u53d6\u6e38\u6807\ncursor = conn.cursor()\n\n# \u6267\u884csql\u8bed\u53e5\n# sql = 'select * from USER_TABLE where user=&quot;%s&quot; and pwd=%s' % (user,pwd) \u81ea\u5df1\u62fc\u63a5sql\u8bed\u53e5\u6709\u5b89\u5168\u98ce\u9669\n# rows = cursor.excute(sql)\nsql = 'select * from USER_TABLE where user=&quot;%s&quot; and pwd=%s'\nrows = cursor.excute(sql,(user,pwd))\n\ncursor.close()\nconn.close()\n\nif rows:\n    print(&quot;\u767b\u5f55\u6210\u529f&quot;)\nelse:\n    print(&quot;\u767b\u5f55\u5931\u8d25&quot;)<\/code><\/pre> \n <h2 id=\"\u589e\u5220\u6539\u67e5\u64cd\u4f5c\">\u589e\u5220\u6539\u67e5\u64cd\u4f5c<\/h2> \n <h3 id=\"\u63d2\u5165\u6570\u636e\">\u63d2\u5165\u6570\u636e<\/h3> \n <pre><code>import pymysql\nuser = input('\u8bf7\u8f93\u5165\u7528\u6237\u540d\u8bf7\u8f93\u5165\u5bc6\u7801:').strip()\npwd= input(&quot;\u8bf7\u8f93\u5165\u5bc6\u7801:&quot;).strip()\n\n# \u5efa\u7acb\u8fde\u63a5\nconn = pymysql.connect(\n    host = '192.168.1.1',\n    port = '3306',\n    user = 'root',\n    password = '123',\n    db = 'myTestDB',\n    charset = 'utf8',\n)\n\n# \u83b7\u53d6\u6e38\u6807\ncursor = conn.cursor()\n\n\nsql = 'insert into USER_TABLE(user,pwd) values(%s,%s)'\n\n# \u63d2\u5165\u5355\u4e2a\u6570\u636e\nrows1 = cursor.excute(sql,(user,pwd))\n\n# \u63d2\u5165\u591a\u4e2a\u6570\u636e\nrows2 = cursor.excutemany(sql,[(user,pwd),('aaa','123'),('bbb','123')])\n# \u67e5\u770b\u63d2\u5165\u4e4b\u524d\u7684\u6570\u636e\u5e93\u6570\u91cf\nprint(cursor.lastrowid)\nconn.commit()\ncursor.close()\nconn.close()\n\n<\/code><\/pre> \n <h3 id=\"\u67e5\u627e\u6570\u636e\">\u67e5\u627e\u6570\u636e<\/h3> \n <pre><code>import pymysql\nuser = input('\u8bf7\u8f93\u5165\u7528\u6237\u540d\u8bf7\u8f93\u5165\u5bc6\u7801:').strip()\npwd= input(&quot;\u8bf7\u8f93\u5165\u5bc6\u7801:&quot;).strip()\n\n# \u5efa\u7acb\u8fde\u63a5\nconn = pymysql.connect(\n    host = '192.168.1.1',\n    port = '3306',\n    user = 'root',\n    password = '123',\n    db = 'myTestDB',\n    charset = 'utf8',\n)\n\n# \u83b7\u53d6\u6e38\u6807\ncursor = conn.cursor()\n\nsql = 'select * from USER_TABLE;'\n# \u67e5\u8be2\nrows  = cursor.excte(sql)\n\n# \u53d6\u5355\u4e2a\u6570\u636e\nsingle_data = cursor.fetchone()\n# \u53d6\u591a\u4e2a\u6570\u636e\nmultiple_data = cursor.fetchmany(2)\n# \u53d6\u51fa\u6240\u6709\u6570\u636e\nall_data = cursor.fetchall()\n# scroll \u7edd\u5bf9\u4f4d\u7f6e\u79fb\u52a8\ncursor.scroll(3,mode='absolute')\n# scroll \u76f8\u5bf9\u4f4d\u7f6e\u79fb\u52a8\ncursor.scroll(3,mode='relative')\n\nconn.commit()\ncursor.close()\nconn.close()\n<\/code><\/pre> \n<\/div>","orderid":"0","title":"pymysql\u6a21\u5757\u5e38\u7528\u64cd\u4f5c","smalltitle":"","mid":"0","fname":"Ruby","special_id":"0","bak_id":"0","info":"0","hits":"315","pages":"1","comments":"0","posttime":"2019-09-04 00:59:57","list":"1567529997","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"<A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=pymysql' target=_blank>pymysql<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%C4%A3%BF%E9' target=_blank>\u6a21\u5757<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%B3%A3%D3%C3' target=_blank>\u5e38\u7528<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%B2%D9%D7%F7' target=_blank>\u64cd\u4f5c<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"120.229.33.222","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"pymysql\u6a21\u5757\u5e38\u7528\u64cd\u4f5c","lastview":"1713477801","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}