qt测试mysql_Qt MySQL数据库访问测试程序

/**********************数据库准备工件**************************//* mysql -p -u root show databases; create database tes

/**********************数据库准备工件**************************/

/*

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

#include

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()<

}

QSqlQuery query;

if(query.exec("select username,idnumber from login"))

{

qDebug()<

}

while(query.next())

{

m_name = query.value(0).toString();

m_password = query.value(1).toString();

qDebug()<

qDebug()<

}

return 0;

}

注意：编译时不要忘记了在.pro中添加 QT     +=sql

，