使用C语言实现MySQL的连接

#include <iostream>
#include <mysql.h>
using namespace std;
 
int main()
{
    //获取客户端的版本信息
    cout<<"mysql client version: "<<mysql_get_client_info()<<endl;
    return 0;
}

mysqlConnect:mysqlConnect.cc
  g++ $^ -o $@ -std=c++11 -I./include -L./lib -lmysqlclient
.PHONY:clean
clean:
  rm -rf mysqlConnect 

MYSQL* mysql_init(MYSQL *mysql);

typedef struct st_mysql {
  NET net;      /* Communication parameters */
    unsigned char *connector_fd;    /* ConnectorFd for SSL */
    char *host,*user,*passwd,*unix_socket,*server_version,*host_info;
    char *info, *db;
    struct charset_info_st *charset;
    MYSQL_FIELD *fields;
    MEM_ROOT field_alloc;
    my_ulonglong affected_rows;
    my_ulonglong insert_id;   /* id if insert on table with NEXTNR */
    my_ulonglong extra_info;    /* Not used */
    unsigned long thread_id;    /* Id for connection in server */
    unsigned long packet_length;
    unsigned int port;
    unsigned long client_flag,server_capabilities;
    unsigned int protocol_version;
    unsigned int field_count;
    unsigned int server_status;
    unsigned int server_language;
    unsigned int warning_count;
    struct st_mysql_options options;
    enum mysql_status status;
    my_bool free_me;    /* If free in mysql_close */
    my_bool reconnect;    /* set to 1 if automatic reconnect */
 
    /* session-wide random string */
    char scramble[SCRAMBLE_LENGTH+1];
    my_bool unused1;
    void *unused2, *unused3, *unused4, *unused5;
 
    LIST *stmts;                     /* list of all statements */
    const struct st_mysql_methods *methods;
    void *thd;
    /*
      Points to boolean flag in MYSQL_RES  or MYSQL_STMT. We set this flag
      from mysql_stmt_close if close had to cancel result set of this object.
    */
    my_bool *unbuffered_fetch_owner;
    /* needed for embedded server - no net buffer to store the 'info' */
    char *info_buffer;
    void *extension;
} MYSQL;

MYSQL* mysql_real_connect(MYSQL *mysql, const char *host,
          const char *user,
          const char *passwd,
          const char *db,
          unsigned int port,
          const char *unix_socket,
          unsigned long clientflag);

void mysql_close(MYSQL *sock);

int mysql_query(MYSQL *mysql, const char *q);

int mysql_set_character_set(MYSQL *mysql, const char *csname);

typedef struct st_mysql_res {
  my_ulonglong  row_count;
  MYSQL_FIELD *fields;
  MYSQL_DATA  *data;
  MYSQL_ROWS  *data_cursor;
  unsigned long *lengths;   /* column lengths of current row */
  MYSQL   *handle;    /* for unbuffered reads */
    const struct st_mysql_methods *methods;
    MYSQL_ROW row;      /* If unbuffered read */
    MYSQL_ROW current_row;    /* buffer to current row */
    MEM_ROOT  field_alloc;
    unsigned int  field_count, current_field;
    my_bool eof;      /* Used by mysql_fetch_row */
    /* mysql_stmt_close() had to cancel this result */
    my_bool       unbuffered_fetch_cancelled;
    void *extension;
} MYSQL_RES;

unsigned int mysql_num_fields(MYSQL_RES *res);

MYSQL_FIELD* mysql_fetch_fields(MYSQL_RES *res);

MYSQL_FIELD* mysql_fetch_fields(MYSQL_RES *res);

typedef struct st_mysql_field {
  char *name;                 /* Name of column */
  char *org_name;             /* Original column name, if an alias */
  char *table;                /* Table of column if column was a field */
  char *org_table;            /* Org table name, if table was an alias */
  char *db;                   /* Database for table */

						

							上一篇：							
								ESC键用于退出C/C++中的while循环							
						
						

							下一篇：							
								避免落入c＃float.Parse / float.TryParse的陷阱