#include<iostream>
#include<string>
#include<cstring>
#include<cstdlib>
#include<cstdio>
#include"mysql/mysql.h"
using namespace std;
int main()
{
MYSQL my_connection;
MYSQL_RES * res_ptr;
MYSQL_ROW sqlrow;
mysql_init(&my_connection);
if(mysql_real_connect(&my_connection,"localhost","root","jueying","test2",0,NULL,0))
cout<<"Connecton success"<<endl;
int res;
res=mysql_query(&my_connection,"select childno,fname,age from children where age > 5");
if(res)
{
cout<<"select error:"<<mysql_error(&my_connection);
}
else
{
res_ptr=mysql_store_result(&my_connection);
if(res_ptr)
{
cout<<"retriveved "<<mysql_num_rows(res_ptr);
while((sqlrow=mysql_fetch_row(res_ptr)))
{
int size_temp=0;
while(size_temp<mysql_field_count(&my_connection))
{
/* cout<<sqlrow[size_temp];
size_temp++;
*/
switch(size_temp)
{
case 0: cout<<"the number of the student :";
break;
case 1:cout<<"the number of the student :";
break;
case 2:
cout<<"the age of the student :";
break;
}
cout<<sqlrow[size_temp]<<endl;
size_temp++;
}
cout<<endl;
}
}
}
mysql_free_result(res_ptr);
return 0;
}