Qt 连接数据库
1、头文件
#include <QtCore/QCoreApplication>
#include <QtSql>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QDebug>
#include <QString>
#include <QVariant>
#include <QSqlRecord>
2、主函数
int main(int argc,char * argv[])
{
QCoreApplication a(argc,argv);
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");//加载驱动
db.setHostName("localhost");//主机名
db.setDatabaseName("test");//数据库名称
db.setUserName("root");//用户名
db.setPassword("qazqaz");//密码
if(db.open())
{
qDebug()<<"database is established!";//成功加载
}
else
{
qDebug()<<"build error!";
return a.exec();
}
QSqlQuery query;//执行query
query.exec(QObject::tr("create table student(sno varchar(10) not null primary key,sname varchar(20) not null,sclass(10) not null )"));
query.exec(QObject::tr("insert into student (sno, snmae, sclass) values('201200824125','leinei','121')"));
query.exec(QObject::tr("insert into student (sno, sname, sclass) values('201200824126','wuming','131')"));
query.exec(QObject::tr("insert into student (sno, snmae, sclass) values('201200824127','zhouqu','152')"));
query.exec("select from student");
qDebug()<<"sno sname sclass";
while(query.next())
{
qDebug()<<query.value(0).toString()<<" "<<query.value(1).toString()<<" "<<query.value(2).toString();
}
query.clear();
db.close();
return a.exec();
}