📄 uclinux下sqlite嵌入式数据库移植全攻略(6).htm
字号:
<tr><td height=20 align=center>http://www.sina.com.cn 2004年12月17日 08:40 <font color=#A20010>天极yesky</font></td></tr>
<tr><td height=15></td></tr>
<tr><td class=l17><font id="zoom" class=f14>
<!-- 正文内部文字导航 : begin -->
<!-- 正文内部文字导航 : end -->
<p> 文/余涛</p>
<p>
<p>
<table borderColor=#ffcc66 width="90%" align=center bgColor=#d8d8d1 border=1>
<tbody>
<tr>
<td>strcpy(p->outfile,azArg[1]);</td></tr></tbody></table>
<p>
<p><br> 用：<br><br>
<p>
<p>
<table borderColor=#ffcc66 width="90%" align=center bgColor=#d8d8d1 border=1>
<tbody>
<tr>
<td>strcpy(outfilename,azArg[1]);<br>p->outfilep = outfilename;</td></tr></tbody></table>
<p>
<p><br> 替换。<br><br> 再继续，找到类似这样的一句：<br><br>
<p>
<p>
<table borderColor=#ffcc66 width="90%" align=center bgColor=#d8d8d1 border=1>
<tbody>
<tr>
<td>fprintf(p->out,"%9.9s: %s\n","output",</td></tr></tbody></table>
<p>
<p><br> 将：<br><br>
<p>
<p>
<table borderColor=#ffcc66 width="90%" align=center bgColor=#d8d8d1 border=1>
<tbody>
<tr>
<td>fprintf(p->out,"%9.9s: %s\n","output", strlen(p->outfile) ? p->outfile : "stdout");</td></tr></tbody></table>
<p>
<p><br> 用：<br><br>
<p>
<p>
<table borderColor=#ffcc66 width="90%" align=center bgColor=#d8d8d1 border=1>
<tbody>
<tr>
<td>fprintf(p->out,"%9.9s: %s\n","output", p->outfilep && strlen(p->outfilep) ? p->
<!--NEWSZW_HZH_BEGIN-->
<table border=0 cellspacing=0 cellpadding=0 align=left >
<!--
<table id="innerad" border=0 cellspacing=0 cellpadding=0 align=left style="display:none">
-->
<tr><td>
<!--画中画广告开始-->
<table border=0 cellspacing=0 cellpadding=0 align=left>
<tr><td>
<!--科技新闻内页画中画开始-->
<!--D61C4C53F9BB-->
<IFRAME MARGINHEIGHT=0 MARGINWIDTH=0 FRAMEBORDER=0 WIDTH=360 HEIGHT=300 SCROLLING=NO SRC="http://122.adsina.allyes.com/main/adfshow?user=AFP6_for_SINA|Tech|techpip&db=sina&border=0&local=yes">
<SCRIPT LANGUAGE="JavaScript1.1" SRC="http://122.adsina.allyes.com/main/adfshow?user=AFP6_for_SINA|Tech|techpip&db=sina&local=yes&js=on"></SCRIPT>
<NOSCRIPT><A HREF="http://122.adsina.allyes.com/main/adfclick?user=AFP6_for_SINA|Tech|techpip&db=sina"><IMG SRC="http://122.adsina.allyes.com/main/adfshow?user=AFP6_for_SINA|Tech|techpip&db=sina" WIDTH=360 HEIGHT=300 BORDER=0></a></NOSCRIPT></IFRAME>
<!--nwy/ms/1216/B-->
<!--科技新闻内页画中画结束-->
</td></tr></table>
<!--画中画广告结束-->
</td></tr>
<tr><td>
<!-- 画中画下文字链广告（从上至下顺序为01，02，03，04文字，需加class=a01）-->
<table width=360 border=0 cellpadding=0 cellspacing=0>
<tr><td height=9></td></tr>
<tr><td>
<table width=360 border=0 cellpadding=0 cellspacing=0 background=http://image2.sina.com.cn/dy/images/xfrd_02.gif>
<tr><td height=45 rowspan=2><img src=http://ad4.sina.com.cn/shc/xfrd_01.GIF width=70 height=45 border=0></td><td width=286 style='padding-top:4px;padding-left:5px'>
<!--F70BB90BB6BA--><!--nwy/uc/A-->
<script LANGUAGE="JavaScript">
ad1= "想送免费的歌曲祝福吗";
link1= "http://bobo.sina.com.cn/";
//左上
ad2= "汽车生活方式大比拼";
link2= "http://adclient.dentsu.com.cn/html.ng/adspec=words&adtype=wen_zi_lian&affiliate=sina&campaignid=59&channel=ke_ji_page&log=0¶ms.styles=clickcmd?";
//右上
ad3= "天堂II 混沌的年代";
link3= "http://sinapay.sina.com.cn/tiantang/choose_style.html";
//左下
ad4= "天堂II 混沌的年代";
link4= "http://sinapay.sina.com.cn/tiantang/choose_style.html";
//右下
//浏览器类型变量
var InternetExplorer = navigator.appName.indexOf("Microsoft") != -1;
//ie内容
function IEad(){
adCode = '<OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" WIDTH="280" HEIGHT="40" id="ad_note" ALIGN=""><PARAM NAME=movie VALUE="http://image2.sina.com.cn/dy/zwyhzh/ad_note.swf"> <PARAM NAME=quality VALUE=high> <PARAM NAME=wmode VALUE=transparent> <PARAM NAME=bgcolor VALUE=#FFFFFF> <param name="swLiveConnect" value="true"> '
+' <EMBED src="http://image2.sina.com.cn/dy/zwyhzh/ad_note.swf" quality=high wmode=transparent bgcolor=#FFFFFF WIDTH="280" HEIGHT="40" NAME="ad_note" ALIGN="" TYPE="application/x-shockwave-flash" PLUGINSPAGE="http://www.macromedia.com/go/getflashplayer" swLiveConnect="true"></EMBED></OBJECT>'
document.write(adCode);
document.getElementById('ad_note').SetVariable("ad1", ad1);
document.getElementById('ad_note').SetVariable("ad2", ad2);
document.getElementById('ad_note').SetVariable("ad3", ad3);
document.getElementById('ad_note').SetVariable("ad4", ad4);
document.getElementById('ad_note').SetVariable("link1", link1);
document.getElementById('ad_note').SetVariable("link2", link2);
document.getElementById('ad_note').SetVariable("link3", link3);
document.getElementById('ad_note').SetVariable("link4", link4);
}
//ns内容
function NSad(){
adCode = '<table width=286 border=0 cellpadding=0 cellspacing=0>'
+'<tr height=20><td width=143 style="padding-top:5px;padding-left:5px"> <img src=http://image2.sina.com.cn/dy/images/xfrd_04.gif width=7 height=7> '
+'<a href='+ link1 +' class=a01 target=_blank>'+ ad1 +'</a>'
+'</td><td width=143 style="padding-top:5px;"> <img src=http://image2.sina.com.cn/dy/images/xfrd_04.gif width=7 height=7> '
+'<a href='+ link2 +' class=a01 target=_blank>'+ ad2 +'</a>'
+'</td></tr>'
+'<tr height=20><td style="padding-left:5px"> <img src=http://image2.sina.com.cn/dy/images/xfrd_04.gif width=7 height=7> '
+'<a href='+ link3 +' class=a01 target=_blank>'+ ad3 +'</a>'
+'</td><td> <img src=http://image2.sina.com.cn/dy/images/xfrd_04.gif width=7 height=7> '
+'<a href='+ link4 +' class=a01 target=_blank><SPAN ID="oSpan" UNSELECTABLE="on" >'+ ad4 +'</span></a></td></tr></table>'
document.write(adCode);
}
//主过程
if(InternetExplorer == true){
IEad();
}else{
NSad();
}
</script>
</td><td width=4 rowspan=2><img src=http://image2.sina.com.cn/dy/images/xfrd_03.gif width=4 height=45></td></tr>
</table>
</td></tr>
</table>
</td></tr>
</table>
<!--NEWSZW_HZH_END-->
;outfilep : "stdout");</td></tr></tbody></table>
<p>
<p><br> 替换。<br><br> 完成修改。<br><br> 上面的所有的对sqlite的修改完成后，你就可以make dep；make lib_only；make user_only；make romfs；make image了。<br><br> 如果你对sqlite的修改，在make user_only过程中出现错误的话，你可以忽略make dep；make lib_only命令，直接再次进行make user_only；make romfs；make image；就可以了，而不用重复make dep；make lib_only。<br><br> make image会帮你生成romfs文件系统。现在在uClinux-dist/images下面就有编译生成的romfs文件系统了。这个就是我们需要的包含有sqlite的romfs了。<br><br> 在上面的过程中，你可以不用在“make image”后再去“make”生成kernel内核，因为你只需要生成romfs就可以了，它里面已经有sqlite了。<br><br> 现在你就可以把你生成的含有sqlite应用程序的romfs下载到开发板上运行一下。<br><br>
<p>
<p>
<table borderColor=#ffcc66 width="90%" align=center bgColor=#d8d8d1 border=1>
<tbody>
<tr>
<td>Welcome to<br>____ _ _<br>/ __| ||_| <br>_ _| | | | _ ____ _ _ _ _ <br>| | | | | | || | _ \| | | |\ \/ /<br>| |_| | |__| || | | | | |_| |/ \<br>| ___\____|_||_|_| |_|\____|\_/\_/<br>| |<br>|_|<br><br>GDB/ARMulator support by <davidm@snapgear.com><br>For further information check:<br>http://www.uclinux.org/<br><br>Command: /bin/ifconfig eth0 up 10.0.0.2<br>Execution Finished, Exiting<br>init: Booting to single user mode<br><br>Sash command shell (version 1.1.1)<br>/> cd bin<br>/bin> ls -l sqlite<br>-rwxr-xr-x 1 0 0 327072 Jan 01 00:00 sqlite<br>/bin >cd /tmp<br>/tmp>sqlite test.sqlite<br>sqlite> create table my(name varchar(80), num smallint);<br>sqlite> insert into my values('yutao', 100);<br>sqlite> insert into my values('uclinux', 99);<br>sqlite> select * from my;<br>yutao|100<br>uclinux|99<br>sqlite> .tables<br>my<br>sqlite> .schema<br>create table my(name varchar(80), num smallint);<br>sqlite> .q<br>/tmp>ls –l test.sqlite</td></tr></tbody></table>
<p>
<p><br> 你要保证你的/tmp是可写的目录。<br><br> 好，现在你的sqlite就已经在uclinux运行起来了，感觉如何呀，在uclinux也可以玩玩“select * from”，感觉很爽吧。</span><br>
<p></span></span>
<p align=right><a style="FONT-SIZE: 14px" href="http://tech.sina.com.cn/other/2004-12-17/0840478378.shtml">[上一页]</a> <a href="http://tech.sina.com.cn/other/2004-12-17/0840478374.shtml">[1]</a> <a href="http://tech.sina.com.cn/other/2004-12-17/0840478375.shtml">[2]</a> <a href="http://tech.sina.com.cn/other/2004-12-17/0840478376.shtml">[3]</a> <a href="http://tech.sina.com.cn/other/2004-12-17/0840478377.shtml">[4]</a> <a href="http://tech.sina.com.cn/other/2004-12-17/0840478378.shtml">[5]</a> [6]
<p></p>
<table width=90% border=0 align=center>
<tr></tr>
</table>
<br clear=all>
<table width=565 border=0 cellspacing=0 cellpadding=0>
<tr><td class=f14 height=30 valign=top> 点击此处查询<a href=http://sinanews.chinasearch.com.cn/sinanews.exe?word=ucLinux target=_blank>全部<font color=red>ucLinux</font>新闻</a> <a href=http://sinanews.chinasearch.com.cn/sinanews.exe?word=操作系统 target=_blank>全部<font color=red>操作系统</font>新闻</a> </td></tr></table>
</td></tr>
</table>
</div>
<br>
<table width=560 border=0 cellspacing=0 cellpadding=0>
<tr><td class=f14>
<a href=http://tech.sina.com.cn/topnews/index.html>新浪科技24小时热门新闻排行</a>
<a href=http://tech.sina.com.cn/down/drivers/>硬件驱动程序高速下载</a>
<br><br>
</td></tr>
<tr><td>
<table width=565 border=0 cellspacing=0 cellpadding=0>
<tr><td><form target="_blank" action="http://mms.sina.com.cn/xmlmms/xmlmmsQue.php" method="post" name="from_">
<input type="hidden" name="xmlCfg" value="http://rss.sina.com.cn/mms/tech/99/21/5/2-1-478379.xml">
<input type="hidden" name="sourceFrom" value="100001">
<input type="hidden" name="from" value="442">
<input type="submit" name="submit_" style="width:120" value="多种方式看新闻">
</form></td><td align=right>【<a href=http://comment.news.sina.com.cn/cgi-bin/comment/comment.cgi?channel=kj&newsid=478374>评论</a>】【<a href=http://stat.sina.com.cn/cgi-bin/sms/edit_sms.cgi?title=ucLinux%CF%C2sqlite%C7%B6%C8%EB%CA%BD%CA%FD%BE%DD%BF%E2%D2%C6%D6%B2%C8%AB%B9%A5%C2%D4%286%29&url=tech.sina.com.cn/other/2004-12-17/0840478379.shtml>推荐</a>】【<a href="javascript:doZoom(16)">大</a> <a href="javascript:doZoom(14)">中</a> <a href="javascript:doZoom(12)">小</a>】【<a href="javascript:doPrint()">打印</a>】【<a href=http://www.sina.com.cn/ddt/ target=_blank>下载点点通</a>】【<a href="javascript:window.close()">关闭</a>】</td></tr>
</table></td></tr>
</table>
<BR>
<table width=560 border=0 cellspacing=0 cellpadding=0>
<tr><td>
<!-- 正文底部小通栏 -->
<table width=585 border=0 cellpadding=0 cellspacing=0 align=center>
<tr><td>
<!--科技频道内页底部小通栏开始-->
<!--DCD3066795C5-->
<OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" WIDTH="585" HEIGHT="50">
<PARAM NAME=movie VALUE="http://ad4.sina.com.cn/200412/10/6765_picasso_tech_sfc_200412.swf"> <PARAM NAME=quality VALUE=high><param name=wmode value=opaque>
<EMBED src="http://ad4.sina.com.cn/200412/10/6765_picasso_tech_sfc_200412.swf" quality=high WIDTH="585" HEIGHT="50" TYPE="application/x-shockwave-flash" PLUGINSPAGE="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash"></EMBED>
</OBJECT><!--xinzhi/2004-12-17/B-->
<!--科技频道内页底部小通栏结束-->
</td></tr>
<tr><td height=5></td></tr>
</table>
</td></tr>
</table>
<br>
<table width=560 border=0 cellspacing=0 cellpadding=0>
<tr><td>
<div id=PublicRelation1 name="PublicRelation" style="DISPLAY:none">
<table><tr><td> </td>
<td class=f14>
<p><!--要求文字在17字以内！-->
<!--科技新闻内页文字链01开始-->
<!--4EF9FD7107A8-->
<a href=http://ad.cn.doubleclick.net/clk;12480651;10609175;z?http://www-900.ibm.com/cn/servers/eserver/openpower/ target=_blank><font color=red>Linux，改变世界的力量</font></a><!--weixing/2004-12-16/B-->
<!--科技新闻内页文字链01结束--> <!--994C252CDDD6-->
<a href=http://adclient.dentsu.com.cn/html.ng/adspec=image&adtype=wen_zi_lian&affiliate=sina&campaignid=59&channel=ke_ji_page&log=0¶ms.styles=clickcmd? target=_blank><font color=red>中法文化年，东风雪铁龙典藏版限量而出</font></a><!--xinzhi/2004-12-31/B--></p>
</td></tr></table>
</div>
<SCRIPT>
//<!--广告发布-->
<!--
if (checkPubTime(getPubTime()))
{
PublicRelation1.style.display="";
}
-->
</SCRIPT>
</td></tr>
</table>
</td><td width=1 bgcolor=#747474 rowspan=2></td><td width=129 valign=top></td></tr>
</table>
<!-- 右侧功能条 begin -->
<div id="toolBar" style="position:absolute;display:'none'">
<table width=129 border=0 cellpadding=0 cellspacing=0>
<tr><td align=right>
<!-- 搜索 begin-->
<script language="javascript">
function select_cgi(fn)
{
search_form1 = fn;
if(search_form1._ss.value == "newstitle") //新闻标题
{
search_form1.searchcontent.name="word";
search_form1.action = "http://sinanews.zhongsou.com/sinanews.exe";
return;
}
else if(search_form1._ss.value == "newsft") //新闻全文
{
//alert("newsft");
search_form1.searchcontent.name="word";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -