数据库pymsql之使用简单登陆注册功能实现

import pymysql

conn = pymysql.connect(
    host='127.0.0.1',
    port=3306,
    user='root',
    passwd='000',
    database='day02',
    charset='utf8',
    autocommit=True #自动二次确认

)  # 连接数据库

cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)  # 将查询结果以字典返回
#增加数据
'''
sql = "insert into userinfo(username,passwd) values (%s,%s)"
try:
    cursor.execute(sql,('loky',123))
    print('插入数据成功')
except Exception as e:
    print(e)
finally:
    cursor.close()
    conn.close()
'''
# #修改
#
# sql = "update userinfo set username='loky' where id=3"
# cursor.execute(sql)
# conn.commit()
#
# cursor.executemany(sql,[(),(),()])
#
#
# #删除
#
# sql = "delete from userinfo where id=1"
#
# cursor.execute(sql)
# conn.commit()

#登陆注册功能----------------数据库pymysql
'''def login():
    while True:
        username = input('请输入用户名：').strip()
        password = input('请输入密码：').strip()
        re_passwd = input('请再次输入密码：').strip()
        if password==re_passwd:
            sql = 'select * from userinfo where username=%s and passwd=%s'
            row_res = cursor.execute(sql,(username,int(re_passwd)))
            if  row_res:
                print('登陆成功！')
                break
            else:
                print('失败')
        else:
            print('两次输入的密码不一致！请重新输入！')
            continue
def register():
    username=input('请输入注册的用户名：').strip()
    password = input('请输入密码：').strip()
    re_passwd = input('请再次输入密码：').strip()
    if password == re_passwd:
        sql = "insert into userinfo(username,passwd) values (%s,%s)"
        row_res = cursor.execute(sql, (username, re_passwd))
        if row_res:
            print('注册成功！')
            print('返回登陆功能！')
            login()



        # cursor.close()
        # conn.close()
func_dic={
        '1': login,
        '2':register

    }

def main():

    while True:
        print("""
            注册登陆功能表：
                    1.登陆
                    2.注册
        """)

        func_choice = input('请输入你要使用的功能：').strip()
        if func_choice not in func_dic:
            print('请输入正确的功能编号！')
            continue

        func_dic.get(func_choice)()

if __name__ == '__main__':
    main()
    '''