pymysql

# __author: "ZXYang"
# date: 2020/5/31

# import pymysql
#
# conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='Zz0103', db='test02', charset='utf8')
#
# cursor = conn.cursor()
#
# cursor.execute('insert into tab11(caption) values("FF")')
#
# conn.commit()
#
# cursor.close()

# import pymysql
# conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='Zz0103', db='test02', charset='utf8')
# cursor = conn.cursor()
# cursor.execute('insert into tab11(caption) values("bb")')
# conn.commit()
# cursor.close()
# conn.close()

import pymysql

conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='Zz0103', db='test02', charset='utf8')
cursor = conn.cursor()
# cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)                                      # 设置游标类型  取值时设置取值类型
# r = cursor.execute('insert into tab11(caption) values("hhkk")')
# print(r)
# inp = input('请输入班级：')

# sql = 'insert into tab11(caption) values("%s")'
# sql = sql % (inp,)
# r = cursor.execute(sql)                                                                     # 导致sql注入

# r = cursor.execute('insert into tab11(caption) values(%s)', inp)                            # 参数传递  安全性高
# r = cursor.execute("insert into tab10(name,age,part_id) values(%s,%s,%s)", ('xx', 18, 1))
# l = [
#     ('zzz', 18, 2),
#     ('xxx', 18, 2),
#     ('yyy', 18, 2),
#     ('zxy', 18, 2)
# ]
# r = cursor.executemany("insert into tab10(name,age,part_id) values(%s,%s,%s)", l)            #  l 列表，批量《操作》
# print(r)
# r = cursor.execute("delete from tab11 where nid>%s", (3,))                                  #  删除
# r = cursor.execute("delete from tab11")                                                     #  execute 执行结果返回：受影响的行数
# print(r)

#   查询
# r = cursor.execute('select name as n,age as a from tab10')
# r = cursor.execute("select name,age from tab10")
# print(r)
# data1 = cursor.fetchone()                                                                      # 《取》 第一个
# print(data1)
# datas = cursor.fetchall()                                                                      # 取  查询的所有
# for i in datas:
#     print(i)
# print(datas)

# data = cursor.fetchone()
# print(data)
# data = cursor.fetchone()
# print(data)
# cursor.scroll(3, mode='absolute')                          # 绝对指针
# cursor.scroll(2, mode='relative')                       # 相对指针
# data = cursor.fetchone()
# print(data)


# r = cursor.execute('insert into tab11(caption) values(%s)', [('qq'), ('ww'), ('ee')])         # 执行多个 用： exxeutemany
# r = cursor.execute('insert into tab11(caption) values(%s)', ('kk'))
# conn.commit()
nid = cursor.lastrowid
print(nid)

conn.commit()
cursor.close()
conn.close()