代码:
% c% n7 l& E) J9 W #include
+ T- F1 F& s! \3 j/ W5 c #include 4 t. M( f4 ?8 m# ~' F' z8 F
#include "/usr/local/include/mysql/mysql.h" //安装的mysql的头文件所在的位置
2 u0 P4 m( U2 c5 e! w using namespace std;
4 [7 W8 v9 }1 n+ r0 {; @: {. U string host="数据库地址";4 W" K8 ^ m5 w% m
string user="用户名";" m/ G7 ]: b: p8 l2 h o9 I" `7 b
string pwd="密码";
* i6 W3 x( K; B# K$ Y5 x string dbname="数据库";' x4 A3 ~, S- g& X# w
string sql="查询语句";
6 i3 m; Z: t: o% ~, _ unsigned int port=3309;#端口号/ E$ N% G: _$ P: H# F/ C; K
int status;
5 s% Q |$ ` b: g( e8 I int main(){9 N) U5 u0 R$ h% G+ A
MYSQL *mysql;) E% J# G; I( J4 h/ R- F
mysql=mysql_init(0);9 O% M$ Q9 \9 i# ^
MYSQL_RES *result;7 y1 @( { ]0 h$ M; |, _3 z; R
MYSQL_ROW row;1 }; Y. C. e1 o: }
if(mysql_real_connect(mysql,host.c_str(),user.c_str(),pwd.c_str(),dbname.c_str(),port,NULL,CLIENT_FOUND_ROWS)==NULL){
% m9 h) w+ K/ @, D' {. n cout |