Wangzi_Python 8.30---Python与数据库的交互

import pymysql

# 获取连接对象 ip port user password db utf-8
db_config = {
    'host':'******',
    'port': 3306,
    'user': '******',
    'password':'******',
    'db':'wangzi',
    'charset':'utf8',
    }
#获取连接对象 ip port user password db utf-8
con = pymysql.connect(**db_config)  #**拆成键值对的形式
#游标对象- ---C里面的指针
cur = con.cursor()
try:
    sql = "select * from students"
    # sql = "insert into students value(0,'wangzi0',1)"


    rv = cur.execute(sql)  #帮我们执行
    # print(cur.fetchone())
    # print(cur.fetchmany(3))#元组形式展示结果
    a = cur.fetchall() #少用 内存
    print(a)

except Exception as e:
    print(e)
    con.rollback()
else:
    con.commit()
finally:
    cur.close()
    con.close()