毕业设计:2023-2024年计算机专业毕业设计选题汇总(建议收藏)
毕业设计:2023-2024年最新最全计算机专业毕设选题推荐汇总
🍅感兴趣的可以先收藏起来,点赞、关注不迷路,大家在毕设选题,项目以及论文编写等相关问题都可以给我留言咨询,希望帮助同学们顺利毕业 。🍅
1、项目介绍
技术栈:
Python语言、Flask框架、MySQL数据库、HTML、可视化大屏
2、项目界面
(1)数据可视化分析
(2)学历可视化分析
(3)热门岗位可视化分析
(4)招聘数据
(5)个人信息页面
(6)注册登录界面
3、项目说明
Flask招聘数据采集分析可视化系统是一个基于Flask框架开发的应用程序,旨在帮助用户高效地采集、分析和可视化招聘数据。
该系统具有以下主要功能和特点:
-
数据采集:系统能够自动从各大招聘网站抓取招聘信息,包括职位名称、公司名称、薪资待遇、工作地点等关键信息。用户可以根据自己的需求设置抓取的时间范围、关键词等参数。
-
数据分析:系统能够对采集到的数据进行多维度的分析,包括职位数量、薪资分布、热门行业等。用户可以通过图表和统计数据快速了解招聘市场的趋势和变化,并做出相应的决策。
-
可视化展示:系统提供丰富的可视化图表,如柱状图、饼图、折线图等,帮助用户直观地展示和比较不同指标之间的关系和变化趋势。用户可以根据自己的需求自定义图表样式和展示方式。
-
用户管理:系统支持用户注册、登录和权限管理,保护用户数据的安全性和隐私性。用户可以根据自己的角色和权限访问和管理系统的功能和数据。
-
可扩展性:系统基于Flask框架开发,具有良好的可扩展性和灵活性。用户可以根据自己的需求定制和扩展系统的功能和界面。
通过使用Flask招聘数据采集分析可视化系统,用户可以更加高效地获取和分析招聘数据,及时把握市场动态,为招聘决策提供有力支持。
4、核心代码
from flask import Flask,request,url_for, jsonify
import pymysql
from flask_cors import *
import pandas as pd
from collections import Counter
app = Flask(__name__)
app.config['JSON_AS_ASCII'] = False
CORS(app, supports_credentials=True)
from flask.json import JSONEncoder as _JSONEncoder
class JSONEncoder(_JSONEncoder):
def default(self, o):
import decimal
if isinstance(o, decimal.Decimal):
return float(o)
super(JSONEncoder, self).default(o)
app.json_encoder = JSONEncoder
@app.route('/page2',methods=['GET'])
def page2():
if(len(request.args)!=0):
data_year = request.args['year']
data_top = request.args['top']
sql = "SELECT `name`,box_office from films WHERE `year` = "+data_year+" ORDER BY box_office DESC LIMIT 0," +data_top
else:
sql = "SELECT sum(1),'老用户' from orders where left(`Order Date`,4) = '2014'" \
" UNION SELECT SUM(1),'新用户' from orders where left(`Order Date`,4) = '2017'"
conn = pymysql.connect(host='127.0.0.1', user='root', password='123456', port=3306, db='zhaopin',
charset='utf8')
cursor = conn.cursor()
cursor.execute(sql)
values = cursor.fetchall()
jsondata = {}
datas = []
for index,i in enumerate(values):
mydict = {}
mydict["value"] = i[0]
mydict["name"] = i[1]
datas.append(mydict)
jsondata['datas'] = datas
j = jsonify(jsondata)
cursor.close()
conn.close()
return j
@app.route('/page3',methods=['GET'])
def page3():
if(len(request.args)!=0):
data_type = request.args['type']
sql = "SELECT SUM(1) from orders where left(`Order Date`,4) = '2014' and `Category` LIKE '%" + data_type + "%' " \
" UNION SELECT SUM(1) from orders where left(`Order Date`,4) = '2015' and `Category` LIKE '%" + data_type + "%' " \
" UNION SELECT SUM(1) from orders where left(`Order Date`,4) = '2016' and `Category` LIKE '%" + data_type + "%' " \
" UNION SELECT SUM(1) from orders where left(`Order Date`,4) = '2017' and `Category` LIKE '%" + data_type + "%' "
else:
sql = "SELECT SUM(1) from search_data where education LIKE '%大专%'" \
" UNION SELECT SUM(1) from search_data where education LIKE '%本科%'" \
" UNION SELECT SUM(1) from search_data where education LIKE '%硕士%'" \
" UNION SELECT SUM(1) from search_data where education LIKE '%2年经验%'"
conn = pymysql.connect(host='127.0.0.1', user='root', password='123456', port=3306, db='zhaopin',
charset='utf8')
cursor = conn.cursor()
cursor.execute(sql)
values = cursor.fetchall()
jsondata = {}
xd = []
for index,i in enumerate(values):
xd.append(i[0])
jsondata['data'] = xd
j = jsonify(jsondata)
cursor.close()
conn.close()
return j
@app.route('/page4',methods=['GET'])
def page4():
data_year = ''
if(len(request.args)!=0):
data_year = request.args['year']
data_top = int(request.args['top'])
else:
data_top = 10
sql = "SELECT SUM(Discount) from orders where Region LIKE '%East%' " \
"UNION SELECT SUM(Discount) from orders where Region LIKE '%South%'" \
" UNION SELECT SUM(Discount) from orders where Region LIKE '%West%'" \
"UNION SELECT SUM(Discount) from orders where Region LIKE '%Central%'"
conn = pymysql.connect(host='127.0.0.1', user='root', password='123456', port=3306, db='zhaopin',
charset='utf8')
cursor = conn.cursor()
cursor.execute(sql)
values = cursor.fetchall()
jsondata = {}
xd = []
yd = ['East', 'South', 'West', 'Central']
datas = []
for index, i in enumerate(values):
mydict = {}
mydict["value"] = i[0]
mydict["name"] = yd[index]
datas.append(mydict)
xd.append(i[0])
jsondata['categories'] = yd
jsondata['data'] = xd
jsondata['datas'] = datas
j = jsonify(jsondata)
cursor.close()
conn.close()
return j
@app.route('/data',methods=['GET'])
def data():
limit = int(request.args['limit'])
page = int(request.args['page'])
page = (page-1)*limit
conn = pymysql.connect(host='127.0.0.1', user='root', password='123456', port=3306, db='zhaopin',
charset='utf8')
cursor = conn.cursor()
cursor.execute("select count(*) from search_data");
count = cursor.fetchall()
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
cursor.execute("select * from search_data limit "+str(page)+","+str(limit));
data_dict = []
result = cursor.fetchall()
for field in result:
data_dict.append(field)
table_result = {"code": 0, "msg": None, "count": count[0], "data": data_dict}
cursor.close()
conn.close()
return jsonify(table_result)
@app.route('/addUser',methods=['POST'])
def addUser():
get_json = request.get_json()
name = get_json['name']
password = get_json['password']
conn = pymysql.connect(host='127.0.0.1', user='root', password='123456', port=3306, db='zhaopin',
charset='utf8')
cursor = conn.cursor()
sql = "insert into `user` values(null,'"+name+"','"+password+"')"
cursor.execute(sql);
conn.commit()
table_result = {"code": 200, "msg": "成功"}
cursor.close()
conn.close()
return jsonify(table_result)
@app.route('/loginByPassword',methods=['POST'])
def loginByPassword():
get_json = request.get_json()
name = get_json['name']
password = get_json['password']
conn = pymysql.connect(host='127.0.0.1', user='root', password='123456', port=3306, db='zhaopin', charset='utf8')
cursor = conn.cursor()
cursor.execute("select count(*) from `user` where `name` = '" + name +"' and password = '" + password+"'");
count = cursor.fetchall()
if(count[0][0] != 0):
table_result = {"code": 200, "msg": "成功"}
else:
table_result = {"code": 500, "msg": "失败"}
cursor.close()
conn.close()
return jsonify(table_result)
if __name__ == "__main__":
app.run(port=5000)
源码获取:
🍅由于篇幅限制,获取完整文章或源码、代做项目的,查看我的【用户名】、【专栏名称】、【顶部选题链接】就可以找到我啦🍅
大家点赞、收藏、关注、评论啦 、查看👇🏻获取联系方式👇🏻