?? sql_db_del.c
字號:
#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); //關閉數據庫
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -