Qt中操作数据库例子-插入数据

#include <QtCore/QCoreApplication> #include <QtSql/qsql.h> #include <QtSql/qsqldatabase.h> #include <QtSql/qsqlquery.h> #include <QtSql/qsqlerror.h> #include <qstring.h> #include <qfile.h> #include <qdebug.h> #include <qvariant.h> bool createConnection(QString driver, QString dbName) { QSqlDatabase db = QSqlDatabase::addDatabase(driver); db.setDatabaseName(dbName); if (!db.open()) { qDebug() << db.lastError(); return false; } return true; } int main(int argc, char *argv[]) { QCoreApplication a(argc, argv); QSqlDatabase database = QSqlDatabase::addDatabase("QSQLITE"); QString dbName = "CashSystem.db"; //QSqlDatabase database = QSqlDatabase::database(dbName); database.setDatabaseName(dbName); /* if (!database.isValid()) { //database = QSqlDatabase::addDatabase("QSQLITE", dbName); database = QSqlDatabase::addDatabase("QSQLITE"); database.setDatabaseName("CashSystem.db"); } if (database.open()) { qDebug() << "Database Opened"; } else { qDebug() << "Database not Opened"; }*/ /**/ if (database.open()) { qDebug() << "Database Opened"; QSqlQuery sql_query; QString create_sql = "create table member (id int primary key, name varchar(30), address varchar(30))"; // 创建数据表 //QString create_sql = "create table member (id int primary key, name varchar(30), address varchar(30))"; QString insert_sql = "insert into member values(?,?,?)"; //插入数据 QString select_all_sql = "select * from member"; sql_query.prepare(select_all_sql); if (!sql_query.exec()) //? { qDebug() << sql_query.lastError(); } else { while (sql_query.next()) { int id = sql_query.value(0).toInt(); QString name = sql_query.value(1).toString(); QString address = sql_query.value(2).toString(); qDebug() << QString("ID:%1 Name:%2 Address:%3").arg(id).arg(name).arg(address); } } /* sql_query.prepare(create_sql); // //创建表 if (!sql_query.exec()) //查看创建表是否成功 { qDebug() << QObject::tr("Table create failed");; qDebug() << sql_query.lastError(); } else { qDebug() << "table created"; //插入数据 sql_query.prepare(insert_sql); QVariantList GroupIDs; GroupIDs.append(0); GroupIDs.append(1); GroupIDs.append(2); QVariantList GroupNames; GroupNames.append("hsp"); GroupNames.append("rl"); GroupNames.append("spl"); QVariantList GroupAdress; GroupAdress.append(QObject::tr("南充")); GroupAdress.append("baoji"); GroupAdress.append("nachong"); sql_query.addBindValue(GroupIDs); sql_query.addBindValue(GroupNames); sql_query.addBindValue(GroupAdress); if (!sql_query.execBatch()) //? { qDebug() << sql_query.lastError(); } else { qDebug() << "insert sucess"; } //查询所有记录 sql_query.prepare(select_all_sql); if (!sql_query.exec()) //? { qDebug() << sql_query.lastError(); } else { while (sql_query.next()) { int id = sql_query.value(0).toInt(); QString name = sql_query.value(1).toString(); QString address = sql_query.value(2).toString(); qDebug() << QString("ID:%1 Name:%2 Address:%3").arg(id).arg(name).arg(address); } } }*/ } database.close(); return a.exec(); }