//自己設定連線名,不使用預設連線名
if (SdbSqlite.contains("Conn2sqlite"))
{
SdbSqlite = QSqlDatabase::database("Conn2sqlite");
}
else
SdbSqlite = QSqlDatabase::addDatabase(
"QSQLITE","Conn2sqlite");
SdbSqlite.setDatabaseName("FiveChess.database"); //資料庫名稱
定義QSqlDatabase SdbSqlite;並連線sqlite資料庫
QString StrSql1 =
QString("select name,grade,integration,round,victory,defeat,rank"
" from member where account = "%0" and password = "%1";")
.arg(StrAcn,StrPsdOrNew);
QSqlQuery query1(SdbSqlite);
query1.exec(StrSql1);
查詢語句
//自己設定連線名,不使用預設連線名
if (SdbSqlite.contains("Conn2sqlite"))
{
SdbSqlite = QSqlDatabase::database("Conn2sqlite");
}
else
{
SdbSqlite = QSqlDatabase::addDatabase(
"QSQLITE","Conn2sqlite");
}
SdbSqlite.setDatabaseName("FiveChess.database"); //資料庫名稱
定義QSqlDatabase SdbSqlite;並連線sqlite資料庫
QString StrSql1 =
QString("select name,grade,integration,round,victory,defeat,rank"
" from member where account = "%0" and password = "%1";")
.arg(StrAcn,StrPsdOrNew);
QSqlQuery query1(SdbSqlite);
query1.exec(StrSql1);
查詢語句