|
1. queryMenu.prepare("insert into ordering (desknum,foodname,foodprice) values(:desknumm,:foodname,:foodprice)"); //準備執(zhí)行SQL查詢 queryMenu.bindValue(":desknumm", nid); //在占位符上確定綁定的值 queryMenu.bindValue(":foodname", foodnm); queryMenu.bindValue(":foodprice",fdprice); queryMenu.exec(); 2. QSqlQuery query; query.exec("select * from employment where username="+str[0]); query.exec("select * from employment where username=?"); query.bindValue(0,str[0]); //str[0]存放的是從界面獲取的用戶名 query.exec(); 3. bool createConnection() { QSqlDatabase db=QSqlDatabase::addDatabase("QMYSQL"); //連接數(shù)據(jù)庫驅(qū)動 db.setUserName("zzp"); db.setPassword("zzp"); db.setHostName("localhost"); //數(shù)據(jù)庫所在主機的IP，此處數(shù)據(jù)庫保存在本地 db.setDatabaseName("ordersystem");//數(shù)據(jù)庫名 db.setPort(3306); //端口號 if(!db.open()) { qDebug()<<"Failed to connect to root mysql admin"; } else { qDebug()<<"open database successful!"; return true; } }
|
|
|
