#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);
}