sql_insert.c

来自「教学资源管理系统教室分配子系统,也是一个毕业设计.minigui下的!」· C语言 代码 · 共 25 行

#include <stdio.h>
#include "sqlite3.h" /* orignal is <sqlite3.h> */


int sql_instert (char daxia[12] , char ke[12] , char jiaoshi[12] ,char riqi[12]){
	sqlite3 *db = NULL;
	char  *zErrMsg = 0 , sql_cmd[200];
	int rc;


	sqlite3_open("zieckey.db", &db);

rc = sprintf(sql_cmd,"INSERT INTO sq (xingqi,kebie,jiaoshi,riqi) VALUES('%s','%s','%s','%s')",daxia,ke,jiaoshi,riqi);
//rc = sprintf(sql_cmd,"INSERT INTO sq (xingqi,kebie,jiaoshi,riqi) VALUES('星期一','晚自习','203','2008/04/20')");
	rc = sqlite3_exec(db,sql_cmd,  NULL, NULL, &zErrMsg);

	if(rc==SQLITE_OK)

		printf("inster sq successful\n");

	else

		printf("%s\n",zErrMsg);
}