python连接数据库

import pymysql;
#1.连接数据库
conn = pymysql.connect(
    host='localhost',
    user='root',
    password='***',#密码
    db='jiang', #数据库名
    charset='utf8',
)
#2.创建游标对象
cur = conn.cursor()
#3.对数据库进行CRUD操作
try:
    create_sqli = "create table hello (id int, name varchar(30));"
    cur.execute(create_sqli)
except Exception as e:
    print("创建数据表失败:", e)
else:
    print("创建数据表成功;")
#
try:
    insert_sqli = "insert into hello values(1, '杨将');"
    cur.execute(insert_sqli)
except Exception as e:
    print("插入数据失败:", e)
else:
    conn.commit()
    print("插入数据成功;")
# 4. 关闭游标
cur.close()
# 5. 关闭连接
conn.close()

　　pyton连接数据库需要先安装pymysql模块：pip install pymysql
安装完成后导入pymysql模块：import pymysql