main.cpp

来自「嵌入数据库封装例程」· C++ 代码 · 共 37 行

#include <iostream>
#include <string>
#include "dsqlxprez_2.h"

int 
main() 
{
  try 
    {
    dsqlxprez::Connection conn;
    conn.open("mydb");
    dsqlxprez::Statement *stmt = conn.createStatement();
    stmt->execute("create table albums(title VARCHAR(51),artist CHAR(30))");
    stmt->execute("insert into albums values('Brothers in Arms','Dire Straits')");
    stmt->execute("insert into albums values('Unplugged','Eric Clapton')");
    dsqlxprez::ResultSet* rslt = stmt->executeQuery("select * from albums");
    dsqlxprez::ResultSetMetaData* r_mtdt = rslt->getMetaData();
    int cols = r_mtdt->getColumnCount();
    while (rslt->next()) 
      {
	for (int i=0;i<cols;i++) 
	  std::cout << r_mtdt->getColumnName(i+1) << ' ' 
		    << '(' << r_mtdt->getColumnType(i+1) << "): "
		    << rslt->getString(i+1); 
	std::cout << '\n';
      }
    conn.refreshMetaData();
    if(conn.getDatabaseMetaData()->doesObjectExist("albums","table"))
      stmt->execute("drop table albums");
  }
  catch(dsqlxprez::SQLException ex) 
    {
      std::cout << ex.what() << '\n';
    }
  return 0;
}