临时文件上传资源。。。

#include "widget.h" #include "ui_widget.h" Widget::Widget(QWidget *parent) : QWidget(parent), ui(new Ui::Widget) { ui->setupUi(this); //[1] 根据数据库的类型来连接数据 QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL"); db.setHostName("localhost"); db.setDatabaseName("dbtest"); db.setUserName("root"); db.setPassword("root"); //[2] 打开数据库 if(db.open()) { qDebug() << "Database connect success! "; }else { qDebug() << "Database connect error!" << db.lastError(); } //[3] 根据需求，创建数据库所需要的表 QSqlQuery query; QString sqlCreateTable = QString("create table staff(id integer primary key autoincrement," "name varchar(20)," "age int," "address varchar(50)," "salary int);"); if(!query.exec(sqlCreateTable)) { qDebug() << "create table" << db.lastError(); } } Widget::~Widget() { delete ui; } void Widget::on_addBtn_clicked() { } void Widget::on_updateBtn_clicked() { } void Widget::on_deleteBtn_clicked() { } void Widget::on_selectBtn_clicked() { ui->listWidget->clear(); // 在查询数据之前，清空列表上的内容 QSqlQuery query; //[1] 向数据库下达查询数据的命令 QString sqlSelect = QString("select * from staff;"); if(!query.exec(sqlSelect)) { qDebug() << "Error insert into data" << db.lastError(); } //[2] 遍历数据库记录 while(query.next()) { int id = query.value("id").toInt(); QString name = query.value("name").toString(); int age = query.value("age").toInt(); QString address = query.value("address").toString(); QString salary = query.value("salary").toString(); qDebug() << "id = " << id << "name = " << name << "age = " << age << "address = " << address << "salary = " << salary; } }