python中操作数据库之pymysql

import pymysql

conn = pymysql.connect(host='127.0.0.1',port=3306,user='root',passwd='ljj83538301',db='test',charset='utf8')
cursor = conn.cursor()


# r为受影响的行数

# r = cursor.execute('insert into tb5(name) values ("刘晶晶")')#静态是数据
# 字符串拼接SQL，可以执行
"""
inp = input("请输入需要插入的人名")
sql = 'insert into tb5(name) values ("%s")'%inp
r = cursor.execute(sql)
"""
# 下面这种才是正常的，避免SQL注入
# inp = input("请输入需要插入的人名")
# r = cursor.execute('insert into tb5(name) values(%s)',inp)
# print(r)

# r = cursor.execute('insert into tb5(name,ager) values(%s,%s)',("ljj1",15))
"""
l=[("ljj1",15),("ljj2",15),("ljj3",15),("ljj4",15)]
r = cursor.executemany('insert into tb5(name,ager) values(%s,%s)',l)
"""
"""
r= cursor.execute('update tb5 set name = %s where nid = %s',('林俊杰',6))
"""
"""
r =  cursor.executemany('delete from tb5 where nid =%s',(6,))
"""
l=[("ljj1",15),("ljj2",15),("ljj3",15),("ljj4",15)]
r = cursor.executemany('insert into tb5(name,ager) values(%s,%s)',l)
conn.commit()
nid = cursor.lastrowid
print(nid)
print(r)
#
# result = cursor.fetchall()
# cursor.scroll(0,mode='absolute')
# result1 = cursor.fetchone()
# cursor.scroll(-1,mode='relative')
# result2 = cursor.fetchmany(3)
# print(result)
# print(result1)
# print(result2)





cursor.close()
conn.close()

conn = pymysql.connect(host='127.0.0.1',port=3306,user='root',passwd='ljj83538301',db='test',charset='utf8')是对数据库进行连接

cursor = conn.cursor()创建游标

inp = input("请输入需要插入的人名")
sql = 'insert into tb5(name) values ("%s")'%inp
r = cursor.execute(sql)
conn.commit()

增加：

# inp = input("请输入需要插入的人名")
# r = cursor.execute('insert into tb5(name) values(%s)',inp)
# print(r)

修改：

r= cursor.execute('update tb5 set name = %s where nid = %s',('林俊杰',6))

删除：

r =  cursor.executemany('delete from tb5 where nid =%s',(6,))

查询：

cursor.execute('select * from userinfo where username=%s and password=%s',('ljj',123))