mysqlqt5
我的系统：win7 64bit
qt版本：qt5.4 vs2013的编译器
mysql5.6安装正常
我是初学者，想试验一下mysql的使用，用main函数调用以下代码时出现：
starting c:\qt\qt5.4.1\qtprojects\build-mysql_test-desktop_qt_5_4_1_msvc2013_64bit-debug\debug\mysql_test.exe...
build error!haha
c:\qt\qt5.4.1\qtprojects\build-mysql_test-desktop_qt_5_4_1_msvc2013_64bit-debug\debug\mysql_test.exe exited with code 0
代码如下：
#ifndef CONNECTDATABASE_H
#define CONNECTDATABASE_H
#include
#include
#include
#include
#include
#include
bool connectiondatabase()
{
QSqlDatabase db(QSqlDatabase::addDatabase("QMYSQL"));
db.setHostName("localhost");
db.setDatabaseName("Student");
db.setUserName("root");
db.setPassword("123456");
if(db.open())
{
qDebug() }
else
{
qDebug() return false;
}
QSqlQuery query;
query.exec(QObject::tr("create table student(sno varchar(10) not null primary key,sname " "varchar(20) not null,scalss varchar(10) not null"));query.exec(QObject::tr("insert into student(sno,sname,sclass) values('2009001','lilei'," "'0901')"));query.exec(QObject::tr("insert into student(sno,sname,sclass) values('2009002','lucy'," "'0902')"));query.exec(QObject::tr("insert into student(sno,sname,sclass) values('2009003','mike'," "'0903')"));query.exec("select * from student");qDebug()<<"sno sname scalss";while(query.next()){ qDebug()<}
#endif // CONNECTDATABASE_H
