源代码:
#include <Windows.h>
#include <mysql.h>
#include <iostream>
using namespace std;
int main()
{
MYSQL mysql;
MYSQL_RES *res;
MYSQL_ROW row;
mysql_init(&mysql);
if (!mysql_real_connect(&mysql, "localhost", "root", "111111", "geng", 3306, NULL, 0))
cout << "数据库连接失败" << endl;
else
cout << "数据库连接成功" << endl;
char sno[20];
char name[20];
char age[10];
char sqlstr[1024];
printf("输入学号:");
scanf("%s", sno);
printf("输入姓名:");
scanf("%s", name);
printf("输入年龄:");
scanf("%s",age);
int len = sprintf(sqlstr, "INSERT INTO cc (sno,name,age) VALUES('%s','%s','%s');", sno,name,age);
mysql_query(&mysql, sqlstr);
if (len < 0)
printf("insert data failed\n");
else
printf("insert data succeed\n");
mysql_query(&mysql, "select * from cc");
res = mysql_store_result(&mysql);
printf("sno\t name\t age\n");
while (row = mysql_fetch_row(res))
{
printf("%s\t ",row[0]);
printf("%s\t ",row[1]);
printf("%s\t ",row[2]);
puts("");
}
//释放结果集
mysql_free_result(res);
mysql_close(&mysql);
return 0;
}