pymysql的使用3

import pymysql

print('连接数据库...')
conn = pymysql.connect(
    host = "localhost",
    user = "root",
    password = "",
    database = "s23",
    port = 3306,
    charset = 'utf8'
)
print('连接成功',conn)
#cursor 游标对象
cur = conn.cursor()
# 修改操作
name = input('输入要添加的用户名：')
password = input('输入该用户的密码')
sql = 'insert into user (username,pwd) value (%s,%s)'
# %s不用加"",也不用自己拼接了
print(sql)
retnum = cur.execute(sql,[name,password])
# 把需要的参数写在execute里
print(retnum)#受影响的行数
if retnum:
    print('修改成功')
else:
    print('修改失败')
#这里虽然retnum有值，但是再查询发现没有插入数据
#增加，删除，修改之后要commit
# 否则修改不生效
conn.commit()
query = 'select * from user '
ret = cur.execute(query)
result = cur.fetchall()
#fetch 用来获取数据
#fetchone 、 fetchmany 、 fetchall
print(result)

cur.close()
cur2 = conn.cursor(cursor=pymysql.cursors.DictCursor)
#以字典形式获取 cursor=pymysql.cursors.DictCursor
cur2.execute(query)
retsult2 = cur2.fetchall()
print(retsult2)
conn.close()