/**********************數據庫准備工件**************************/
/*
mysql -p -u root
show databases;
create database testmysql
create table login(username varchar(20),idnumber varchar(20));
insert into login values('huise','123456');
show table login;
select * from login;
*/
#include <QtGui>
#include <QtSql>
int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);
QString m_name;
QString m_password;
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("localhost");
db.setDatabaseName("testmysql");
db.setUserName("root");
db.setPassword("72074918");
if(!db.open())
{
qDebug()<<"Failed to mysql";
}
QSqlQuery query;
if(query.exec("select username,idnumber from login"))
{
qDebug()<<"failed query.exce";
}
while(query.next())
{
m_name = query.value(0).toString();
m_password = query.value(1).toString();
qDebug()<<m_name;
qDebug()<<m_password;
}
return 0;
}
注意：編譯時不要忘記了在.pro中添加 QT +=sql
