【原创】QT4 Windows OpenSource版中如何连接数据库 [复制链接]

  QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
  db.setHostName("localhost");   // 这个实际上就是本机
  db.setDatabaseName("mssql_qt"); // 这个实际上就是数据源名DSN
  db.setUserName("sa");
  db.setPassword("password");
  bool ok = db.open();
  QSqlQuery query;
  query.exec("create table person (id int primary key, "
          "firstname varchar(20), lastname varchar(20))");
  query.exec("insert into person values(101, 'Danny', 'Young')");
  query.exec("insert into person values(102, 'Christine', 'Holand')");
  query.exec("insert into person values(103, 'Lars', 'Gordon')");
  query.exec("insert into person values(104, 'Roberto', 'Robitaille')");
  query.exec("insert into person values(105, 'Maria', 'Papadopoulos')");
  db.close();

这些可以简写，例连结sqlserver数据库可写成如下：
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC3");
db.setDatabaseName("DRIVER={SQL
Server};Server="+host+";Database="+database+";Uid="+user+";Pwd="+password+";");