tornado数据库:
db = pymysql.Connection(host="47.98.254.167", user="shao", password="1111", database="tornado_test1",
charset="utf8",
port=3306)
class StuHandler(tornado.web.RequestHandler):
def get(self, *args, **kwargs):
cur = db.cursor()
sql = 'select * from stu'
str1 = cur.execute(sql)
# db.commit()
print(cur.fetchall())
print(type(cur.fetchone()))
self.write('数据插入成功\n')