毕业设计:2023-2024年计算机专业毕业设计选题汇总(建议收藏)
毕业设计:2023-2024年最新最全计算机专业毕设选题推荐汇总
🍅感兴趣的可以先收藏起来,点赞、关注不迷路,大家在毕设选题,项目以及论文编写等相关问题都可以给我留言咨询,希望帮助同学们顺利毕业 。🍅
1、项目介绍
技术栈:
Python语言、Flask框架、MySQL数据库、30万订单数据、HTML
研究背景: 随着大数据技术的迅速发展,我们更渴望通过大数据技术来获取对于电子商务平台的用户购买行为,通过用户购买的行为来分析和判断各个商品对于用户的需求,以便为用户提供更好的购买体验。通过数据分析,能够挖掘数据背后丰富的内涵,为移动用户在合适的时间、合适的地点精准推荐合适的内容。直接避免了省代、市代、区代等中间商赚差价,从而大大节省了成本,这笔节省的成本无论是对消费者、供应商、白龙马商城都是有好处的,真正实现了共赢局面。
2、项目界面
(1)数据可视化大屏
(2)柱状图分析
(3)饼状图分析
(4)折线图分析
(5)会员账号管理
(6)订单数据管理
3、项目说明
研究背景: 随着大数据技术的迅速发展,我们更渴望通过大数据技术来获取对于电子商务平台的用户购买行为,通过用户购买的行为来分析和判断各个商品对于用户的需求,以便为用户提供更好的购买体验。通过数据分析,能够挖掘数据背后丰富的内涵,为移动用户在合适的时间、合适的地点精准推荐合适的内容。而白龙马的商业模式是生产商——白龙马商城——消费者这种商业模式,直接避免了省代、市代、区代等中间商赚差价,从而大大节省了成本,这笔节省的成本无论是对消费者、供应商、白龙马商城都是有好处的,真正实现了共赢局面。
课题的任务:系统主要通过分析白龙马电商平台用户访问日志,实现用户在不同时间纬度的网站访问量、不同省份对网站访问量、不同年龄层级用户对网站访问量,网站新老用户统计等功能(可在完成基础功能上自由扩展新功能)。
设计要求:(1)查阅有关大数据分析的相关资料,获取白龙马电商购物平台相关数据,借助大数据分析基本原理,确定本程序的基本方案,编写开题报告(2)完成基于大数据离线技术的白龙马电商用户行为日志数据分析系统的方案设计(3)完成基于大数据离线技术的白龙马电商用户行为日志数据分析系统的软件编程(4)能够运用大数据分析的解决方法,对设计的系统进行准确,具体,详细的描述与编程(5)对设计的程序进行编码与调试,能够满足大数据分析数据的基本要求
4、核心代码
@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(`订单时间`,4) = '2018'" \
" UNION SELECT SUM(1),'新用户' from orders where left(`订单时间`,4) = '2019'"
conn = pymysql.connect(host='127.0.0.1', user='root', password='123456', port=3306, db='blmshoop',
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 orders where left(`订单时间`,7) = '2018-07'" \
" UNION SELECT SUM(1) from orders where left(`订单时间`,7) = '2019-10'" \
" UNION SELECT SUM(1) from orders where left(`订单时间`,4) = '2018'" \
" UNION SELECT SUM(1) from orders where left(`订单时间`,4) = '2019'"
conn = pymysql.connect(host='127.0.0.1', user='root', password='123456', port=3306, db='blmshoop',
charset='utf8')
cursor = conn.cursor()
cursor.execute(sql)
values = cursor.fetchall()
jsondata = {}
xd = []
for index,i in enumerate(values):
xd.append(i[0])
yd = []
for index, i in enumerate(values):
yd.append(i[0]+900)
jsondata['data'] = xd
jsondata['data1'] = yd
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='blmshoop',
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('/page5',methods=['GET'])
def page5():
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(`用户id`,1) = '9'" \
" UNION SELECT SUM(1),'青年' from orders where left(`用户id`,2) = '10'"\
" UNION SELECT SUM(1),'中年' from orders where left(`用户id`,2) = '11'"\
" UNION SELECT SUM(1),'老年' from orders where left(`用户id`,2) = '12'"
conn = pymysql.connect(host='127.0.0.1', user='root', password='123456', port=3306, db='blmshoop',
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('/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='blmshoop',
charset='utf8')
cursor = conn.cursor()
cursor.execute("select count(*) from orders");
count = cursor.fetchall()
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
cursor.execute("select * from orders 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('/data1',methods=['GET'])
def data1():
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='blmshoop',
charset='utf8')
cursor = conn.cursor()
cursor.execute("select count(*) from china_city_list");
count = cursor.fetchall()
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
cursor.execute("select * from china_city_list 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='blmshoop',
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='blmshoop', charset='utf8')
cursor = conn.cursor()
cursor.execute("select count(*) from `user` where `username` = '" + 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)
5、源码获取方式
🍅由于篇幅限制,获取完整文章或源码、代做项目的,查看我的【用户名】、【专栏名称】、【顶部选题链接】就可以找到我啦🍅
感兴趣的可以先收藏起来,点赞、关注不迷路,下方查看👇🏻获取联系方式👇🏻