Visual C++ > Tip&Tech > mysql ¿¬µ¿ C ÇÁ·Î±×·¡¹Ö
 
C/C++
Library
Tip&Tech
Q&A
 
 
Tip&Tech
  HOME > Visual C++ > Tip&Tech
 
ÀÛ¼ºÀÏ : 10-08-10 20:44
mysql ¿¬µ¿ C ÇÁ·Î±×·¡¹Ö
 ±Û¾´ÀÌ : µ¢º¡ÀÌ (211.¢½.155.10)
Á¶È¸ : 5,123   Ãßõ : 0   ºñÃßõ : 0  
#define SOCKET int
//#include <windows.h>
//#include <winsock.h>
#include <mysql.h>
#include <string.h>
#include <stdio.h>

#pragma comment(lib, "libmySQL.lib")
#pragma comment(lib, "ws2_32.lib") 

#define DB_HOST "localhost"
#define DB_USER "root"
#define DB_PASS "1234"
#define DB_NAME "haksa"

int main()
{
    MYSQL *connection=NULL, conn;
    MYSQL_RES *sql_result;
    MYSQL_ROW sql_row;
    int query_stat;
 
    char query[255];

 mysql_init(&conn);
 connection = mysql_real_connect(&conn,
  DB_HOST,
        DB_USER,
  DB_PASS,
  DB_NAME,
  3306,(char *)NULL, 0);

    if(connection==NULL)
    {
        fprintf(stderr, "Mysql connection error : %s", mysql_error(&conn));
        return 1;
    }

 /*
    sprintf(query,"%s","create table D1day ( no int, name char(8) )");

 query_stat=mysql_query(connection,query );
    if (query_stat != 0)
    {
        fprintf(stderr, "Mysql query error : %s", mysql_error(&conn));
        return 1;
    }


  // ·¹ÄÚµå »ðÀÔ
    for(int i=0;i<100;i++)
    { 
        sprintf(query,"insert into dday values('%d','%s')",i,"aaaaaaaa");
        query_stat = mysql_query(connection, query);
        if (query_stat != 0)
        {
            fprintf(stderr, "Mysql query error : %s", mysql_error(&conn));
            return 1;
        }
    }
 */

 // ¼¿·ºÆ®
 sprintf(query,"select * from dday");
    query_stat=mysql_query(connection,query);
    if (query_stat != 0)
    {
        fprintf(stderr, "Mysql query error : %s", mysql_error(&conn));
        return 1;
    }
    // °á°ú Ãâ·Â
    sql_result=mysql_store_result(connection);
    while((sql_row=mysql_fetch_row(sql_result))!=NULL)
    {
        printf("[%2s] %s\n",sql_row[0],sql_row[1]);
    }
    mysql_free_result(sql_result);

    // DB ¿¬°á ´Ý±â
    mysql_close(connection);

 return 0;   
}


 
 

Total 66,696
¹øÈ£ Á¦   ¸ñ ±Û¾´ÀÌ ³¯Â¥ Ãßõ ºñÃßõ Á¶È¸
66696 ¸®´ª½º¿ë ºñµ¿±â ¼ÒÄÏ Å¬·¡½º µ¢º¡ÀÌ 08-10 0 0 5736
66695 mysql ¿¬µ¿ C ÇÁ·Î±×·¡¹Ö µ¢º¡ÀÌ 08-10 0 0 5124
66694 [¸®´ª½º C]¼ÒÄÏÀ» ÀÌ¿ëÇÑ TCP Åë½Å. ¼­¹ö&Ŭ¶óÀÌ¾ðÆ® ±âÃÊ µ¢º¡ÀÌ 08-10 0 0 9162
66693 ¸®´ª½º»ç¿ë½Ã ÂüÁ¶ => ¸®´ª½º¿¡¼­ ÄÄÆÄÀϽà sqrt(), atan(), ¡¦ µ¢º¡ÀÌ 05-27 0 0 5523
66692 [C] strlen, strcmp, strcpy, strcat Á÷Á¢ ÀÛ¼ºÇϱ⠵¢º¡ÀÌ 05-26 0 0 5519
66691 ¸®´ª½º»ç¿ë½Ã ÂüÁ¶ => ÀԷ¹öÆÛ ºñ¿ì±â fflush(stdin) MS VS ¡¦ µ¢º¡ÀÌ 05-25 0 0 7506
66690 ¹®ÀÚ¿­ ´Ù·ç±â (º¹»ç, ÇÕÄ¡±â, ºñ±³Çϱâ) µ¢º¡ÀÌ 05-14 0 0 10536
66689 °£´ÜÇÑ if¹® µ¢º¡ÀÌ 04-24 0 0 5147
 1  2  3  4  5  6  7  8  9  10    
 
°³ÀÎȨÆäÀÌÁö ´ýº¡´åÄÄÀº ÇÁ·Î±×·¡¸Ó¿Í µðÀÚÀ̳ÊÀ§ÇÑ ITÄ¿¹Â´ÏƼ °ø°£ÀÔ´Ï´Ù.
Copyright ¨Ï www.dumbung.com. All rights reserved.