#include "mainwindow.h"
void MainWindow::setMyLineEdit()
{
ui->stuNumber -> setMaxLength( 11 ); //学号限制为11位
ui->classLevel -> setMaxLength( 4 ); //年级限制为两位
ui->stuPhone -> setMaxLength( 11 ); //手机号13位
QRegExp regExp("[0-9]+$");
QRegExp dor("^((0([1-9]{1}))|(1[1|2]))/(([0-2]([1-9]{1}))|(3[0|1]))/(d{2}|d{4})$");
QRegExpValidator *pattern= new QRegExpValidator(regExp, this);//创建了一个表达式
// QRegExpValidator *pat= new QRegExpValidator(dor, this);//创建了一个表达式
//交付使用
ui->stuNumber ->setValidator(pattern); //学号限输入制为数字
ui->classLevel ->setValidator(pattern); //班级限输入制为数字
ui->stuPhone ->setValidator(pattern); //学生
//设置提示内容
ui->stuName ->setPlaceholderText("示例:张三");
ui->stuNumber ->setPlaceholderText("11位学号");
ui->stuPhone ->setPlaceholderText("请输入手机号");
ui->className ->setPlaceholderText("示例:软件1班");
ui->classLevel ->setPlaceholderText("示例:2018");
ui->headTeacher ->setPlaceholderText("班主任名字");
ui->instructor ->setPlaceholderText("辅导员名字");
QStringList qstr_campus;
QStringList qstr_department;
QStringList qstr_sex;
QStringList qstr_buildingno;
QStringList qstr_floor;
QStringList qstr_dormitoryno;
QStringList qstr_dormitorylevel;
qstr_department << "计算机工程系" << "土木工程系" << "机电信息系" << "化学工程系" << "经济管理系";
qstr_campus << "请选择" << "北校区" << "南校区";
qstr_sex << "请选择" << "男" << "女";
qstr_buildingno << "请选择" << "1栋" << "2栋" << "3栋" << "4栋" << "5栋" << "6栋" << "7栋" << "8栋" << "9栋" << "10栋" << "11栋" << "12栋" << "13栋" << "14栋";
qstr_floor << "请选择" << "一层" << "二层" << "三层" << "四层" << "五层" << "六层" << "七层";
qstr_dormitorylevel << "请选择" << "一级宿舍" << "二级宿舍";
// qstr_dormitoryno << ;
ui->department ->addItems (qstr_department );
ui->campus ->addItems (qstr_campus );
ui->sex ->addItems (qstr_sex );
ui->buildingno ->addItems (qstr_buildingno );
ui->floor ->addItems (qstr_floor );
ui->dormitorylevel ->addItems (qstr_dormitorylevel );
}
void MainWindow::setAddTableWidget()
{
QTableWidgetItem *headerItem;
QStringList headerText;
headerText << "系别" << "校区" << "性别" << "楼号" << "楼层"<< "宿舍号"<< "床位号" << "宿舍级别" << "学 号" << "姓 名" << "学生手机号" << "年级";
ui->addTableWidget->setColumnCount(headerText.count());//列数设置为与 headerText的行数相等
for (int i = 0; i < ui->addTableWidget->columnCount(); i++)
{
headerItem = new QTableWidgetItem(headerText.at(i));//新建一个QTableWidgetItem, headerText.at(i)获取headerText的i行字符串
QFont font = headerItem->font();//获取原有字体设置
font.setBold(true);//设置为粗体
font.setPixelSize(12);//字体大小
headerItem->setTextColor("#2E8B57");//字体颜色
ui->addTableWidget->setHorizontalHeaderItem(i,headerItem);//设置表头单元格的Item
}
selectDormitoryno();
}
void MainWindow::selectDormitoryno()
{
ui->addTableWidget->clearContents();
QSqlDatabase db = star_mysql();
QSqlQuery *query = new QSqlQuery;
QString first = "SELECT * FROM test_db.dorm where ";
QString strdepartment = " department = '" + ui->department->currentText () + "'";
first += strdepartment;
QString campus = ui->campus ->currentText ();
QString strsex = QString::number(ui->sex ->currentIndex());
QString strbuildingno = QString::number(ui->buildingno ->currentIndex());
QString strfloor = QString::number(ui->floor ->currentIndex());
QString strdormitorylevel = QString::number(ui->dormitorylevel ->currentIndex());
if (campus != "请选择" ) first += (campus = " and campus = '" + campus + "'" );
if (strsex != "0") first += (strsex = " and sex = " + strsex );
if (strbuildingno != "0") first += (strbuildingno = " and buildingno = " + strbuildingno );
if (strfloor != "0") first += (strfloor = " and floor = " + strfloor );
if (strdormitorylevel != "0") first += (strdormitorylevel = " and dormitorylevel = " + strdormitorylevel);
query->prepare(first);
if(!query->exec()) qDebug() << "insert fail of selectDormitoryno";
QSqlRecord rec = query->record();
query->next();
//=================================================================================
QSqlQuery *querylist = new QSqlQuery;
QString str1;
QString str2;
// str1 = "SELECT * FROM test_db.stulist where stunumber = ";
// str2 = query->value(rec.indexOf("stunameber")).toString();
// str1 += str2;
// qDebug() << str1;
// querylist->prepare(str1);
// querylist->exec();
// QSqlRecord reclist = querylist->record();
// querylist->next();
// qDebug() << querylist->value(reclist.indexOf("stuname"));
// str2 = querylist->value(reclist.indexOf("stuname")).toString();
//=================================================================================
do{
// query->record();
//=================================================================================
str1 = "SELECT * FROM test_db.stulist where stunumber = ";
str2 = query->value(rec.indexOf("stunameber")).toString();
str1 += str2;
querylist->prepare(str1);
querylist->exec();
QSqlRecord reclist = querylist->record();
querylist->next();
//=================================================================================
ui->addTableWidget->setItem(g_rowCountForAddTableWidget, 0, new QTableWidgetItem( query->value(rec.indexOf("department" )).toString()));
ui->addTableWidget->setItem(g_rowCountForAddTableWidget, 1, new QTableWidgetItem( query->value(rec.indexOf("campus" )).toString()));
ui->addTableWidget->setItem(g_rowCountForAddTableWidget, 2, new QTableWidgetItem(g_CHSex [query->value(rec.indexOf("sex" )).toInt ()]));
ui->addTableWidget->setItem(g_rowCountForAddTableWidget, 3, new QTableWidgetItem(g_CHBuildingno [query->value(rec.indexOf("buildingno" )).toInt ()]));
ui->addTableWidget->setItem(g_rowCountForAddTableWidget, 4, new QTableWidgetItem(g_CHFloor [query->value(rec.indexOf("floor" )).toInt ()]));
ui->addTableWidget->setItem(g_rowCountForAddTableWidget, 5, new QTableWidgetItem( query->value(rec.indexOf("dormitoryno" )).toString()));
ui->addTableWidget->setItem(g_rowCountForAddTableWidget, 6, new QTableWidgetItem(g_CHBedno [query->value(rec.indexOf("bedno" )).toInt ()]));
ui->addTableWidget->setItem(g_rowCountForAddTableWidget, 7, new QTableWidgetItem(g_CHDormitorylevel [query->value(rec.indexOf("dormitorylevel")).toInt ()]));
ui->addTableWidget->setItem(g_rowCountForAddTableWidget, 8, new QTableWidgetItem(query->value(rec.indexOf( "stunameber" )).toString()));
//学生表的内容
ui->addTableWidget->setItem(g_rowCountForAddTableWidget, 9, new QTableWidgetItem(querylist->value(reclist.indexOf("stuname")).toString()));
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
qt项目,工具源码,适合毕业设计、课程设计作业,所有源码均经过严格测试,可以直接运行,可以放心下载使用。有任何使用问题欢迎随时与博主沟通,第一时间进行解答! 软件开发设计:PHP、QT、应用软件开发、系统软件开发、移动应用开发、网站开发C++、Java、python、web、C#等语言的项目开发与学习资料 硬件与设备:单片机、EDA、proteus、RTOS、包括计算机硬件、服务器、网络设备、存储设备、移动设备等 操作系统:LInux、IOS、树莓派、安卓开发、微机操作系统、网络操作系统、分布式操作系统等。此外,还有嵌入式操作系统、智能操作系统等。 云计算与大数据:数据集、包括云计算平台、大数据分析、人工智能、机器学习等,云计算是一种基于互联网的计算方式,通过这种方式,共享的软硬件资源和信息可以按需提供给计算机和其他设备。
资源推荐
资源详情
资源评论
收起资源包目录
用Qt通过ODBC连接MySQL数据库实现学生管理系统.zip (17个子文件)
cm
StudentSormitoryManagementSystem.pro.user 22KB
StudentSormitoryManagementSystem.pro.user.bba2763 22KB
mainwindow.h 2KB
dialog.ui 3KB
dialog.cpp 1KB
batchAdd.cpp 66B
find.cpp 4KB
mainwindow.cpp 3KB
deletestu.cpp 4KB
addorm.cpp 9KB
main.cpp 423B
mainwindow.ui 30KB
StudentSormitoryManagementSystem.pro 1KB
add.cpp 17KB
StudentSormitoryManagementSystem.pro.user.4.8-pre1 23KB
dialog.h 367B
delet.cpp 175B
共 17 条
- 1
资源评论
妄北y
- 粉丝: 9820
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功