Copyright(c) 2005 
File Name 
  dbtest.c
Version:
 1.0
Abstract:
  soure file interface for PV database test
Author:
  ailinyang
Created on:
2005-1-17
Modified Person:
--*/

#include <unistd.h>
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <mysql/mysql.h>

int main(void )
{
  int id;
  MYSQL mysql;
  MYSQL_ROW row;
  MYSQL_RES * res;
  char sqlbuf[256];

  /*init mysql*/

 if(mysql_init(&mysql)== NULL){
   fprintf(stderr,"%s %d: mysql init failed!\n", __FILE__,__LINE__);
   return -1;
  }

 /* connect mysql*/

 if(mysql_real_connect(&mysql,localhost,pvd,yang,pvd,8080,NULL,0)== NULL){
   fprintf(stderr,"%s%d:mysql connect failed !\n",__FILE__,__LINE__);
   return -1;
 }

/* query mysql*/

 sprintf(sqlbuf,"select id,name from web_list limit %d",3);
 if(mysql_real_query(&mysql,sqlbuf,strlen(sqlbuf))!= 0){
  fprintf(stderr,"%s%d:mysq; query failed!\n",__FILE__,__LINE__);
   return -1;
 }

/*store mysql result */

if((res=mysql_store_result(&mysql))==NULL){
  fprintf(stderr,"%s %d : result NULL!\n",__FILE__,__LINE__);
  return -1;
  }

 while(row = mysql_fetch_row(res)){

     id = atoi(row[0]);
     fprintf(stderr,"Load web %d...[%s]\n",id,row[1]);
 }


 /* Free mysql result*/
 mysql_free_result(res);

/*close mysql*/

mysql_close(&mysql);

return 0:

}