How to connect QT to a MySQL database and insert data?

1 year ago
Jackson Davis
2 minutes

To connect MySQL database and add data in QT, you need to follow these steps:

  1. To create a database connection in a QT project:
    In QT, you can use the QSqlDatabase class to connect to a database. First, include the headers QSqlDatabase and QSqlQuery in your project. Then use the following code to create the database connection:
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("hostname"); // 指定MySQL服务器地址
db.setPort(port); // 指定MySQL服务器端口
db.setDatabaseName("database_name"); // 指定要连接的数据库名称
db.setUserName("username"); // 指定用户名
db.setPassword("password"); // 指定密码

if(db.open()){
    // 数据库连接成功
} else {
    // 数据库连接失败
}
  1. Add data to the database:
    Once connected successfully, you can use the QSqlQuery class to execute SQL statements and add data. Here is an example:
QSqlQuery query;
QString insertQuery = "INSERT INTO table_name (column1, column2) VALUES (:value1, :value2)";
query.prepare(insertQuery);
query.bindValue(":value1", value1); // 绑定参数
query.bindValue(":value2", value2); // 绑定参数

if(query.exec()){
    // 数据添加成功
} else {
    // 数据添加失败
}

Note: In the code above, you need to replace “table_name” with the name of the table where you want to insert data, and replace “column1” and “column2” with the names of the columns where you want to insert data. Additionally, “:value1” and “:value2” are bound parameters, you need to replace “value1” and “value2” with the actual values you want to insert.

This is a basic example of connecting to and adding data to a MySQL database. You may need to make appropriate modifications and extensions based on your project requirements.

bannerAds