QT代码对行政班级学生的生日、性别等可进行统计,老师的性别,年龄 等进行统计。(本质上是查询功能的应用)
时间: 2024-03-16 07:46:20 浏览: 12
下面是一个简单的QT代码示例,用于对行政班级学生的生日、性别等信息进行统计:
```
// 查询学生生日、性别等信息
QStringList studentFields = {"birthday", "gender"};
QSqlQuery query;
query.prepare("SELECT " + studentFields.join(", ") + " FROM student WHERE class_id = :classId");
query.bindValue(":classId", classId);
query.exec();
// 统计生日、性别的数量
int numMales = 0;
int numFemales = 0;
QMap<QString, int> birthdayCounts;
while (query.next()) {
QString gender = query.value(1).toString();
if (gender == "Male") {
numMales++;
} else if (gender == "Female") {
numFemales++;
}
QString birthday = query.value(0).toString();
if (!birthdayCounts.contains(birthday)) {
birthdayCounts.insert(birthday, 1);
} else {
birthdayCounts[birthday]++;
}
}
// 显示统计结果
qDebug() << "Number of males: " << numMales;
qDebug() << "Number of females: " << numFemales;
qDebug() << "Birthday counts: ";
for (const auto& birthday : birthdayCounts.keys()) {
qDebug() << birthday << ": " << birthdayCounts[birthday];
}
```
同样地,我们也可以对老师的性别、年龄等信息进行统计,只需要修改相应的查询语句和统计方法即可。