数据库和python

pymysql 模块

1、连接数据库

import pymysql
conn = pymysql.connect(host='127.0.0.1',user = 'root',password ='123456',database = 'py27')
# # cur = conn.cursor(cursor=pymysql.cursors.DictCursor)     ##这样是返回字典
cur = conn.cursor() ####默认是取元组
cur.execute('select * from book')
print(cur.fetchone()) ###一条一条取
print(cur.fetchmany(2)) ####数字几返回几条数据
print(cur.fetchall()) ###显示所有
cur.close()
conn.close()

2、插入更新数据

import pymysql
conn = pymysql.connect(host='127.0.0.1',user = 'root',password ='123456',database = 'py27')
cur = conn.cursor()
cur.execute('insert into book values (你好,al,cehsi,100,2020-04-05)')
conn.commit()   ###提交或者修改都需要提交数据
cur.close()
conn.close()

3、以参数方式传递

import pymysql
num = input(>>>)
sql = 'select * from book where a = %s'
conn = pymysql.connect(host = '127.0.0.1',user = 'root',password = '123456',database= 'py27')
cur = conn.cursor()
cur.execute(sql,num) ###传递单个参数
#cur.excute(sql,(sql1,sql2,))  ####传递多个参数
print(cur.fetchall())
cur.close()
conn.close()

4、数据库增删改查封装

在这里插入代码片