mysql的代码_mysql操作代码

int_tmain(intargc, _TCHAR*argv[])

{

MYSQL MyData;if(0!=mysql_library_init(0, NULL, NULL))

{

cout<

cout<

}if(NULL==mysql_init(&MyData))

{

cout<

cout<

}if(0!=mysql_options(&MyData, MYSQL_SET_CHARSET_DIR,"gbk"))

{

cout<

cout<

}if(NULL==mysql_real_connect(&MyData,"localhost","root","123","test",6666, NULL,0))

{

cout<

cout<

}stringSqlStr="create table bblovedd";

SqlStr+="(";

SqlStr+="name varchar(30),";

SqlStr+="id int not null primary key";

SqlStr+=")";if(0!=mysql_query(&MyData, SqlStr.c_str()))

{

cout<

cout<

}

SqlStr="insert into bblovedd values ('wangjb', 20090703)";if(0!=mysql_query(&MyData, SqlStr.c_str()))

{

cout<

cout<

}

SqlStr="select * from bblovedd";

MYSQL_RES*result=NULL;if(0!=mysql_query(&MyData, SqlStr.c_str()))

{

cout<

cout<

}

result=mysql_store_result(&MyData);

my_ulonglong RowCount=mysql_num_rows(result);

cout<

unsignedintFieldCount=mysql_num_fields(result);

MYSQL_FIELD*field=NULL;for(unsignedinti=0; i

{

field=mysql_fetch_field_direct(result, i);

cout<name<

}

cout<

MYSQL_ROW row=NULL;

row=mysql_fetch_row(result);while(row)

{for(unsignedinti=0; i

cout<

cout<

row=mysql_fetch_row(result);

}

SqlStr="drop table bblovedd";if(0!=mysql_query(&MyData, SqlStr.c_str()))

{

cout<

cout<

}

mysql_free_result(result);

mysql_close(&MyData);

mysql_server_end();return0;}