qt4.11版本数据库的增删改查
时间: 2023-10-07 15:05:25 浏览: 43
由于Qt4.11版本已经过时,建议使用更高版本的Qt。以下是Qt中数据库的增删改查的示例代码(基于Qt5):
添加操作:
```cpp
QSqlQuery query;
query.prepare("INSERT INTO student (name, age) VALUES (?, ?)");
query.addBindValue("Tom");
query.addBindValue(18);
query.exec();
```
删除操作:
```cpp
QSqlQuery query;
query.prepare("DELETE FROM student WHERE id=?");
query.addBindValue(1);
query.exec();
```
修改操作:
```cpp
QSqlQuery query;
query.prepare("UPDATE student SET age=? WHERE name=?");
query.addBindValue(20);
query.addBindValue("Tom");
query.exec();
```
查询操作:
```cpp
QSqlQuery query;
query.exec("SELECT * FROM student");
while(query.next()) {
int id = query.value(0).toInt();
QString name = query.value(1).toString();
int age = query.value(2).toInt();
qDebug() << id << name << age;
}
```