QtÁ¬½ÓʹÓÃSQLiteÊý¾Ý¿âʾÀý

ת×Ô：http://www.cppblog.com/biao/archive/2009/04/15/79958.html

#include <QtCore/QCoreApplication> #include <QtSql> #include <qDebug> int main(int argc, char *argv[]) { QCoreApplication a(argc, argv); QTextCodec::setCodecForCStrings(QTextCodec::codecForName("utf8")); QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE"); db.setDatabaseName("MyDB"); // Êý¾Ý¿âÃûÓë·¾¶, ´ËʱÊÇ·ÅÔÚͬĿ¼Ï db.open(); // Á¬½ÓÊý¾Ý¿â, È»ºó¾Í¿ÉÒÔʹÓÃÁË. QSqlQuery query; // query.prepare("insert into user(id, name) values(:id, :name)"); // query.bindValue(":id", 2); // query.bindValue(":name", "»Æ±ë"); // bool ok = query.exec(); // // query.prepare("insert into user(id, name) values(:id, :name)"); // query.bindValue(":id", 3); // query.bindValue(":name", "°¢ÅÜ"); // query.exec(); // // if (!ok) { // qDebug() << "Already exits."; // } // // query.exec("create table hello(id int primary key)"); query.exec("select * from user"); while (query.next()) { int id = query.value(0).toInt(); QString name = query.value(1).toString(); qDebug() << "Id=" << id << ", Name=" << name; } return 0; }