16,203
社区成员
发帖
与我相关
我的任务
分享
QT +=core gui sql
#TARGET =
#DEPENDPATH += .
#INCLUDEPATH += .
SOURCES += \
main.cpp
#include <QtCore/QCoreApplication>
#include <QtSql>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QString>
int main(int argc,char *argv[])
{
QCoreApplication a(argc,argv);
QTextCodec *codec = QTextCodec::codecForName("UTF-8");
QTextCodec::setCodecForLocale(codec);
QTextCodec::setCodecForCStrings(codec);
QTextCodec::setCodecForTr(codec);
QSqlDatabase db=QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("localhost");
db.setDatabaseName("project");
db.setUserName("root");
db.setPassword("0");
if(db.open())
{
qDebug()<<"database is established!";
}
else
{
qDebug()<<"build error!";
return a.exec();
}
QSqlQuery query;
query.exec(QObject::tr("select * from student"));
QSqlRecord rec=query.record();
int count=rec.count();
qDebug()<<"Number of column:"<<count;
while(query.next())
{
rec=query.record();
int name=rec.indexOf("name");
int card=rec.indexOf("card");
int user=rec.indexOf("user");
int password=rec.indexOf("password");
int book =rec.indexOf("book");
QString value1 =query.value(name).toString();
QString value2 =query.value(card).toString();
QString value3 =query.value(user).toString();
QString value4 =query.value(password).toString();
QString value5 =query.value(book).toString();
qDebug()<<"name:"<<value1<<"\t"<<"card:"<<value2<<"\t"<<"user:"<<value3
<<"\t"<<"password:"<<value4<<"\t"<<"book:"<<"\t"<<value5;
}
query.clear();
db.close();
return a.exec();
}
QTextCodec::setCodecForTr(QTextCodec::codecForName("GBK"));//UTF-8 GBK
QTextCodec::setCodecForLocale(QTextCodec::codecForName("GBK"));
QTextCodec::setCodecForCStrings(QTextCodec::codecForName("GBK"));