mytest.c

嵌入式MYSQL编程例子,在WINDOWS或者LINUX上都可以运行

/*C4*/
/****************************************************************/
/*	Author:	Jethro Wright, III	TS :  3/ 4/1998  9:15	*/
/*	Date:	02/18/1998					*/
/*	mytest.c :  do some testing of the libmySQL.DLL....	*/
/*								*/
/*	History:						*/
/*		02/18/1998  jw3  also sprach zarathustra....	*/
/****************************************************************/


#include        <windows.h>
#include	<stdio.h>
#include	<string.h>

#include	"mysql.h"

#define		DEFALT_SQL_STMT	"SELECT * FROM db"
#ifndef offsetof
#define offsetof(TYPE, MEMBER) ((size_t) &((TYPE *)0)->MEMBER)
#endif


/********************************************************
**
**		main  :-
**
********************************************************/
MYSQL mysql; 


void YQSQL_Test()
{
if (!mysql_set_character_set(&mysql, "GB2312"))
{
    MY_CHARSET_INFO cs;
    mysql_get_character_set_info(&mysql, &cs);

    if(strcmp(cs.csname,"gb2312") != 0)

    printf("character set information:\r\n");
    printf("character set name: %s\r\n", cs.name);
    printf("collation name: %s\r\n", cs.csname);
    printf("comment: %s\r\n", cs.comment);
    printf("directory: %s\r\n", cs.dir);
    printf("multi byte character min. length: %d\r\n", cs.mbminlen);
    printf("multi byte character max. length: %d\r\n", cs.mbmaxlen);
}
}


MYSQL_RES*  find_ps () 
{ 
   MYSQL_ROW m_row; 
   MYSQL_RES *m_res; 
   char sql[1024];
   int res=1; 
   int j = 0;
   int k = 0;
   char input;

   int *id; 
 int result;



    memset(sql,0,1024);
   
  strcpy(sql,"select * from FAX_YHB");


        if(mysql_query(&mysql,sql) != 0) 
        { 
            printf("sql error: =%s  ",sql);
            return res; 
        } 
        m_res = mysql_store_result(&mysql); 
        if(m_res==NULL) 
        { 
            res = 3; 
            return res; 
        } 

        while ( m_row = mysql_fetch_row( m_res ) ) 
        {
            j = mysql_num_fields( m_res ) ;

            for ( k = 0 ; k < j ; k++ )
            {
              printf("%s    ",((m_row[k]==NULL)||(!strlen(m_row[k])))?"NULL":m_row[k]);
            }
            puts( "\r\n==============================" ) ;
        }
   mysql_free_result(m_res); 
   
   return res; 
} 
void print_char(char** g)//当调用的时候传递进来的不是数组,而是字
{
    int i = 0;
    for(i = 0; i < 4; i++)
    {
        printf("%s    ",g[i]);
    }
}

 
int
main( int argc, char * argv[] )
{
   char host[32]="192.168.1.99"; 
   char user[32]="root"; 
   char passwd[32]="yq902902"; 
   char dbname[32]="switch";    
    


   char a[5];
   char *result[] = {"abc","abcde","abcde","abcdef"};


print_char(result);
       //char **p = 


   if( mysql_init(&mysql) == NULL ) 
   {      
      return 1; 
   } 
   if (mysql_real_connect(&mysql,host,user,passwd,dbname,0,NULL,0) == NULL) 
   {       
      return 1; 
   } 
   YQSQL_Test();
   find_ps();   
   mysql_close(&mysql);     
   return 0; 
}