C/Visual C - EJMEPLO DE C++ Y SQL

/*

 |==========================================================================

 | demo12.c   ejemplo de superindio

 |==========================================================================

 */

#include <stdio.h>

#include <string.h>

#include "mysql.h"

int main( int argc, char *argv[] ) {

        MYSQL *conn;                    /* variable de conexión para MySQL                                */

        MYSQL_RES *res;                 /* variable que contendra el resultado de la consuta              */

        MYSQL_ROW  row;                 /* variable que contendra los campos por cada registro consultado */

        char *server   = "localhost";   /* direccion del servidor 127.0.0.1, localhost o direccion ip     */

        char *user     = "root";        /* usuario para consultar la base de datos                        */

        char *password = "";            /* contraseña para el usuario en cuestion                         */

        char *database = "dbcalabresa"; /* nombre de la base de datos a consultar                         */

        unsigned long  iLeng=0;

        conn = mysql_init(NULL);        /* inicializacion a nula la conexión                              */

        /* conectar a la base de datos                                    */

        if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) {

                /* definir los parámetros de la conexión antes establecidos */

                fprintf(stderr, "%s\n", mysql_error(conn)); /* si hay un error definir cual fue dicho error */

                printf("hay un error al conectar MariaDB \n");

                return(-1);

        }

        res = mysql_list_processes(conn);

        iLeng = mysql_fetch_lengths(res);

        printf("%l\n", iLeng );

        while ((row = mysql_fetch_row(res)) != NULL)

                /* printf("%s\t%s\t%s \n", row[0],row[1],row[2]);   */

                printf("%s\t%s\t%s \n", row[0],row[2],row[6]);

        mysql_free_result(res);

        mysql_close(conn);

}

/*

 |--------------------------------------------------------------------

 | c:\Mariadb\bin>mysql -h localhost -u root -p

 |

 | SHOW PROCESSLIST (command for mysq console)

 |  0   1       2      3    4         5      6       7      8

 | Id | User  | Host | db | Command | Time | State | Info | Progress |

 |--------------------------------------------------------------------

 */

@Echo Off

Rem  Compile options file directory path.

Set  LD_LIBRARY_PATH=C:\MinGW\lib\;C:\MinGW\local\lib\;c:\Mariadb\lib\

Set  DIRLIB=C:\Mariadb\lib

Set  INCMGW=C:\MinGW\Include

Set  INCSQL=C:\Mariadb\include\mysql

Rem  Win32 (MinGW) dynamically loaded DLL search path.

Set  PATH=C:\MinGW;C:\MinGW\bin;C:\MinGW\local\bin;c:\Mariadb\bin;c:\Mariadb\lib;%PATH%

Rem  Temporary files directory path.

Set  TEMP=%TEMP%

Set CODC=%1.c

Set CODO=%1.o

Set CODE=%1.exe

Rem C:\MinGW\bin\gcc test.c -o test -Wl,-v

Rem C:\MinGW\bin\gcc -c %CODC% -o %CODO%

@Echo On

Rem C:\MinGW\bin\gcc %CODC% -o %CODE%  --verbose

echo ===================================================================

echo -I%INCMGW% -I%INCSQL%

echo ===================================================================

rem C:\MinGW\bin\gcc -I%INCMGW% -I%INCSQL%  %CODC% -o %CODE%  -lpdcurses -lpdcurses_dll  --verbose

C:\MinGW\bin\gcc -I%INCMGW% -I%INCSQL% -L%DIRLIB% -L%LD_LIBRARY_PATH% %CODC% -o %CODE%  -lmysql --verbose