作者:dangfm
标签:paths mysql search inherited xcode
感谢原作者!
<pre code_snippet_id=
"332709"
snippet_file_name=
"blog_20140507_1_2438306"
name=
"code"
class
=
"objc"
>#import <mysql.h>
MYSQL mysql;
int
mysql_connection(){
mysql_init(&mysql);
if
(!mysql_real_connect(&mysql,
"127.0.0.1"
,
"root"
,
""
,
"test"
, 3306, NULL, 0)){
NSLog(@
"连接失败"
);
}
else
{
NSLog(@
"连接成功"
);
}
return
(0);
}
int
mysql_execute(){
int
i = mysql_query(&mysql,
"SELECT * FROM testsss"
);
if
(i) {
NSLog(@
"查询失败"
);
}
else
{
NSLog(@
"查询成功"
);
}
MYSQL_RES *result = mysql_store_result(&mysql);
if
(result) {
int
num_fields = mysql_num_fields(result);
int
num_rows = mysql_num_rows(result);
NSLog(@
"有多少条记录:%d"
,num_rows);
}
return
0;
}
</pre>