#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;
}