大家好，我是java1234_小锋老师，最近写了一套【NLP舆情分析】基于python微博舆情分析可视化系统(flask+pandas+echarts)视频教程，持续更新中，计划月底更新完，感谢支持。今天讲解用户注册实现
视频在线地址：
2026版【NLP舆情分析】基于python微博舆情分析可视化系统(flask+pandas+echarts+爬虫) 视频教程 （火爆连载更新中..）_哔哩哔哩_bilibili
课程简介：
本课程采用主流的Python技术栈实现，Mysql8数据库，Flask后端，Pandas数据分析，前端可视化图表采用echarts，以及requests库，snowNLP进行情感分析，词频统计，包括大量的数据统计及分析技巧。
实现了，用户登录，注册，爬取微博帖子和评论信息，进行了热词统计以及舆情分析，以及基于echarts实现了数据可视化，包括微博文章分析，微博IP分析，微博评论分析，微博舆情分析。最后也基于wordcloud库实现了词云图，包括微博内容词云图，微博评论词云图，微博评论用户词云图等功能。
用户注册实现
我们再来实现下注册功能。
首先提供下前端静态网页模版register.html，放到templates下
<!doctype html>
<html lang="en">
<head><meta charset="utf-8"><meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"><title>用户注册</title><link rel="shortcut icon" href="{{ url_for('static', filename='favicon.ico') }}" type="image/x-icon"><link rel="stylesheet" href="/static/css/backend-plugin.min.css"><link rel="stylesheet" href="/static/css/backend.css">
</head>
<body class=" ">
<!-- loader Start -->
<div id="loading"><div id="loading-center"></div>
</div>
<!-- loader END --><div class="wrapper"><section class="login-content"><div class="container h-100"><div class="row align-items-center justify-content-center h-100"><div class="col-md-5"><div class="card p-3"><div class="card-body"><div class="auth-logo"><img src="/static/picture/logo.png" class="img-fluid rounded-normal darkmode-logo"alt="logo"><img src="/static/picture/logo-dark.png" class="img-fluid rounded-normal light-logo"alt="logo"></div><h3 class="mb-3 font-weight-bold text-center">用户注册</h3><div class="mb-5"><p class="line-around text-secondary mb-0"><spanclass="line-around-1">微博舆情分析管理系统</span></p></div><form><div class="row"><div class="col-lg-12"><div class="form-group"><label class="text-secondary">用户名：</label><input class="form-control" id="username" name="username" type="text"placeholder="请输入用户名..."></div></div><div class="col-lg-12 mt-2"><div class="form-group"><div class="d-flex justify-content-between align-items-center"><label class="text-secondary">密码：</label></div><input class="form-control" id="password" name="password" type="password"placeholder="请输入密码..."></div></div><div class="col-lg-12 mt-2"><div class="form-group"><div class="d-flex justify-content-between align-items-center"><label class="text-secondary">确认密码：</label></div><input class="form-control" id="password2" name="password2" type="password"placeholder="请输入确认密码..."></div></div></div><button type="button" onclick="submitForm()" class="btn btn-primary btn-block mt-2">登录</button><div class="col-lg-12 mt-3"><p class="mb-0 text-center"><font id="info" color="red"></font> 已有账号?<ahref="/user/login">用户登录</a></p></div></form></div></div></div></div></div></section>
</div>
<script>function submitForm() {let username = $("#username").val()let password = $("#password").val()let password2 = $("#password2").val()if (username == "") {$("#info").text("用户名不能为空!")return false;}if (password == "") {$("#info").text("密码不能为空!")return false;}if (password2 == "") {$("#info").text("确认密码不能为空!")return false;}if (password != password2) {$("#info").text("确认密码不正确!")return false;}$.post('/user/register', {'username': username,'password': password,'password2': password2}, function (result) {if (result.error) {$("#info").text(result.info)} else {$("#info").text("注册成功!")}})}
</script>
<!-- Backend Bundle JavaScript -->
<script src="/static/js/backend-bundle.min.js"></script>
<!-- Chart Custom JavaScript -->
<script src="/static/js/customizer.js"></script><script src="/static/js/sidebar.js"></script><!-- Flextree Javascript-->
<script src="/static/js/flex-tree.min.js"></script>
<script src="/static/js/tree.js"></script><!-- Table Treeview JavaScript -->
<script src="/static/js/table-treeview.js"></script><!-- SweetAlert JavaScript -->
<script src="/static/js/sweetalert.js"></script><!-- Vectoe Map JavaScript -->
<script src="/static/js/vector-map-custom.js"></script><!-- Chart Custom JavaScript -->
<script src="/static/js/chart-custom.js"></script>
<script src="/static/js/01.js"></script>
<script src="/static/js/02.js"></script><!-- slider JavaScript -->
<script src="/static/js/slider.js"></script><!-- Emoji picker -->
<script src="/static/js/index.js" type="module"></script><!-- app JavaScript -->
<script src="/static/js/app.js"></script>
</body>
</html>userDao.py里实现add()注册添加用户方法以及判断用户名是否重复的getByUserName()方法：
def add(user: User):"""注册添加用户:param user::return:"""con = Nonetry:con = dbUtil.getCon()cursor = con.cursor()cursor.execute(f"insert into t_user values(null,'{user.username}','{user.password}','{user.createtime}')")return cursor.fetchone()except Exception as e:print(e)con.rollback()return Nonefinally:dbUtil.closeCon(con)
def getByUserName(username):"""根据用户名查询用户信息:param username::return:"""con = Nonetry:con = dbUtil.getCon()cursor = con.cursor()sql = "SELECT username from t_user"if username != None and username != '':sql += f" where username='{username}'"print(sql)cursor.execute(sql)return cursor.rowcountexcept Exception as e:print(e)con.rollback()return Nonefinally:dbUtil.closeCon(con)user.py里实现用户注册业务逻辑方法register()
@ub.route('/register', methods=['GET', 'POST'])
def register():"""用户注册:return:"""if request.method == 'GET':return render_template('register.html')else:username = request.values.get('username')password = request.values.get('password')password2 = request.values.get('password2')if username is None or username.strip() == '':return jsonify(error=True, info='用户名不能为空!')if password is None or password.strip() == '':return jsonify(error=True, info='密码不能为空!')if password2 is None or password2.strip() == '':return jsonify(error=True, info='确认密码不能为空!')if password != password2:return jsonify(error=True, info='确认密码不正确!')# 检查用户名重复if len(userDao.getByUserName(username)):return jsonify(error=True, info='该用户名已存在!')else:user = User(username, MD5Utility.encrypt(password))user.createtime = datetime.now()if userDao.add(user) > 0:return jsonify(success=True, info='OK')else:return jsonify(error=True, info='注册失败，请联系管理员!')运行测试：
