sqlite and rtree_拔剑-浆糊的传说_新浪博客

// from lilin

// 创建表

ansiSQL.Format(" CREATE TABLE %s_%d (ID INTEGER PRIMARY KEY,nFID INTEGER,BSM INTEGER,DLBM VARCHAR(6),YSDM VARCHAR(15),TBBH VARCHAR(10),DLMC VARCHAR(60),QSXZ VARCHAR(3),QSDWDM VARCHAR(20),QSDWMC VARCHAR(60),TBMJ DOUBLE, XZQDM VARCHAR(20),XZQMC VARCHAR(60),R INTEGER, G INTEGER, B INTEGER, geometry blob );", layerNameAnsi, iLevel);

tmpSQL = (char *)LPCSTR(ansiSQL);

utf8SQL = AnsiToUTF_8(tmpSQL);

sqlite3_exec( m_db , utf8SQL , 0 , 0 , &zErrMsg );

//创建索引虚表

ansiSQL.Format(" CREATE VIRTUAL TABLE  %s_%d_INDEX USING RTREE (ID INTEGER PRIMARY KEY, MINX DOUBLE, MAXX DOUBLE, MINY DOUBLE, MAXY DOUBLE);", layerNameAnsi, iLevel);

tmpSQL = (char *)LPCSTR(ansiSQL);

utf8SQL = AnsiToUTF_8(tmpSQL);

sqlite3_exec( m_db , utf8SQL , 0 , 0 , &zErrMsg );

// 如果更新记录，增删改几何体时

更新索引的方法：在虚表中插入(ID,MBR)