大家好，我是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='注冊失敗，請聯系管理員!')運行測試：
