3,881
社区成员
发帖
与我相关
我的任务
分享
#include <QtCore/QCoreApplication>
#include <qstring.h>
#include <qstringlist.h>
#include <qsqlerror.h>
#include <QDebug>
#include <QtSql>
#include <QTextCodec>
#include <iostream>
void initCodec()
{
QTextCodec *codec = QTextCodec::codecForName("System");
QTextCodec::setCodecForLocale(codec);
QTextCodec::setCodecForCStrings(codec);
QTextCodec::setCodecForTr(codec);
}
int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);
initCodec();
qDebug() << QSqlDatabase::drivers();
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("238.178.4.69");
db.setPort(3306);
db.setDatabaseName("****");
db.setUserName("****");
db.setPassword("****");
if(db.open())
std::cout<<"Connect database successfully\n";
else
std::cout<<"Connect database unsuccessfully\n";
QSqlQuery query;
//bp的值是false
bool bp = query.prepare("INSERT INTO table_test (id, text, name,key) VALUES (?, ?, ?,?)");
query.bindValue(0, 1001);
query.bindValue(1, "Bart");
query.bindValue(2, "Simpson");
query.exec();
db.close();
return a.exec();
}