static bool createConnetc()
{
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("192.168.20.201"); //远程服务器地址
db.setPort(3306); //远程服务器端口
db.setUserName("root");
db.setPassword("root");
if (!db.isValid())
{
QMessageBox::critical(0, QObject::tr("Database"), db.lastError().text());
return false;
}
//open database connect
db.open();
QSqlQuery query = db.exec("Create Database If Not Exists realname Character Set UTF8;");
db.setDatabaseName("realname");
if (db.open())
{
if (!query.exec("select *from user where account='admin'"))
{
query.exec("create table if not exists user(account VARCHAR(15) not null, password VARCHAR(20) not null)");
query.exec("insert into user set account='admin',password='1';");
}
return true;
}
else
{
return false;
}
}
QT在远程服务器上创建mysql数据库
最新推荐文章于 2023-12-28 17:11:53 发布