开发工具:Qt Creator 4.2.1 (Community)
开发平台:windows 7
数据库:MySql 5.5.45
一、在.pro配置文件中添加添加数据库
QT += core gui sql #后面追加上sql
二、头文件引入
#include <QDebug>
#include <QMessageBox>
#include <QSqlError>
#include <QSqlQuery>
#include <QVariantList>
三、下面直接上代码
//打印QT支持的数据库驱动
qDebug() << QSqlDatabase::drivers();
//指定MYSQL数据库
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
//连接数据库
db.setHostName("127.0.0.1");
db.setUserName("root");
db.setPassword("123456");
db.setPort(3306);
db.setDatabaseName("test");
//打开数据库
if(!db.open()){ //数据库打开失败
QMessageBox::warning(this, "warming", db.lastError().text());
return;
}else{
QMessageBox::information(this, "msg", "连接成功");
}
QSqlQuery query;
//新建表
QString sql = "create table if not exists student(id int primary key auto_increment, uname char(50) NOT NULL,pwd char(50) NOT NULL) engine=InnoDB default charset=utf8;";
if(query.exec(sql)){
QMessageBox::information(this, "msg", "新建student成功");
}
//插入数据
sql = "insert into student(uname,pwd) values('sindsun','123456')";
if(query.exec(sql)){
QMessageBox::information(this, "msg", "插入一条记录成功");
}
//批量插入
//odbc风格 --windows风格
//预处理语句
//?相当于占位符
/*query.prepare("insert into student(uname,pwd) values(?,?)");
//给字段设置内容,list
QVariantList unameList;
unameList << QString("张三").toUtf8() << QString("李四").toUtf8() << QString("王麻子").toUtf8() ;
QVariantList pwdList;
pwdList << "9698" << "2243" << "8899";
//给字段绑定相应的值
query.addBindValue(unameList);
query.addBindValue(pwdList);
//执行预处理命令
query.execBatch();*/
//oracle风格
//占位符 : + 自定义名称
query.prepare("insert into student(uname,pwd) values(:name,:pwd);");
//给字段设置内容,list
QVariantList unameList;
unameList << QString("五哥").toUtf8() << QString("刘能").toUtf8() << QString("本广").toUtf8() ;
QVariantList pwdList;
pwdList << "789987" << "11542243" << "884564599";
//给字段绑定
query.bindValue(":name",unameList);
query.bindValue(":pwd",pwdList);
//执行预处理命令
query.execBatch();
//查询
sql = "select * from student";
query.exec(sql);
while(query.next()){
//取出并打印值
qDebug() << query.value("id").toInt()
<< query.value("uname").toString()
<< query.value("pwd").toString();
}