|
- int main(int argc,char** argv)
- {
- QApplication app(argc,argv);
- QSqlDatabase db=QSqlDatabase::addDatabase("QMYSQL");
- db.setHostName("127.0.0.1");
- db.setPort(3306);
- db.setDatabaseName("student");
- db.setUserName("root");
- if(!db.open()){
- QMessageBox::warning(NULL,"warning!","failure");
- }else{
- QMessageBox::information(NULL,"OK!","success!");
- }
- QSqlQuery query;
- query.exec(QObject::tr("create table Student(sno varchar(10) not null primary key,sname varchar(20) not null,sclass 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\tsname\tsclass";
- while(query.next())
- {
- qDebug() << query.value(0).toString()<< "\t"<<query.value(1).toString() << "\t" << query.value(2).toString();
- }
- return app.exec();
- }
复制代码 我这里vs2008+qt4.8.2运行是可以查询出刚刚插入的数据,附上图片给您看,那个query那里不用扔进QSqlDatabase都可以,
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有帐号?立即注册
x
|