linux内核数据库sqlite3的移植,sqlite3嵌入式数据库arm+linux移植

1.   下载sqlite3源代码

2. 解压源代码&＃xff1a;

tar  xvzf   sqlite-amalgamation-3.6.1.tar.gz

3. 配置交叉编译到arm linux平台:

./configure --prefix&＃61;/home/rootfs/home/sqlite --target&＃61;arm-linux --host&＃61;arm-linux LD&＃61;arm-linux-ld

4. 编译:

make

5. 安装:

make install

头文件和生成的库文件将安装到:/home/rootfs/home/sqlite目录下。

6. 写自己的数据库应用

&＃xff03;i nclude &＃xff03;i nclude static int callback(void *NotUsed, int argc, char **argv, char **azColName){

int i;

for(i&＃61;0; iprintf("%s &＃61; %s\n", azColName[i], argv[i] ? argv[i] : "NULL");

}

printf("\n");

return 0;

}

int main(int argc, char **argv){

sqlite3 *db;

char *zErrMsg &＃61; 0;

int rc;

if( argc!&＃61;2 ){

fprintf(stderr, "Usage: %s DATABASE \n", argv[0]);

return 0;

}

rc &＃61; sqlite3_open(argv[1], &db);

if( rc ){

fprintf(stderr, "Can&＃39;t open database: %s\n", sqlite3_errmsg(db));

sqlite3_close(db);

return 0;

}

char *sql &＃61; " CREATE TABLE SensorData(               \

ID       INTEGER PRIMARY KEY,  \

SensorID INTEGER,              \

SiteNum  INTEGER,              \

Time     VARCHAR(12),          \

SensorParameter REAL           \

);";

//使用sql字符串指定的sql语言 创建数据表SensorData

sqlite3_exec( db , sql , 0 , callback , &zErrMsg );

//插入数据到数据表

sql &＃61; "INSERT INTO &＃39;SensorData&＃39; VALUES( 0 , 1 , 1 ,  &＃39;200605011206&＃39;, 18.9 );" ;

sqlite3_exec( db , sql , 0 , callback , &zErrMsg );

//插入数据到数据表

sql &＃61; "INSERT INTO  &＃39;SensorData&＃39;  VALUES(1 , 1 , 1 , &＃39;200605011306&＃39;, 16.4 );" ;

sqlite3_exec( db , sql , 0 , callback , &zErrMsg );

int nrow &＃61; 0, ncolumn &＃61; 0;

char **azResult;

int i;

//从数据表查询数据

sql &＃61; "SELECT * FROM SensorData ";

sqlite3_get_table( db , sql , &azResult , &nrow , &ncolumn , &zErrMsg );

printf( "row:%d column&＃61;%d" , nrow , ncolumn );

printf( "The result of querying is :" );

for( i&＃61;0 ; i     printf( "azResult[%d] &＃61; %s \r\n", i , azResult[i] );

}

sqlite3_free_table( azResult );

if( rc!&＃61;SQLITE_OK ){

fprintf(stderr, "SQL error: %s\n", zErrMsg);

sqlite3_free(zErrMsg);

}

sqlite3_close(db);

return 0;

}

7. 编写Makefile

prefix&＃61;/home/rootfs/home/sqlite

exec_prefix&＃61;${prefix}

libdir&＃61;${exec_prefix}/lib

includedir&＃61;${prefix}/include

Libs &＃61; -L${libdir} -lsqlite3 -lpthread

Cflags &＃61; -I${includedir}

CROSS_COMPILE &＃61; arm-linux-

CC &＃61; $(CROSS_COMPILE)gcc

LD &＃61; $(CROSS_COMPILE)ld

radiodb: radiodb.o

$(CC) $^ $(Libs)  -o $&＃64;

radiodb.o:radiodb.c

$(CC) $(Cflags) -c $^ -o $&＃64;

clean:

rm -rf radiodb  *.o

in:

cp radiodb /home/rootfs/home/sqlite

注意makefile里的红色字体内容可以在sqlite安装目录的lib下的pkconfig下的文件查得。