QT连接SQL（1） QSQLQuery prepare and bindValue

#include

#include  

#include  

int main(int argc, char *argv[]) 

{ 

 QCoreApplication a(argc, argv); 

 QString severname = "SUDA-20130101OV\\SQLEXPRESS"; 

 QString dbname = "test";//自己建的表 

 QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");//使用ODBC连接 

 //在连接过程中，ODBC驱动显示not loaded ,从别的计算机上把sqldrivers拷贝过来，就可以用了 

 //前提里面有ODBC的类和库 

 // qDebug() << "ODBC driver valid?" << db.isValid(); 

 db.setConnectOptions(); 

 QString dsn = QString::fromLocal8Bit("DRIVER={SQL Native Client};SERVER=%1;DATABASE=%2;Trusted_Connection=Yes;").arg(severname).arg(dbname); 

 db.setDatabaseName(dsn); 

 if(db.open()) 

 { 

 qDebug()<<"opened"; 

 QString query = "INSERT INTO [test].[dbo].[lm_people] ([ID] ,[FirstName] ,[LastName]) VALUES (:ID,:Firstname,:LastName)"; 

 QSqlQuery qry; 

 qry.prepare(query); 

 qry.bindValue(":ID","99"); 

 qry.bindValue(":FirstName","8"); 

 qry.bindValue(":LastName","10"); 

 if(qry.exec()) 

 { 

 qDebug()<<"Record Inserted"; 

 } 

 qDebug()<<"Closing..."; 

 db.close(); 

 } 

 else 

 { 

 qDebug()<<"not opened"; 

 } 

 return a.exec(); 

} 

 详细内容可以查看此博友的文章http://blog.csdn.net/fzu_dianzi/article/details/6959268