sql_db_del.c

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

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


int sql_db_del (char jilu[11]){
	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);
//	 sprintf(sql_cmd,"DELETE FROM sq WHERE number = '%s'",jilu);
rc = sprintf(sql_cmd,"UPDATE sq SET xingqi = '%s',kebie = '%s',jiaoshi = '%s',riqi = '%s' WHERE number = '%s'","空","空","空","空",jilu);
	rc = sqlite3_exec(db,sql_cmd,  NULL, NULL, &zErrMsg);

	if(rc==SQLITE_OK)

		printf("dele sq successful\n");

	else

		printf("%s\n",zErrMsg);
	sqlite3_close(db); //关闭数据库
}