下来的时候赶紧找资料,刚才搜索了几下,终于找到一些:
1,[比较详细]在 C 里嵌入 SQL:http://www.pgsqldb.org/pgsqldoc-7.4/ecpg.html
2,[在MySQL数据库中使用C执行SQL语句]:http://www.dvbbs.net/tech/data/2006031818989.asp
3,MySQL客户工具和API:http://www.yesky.com/imagesnew/software/mysql/manual_Clients.html
4,基于mysql的高性能数据库应用开发:http://cache.baidu.com/c?word=mysql%3B%5F%3Breal%3B%5F%3Bconnect%2C%B2%CE%CA%FD&url=http%3A//www%2Edaima%2Ecom%2Ecn/Info/76/Info27780/&b=0&a=2&user=baidu
大家一起来开始练习罗
注:下面的所有例子在mandriva linux下测试通过
1,使用c语言操作mysql之前,先在mysql里头创建一个数据库,一个表,在表里头添加数据如下:
创建数据库,库名为cusemysql:
mysql>create database cusemysql;
创建表,表名为:
mysql>use cusemysql;
mysql>create table children(childno int not null unique,fname varchar(20),age int);
添加一点数据哦:
mysql>insert into children values(5,"花儿",10);
对拉,为了方便起见,把表的大致样子给大家看看
childno fname age
1 小星 9
2 大量 15
2 ,下面进行具体的操作
插入:insert
好的,我们现编辑一段c代码,取名为insert.c
///
#include <stdio.h>
#include <stdlib.h>
#include "/usr/local/mysql/include/mysql/mysql.h"
int main(int argc, char *argv[])
{
MYSQL my_connection;
int res;
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, "localhost", "root", "","cusemysql",0,NULL,CLIENT_FOUND_ROWS))
{
printf("Connection success/n");
res = mysql_query(&my_connection, "insert into children values(10,'Ann',5)");
if (!res)
{
printf("Inserted %lu rows/n",(unsigned long)mysql_affected_rows(&my_connection));
}
else
{
//分别打印出错误代码及详细信息
fprintf(stderr, "Insert error %d: %s/n",mysql_errno(&my_connection),mysql_error(&my_connection));
}
mysql_close(&my_connection);
}
else
{
fprintf(stderr, "Connection failed/n");
if (mysql_errno(&my_connection))
{
fprintf(stderr, "Connection error %d: %s/n",mysql_errno(&my_connection),mysql_error(&my_connection));
}
}
return EXIT_SUCCESS;
}
/
代码写完了,要编译哦
#gcc -o insert insert.c -L /usr/local/mysql/lib/mysql
#include <stdio.h>
#include <stdlib.h>
#include "/usr/local/mysql/include/mysql/mysql.h"
int main(int argc, char *argv[])
{
MYSQL my_connection;
MYSQL_RES *res_ptr;
MYSQL_ROW sqlrow;
int res;
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, "localhost", "root", "","cusemysql",0,NULL,CLIENT_FOUND_ROWS))
{
printf("Connection success/n");
res = mysql_query(&my_connection, "select childno,fname,age from children where age<20");
if (res)
{
printf("SELECT error:%s/n",mysql_error(&my_connection));
}
else
{
res_ptr=mysql_store_result(&my_connection);
if(res_ptr)
{
printf("Retrieved %lu Rows/n",(unsigned long)mysql_num_rows(res_ptr));
while((sqlrow=mysql_fetch_row(res_ptr)))
{
printf("Fetched data.../n");
}
if (mysql_errno(&my_connection))
{
fprintf(stderr,"Retrive error:%s/n",mysql_error(&my_connection));
}
}
mysql_free_result(res_ptr);
}
mysql_close(&my_connection);
}
else
{
fprintf(stderr, "Connection failed/n");
if (mysql_errno(&my_connection))
{
fprintf(stderr, "Connection error %d: %s/n",
mysql_errno(&my_connection),
mysql_error(&my_connection));
}
}
return EXIT_SUCCESS;
}
//
面语句实现的功能是:检索出年龄小于20岁的小孩的信息,不过没有对信息进行任何处理哦
下次我们对数据进行一定的处理
这里介绍上面用到的几个函数:
|
检索并处理[比较全面哦,呵呵]:select
下面是详细的代码:
//
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include "/usr/local/mysql/include/mysql/mysql.h"
int main(int argc, char *argv[])
{
MYSQL my_connection;
MYSQL_RES *res_ptr;
MYSQL_ROW sqlrow;
MYSQL_FIELD *fd;
char aszflds[25][25];
int res;
int i,j,k;
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, "localhost", "root", "","cusemysql",0,NULL,CLIENT_FOUND_ROWS))
{
printf("Connection success/n");
res = mysql_query(&my_connection, "select childno,fname,age from children where age<20");
if (res)
{
printf("SELECT error:%s/n",mysql_error(&my_connection));
}
else
{
res_ptr=mysql_store_result(&my_connection);
if(res_ptr)
{
printf("Retrieved %lu Rows/n",(unsigned long)mysql_num_rows(res_ptr));
for(i=0;fd=mysql_fetch_field(res_ptr);i++)
strcpy(aszflds[i],fd->name);
printf("下面是检索出的各条记录信息:/n");
j=mysql_num_fields(res_ptr);
for(i=0;i<j;i++)
printf("%s/t",aszflds[i]);
printf("/n");
while((sqlrow=mysql_fetch_row(res_ptr)))
{
for(i=0;i<j;i++)
printf("%s/t",sqlrow[i]);
printf("/n");
}
if (mysql_errno(&my_connection))
{
fprintf(stderr,"Retrive error:s/n",mysql_error(&my_connection));
}
}
mysql_free_result(res_ptr);
}
mysql_close(&my_connection);
}
else
{
fprintf(stderr, "Connection failed/n");
if (mysql_errno(&my_connection))
{
fprintf(stderr, "Connection error %d: %s/n",
mysql_errno(&my_connection),
mysql_error(&my_connection));
}
}
return EXIT_SUCCESS;
}
//
主要要注意的几个地方是:
1,mysql.h的路径,必须确定它的绝对路径哦(这句话是错误的,只要 在编译是把对应库编译进去即可,具体操作方法请查询本博客)
2,注意你的数据库的用户名和密码是否正确
3,在编译的时候必须包含这个库文件mysqlclient.a[记不太清楚,不过你可以直接包含它所在的目录下的所有库,肯定就没有问题,
各方意见:
一.
编译方法有点不规范。
正确的应该是这样:
1.在程序开头包含头文件应这样写:
#include <mysql.h>
2.编译应这样写:
$ gcc -o mysql $(mysql_config --cflags) mysql.c $(mysql_config --libs)