///c++ 链接数据库
编译时用g++ test.c –o mysqltest –L /usr/lib/mysql - lmysqlclient
#include<mysql/mysql.h>
#include<iostream>
#include<stdio.h>
#include<stdlib.h>
using namespace std;
MYSQL *conn;
MYSQL_RES *res;
MYSQL_ROW row;
int main()
{
char *server="localhost";
char *user="root";
char *password = "123456";
char *database = "ysj";
conn = mysql_init(NULL);
//连接数据库
if(!mysql_real_connect(conn,server,user,password,database,0,NULL,0))
{
fprintf(stderr,"%s\n",mysql_error(conn));
exit(1);
}
mysql_set_character_set(conn,"utf8");
if(mysql_query(conn,"select *from students
编译时用g++ test.c –o mysqltest –L /usr/lib/mysql - lmysqlclient
#include<mysql/mysql.h>
#include<iostream>
#include<stdio.h>
#include<stdlib.h>
using namespace std;
MYSQL *conn;
MYSQL_RES *res;
MYSQL_ROW row;
int main()
{
char *server="localhost";
char *user="root";
char *password = "123456";
char *database = "ysj";
conn = mysql_init(NULL);
//连接数据库
if(!mysql_real_connect(conn,server,user,password,database,0,NULL,0))
{
fprintf(stderr,"%s\n",mysql_error(conn));
exit(1);
}
mysql_set_character_set(conn,"utf8");
if(mysql_query(conn,"select *from students