当你需要在纯C语言的应用程序中访问MySQL表中的数据时,是非常繁琐的事情,而该框架可以帮你大量的简化编码的工作,该框架采用Python开发,适用于C语言程序。
示例代码:
#include<db.h>#include<stdio.h>#include<string.h>#include<time.h>intmain(intargc,char**argv){intret;MYSQLglobal_mysql;MYSQL*m;db_ex_customer*cust1;db_ex_item*item1,*item2;mysql_init(&global_mysql);/**connecttoMySQLasusual*/m=mysql_real_connect(&global_mysql,"localhost","root","","ex1",3036,NULL,0);/**passtheMySQLconnectiontofunction,thatinitializesthe"ORM"*/ret=db_init(&global_mysql);/**the*__newmethodcreatesemptystructure*/cust1=db_ex_customer__new();/**settingthestructureattributewithallocatedstring,*itwillbefreedduringcallof*__freemethod*/cust1->name=strdup("alesak");/**thismethodsinsertsthestructureintoaccordingtable.*Ifithasserialfield,itsvalueisreflectedintostructure*/ret=db_ex_customer__insert(cust1);item1=db_ex_item__new();item1->customer_id=cust1->id;item1->itemname=strdup("simpleorm");ret=db_ex_item__insert(item1);item2=db_ex_item__new();item2->customer_id=cust1->id;item2->itemname=strdup("advancedorm");ret=db_ex_item__insert(item2);db_ex_customer__free(cust1);db_ex_item__free(item1);db_ex_item__free(item2);return(0);}
评论