: .c .oCC=gcc SRCS=mysql1.c mydb.cOBJS=$(SRCS:.c=.o) EXEC=mysql1all: $(OBJS)$(CC) -o $(EXEC) $(OBJS) -lmysqlclient@echo ‘-------------ok--------------‘.c.o:$(CC) -Wall -g -o $@ -c $< clean:rm -f $(OBJS)rm -f core*mydb.h#ifndef MYDB_H_ #define MYDB_H_void init_db(); int conn_db(const char *hostname, const char *username, const char *password,const char *dbname); void disconn_db(); int ...
#include <string.h> #include <stdlib.h> #include <math.h>#include "/usr/local/mysql/include/mysql.h"static MYSQL mysql, *sock; char sql[1024]; MYSQL_RES *res=NULL; MYSQL_ROW row ; int num_fields; int num_rows = 0;int main(){memset(sql, 0x00, sizeof(sql));mysql_init(&mysql); if(!(sock = mysql_real_connect(&mysql, (char *)"localhost", (char *)"ebipcs", (char *)"Dcep2vUnAX"...
#include <string.h> #include <stdlib.h> #include <math.h>#include "/usr/local/mysql/include/mysql.h"static MYSQL mysql, *sock; char sql[1024]; MYSQL_RES *res=NULL; MYSQL_ROW row ; int num_fields; int num_rows = 0;int main(){memset(sql, 0x00, sizeof(sql));mysql_init(&mysql); if(!(sock = mysql_real_connect(&mysql, (char *)"localhost", (char *)"ebipcs", (char *)"Dcep2vUnAX"...
//////////////////////////// /*建立第1张表 goods*////////////////////////////////////////////////////////////////// void create_goods() {int rc; //rc为返回值,判断函数是否执行成功 rc=0函数执行成功,rc !=0函数执行失败sqlite3 *db; //SQLite数据库指针 sqlite3结构体 *db指向sqlite3结构体的指针char *pFileName = "Taobao_Shopping.db"; //数据库文件名char * zErr; /* 定义返回错误信息的变量*/rc = sql...