test_tof.cxx File Reference

#include <iostream>
#include <string>
#include <cstdlib>
#include <time.h>
#include <stdio.h>
#include <string.h>
#include <mysql/mysql.h>
#include <fstream>

Go to the source code of this file.

Macros
#define	TEST_SQL

Functions
int	main (int argc, char **argv)

Macro Definition Documentation

TEST_SQL

#define TEST_SQL

Definition at line 12 of file test_tof.cxx.

Function Documentation

main()

int main	(	int	argc,
		char **	argv
	)

Definition at line 14 of file test_tof.cxx.

                                {
  char *opt_host_name = "bes3db1.ihep.ac.cn";   
 char *opt_user_name = "maqm";   
 unsigned int opt_port_num = 3306;   
 char *opt_socket_name = NULL;   
 char *opt_db_name = "offlinedb";
 unsigned int opt_flags = 0;   
 MYSQL *conn;   
 
 
 
 conn = mysql_init(NULL);   
     
 mysql_real_connect(conn, opt_host_name, opt_user_name, opt_password, 
           opt_db_name, opt_port_num, opt_socket_name, opt_flags);
 //printf("connect the database ok\n");
  if(conn!=0){
    std::cout<<"connect the database ok\n"<<std::endl;
  }else{
    std::cout<<"can't connect to the db:"<<std::endl;
    return -1;
  }
  
unsigned long *lengths;
 
 MYSQL_RES *res_set;
 MYSQL_ROW row;
 
 char stmt1[200];//="select context from mytesttable where id = %d,";
 sprintf(stmt1,"select  EtfTofPar from TofCalConst where serno = 2098");
 
 printf("%s\n",stmt1);
 
 int status = mysql_real_query(conn, stmt1, strlen(stmt1)); 
  if(status)
    {
          std::cout << "Query is:" <<stmt1<< " failed: " << mysql_error(conn) << std::endl;
          return -1;}
 res_set = mysql_store_result (conn);
 mysql_field_seek (res_set, 0); 
 
 //int lengths = 0;
 row = mysql_fetch_row (res_set);
 lengths = mysql_fetch_lengths(res_set);
  std::cout<<"lengths[0]: " << lengths[0] <<std::endl;
 
 mysql_free_result(res_set);
 
 mysql_close(conn);
 
 
 
  return 0;
}