Python 常用操作

最新推荐文章于 2022-06-15 19:48:01 发布

BusyMonkey

最新推荐文章于 2022-06-15 19:48:01 发布

阅读量790

点赞数 1

分类专栏： Python 文章标签： python

本文链接：https://blog.csdn.net/Dopamy_BusyMonkey/article/details/70260192

版权

Python 专栏收录该内容

25 篇文章 0 订阅

订阅专栏

1、发送Get请求，文件保存

#!/usr/bin/python3

import urllib.request

data = dict()
data['code'] = '0600804'
data['start'] = '20200101'
data['end'] = '20200404'

url_param = urllib.parse.urlencode(data)
url = "http://quotes.money.163.com/service/chddata.html?"
all_url = url + url_param

data = urllib.request.urlopen(all_url).read()
record = data.decode('ANSI')
record = record.replace('\r\n','\r').replace("'",'')

f = open('test.csv', 'w')
f.write(record)
f.close()

2、操作MySql

import MySQLdb
import tornado.ioloop
import tornado.web

cxn = MySQLdb.Connect(host = '127.0.0.1', user = 'root', passwd = '')

class Test(tornado.web.RequestHandler):
    def get(self):
        result = ""
        cur = cxn.cursor()
        cur.execute("USE test")
        cur.execute("SELECT * FROM users")
        for row in cur.fetchall():
            result += row.__str__()
        print(result)
        self.write(result)

class Login(tornado.web.RequestHandler):
    def get(self):
        userName = self.get_argument('userName','hello')
        passWord = self.get_argument('passWord','hello')
        sql = "SELECT * FROM users WHERE username='%s'" %(userName)
        cur = cxn.cursor()
        cur.execute("USE test")
        cur.execute(sql)
        result = cur.fetchall()
        cur.close()
        cxn.commit()
        if result[0][2] == passWord:
            self.write("1")
        else:
            self.write("0")

application = tornado.web.Application([
    (r"/test", Test), (r"/login", Login)
])

if __name__=="__main__":
    application.listen(8888)
    tornado.ioloop.IOLoop.instance().start()
    cxn.close()