日韩一区二区三区精品,欧美疯狂xxxxbbbb牲交,热99re久久免费视精品频,人妻互换 综合,欧美激情肉欲高潮视频

s3c6410下移植sqlite3.7.8

發(fā)布者:Huayu8888最新更新時(shí)間:2024-09-23 來(lái)源: cnblogs關(guān)鍵字:s3c6410  移植  sqlite3  7 手機(jī)看文章 掃描二維碼
隨時(shí)隨地手機(jī)看文章

1、下載源代碼http://www.sqlite.org/download.html

2、tar -zxvf sqlite-amalgamation-3.6.23.1.tar.gz

3、進(jìn)入sqlite-3.6.23.1

4、mkdir build

5、cd build

6、../configure --host=arm-linux --prefix=/usr/local/sqlite3 注意:使用arm-linux-gcc 3.4.5時(shí)出現(xiàn)如下錯(cuò)誤 checking for C compiler default output file name... configure: error: C compiler cannot create executables See `config.log' for more details.

懷疑沒(méi)有寫(xiě)權(quán)限,使用如下配置通過(guò) sudo ../configure --host=arm-linux --prefix=/usr/local/sqlite3 移植到開(kāi)發(fā)板上無(wú)法運(yùn)行,使用下面配置 ../configure --host=arm-unknown-linux-gnu --prefix=/usr/local/sqlite3

7、make

出現(xiàn)問(wèn)題: arm-none-linux-gnueabi-gcc: 3.6.23.1': No such file or directory < command-line>: warning: missing terminating ' character ^Cmake: *** [sqlite3.lo] 錯(cuò)誤 1

解決:

Makefile中 -DPACKAGE_STRING='sqlite 3.6.23.1' 改為: -DPACKAGE_STRING='sqlite_3.6.23.1'

8、sudo make install

出現(xiàn)問(wèn)題: arm-linux-ranlib /usr/local/sqlite3/lib/libsqlite3.a ./libtool: line 6619: arm-linux-ranlib: command not found make[1]: *** [install-libLTLIBRARIES] 錯(cuò)誤 127 make[1]:正在離開(kāi)目錄 `/work/development/sqlite/sqlite-3.6.23.1/build' make: *** [install-am] 錯(cuò)誤 2

原因:root權(quán)限的時(shí)候沒(méi)有設(shè)置arm-linux 的PATH

解決: su 根用戶(hù)登錄 export PATH=$PATH:/work/tools/arm/bin

make install

9、cd /usr/local/sqlite3

10、cp -arf bin include lib /work/nfs_root/sqlite/ 復(fù)制到nfs共享文件夾下

11、mount -t nfs -o intr,nolock,rsize=1024,wsize=1024 192.168. 0.128:/work/nfs_root /mnt/nfs/ mount nfs文件系統(tǒng)

12、cp /mnt/nfs/sqlite/bin/* /usr/bin/ mkdir /usr/lib cp -arf /mnt/nfs/sqlite/lib/* /usr/lib/ mkdir /usr/include cp /mnt/nfs/sqlite/include/* /usr/include/

13、開(kāi)發(fā)板上創(chuàng)建數(shù)據(jù)庫(kù) # /usr/bin/sqlite3 demo SQLite version 3.6.23.1 Enter '.help' for instructions Enter SQL statements terminated with a ';' sqlite> create table tbl_demo(uid int, uname varchar(20)); sqlite> insert into tbl_demo values(1, 'jimmy'); sqlite> insert into tbl_demo values(2, 'srp'); sqlite> .quit

14、編寫(xiě)測(cè)試程序test.c


#include   

#include   

#include 'sqlite3.h'  

  

static int callback(void *NotUsed, int argc, char **argv, char **azColName)  

{  

int i;  

  

for(i=0; iprintf('%s = %sn', azColName[i], argv[i] ? argv[i] : 'NULL');  

}  

  

printf('n');  

  

return 0;  

}  

  

  

int main(int argc, char **argv)  

{  

sqlite3 *db;  

char *zErrMsg = 0;  

int rc;  

  

if( argc!=3 ){  

fprintf(stderr, 'Usage: %s DATABASE SQL-STATEMENTn', argv[0]);  

exit(1);  

}  

  

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

if( rc ){  

fprintf(stderr, 'Can't open database: %sn', sqlite3_errmsg(db));  

sqlite3_close(db);  

exit(1);  

}  

  

rc = sqlite3_exec(db, argv[2], callback, 0, &zErrMsg);  

if( rc!=SQLITE_OK ){  

fprintf(stderr, 'SQL error: %sn', zErrMsg);  

sqlite3_free(zErrMsg);  

}  

  

sqlite3_close(db);  

  

return 0;  

}  

#include

#include

#include 'sqlite3.h'


static int callback(void *NotUsed, int argc, char **argv, char **azColName)

{

int i;


for(i=0; iprintf('%s = %sn', azColName[i], argv[i] ? argv[i] : 'NULL');

}


printf('n');


return 0;

}



int main(int argc, char **argv)

{

sqlite3 *db;

char *zErrMsg = 0;

int rc;


if( argc!=3 ){

fprintf(stderr, 'Usage: %s DATABASE SQL-STATEMENTn', argv[0]);

exit(1);

}


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

if( rc ){

fprintf(stderr, 'Can't open database: %sn', sqlite3_errmsg(db));

sqlite3_close(db);

exit(1);

}


rc = sqlite3_exec(db, argv[2], callback, 0, &zErrMsg);

if( rc!=SQLITE_OK ){

fprintf(stderr, 'SQL error: %sn', zErrMsg);

sqlite3_free(zErrMsg);

}


sqlite3_close(db);


return 0;

}

15、編譯 arm-linux-gcc test.c -I /usr/local/sqlite3/include -L /usr/local/sqlite3/lib -lsqlite3 -o test

16、將test拷貝到開(kāi)發(fā)板與數(shù)據(jù)庫(kù)demo同一個(gè)目錄下 sqlite demo test

17、運(yùn)行 # ./test demo 'select * from tbl_demo' uid = 1 uname = jimmy

uid = 2 uname = srp

18、sqlite移植成功

注意: #gcc test.c -I /usr/local/sqlite3/include -L /usr/local/sqlite3/lib -lsqlite3 -o test

/usr/bin/ld: skipping incompatible /usr/local/sqlite3/lib/libsqlite3.so when searching for -lsqlite3 /usr/bin/ld: skipping incompatible /usr/local/sqlite3/lib/libsqlite3.a when searching for -lsqlite3 /usr/bin/ld: cannot find -lsqlite3 collect2: ld 返回 1

原因:sqlite是使用arm-linux-gcc編譯的,所以使用的gcc與arm-linux-gcc不兼容


關(guān)鍵字:s3c6410  移植  sqlite3  7 引用地址:s3c6410下移植sqlite3.7.8

上一篇:UT-S3C6410 android系統(tǒng)實(shí)現(xiàn)同伙usb wifi無(wú)線(xiàn)上網(wǎng)功能
下一篇:第五章 搭建S3C6410開(kāi)發(fā)板的測(cè)試環(huán)境 心得筆記

小廣播
設(shè)計(jì)資源 培訓(xùn) 開(kāi)發(fā)板 精華推薦

最新單片機(jī)文章

 
EEWorld訂閱號(hào)

 
EEWorld服務(wù)號(hào)

 
汽車(chē)開(kāi)發(fā)圈

 
機(jī)器人開(kāi)發(fā)圈

電子工程世界版權(quán)所有 京ICP證060456號(hào) 京ICP備10001474號(hào)-1 電信業(yè)務(wù)審批[2006]字第258號(hào)函 京公網(wǎng)安備 11010802033920號(hào) Copyright ? 2005-2025 EEWORLD.com.cn, Inc. All rights reserved