fullname.c

  name="google_ads_frame" marginwidth="0" marginheight="0" src="http://pagead2.googlesyndication.com/pagead/ads?client=ca-pub-5572165936844014&dt=1194442938015&lmt=1194190197&format=336x280_as&output=html&correlator=1194442937843&url=file%3A%2F%2F%2FC%3A%2FDocuments%2520and%2520Settings%2Flhh1%2F%E6%A1%8C%E9%9D%A2%2FCLanguage.htm&color_bg=FFFFFF&color_text=000000&color_link=000000&color_url=FFFFFF&color_border=FFFFFF&ad_type=text&ga_vid=583001034.1194442938&ga_sid=1194442938&ga_hid=1942779085&flash=9&u_h=768&u_w=1024&u_ah=740&u_aw=1024&u_cd=32&u_tz=480&u_java=true" frameborder="0" width="336" scrolling="no" height="280" allowtransparency="allowtransparency"> #include <string.h>
#include <stdio.h>
#include <dir.h>

void main(void)
 {
    char s[MAXPATH];
    char drive[MAXDRIVE];
    char dir[MAXDIR];
    char file[MAXFILE];
    char ext[MAXEXT];

    getcwd(s,MAXPATH);               /* get the current working directory */
    strcat(s,"//");                  /* append on a trailing / character */
    fnsplit(s,drive,dir,file,ext);  /* split the string to separate elems */
    strcpy(file,"DATA");
    strcpy(ext,".TXT");
    fnmerge(s,drive,dir,file,ext);   /* merge everything into one string */
    puts(s);                         /* display resulting string */
}

 

创建具有外键约束的五层关联表 使用自增主键 外键引用完整性 批量插入效率优化 索引优化 数据一致性校验 CHECKZERO(sqlite3_exec(db, "PRAGMA foreign_keys = ON", 0, 0, 0)); const char* createProvinceChStr = "CREATE TABLE IF NOT EXISTS TBL_CxhfCodeProvince(id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL,FullName TEXT NOT NULL, Code TEXT NOT NULL);"; const char* createCityChStr = "CREATE TABLE IF NOT EXISTS TBL_CxhfCodeCity(id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT NOT NULL, FullName TEXT NOT NULL, Code TEXT NOT NULL, province_id INTEGER, FOREIGN KEY (province_id) REFERENCES TBL_CxhfCodeProvince(id));"; const char* createDistrictChStr = "CREATE TABLE IF NOT EXISTS TBL_CxhfCodeDistrict(id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, FullName TEXT NOT NULL, Code TEXT NOT NULL, city_id INTEGER, FOREIGN KEY (city_id) REFERENCES TBL_CxhfCodeCity(id));"; const char* createStreetChStr = "CREATE TABLE IF NOT EXISTS TBL_CxhfCodeStreet(id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, FullName TEXT NOT NULL, Code TEXT NOT NULL, district_id INTEGER, FOREIGN KEY (district_id) REFERENCES TBL_CxhfCodeDistrict(id));"; const char* createCommunityChStr = "CREATE TABLE IF NOT EXISTS TBL_CxhfCodeCommunity(id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, FullName TEXT NOT NULL, Code TEXT NOT NULL, street_id INTEGER, FOREIGN KEY (street_id) REFERENCES TBL_CxhfCodeStreet(id));"; // 不存在就插入OR IGNORE 不存在就更新OR REPLACE const char* Provincesql = "INSERT OR IGNORE INTO TBL_CxhfCodeProvince(id, name, FullName,Code) VALUES (?, ?, ?, ?);"; const char* Citysql = "INSERT OR IGNORE INTO TBL_CxhfCodeCity(id, name, FullName, Code, province_id) VALUES (?, ?, ?, ?, ?);"; const char* Districtsql = "INSERT OR IGNORE INTO TBL_CxhfCodeDistrict(id, name, FullName, Code, city_id) VALUES (?, ?, ?, ?, ?);"; const char* Streetsql = "INSERT OR IGNORE INTO TBL_CxhfCodeStreet(id, name, FullName, Code, district_id) VALUES (?, ?, ?, ?, ?);"; const char* Communitysql = "INSERT OR IGNORE INTO TBL_CxhfCodeCommunity(id, name, FullName, Code, street_id) VALUES (?, ?, ?, ?, ?);"; sqlite3_exec(db, "BEGIN TRANSACTION", 0, 0, &errMsg); // 准备插入省份的预编译语句 sqlite3_stmt* stmt; const char* Provincesql = "INSERT OR IGNORE INTO TBL_CxhfCodeProvince(name, FullName, Code) VALUES (?, ?, ?);"; sqlite3_prepare_v2(db, Provincesql, -1, &stmt, nullptr); for (int i = 0; i < provinceCount; ++i) { sqlite3_bind_text(stmt, 1, provinces[i].name.c_str(), -1, SQLITE_STATIC); sqlite3_bind_text(stmt, 2, provinces[i].fullName.c_str(), -1, SQLITE_STATIC); sqlite3_bind_text(stmt, 3, provinces[i].code.c_str(), -1, SQLITE_STATIC); sqlite3_step(stmt); sqlite3_reset(stmt); } sqlite3_finalize(stmt); // 提交事务 sqlite3_exec(db, "COMMIT", 0, 0, &errMsg); 能否封装成CreateTable函数
07-15
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值