目的是想做一个完整的登录项目,但是出了一些很奇怪的bug

就是你输入信息之后,就只返回了一个服务器的信息如何也不打印‘注册成功’,也没有报错

点登录后,原网页也就刷新了一下

源码如下,不知道哪里错了
login.py
from flask import app,Flask,render_template,redirect,request
import pymysql
app=Flask(__name__)
@app.route('/login',methods=['GET','POST'])
def user_login():
if request.method=='GET':
return render_template('login.html')
username = request.args.get('user')
password = request.args.get('pwd')
conn=pymysql.connect(host='localhost',user='root',password='123',charset='utf8',db='unicom')
cursor=conn.cursor()
cursor.execute('''
CREATE TABLE IF NOT EXISTS info (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(255) NOT NULL UNIQUE,
password VARCHAR(255) NOT NULL
)
''')
try:
cursor.execute("INSERT INTO info (username, password) VALUES (%s, %s)", (username, password))
conn.commit()
return '注册成功'
except pymysql.Error as e:
print(f"Error: {e}")
return str(e)
finally:
cursor.close()
conn.close()
if __name__=='__main__':
app.run()
login.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>登录</title>
<!-- 最新版本的 Bootstrap 核心 CSS 文件 -->
<link rel="stylesheet" href="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/3.4.1/css/bootstrap.min.css" integrity="sha384-HSMxcRTRxnN+Bdg0JdbxYKrThecOKuH5zCYotlSAcp1+c8xmyTe9GYg1l9a69psu" crossorigin="anonymous">
<style>
.account {
width: 500px;
height: 350px;
border: 1px solid #dddddd;
border-radius: 7px;
margin-left: auto;
margin-right: auto;
margin-top: 200px;
padding: 10px 50px;
box-shadow: 5px 5px 5px #aaaaaa;
}
.account h2 {
text-align: center;
}
</style>
</head>
<body>
<nav class="navbar navbar-default">
<div class="container-fluid">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse"
data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">XX导航</a>
</div>
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<li class="active"><a href="#">Link <span class="sr-only">(current)</span></a></li>
<li><a href="#">Link</a></li>
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true"
aria-expanded="false">Dropdown <span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="#">Action</a></li>
<li><a href="#">Another action</a></li>
<li><a href="#">Something else here</a></li>
<li role="separator" class="divider"></li>
<li><a href="#">Separated link</a></li>
<li role="separator" class="divider"></li>
<li><a href="#">One more separated link</a></li>
</ul>
</li>
</ul>
<form class="navbar-form navbar-left">
<div class="form-group">
<input type="text" class="form-control" placeholder="Search">
</div>
<button type="submit" class="btn btn-default">Submit</button>
</form>
<ul class="nav navbar-nav navbar-right">
<li><a href="#">Link</a></li>
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true"
aria-expanded="false">Dropdown <span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="#">Action</a></li>
<li><a href="#">Another action</a></li>
<li><a href="#">Something else here</a></li>
<li role="separator" class="divider"></li>
<li><a href="#">Separated link</a></li>
</ul>
</li>
</ul>
</div><!-- /.navbar-collapse -->
</div><!-- /.container-fluid -->
</nav>
<div class="account">
<h2 class="strong">用户登录</h2>
<form>
<form>
<div class="form-group">
<label for="exampleInputEmail1">用户名</label>
<input type="email" name="user" class="form-control" id="exampleInputEmail1" placeholder="请输入用户名">
</div>
<div class="form-group">
<label for="exampleInputPassword1">密码</label>
<input type="password" name="pwd" class="form-control" id="exampleInputPassword1" placeholder="密码">
</div>
<div>
<label for="exampleInputPassword1">图片验证码</label>
<input type="text" class="form-control" placeholder="请输入图片验证码">
</div>
<br>
<button type="submit" class="btn btn-primary">登 录</button>
</form>
</div>
<script src="https://cdn.bootcdn.net/ajax/libs/jquery/3.7.1/jquery.min.js"></script>
<!-- 最新的 Bootstrap 核心 JavaScript 文件 -->
<script src="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/3.4.1/js/bootstrap.min.js" integrity="sha384-aJ21OjlMXNL5UyIl/XNwTMqvzeRMZH2w8c5cRVpzpU8Y5bApTppSuUkhZXN0VxHd" crossorigin="anonymous"></script>
</body>
</html>