/***************************************************************************
                          test.cpp  -  description
                             -------------------
    begin                : 二  5月 6 2003
    copyright            : (C) 2003 by nan sha Itpark
    email                : zuojin@itpark85
 ***************************************************************************/

/***************************************************************************
 *                                                                         *
 *   This program is free software; you can redistribute it and/or modify  *
 *   it under the terms of the GNU General Public License as published by  *
 *   the Free Software Foundation; either version 2 of the License, or     *
 *   (at your option) any later version.                                   *
 *                                                                         *
 ***************************************************************************/

#include <iostream.h>
#include <libpq++.h>
 
int  main()
 {
   char query_string[256]= "SELECT * FROM test;";
   PgDatabase data("dbname = test_db");
   
   	if (data.ConnectionBad())
   	{
     	 cout <<"connected failed" << endl;
  		 cout <<"Error is "<<data.ErrorMessage() << endl;
         exit(1);
     }
    if (! data.ExecTuplesOk(query_string)) 
    {
      cout<<"Query Failed!" << endl;
       exit(1);
     }
     for(int k=0; k<data.Fields();k++)/**显示字段名称*/
      {
          cout<<data.FieldName(k);
          cout <<"      "     ;
      }
         cout<<endl;
     for (int i = 0; i < data.Tuples();i++)/**取得查询结果的记录数量*/
     {
       	for(int k=0; k<data.Fields();k++)
       {
        	cout << data.GetValue(i,k);
        	cout <<" | "     ;
        }
         cout<<endl;
       
       }
       return 0 ;    
 }