MYSQLmysql;//创建一个mysql对象mysql_init(&mysql);//初始化mysql结构mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"utf-8");//设置数据库编码格式if(mysql_real_connect(&mysql,"l...
MYSQL mysql; //创建一个mysql对象mysql_init(&mysql);//初始化mysql结构mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"utf-8");//设置数据库编码格式if(mysql_real_connect(&mysql,"localhost","root","950420","server",3306,NULL,0)){AfxMessageBox("数据库连接失败");return ;}//数据库连接成功//将数据库的内容读取到程序当中MYSQL_RES *result;//查询结果集MYSQL_ROW sql_row; //行数//MYSQL_FIELD *fd;CString ip_address=""; CString port="";int res=mysql_query(&mysql,"select ip_address,port from set_param");if(!res){result=mysql_store_result(&mysql); //保存查询到的数据集到resultif(result){while(sql_row=mysql_fetch_row(result));//获得具体的数据ip_address=sql_row[0]; //获取数据库中存放的ip地址port=sql_row[1];//获取数据中存放的portGetDlgItem(IDC_IPADDRESS1)->SetWindowText(ip_address); //把数据库中的值 设置到程序当中GetDlgItem(IDC_port)->SetWindowText(port);}}mysql_close(&mysql);
展开