mysql++ 테스트 > C , C++

• 목록

mysql 에서 데이타베이스와 테이블을 만들고 자료을 넣고 테스트함



#include<iostream>
#include<winsock2.h>
#include<mysql++>
using namespace std;

#define USER  "root"
#define PASS  "1234567890"
#define TABLE "toto"
#define DB    "aeo"

int main()
{

MYSQL mysql;
MYSQL_RES *res;
MYSQL_ROW  row;
int count,i;

mysql_init(&mysql);
if(mysql_real_connect(&mysql,NULL,USER,PASS,NULL,3306,NULL,0)==0)
{
    cout <<"Connect No"<<endl;
    exit(0);
}else{
cout <<"Connect Ok"<<endl;
mysql_select_db(&mysql,DB);
if(mysql_query(&mysql,"select * from " TABLE)==1){
cout <<"Query No"<<endl;
}else{
cout <<"Query Ok"<<endl;
res=mysql_store_result(&mysql);
count=mysql_num_fields(res);
while((row=mysql_fetch_row(res)))
{
for(i=0;i<count;i++)
cout << row[i] <<" ";
cout << endl;
}
}
}
mysql_free_result(res);
    mysql_close(&mysql);

return 0;
}