更新mysql数据，pos机程序升级信息

/*
 ============================================================================
 Name        : MysqlTest.c
 Author      : SMBRAVE
 Version     :
 Copyright   : Your copyright notice
 Description : Hello World in C, Ansi-style
 ============================================================================
 */

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

#define CONFIG_FILE        "update.conf"
typedef struct m_config{
    int version;
    char *download_url;
    char *database_name;
}MConfig;
//读取参数
int ReadConf(MConfig *mconfig)
{
    FILE * fp;
    char buf[1024],*p;
    int len;
    //打开文件失败
    if((fp = fopen(CONFIG_FILE,"r")) == NULL){
        perror("Conf open fail");
        return -1;
    }

    //fgets遇到换行或EOF会结束
    while(fgets(buf,sizeof(buf),fp)!=NULL)
    {
        if((buf[0]=='#') || (buf[0]=='\n') )
            continue;//继续下一循环
        len=strlen(buf);
        if(buf[len-1]=='\n') buf[len-1]='\0';
        //寻找’=‘及数据
        if(((p=strchr(buf,'=')) == NULL) || (p==buf) )//if not find =
            continue;
        *p='\0';
        p++;
        for(len=0; len < strlen(buf); len++)
            buf[len]=tolower(buf[len]);
        printf("[Parameter]%s:%s\n",buf,p);
////////////////////////////////读取参数/////////////////////////////////////////////////////////
        //版本号 参数
        if(!strcmp(buf,"version")) mconfig->version = atoi(p);
        //下载程序的地址 参数
        if(!strcmp(buf,"download_url")){
            mconfig->download_url = (char *)malloc(strlen(p) + 1);
            strcpy(mconfig->download_url,p);
        }

        //数据库名 参数
        if(!strcmp(buf,"database_name")){
            mconfig->database_name = (char *)malloc(strlen(p) + 1);
            strcpy(mconfig->database_name,p);
        }
////////////////////////////////////////////////////////////////////////////////////////////////
    }
    return 0;
}
//释放参数
int FreeConf(MConfig *mconf)
{
    //释放下载地址
    if(mconf->download_url != NULL)
        free(mconf->download_url);

    //释放数据库名
    if(mconf->database_name != NULL)
        free(mconf->database_name);
}

int main(void)
{
    char *server = "localhost";
    char *user = "ocard";
    char *password = "ocardmysql";
    MYSQL *mysql;
    MYSQL_RES *res;
    MYSQL_ROW row;
    MConfig conf;

    if(ReadConf(&conf)!=0)return -1;

    mysql = mysql_init(NULL);
    //连接数据库
    if (!mysql_real_connect(mysql, server, user, password, conf.database_name, 0, NULL, 0)) {
        fprintf(stderr, "%s\n", mysql_error(mysql));
        return -1;
    }

    //更新
    char update_sql[200];
    sprintf(update_sql,"UPDATE SYSTEM_CONFIG SET "
            "SYSTEM_LTIME=NOW(),SYSTEM_IVALUE=%d,SYSTEM_SVALUE='%s' "
            "WHERE SYSTEM_KEY='POS_APP_UPDATE_INFO'",conf.version,conf.download_url);
    if (mysql_real_query(mysql, update_sql,(unsigned int ) strlen(update_sql))) {
        fprintf(stderr, "%s\n", mysql_error(mysql));
        return -1;
    }

    //查询
    char *select_sql = "SELECT * FROM SYSTEM_CONFIG WHERE SYSTEM_KEY='POS_APP_UPDATE_INFO'";
    if (mysql_real_query(mysql, select_sql,(unsigned int ) strlen(select_sql))) {
        fprintf(stderr, "%s\n", mysql_error(mysql));
        return -1;
    }
    res = mysql_use_result(mysql);

    while ((row = mysql_fetch_row(res)) != NULL){
        int t;
        for(t = 0;t < mysql_num_fields(res);t++)
            printf("%s ",row[t]);
        printf("\n");
    }

    FreeConf(&conf);
    mysql_free_result(res);
    mysql_close(mysql);
    return EXIT_SUCCESS;
}