python 连接数据库

# Student.py 

#定义学生类
class Student:

    def __init__(self,name,email,age):
        self.name = name
        self.email = email
        self.age = age

    def __str__(self):
        return "Student:%s,%s,%s"%(self.name,self.email,self.age)

#sql_test.py


import pymysql
from mysql.Student import Student

#数据库连接
DBHOST = 'localhost'
DBUSER = 'root'
DBPASSWORD = '123456'
DBNAME = 'test4'

try:
    db = pymysql.connect(DBHOST,DBUSER,DBPASSWORD,DBNAME)
    print('数据库连接成功')
except pymysql.Error as e:
    print('数据库连接失败' + str(e))

#定位游标
cur = db.cursor()

#创建表
cur.execute('DROP TABLE IF EXISTS Student')
sqlQuery = 'create table Student(Name char(20) not NULL, Email char(20),Age int)'
cur.execute(sqlQuery)

#插入数据
sqlQuery = 'insert into Student(Name,Email,Age) value (%s,%s,%s)'
value =('marry','12345@qq.com',20)
cur.execute(sqlQuery,value)
db.commit()

#查询数据
sqlQuery = 'select * from student'
cur.execute(sqlQuery)
results = cur.fetchall()
student_list = []
for row in results:
    name = row[0]
    email = row[1]
    age = row[2]
    test_s = Student(name,email,age)
    student_list.append(test_s)

#打印数据
for ss in student_list:
    print(ss)

pass:

需要安装连接mysql 插件，命令行中输入，pip3 install pymysql