sql_insert.c~

教学资源管理系统教室分配子系统,也是一个毕业设计.minigui下的!

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


int sql_instert (char jioashi[10] , char riqi[16] , ){
	sqlite3 *db = NULL;
	char  *zErrMsg = 0 , sql_cmd[100];
	int rc;


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

	rc = sprintf(sql_cmd,"INSERT INTO sq (jiaoshi,xingqi,kebie) VALUES('205','星期一','一二节')");
	rc = sqlite3_exec(db,sql_cmd,  NULL, NULL, &zErrMsg);

	if(rc==SQLITE_OK)

		printf("inster sq successful\n");

	else

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