qt中mysql数据库经验总结_MySQL

1.queryMenu.prepare("insert into ordering (desknum,foodname,foodprice) values(:desknumm,:foodname,:foodprice)"); //准备执行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"); //连接数据库驱动 db.setUserName("zzp"); db.setPassword("zzp"); db.setHostName("localhost"); //数据库所在主机的IP，此处数据库保存在本地 db.setDatabaseName("ordersystem");//数据库名 db.setPort(3306); //端口号 if(!db.open()) { qDebug()<<"Failed to connect to root mysql admin";
} else { qDebug()<<"open database successful!"; return true; }}