2 3 4 5
login 6 7 8 9
username:
10 password:
11 登录 12 14 15 16 注册页面:1 2 3 4 5login 6 7 8 9 10 11 12 13
username:
14 password:
15 注册 16 18 19 20 21 数据库代码import mysql.connector 3 import cx 4 listdataname=[]; 5 listdatapassword=[]; 6 print(cx.usernamer); 7 conn = mysql.connector.connect(user='root', password='123456', database='test') 8 #cursor = conn.cursor() 9 #usernamerr=cx.usernamer[0] 10 #userpasswordrr=cx.userpasswordr[0] 11 #cursor.execute('insert into userstest (username, userpassword) values (%s, %s)', (usernamerr,userpasswordrr )) 12 #conn.commit() 13 #cursor.close() 14 15 cursor = conn.cursor() 16 cursor.execute('select * from userstest ') 17 values = cursor.fetchall() 18 cursor.close() 19 conn.close() 20 for data in values: 21 name=data[1] 22 password=data[2] 23 24 listdataname.append(name); 25 listdatapassword.append(password) 26 print(listdataname) 27 登录注册方法程序: 1 listdataname=[1]*1000; 2 listdatapassword=[1]*1000; 3 usernamer=[1]*10 4 userpasswordr=[1]*10 5 flag=1 6 import mysql.connector 7 from flask import Flask 8 from flask import render_template, redirect,url_for 9 from flask import request,json 10 #import denglusjk 11 conn = mysql.connector.connect(user='root', password='123456', database='test') 12 cursor = conn.cursor() 13 app = Flask(__name__) 14 @app.route('/reglizi', methods=['POST','GET']) 15 def reg(): 16 global cursor 17 global flag; 18 global usernamer 19 global userpasswordr 20 error = None; 21 print (len(usernamer)) 22 print (len(userpasswordr)) 23 if request.method == 'POST': 24 usernamer[0]=(request.form['username']) 25 userpasswordr[0]=(request.form['password']) 26 cursor.execute('insert into userstest (username, userpassword) values (%s, %s)', (usernamer[0],userpasswordr[0] )) 27 conn.commit() 28 #cursor.close() 29 cursor = conn.cursor() 30 print (cursor) 31 flag+=1; 32 print(usernamer[0]) 33 print(userpasswordr[0]) 34 print (flag) 35 return render_template('register.html', error=error) 36 @app.route('/loginlizi', methods=['POST','GET']) 37 def login(): 38 global conn 39 global listdataname 40 global listdatapassword 41 42 print("has start"); 43 error = None; 44 #cursor = conn.cursor() 45 # print(cursor) 46 # cursor.execute('select * from userstest ') 47 # cursor = conn.cursor() 48 # row = cursor.fetchone() 49 #while row: 50 # print( row ) 51 # row = cursor.fetchone() 52 # listdataname.append(row[1]) 53 # listdatapassword.append(row[2]) 54 # row = cursor.fetchone() 55 # cursor.close() 56 # values = cursor.fetchall() 57 58 #values = cursor.fetchall() 59 # cursor.close() 60 #conn.close() 61 #for data in values: 62 # name=data[1] 63 #password=data[2] 64 #denglusjk.listdataname.append(name) 65 # $denglusjk.listdatapassword.append(password) 66 # print(denglusjk.listdataname) 67 for i in range(len(usernamer)): 68 if request.method == 'POST': 69 print("has cation post"); 70 print(usernamer[i]) 71 if request.form['username']==usernamer[i] and request.form['password']==userpasswordr[i]: 72 return render_template('home.html',username=request.form['username']) 73 return render_template('login.html', error=error) 74 i 75 if __name__ == '__main__': 76 77 app.run(host='10.0.30.171')
10 password:
11 登录 12 14 15 16 注册页面:1 2 3 4 5
14 password:
15 注册 16 18 19 20 21 数据库代码import mysql.connector 3 import cx 4 listdataname=[]; 5 listdatapassword=[]; 6 print(cx.usernamer); 7 conn = mysql.connector.connect(user='root', password='123456', database='test') 8 #cursor = conn.cursor() 9 #usernamerr=cx.usernamer[0] 10 #userpasswordrr=cx.userpasswordr[0] 11 #cursor.execute('insert into userstest (username, userpassword) values (%s, %s)', (usernamerr,userpasswordrr )) 12 #conn.commit() 13 #cursor.close() 14 15 cursor = conn.cursor() 16 cursor.execute('select * from userstest ') 17 values = cursor.fetchall() 18 cursor.close() 19 conn.close() 20 for data in values: 21 name=data[1] 22 password=data[2] 23 24 listdataname.append(name); 25 listdatapassword.append(password) 26 print(listdataname) 27 登录注册方法程序: 1 listdataname=[1]*1000; 2 listdatapassword=[1]*1000; 3 usernamer=[1]*10 4 userpasswordr=[1]*10 5 flag=1 6 import mysql.connector 7 from flask import Flask 8 from flask import render_template, redirect,url_for 9 from flask import request,json 10 #import denglusjk 11 conn = mysql.connector.connect(user='root', password='123456', database='test') 12 cursor = conn.cursor() 13 app = Flask(__name__) 14 @app.route('/reglizi', methods=['POST','GET']) 15 def reg(): 16 global cursor 17 global flag; 18 global usernamer 19 global userpasswordr 20 error = None; 21 print (len(usernamer)) 22 print (len(userpasswordr)) 23 if request.method == 'POST': 24 usernamer[0]=(request.form['username']) 25 userpasswordr[0]=(request.form['password']) 26 cursor.execute('insert into userstest (username, userpassword) values (%s, %s)', (usernamer[0],userpasswordr[0] )) 27 conn.commit() 28 #cursor.close() 29 cursor = conn.cursor() 30 print (cursor) 31 flag+=1; 32 print(usernamer[0]) 33 print(userpasswordr[0]) 34 print (flag) 35 return render_template('register.html', error=error) 36 @app.route('/loginlizi', methods=['POST','GET']) 37 def login(): 38 global conn 39 global listdataname 40 global listdatapassword 41 42 print("has start"); 43 error = None; 44 #cursor = conn.cursor() 45 # print(cursor) 46 # cursor.execute('select * from userstest ') 47 # cursor = conn.cursor() 48 # row = cursor.fetchone() 49 #while row: 50 # print( row ) 51 # row = cursor.fetchone() 52 # listdataname.append(row[1]) 53 # listdatapassword.append(row[2]) 54 # row = cursor.fetchone() 55 # cursor.close() 56 # values = cursor.fetchall() 57 58 #values = cursor.fetchall() 59 # cursor.close() 60 #conn.close() 61 #for data in values: 62 # name=data[1] 63 #password=data[2] 64 #denglusjk.listdataname.append(name) 65 # $denglusjk.listdatapassword.append(password) 66 # print(denglusjk.listdataname) 67 for i in range(len(usernamer)): 68 if request.method == 'POST': 69 print("has cation post"); 70 print(usernamer[i]) 71 if request.form['username']==usernamer[i] and request.form['password']==userpasswordr[i]: 72 return render_template('home.html',username=request.form['username']) 73 return render_template('login.html', error=error) 74 i 75 if __name__ == '__main__': 76 77 app.run(host='10.0.30.171')
本文来自 言寡 的CSDN 博客 ,全文地址请点击:https://blog.csdn.net/qq_21406125/article/details/79235183?utm_source=copy