1,178
社区成员
发帖
与我相关
我的任务
分享
QSqlDatabase db=QSqlDatabase::addDatabase("QSQLITE");
db.setHostName("localhost");
db.setDatabaseName("yu");
db.setUserName("test");
db.setPassword("test");
bool ok=db.open();
if(ok){
QMessageBox msgBox;
msgBox.setText("ok");
msgBox.exec();
}
else{
QMessageBox msgBox;
msgBox.setText("Error connect database!"+db.lastError().text());
msgBox.exec();
}
QSqlQuery query; //以下执行相关QSL语句
query.exec("create table student(id int primary key,name varchar)");
//新建student表,id设置为主键,还有一个name项
query.exec("insert into student values(1,’xiaogang’)");
query.exec("insert into student values(2,’xiaoming’)");
query.exec("insert into student values(3,’xiaohong’)");