Linux下通过C++语言代码来操作MySQL数据库以下文字资料是由(历史新知网www.lishixinzhi.com)小编为大家搜集整理后发布的内容,让我们赶快一起来看一下吧!
代码
#include #include #include /usr/local/include/mysql/mysql h //安装的mysql的头文件所在的位置 using namespace std; string host= 数据库地址 ; string user= 用户名 ;
string pwd= 密码 ; string dbname= 数据库 ; string sql= 查询语句 ; unsigned int port= ;#端口号 int status; int main(){ MYSQL *mysql; mysql=mysql_init( ); MYSQL_RES *result; MYSQL_ROW row; if(mysql_real_connect(mysql host c_str() user c_str() pwd c_str() dbname c_str() port NULL CLIENT_FOUND_ROWS)==NULL){ cout << connect failure! << endl; return EXIT_FAILURE; }else{ cout << connect success! << endl; } mysql_set_character_set(mysql gbk ); status=mysql_query(mysql sql c_str()); if(status != ){ cout << query failure! << endl; } cout << the status is : << status << endl; result=mysql_store_result(mysql); while(row=mysql_fetch_row(result)){ cout << row[ ] << | << row[ ] << endl; } mysql_free_result(result); mysql_close(mysql); }
编译
g++ o test test cpp lmysqlclient I/usr/local/include/mysql/ L/usr/local/lib/mysql lishixinzhi/Article/program/MySQL/201311/29472
分页:123