CentOS 7.2 安装 python 读 mysql

来源：互联网发布：中央数据交换平台编辑：程序博客网时间：2024/06/05 23:29

1、系统自带python 2.7

2、安装mysql：

点击打开链接

3、安装 MySQLdb 库

yum install MySQL-python

在python客户端导入看是否报错：

import MySQLdb

4、自己先建一个users表：

import MySQLdbimport tornado.ioloopimport tornado.webcxn = 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()

0 0