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() '''
数据库pymsql之使用简单登陆注册功能实现
最新推荐文章于 2023-05-07 17:35:42 发布