一、效果展示图
二、前端代码
1、html代码
<1>index.html
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="x-ua-compatible" content="ie=edge">
<title>首页</title>
<link rel="stylesheet" href="../static/css/style.css">
<script src="../static/js/vue.js"></script>
</head>
<body>
<div id='app' class="container">
<img src="../static/img/bg.jpg"/>
<div class="panel">
<div class="content login">
<div class="switch">
<span :class='{"active": active === "login"}' @click='go("login")'>登陆</span>
<span>/</span>
<span :class='{"active": active === "register"}' @click='go("register")'>注册</span>
</div>
<div class='form' id="fromlogin">
<template v-if='active === "register"'>
<div class="input"><input :class='{ hasvalue: registerform.email }' v-model='registerform.email'
type="text" name="email" id='email'/><label for="email">邮箱</label></div>
<div class="input"><input :class='{ hasvalue: registerform.username }'
v-model='registerform.username' type="text" name="username"
id="username"/><label for="username">用户名</label></div>
<div class="input"><input :class='{ hasvalue: registerform.password }'
v-model='registerform.password' type="password" name="password"
id="password"/><label for="password">密码</label></div>
<div class="input"><input :class='{ hasvalue: registerform.repeat }' v-model='registerform.repeat'
type="password" name="repeat" id="passwordrepeat"/><label
for="passwordrepeat">重复密码</label></div>
<span>忘记?</span>
<button type="submit" @click='submitregister'>注册</button>
</template>
<template v-if='active === "login"'>
<div class="input"><input :class='{ hasvalue: loginform.username }' v-model='loginform.username'
type="text" name="username" id="username"/><label
for="username">用户名</label></div>
<div class="input"><input :class='{ hasvalue: loginform.password }' v-model='loginform.password'
type="password" name="password" id="password"/><label
for="password">密码</label></div>
<span>忘记?</span>
<button type="submit" @click='submitlogin'>登陆</button>
</template>
</div>
</div>
</div>
</div>
<script>
var vue = new vue({
el: '#app',
data: {
active: 'login',
registerform: { email: '', username: '', password: '', repeat: '' },
loginform: { username: '', password: '' },
},
methods: {
go(type) {
this.active = type;
},
<!-- 在 submitlogin 方法中 -->
async submitlogin() {
try {
const response = await fetch('/login', {
method: 'post',
headers: {
'content-type': 'application/json',
},
body: json.stringify(this.loginform),
});
const data = await response.json();
console.log('服务器响应:', data);
if (data.success) {
// 登录成功，重定向到 hall.html
window.location.href = './hall';
} else {
// 登录失败，显示错误信息
this.errormessage = '用户名或密码错误';
}
} catch (error) {
console.error('登录时发生错误:', error);
}
},
async submitregister() {
try {
const response = await fetch('/register', {
method: 'post',
headers: {
'content-type': 'application/json',
},
body: json.stringify(this.registerform),
});
const data = await response.json();
console.log('服务器响应:', data);
// 根据服务器响应处理逻辑
} catch (error) {
console.error('注册时发生错误:', error);
}
},
},
});
</script>
</body>
</html>
<2>hall.html
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>功能大厅</title>
<style>
body {
font-family: arial, sans-serif;
background-color: #f4f4f4;
margin: 0;
padding: 0;
display: flex;
justify-content: center;
align-items: center;
height: 100vh;
}
.container {
text-align: center;
}
.button {
display: inline-block;
padding: 15px 30px;
font-size: 16px;
font-weight: bold;
text-decoration: none;
color: #fff;
background-color: #3498db;
border-radius: 5px;
margin: 10px;
transition: background-color 0.3s;
}
.button:hover {
background-color: #2980b9;
}
</style>
</head>
<body>
<div class="container">
<h1>学生成绩管理系统</h1>
<a href="./gradelist" class="button" id="grademanagementbtn">成绩管理</a>
<a href="./sa" class="button" id="subjectanalysisbtn">学科分析</a>
</div>
</body>
</html>
<3>sa.html
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>学科分析</title>
<!-- 引入 layui -->
<link rel="stylesheet" href="https://www.layuicdn.com/layui/css/layui.css">
<script src="https://www.layuicdn.com/layui/layui.js"></script>
<!-- 引入 chart.js 库 -->
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<!-- 引入 jquery -->
<script src="../static/plugins/jquery-3.7.1.min.js"></script>
<!-- 引入基本表格插件 -->
<script type="text/javascript" src="../static/js/jquery.basictable.min.js"></script>
<!-- 引入响应式表格插件 -->
<script type="text/javascript" src="../static/js/reponsetable.min.js"></script>
<!-- 引入 layer 插件 -->
<script type="text/javascript" src="../static/plugins/layer/layer.js"></script>
<!-- 引入 layer 默认主题样式 -->
<link rel="stylesheet" type="text/css" href="../static/plugins/layer/theme/default/layer.css">
<!-- 引入自定义 css 样式 -->
<link rel="stylesheet" type="text/css" href="../static/css/reponse.css">
<link rel="stylesheet" type="text/css" href="../static/css/lib/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="../static/css/custom.css">
<style type="text/css">
/* 新增的样式 */
body {
font-family: 'arial', sans-serif;
margin: 20px;
}
h1 {
color: #333;
}
table {
width: 100%;
border-collapse: collapse;
margin-top: 20px;
}
th, td {
padding: 10px;
border: 1px solid #ddd;
text-align: center;
}
th {
background-color: #f2f2f2;
}
tr:hover {
background-color: #f5f5f5;
}
.layui-layer {
background: #fff;
}
</style>
</head>
<body>
<h1>学科分析</h1>
<!-- 基本表格样式 -->
<table class="layui-table">
<thead>
<tr>
<th></th>
<th>成绩1</th>
<th>成绩2</th>
<th>成绩3</th>
<th>成绩4</th>
<th>成绩5</th>
<th>成绩6</th>
</tr>
</thead>
<tbody>
{% for student in students %}
{% endfor %}
<tr>
<td>最高分</td>
<td>{{ max_grades.g1 }}</td>
<td>{{ max_grades.g2 }}</td>
<td>{{ max_grades.g3 }}</td>
<td>{{ max_grades.g4 }}</td>
<td>{{ max_grades.g5 }}</td>
<td>{{ max_grades.g6 }}</td>
</tr>
<tr>
<td>最低分</td>
<td>{{ min_grades.g1 }}</td>
<td>{{ min_grades.g2 }}</td>
<td>{{ min_grades.g3 }}</td>
<td>{{ min_grades.g4 }}</td>
<td>{{ min_grades.g5 }}</td>
<td>{{ min_grades.g6 }}</td>
</tr>
<tr>
<td>平均分</td>
<td>{{ avg_grades.g1 }}</td>
<td>{{ avg_grades.g2 }}</td>
<td>{{ avg_grades.g3 }}</td>
<td>{{ avg_grades.g4 }}</td>
<td>{{ avg_grades.g5 }}</td>
<td>{{ avg_grades.g6 }}</td>
</tr>
</tbody>
</table>
</body>
</html>
<4>gradelist.html
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>学生信息管理</title>
<link rel="stylesheet" href="https://www.layuicdn.com/layui/css/layui.css">
<script src="https://www.layuicdn.com/layui/layui.js"></script>
<!-- 引入 chart.js 库 -->
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script src="../static/plugins/jquery-3.7.1.min.js"></script>
<script type="text/javascript" src="../static/js/jquery.basictable.min.js"></script>
<script type="text/javascript" src="../static/js/reponsetable.min.js"></script>
<script type="text/javascript" src="../static/plugins/layer/layer.js"></script>
<link rel="stylesheet" type="text/css" href="../static/plugins/layer/theme/default/layer.css">
<link rel="stylesheet" type="text/css" href="../static/css/reponse.css">
<link rel="stylesheet" type="text/css" href="../static/css/lib/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="../static/css/custom.css">
<style type="text/css">
.alertceng {
background: #ffffff;
padding: 10px;
display: none;
}
.alertceng span.title {
margin-right: 10px;
}
</style>
</head>
<body>
<div class="layui-fluid layadmin-homepage-fluid" style="background: #fff;width:90%;margin:0 auto;">
<div id="page">
<h1>学生成绩信息管理</h1>
<table id="table" class="reponsetable"></table>
<script type="text/html" id="editer">
<a class="layui-btn layui-btn-xs" onclick="scatterplot(this)">散点图</a>
<a class="layui-btn layui-btn-xs" onclick="radarchart(this)">雷达图</a>
<a class="layui-btn layui-btn-xs" onclick="careerplan(this)">职业规划</a>
<a class="layui-btn layui-btn-xs" onclick="edittr(this)">修改</a>
<a class="layui-btn layui-btn-xs" onclick="deleterecord(this)">删除</a>
</script>
<div class="btn-container">
<button class="layui-btn" onclick="addnew();">新增信息</button>
</div>
</div>
</div>
<div id="editcontent" class="alertceng">
<p><span class="title">姓名:</span><input type="text" id="name"/></p>
<p><span class="title">成绩1:</span><input type="text" id="g1"/></p>
<p><span class="title">成绩2:</span><input type="text" id="g2"/></p>
<p><span class="title">成绩3:</span><input type="text" id="g3"/></p>
<p><span class="title">成绩4:</span><input type="text" id="g4"/></p>
<p><span class="title">成绩5:</span><input type="text" id="g5"/></p>
<p><span class="title">成绩6:</span><input type="text" id="g6"/></p>
<button id="savebtn">保存</button>
<button id="cancelbtn">取消</button>
</div>
<script type="text/javascript">
$(document).ready(function () {
// 使用后端传递的数据
fetch("/get_student_data")
.then(response => response.json())
.then(data => {
// 获取从后端获取的学生信息数据
var studentdata = data.data;
// 原始数据，json构建
$('#table').basictable({
breakpoint: 768
});
// 使用后端传递的数据
$("#table").reponsetable({
"id": "table",
"operation": "editer",
"type": "numbers",
"colum": [
{"field": "name", "title": "姓名"},
{"field": "g1", "title": "成绩1"},
{"field": "g2", "title": "成绩2"},
{"field": "g3", "title": "成绩3"},
{"field": "g4", "title": "成绩4"},
{"field": "g5", "title": "成绩5"},
{"field": "g6", "title": "成绩6"}
],
"data": studentdata // 使用后端传递的数据
});
// 定义按钮事件
layui.use('layer', function () {
layer = layui.layer;
});
})
.catch(error => console.error('获取学生信息数据时发生错误:', error));
// 显示表单
window.addnew = function () {
$('#editcontent').show();
}
// 保存按钮点击事件
$('#savebtn').on('click', function () {
// 保存操作
var newdata = {
"name": $("#name").val(),
"g1": $("#g1").val(),
"g2": $("#g2").val(),
"g3": $("#g3").val(),
"g4": $("#g4").val(),
"g5": $("#g5").val(),
"g6": $("#g6").val()
};
// 发送异步请求保存到数据库
$.ajax({
type: 'post',
url: '/savedatatodatabase',
data: json.stringify(newdata),
contenttype: 'application/json',
success: function (response) {
// 处理保存成功的逻辑
if (response.success) {
// 这里可以根据实际情况做一些提示或者刷新表格等操作
console.log('数据保存成功');
// 隐藏表单
$('#editcontent').hide();
// 清空输入框
$('#editcontent input').val('');
// 刷新表格数据
refreshtable();
} else {
console.error('数据保存失败');
}
},
error: function (error) {
console.error('保存数据时发生错误:', error);
}
});
});
// 取消按钮点击事件
$('#cancelbtn').on('click', function () {
// 隐藏表单
$('#editcontent').hide();
// 清空输入框
$('#editcontent input').val('');
});
// 定义刷新表格数据的函数
function refreshtable() {
fetch("/get_student_data")
.then(response => response.json())
.then(data => {
// 获取从后端获取的学生信息数据
var studentdata = data.data;
$("#table").reponsetable("setdata", studentdata);
})
.catch(error => console.error('获取学生信息数据时发生错误:', error));
}
// 散点图按钮点击事件
function scatterplot(obj) {
// 散点图按钮点击事件处理逻辑
// ...
}
// 雷达图按钮点击事件
function radarchart(obj) {
// 雷达图按钮点击事件处理逻辑
// ...
}
// 职业规划按钮点击事件
function careerplan(obj) {
// 职业规划按钮点击事件处理逻辑
// ...
}
//删除
// 删除按钮点击事件
window.deleterecord = function (obj) {
var currentrowdata = getcurrentrowdata(obj);
// 发送删除请求
$.ajax({
type: 'post',
url: '/deleterecord',
data: json.stringify(currentrowdata),
contenttype: 'application/json',
success: function (response) {
if (response.success) {
console.log('数据删除成功');
// 刷新表格数据
refreshtable();
} else {
console.error('数据删除失败');
}
},
error: function (error) {
console.error('删除数据时发生错误:', error);
}
});
}
// 获取当前行的学生信息
function getcurrentrowdata(obj) {
var currentrow = $(obj).closest('tr');
var rowdata = {
name: currentrow.find('td[data-field="name"]').text(),
g1: currentrow.find('td[data-field="g1"]').text(),
g2: currentrow.find('td[data-field="g2"]').text(),
// 添加其他成绩项
};
return rowdata;
}
// 修改按钮点击事件
window.edittr=function (obj) {
// 获取当前行的数据
// 获取当前行的数据
var currentrowdata = getcurrentrowdata(obj);
// 将数据填充到表单中
$('#name').val(currentrowdata.name).prop('readonly', true); // 设置为只读
$('#g1').val(currentrowdata.g1);
$('#g2').val(currentrowdata.g2);
$('#g3').val(currentrowdata.g3);
$('#g4').val(currentrowdata.g4);
$('#g5').val(currentrowdata.g5);
$('#g6').val(currentrowdata.g6);
// 显示表单
$('#editcontent').show();
}
// 保存按钮点击事件
$('#savebtn').on('click', function () {
// 保存操作
var newdata = {
"name": $("#name").val(),
"g1": $("#g1").val(),
"g2": $("#g2").val(),
"g3": $("#g3").val(),
"g4": $("#g4").val(),
"g5": $("#g5").val(),
"g6": $("#g6").val()
};
// 发送异步请求保存到数据库
$.ajax({
type: 'post',
url: '/updaterecord', // 修改为更新路由
data: json.stringify(newdata),
contenttype: 'application/json',
success: function (response) {
// 处理更新成功的逻辑
if (response.success) {
console.log('数据更新成功');
// 隐藏表单
$('#editcontent').hide();
// 清空输入框
$('#editcontent input').val('');
// 刷新表格数据
refreshtable();
} else {
console.error('数据更新失败');
}
},
error: function (error) {
console.error('更新数据时发生错误:', error);
}
});
});
//散点图
window.scatterplot=function (obj) {
// 获取当前行的数据
// 获取当前行的数据
var currentrowdata = getcurrentrowdata(obj);
// 构建散点图数据
var scatterchartdata = {
datasets: [{
label: '散点图',
data: [{
x: '成绩1',
y: currentrowdata.g1
}, {
x: '成绩2',
y: currentrowdata.g2
}, {
x: '成绩3',
y: currentrowdata.g3
}, {
x: '成绩4',
y: currentrowdata.g4
}, {
x: '成绩5',
y: currentrowdata.g5
}, {
x: '成绩6',
y: currentrowdata.g6
}],
backgroundcolor: 'rgba(255, 99, 132, 1)' // 颜色
}]
};
// 创建 canvas 元素
var canvas = document.createelement('canvas');
canvas.width = 400; // 设置宽度
canvas.height = 400; // 设置高度
// 将 canvas 元素添加到页面
document.body.appendchild(canvas);
// 创建散点图
var ctx = canvas.getcontext('2d');
new chart(ctx, {
type: 'scatter',
data: scatterchartdata,
options: {
responsive: false,
scales: {
x: {
type: 'category', // 设置 x 轴类型为分类
labels: ['成绩1', '成绩2', '成绩3', '成绩4', '成绩5', '成绩6'],
position: 'bottom'
},
y: {
type: 'linear',
position: 'left'
}
}
}
});
}
// 获取当前行的学生信息
function getcurrentrowdata(obj) {
var currentrow = obj.closest('tr');
var rowdata = {
name: currentrow.queryselector('td[data-field="name"]').textcontent,
g1: parsefloat(currentrow.queryselector('td[data-field="g1"]').textcontent),
g2: parsefloat(currentrow.queryselector('td[data-field="g2"]').textcontent),
g3: parsefloat(currentrow.queryselector('td[data-field="g3"]').textcontent),
g4: parsefloat(currentrow.queryselector('td[data-field="g4"]').textcontent),
g5: parsefloat(currentrow.queryselector('td[data-field="g5"]').textcontent),
g6: parsefloat(currentrow.queryselector('td[data-field="g6"]').textcontent)
};
return rowdata;
}
//雷达图
window.radarchart=function (obj) {
// 获取当前行的数据
var currentrowdata = getcurrentrowdata(obj);
// 构建雷达图数据
var radarchartdata = {
labels: ['成绩1', '成绩2', '成绩3', '成绩4', '成绩5', '成绩6'],
datasets: [{
label: '雷达图',
data: [currentrowdata.g1, currentrowdata.g2, currentrowdata.g3, currentrowdata.g4, currentrowdata.g5, currentrowdata.g6],
backgroundcolor: 'rgba(75, 192, 192, 0.2)', // 填充颜色
bordercolor: 'rgba(75, 192, 192, 1)', // 边框颜色
borderwidth: 1 // 边框宽度
}]
};
// 创建 canvas 元素
var canvas = document.createelement('canvas');
canvas.width = 400; // 设置宽度
canvas.height = 400; // 设置高度
// 将 canvas 元素添加到页面
document.body.appendchild(canvas);
// 创建雷达图
var ctx = canvas.getcontext('2d');
new chart(ctx, {
type: 'radar',
data: radarchartdata,
options: {
responsive: false,
scales: {
r: {
beginatzero: true
}
}
}
});
}
// 获取当前行的学生信息
function getcurrentrowdata(obj) {
var currentrow = obj.closest('tr');
var rowdata = {
name: currentrow.queryselector('td[data-field="name"]').textcontent,
g1: parsefloat(currentrow.queryselector('td[data-field="g1"]').textcontent),
g2: parsefloat(currentrow.queryselector('td[data-field="g2"]').textcontent),
g3: parsefloat(currentrow.queryselector('td[data-field="g3"]').textcontent),
g4: parsefloat(currentrow.queryselector('td[data-field="g4"]').textcontent),
g5: parsefloat(currentrow.queryselector('td[data-field="g5"]').textcontent),
g6: parsefloat(currentrow.queryselector('td[data-field="g6"]').textcontent)
};
return rowdata;
}
//职业规划
// 职业规划按钮点击事件
window.careerplan=function (obj) {
// 获取当前行的数据
var currentrowdata = getcurrentrowdata(obj);
// 向后端发送请求，获取职业规划结果
$.ajax({
type: 'post',
url: '/careerplan',
data: json.stringify({ g6: currentrowdata.g6 }),
contenttype: 'application/json',
success: function (response) {
if (response.success) {
// 显示职业规划结果
showcareerplandialog(response.message);
} else {
console.error('获取职业规划结果失败');
}
},
error: function (error) {
console.error('获取职业规划结果时发生错误:', error);
}
});
}
// 显示职业规划结果的对话框
function showcareerplandialog(message) {
layer.open({
title: '职业规划结果',
content: message,
btn: ['确定'],
yes: function (index, layero) {
// 点击确定按钮的回调，可以根据需要添加其他操作
layer.close(index);
}
});
}
});
</script>
</body>
</html>
2、其他前端代码略
三、后端代码
from flask import flask, render_template, request, jsonify
import pymysql
from flask_cors import cors
app = flask(__name__)
cors(app)
# mysql数据库连接配置
database_config = {
'host': '127.0.0.1',
'user': 'root',
'password': 'your_password',
'database': 'pythonweb',
'cursorclass': pymysql.cursors.dictcursor,
}
# 创建mysql连接
def create_connection():
return pymysql.connect(**database_config)
# 创建users表（如果不存在）
def create_table():
conn = create_connection()
cursor = conn.cursor()
cursor.execute('''
create table if not exists users (
id int auto_increment primary key,
username varchar(255) not null,
password varchar(255) not null
)
''')
conn.commit()
conn.close()
# 创建表格（如果不存在）
create_table()
@app.route("/")
def index():
return render_template("index.html")
@app.route("/login", methods=['post'])
def login():
data = request.json
username = data.get('username')
password = data.get('password')
# 在这里执行与数据库的交互逻辑，检查用户名和密码是否匹配
user = get_user(username, password)
# 在登录成功时返回一个 success 字段
if user:
return jsonify({'success': true, 'message': '登录成功'})
else:
return jsonify({'success': false, 'message': '无效的用户名或密码'}), 401
def get_user(username, password):
conn = create_connection()
cursor = conn.cursor()
cursor.execute('select * from users where username = %s and password = %s', (username, password)) #参数化查询，避免sql注入
user = cursor.fetchone() #将查询结果这一行数据赋值给user变量，如果未查询到则为空
conn.close()
return user #返回查询得到的数据
# 创建grades表（如果不存在）
def create_grades_table():
conn = create_connection()
cursor = conn.cursor()
cursor.execute('''
create table if not exists grade(
name varchar(255) not null,
g1 int not null ,
g2 int not null ,
g3 int not null ,
g4 int not null ,
g5 int not null ,
g6 int not null
)
''')
conn.commit()
conn.close()
# 创建表格（如果不存在）
create_grades_table()
# 路由用于保存数据到数据库
@app.route("/savedatatodatabase", methods=['post'])
def save_data_to_database():
data = request.json
name = data.get('name')
g1 = data.get('g1')
g2 = data.get('g2')
g3 = data.get('g3')
g4 = data.get('g4')
g5 = data.get('g5')
g6 = data.get('g6')
# 在这里执行与数据库的交互逻辑，将数据保存到数据库
success = save_data_to_db(name, g1, g2, g3, g4, g5, g6)
# 响应
if success:
return jsonify({'success': true, 'message': '数据保存成功'})
else:
return jsonify({'success': false, 'message': '数据保存失败'}), 500
def save_data_to_db(name, g1, g2, g3, g4, g5, g6):
try:
conn = create_connection()
cursor = conn.cursor()
cursor.execute('insert into grade (name, g1, g2, g3, g4, g5, g6) values (%s, %s, %s, %s, %s, %s, %s)',
(name, g1, g2, g3, g4, g5, g6))
conn.commit()
conn.close()
return true
except exception as e:
print(f"error saving data to database: {e}")
return false
# 跳转hall.html界面的路由函数
@app.route("/hall")
def hall():
return render_template("hall.html")
# 跳转gradelist.html界面的路由函数
@app.route("/gradelist")
def gl():
return render_template("gradelist.html")
@app.route("/get_student_data")
def get_student_data():
conn = create_connection()
cursor = conn.cursor()
cursor.execute('select name, g1, g2, g3, g4, g5, g6 from grade')
student_data = cursor.fetchall()
conn.close()
return jsonify({"data": student_data})
# 删除路由
# 路由用于删除数据
@app.route("/deleterecord", methods=['post'])
def delete_record():
data = request.json
name = data.get('name')
g1 = data.get('g1')
g2 = data.get('g2')
# 添加其他成绩项
# 在这里执行与数据库的交互逻辑，将数据从数据库中删除
success = delete_record_from_db(name, g1, g2)
# 响应
if success:
return jsonify({'success': true, 'message': '数据删除成功'})
else:
return jsonify({'success': false, 'message': '数据删除失败'}), 500
def delete_record_from_db(name, g1, g2):
try:
conn = create_connection()
cursor = conn.cursor()
cursor.execute('delete from grade where name = %s and g1 = %s and g2 = %s',
(name, g1, g2))
conn.commit()
conn.close()
return true
except exception as e:
print(f"error deleting data from database: {e}")
return false
# 路由用于更新数据
@app.route("/updaterecord", methods=['post'])
def update_record():
data = request.json
name = data.get('name')
g1 = data.get('g1')
g2 = data.get('g2')
g3 = data.get('g3')
g4 = data.get('g4')
g5 = data.get('g5')
g6 = data.get('g6')
# 在这里执行与数据库的交互逻辑，将数据更新到数据库
success = update_record_in_db(name, g1, g2, g3, g4, g5, g6)
# 响应
if success:
return jsonify({'success': true, 'message': '数据更新成功'})
else:
return jsonify({'success': false, 'message': '数据更新失败'}), 500
def update_record_in_db(name, g1, g2, g3, g4, g5, g6):
try:
conn = create_connection()
cursor = conn.cursor()
cursor.execute('update grade set g1=%s, g2=%s, g3=%s, g4=%s, g5=%s, g6=%s where name=%s',
(g1, g2, g3, g4, g5, g6, name))
conn.commit()
conn.close()
return true
except exception as e:
print(f"error updating data in database: {e}")
return false
# 路由用于职业规划
@app.route("/careerplan", methods=['post'])
def career_plan():
data = request.json
g6 = data.get('g6')
# 根据成绩6进行职业规划
career = plan_career(int(g6))
# 响应
return jsonify({'success': true, 'message': career})
# 根据成绩6进行职业规划
def plan_career(g6):
if g6 > 100:
return '黑客'
elif 80 <= g6 <= 100:
return '算法设计师'
elif 60 <= g6 < 80:
return '运维工程师'
elif 40 <= g6 < 60:
return '电脑维修工'
else:
return '板砖'
@app.route("/sa")
def sa():
conn = create_connection()
cursor = conn.cursor()
cursor.execute('select name, g1, g2, g3, g4, g5, g6 from grade')
students = cursor.fetchall()
# 计算最高分、最低分和平均分
max_grades = {'g1': max(student['g1'] for student in students),
'g2': max(student['g2'] for student in students),
'g3': max(student['g3'] for student in students),
'g4': max(student['g4'] for student in students),
'g5': max(student['g5'] for student in students),
'g6': max(student['g6'] for student in students)}
min_grades = {'g1': min(student['g1'] for student in students),
'g2': min(student['g2'] for student in students),
'g3': min(student['g3'] for student in students),
'g4': min(student['g4'] for student in students),
'g5': min(student['g5'] for student in students),
'g6': min(student['g6'] for student in students)}
avg_grades = {'g1': sum(student['g1'] for student in students) / len(students),
'g2': sum(student['g2'] for student in students) / len(students),
'g3': sum(student['g3'] for student in students) / len(students),
'g4': sum(student['g4'] for student in students) / len(students),
'g5': sum(student['g5'] for student in students) / len(students),
'g6': sum(student['g6'] for student in students) / len(students)}
conn.close()
return render_template("sa.html", students=students, max_grades=max_grades, min_grades=min_grades,
avg_grades=avg_grades)
if __name__ == '__main__':
app.run(debug=true)
我要评论
发表评论