10.23作业

#include "widget.h"
#include "ui_widget.h"

Widget::Widget(QWidget *parent)
    : QWidget(parent)
    , ui(new Ui::Widget)
{
    ui->setupUi(this);
    //判断数据库是否存在
    if(!db.contains())
    {
        //说明数据库不存在
        //创建一个数据库addDatabase()
        db = QSqlDatabase::addDatabase("QSQLITE"); //表示数据库驱动为sqlite3

        //给刚刚创建的数据库命名
        db.setDatabaseName("stuInfo.db");

        QMessageBox::information(this, "", "创建数据库成功");
    }
    //打开数据库
    if(!db.open())
    {
        QMessageBox::information(this, "", "打开数据库失败");
    }

    //给数据库创建数据库表
    //实例化一个执行sql语句的类对象 QSqlQuery类
    QSqlQuery query;

    //准备sql语句
    QString sql = "create table if not exists stu_info_table("
                        "id integer primary key autoincrement,"
                        "numb integer,"
                        "name varchar(20),"
                        "sex varcher(4),"
                        "score integer)";
    //执行sql语句
    if(query.exec(sql))
    {
        QMessageBox::information(this, "", "创建数据表成功");
    }
    else
    {
       QMessageBox::information(this, "", "创建数据表失败");
    }
}


Widget::~Widget()
{
    delete ui;
}

//添加按钮对应的槽函数处理
void Widget::on_addbtn_clicked()
{
    //获取ui界面上的信息
    int numb = ui->numEdit->text().toUInt(); //将学号文本转换成整型
    QString name = ui->nameEdit->text();
    QString sex = ui->sexEdit->text();
    int score = ui->scoreEdit->text().toUInt(); //将成绩文本转换成整型
    //保证用户输入完整信息
    if(numb == 0 || name.isEmpty() || sex.isEmpty() || score == 0)
    {
        QMessageBox::information(this, "", "请将信息填写完整");
        return;
    }
    //将信息加入到数据库中
    //需要实例化一个执行sql语句的类对象
    QSqlQuery query;
    //准备sql语句
    QString sql = QString("insert into stu_info_table(numb,name,sex,score) "
            "values(%1, '%2', '%3', %4)")
            .arg(numb).arg(name).arg(sex).arg(score);
    //执行sql语句
    if(query.exec(sql))
        QMessageBox::information(this, "", "添加成功");
    else
        QMessageBox::information(this, "", "添加失败");
}

//显示按钮对应的槽函数处理
void Widget::on_showbtn_clicked()
{
    //实例化一个执行sql语句的类对象
    QSqlQuery query;
    //准备sql语句
    QString sql = "select * from stu_info_table";
    //执行sql语句
    if(query.exec(sql))
    {
        //将数据库里的内容放入ui界面上
        int i = 0;
        while(query.next()) //next遍历内容
        {
            for (int j = 0; j < query.record().count(); j++)
            {
                ui->tableWidget->setItem(i, j, new QTableWidgetItem(query.value(j+1).toString()));
            }
            i++;
        }
    }
}

void Widget::on_serbtn_clicked()
{
    ui->tableWidget->clear();
    int numb = ui->numEdit->text().toUInt(); //将学号文本转换成整型
    QString name = ui->nameEdit->text();
    QString sex = ui->sexEdit->text();
    int score = ui->scoreEdit->text().toUInt(); //将成绩文本转换成整型

    //实例化一个执行sql语句的类对象
    QSqlQuery query;
    //准备sql语句
    QString sql = QString("select * from stu_info_table where numb = %1 or name = '%2' or sex = '%3' or score = %4").arg(numb).arg(name).arg(sex).arg(score);

    if(query.exec(sql))
    {
        QMessageBox::information(this, "", "查找成功");
        int i = 0;
        while(query.next())
        {
            for (int j = 0; j < query.record().count(); j++)
            {
                ui->tableWidget->setItem(i, j, new QTableWidgetItem(query.value(j+1).toString()));
            }
            i++;
        }
    }
    else
        QMessageBox::information(this, "", "查找失败");

}


void Widget::on_delbtn_clicked()
{
    int numb = ui->numEdit->text().toUInt(); //将学号文本转换成整型
    QString name = ui->nameEdit->text();
    QString sex = ui->sexEdit->text();
    int score = ui->scoreEdit->text().toUInt(); //将成绩文本转换成整型

    QSqlQuery query;
    QString sql = QString("delete from stu_info_table where numb=%1 or name='%2' or sex='%3' or score=%4").arg(numb).arg(name).arg(sex).arg(score);
    if(query.exec(sql))
        QMessageBox::information(this, "", "删除成功");
    else
        QMessageBox::information(this, "", "删除失败");
}