#include
#include
int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);
qDebug()<<"Available drivers:";
QStringListdrivers = QSqlDatabase::drivers();
foreach(QString driver, drivers)
qDebug() << "\t" << driver;
QSqlDatabasedb = QSqlDatabase::addDatabase("QSQLITE");//Ìí¼ÓÊý¾Ý¿âÇý¶¯
db.setDatabaseName("/root/Desktop/FirstWorkSpace/QtMySql/kj.db");//注意了路径的‘\’与windows下的相反!!!!
if(!db.open())
{
return false;
}
QSqlQueryquery;
if(query.exec("create table student(id int primary k ey, namevarchar)") )//н¨±ístudent Ö÷¼üÊÇid£¬Ãû×ÖÊǿɱ䳤¶È×Ö·û´®
{
qDebug() <<"Create success !!!";
}
if(query.exec("insert into student values(1,'KongJun')"))
{
qDebug() <<"insert success !!!";
}
query.exec("insert into student values(2,'LiuXiaoWei')");
query.exec("insert into studentvalues(3,'ZhuShiWei')");//²åÈëÈýÌõ¼Ç¼
query.exec("select id,name from student where id >=2");//²éÕÒ±íÖÐid´óÓÚ2µÄ¼Ç¼µÄidºÍÐÕÃû
while(query.next())//query.next()Ö¸Ïò²éÕҵĵÚÒ»Ìõ¼Ç¼£¬È»ºóÿ´ÎÏòºóÒƶ¯Ò»Ìõ¼Ç¼
{
int ele0 = query.value(0).toInt();//idµÄֵת»»ÎªintÐÍ
QString ele1 = query.value(1).toString();
qDebug() << ele0 << ele1;
}
returna.exec();
}