SQLite进阶：Android上的SQLite惯用操作

SQLite进阶：Android上的SQLite常用操作

昨天简单地做一了一个列表展示，现在将增加/修改/删除方法都给加上了，本次增加的内容比较多，比如常见按钮的事件，列表长按事件，Activity之间的跳转及传递参数，按键事件的监听等，希望对初学的朋友有些帮助，同时欢迎老鸟给我做Code review，需要改进的地方，还请指出，谢谢。

下面逐个介绍一个代码，数据库辅助类：DBOpenHelper

</p><p><br></p><p>添加，点击主界面添加按钮进入添加页面：</p><p><img style="max-width: 100%;height: auto;width: auto\9;" src="//img.reader8.net/uploadfile/jiaocheng/20140148/2740/2014012722402431285.png" alt="SQLite进阶：Android上的SQLite惯用操作"></p><p><br></p><p>编辑，点击列表直接跳转到编辑页面：</p><p><img style="max-width: 100%;height: auto;width: auto\9;" src="//img.reader8.net/uploadfile/jiaocheng/20140148/2740/2014012722402431286.png" alt="SQLite进阶：Android上的SQLite惯用操作"><br></p><p><br></p><p>删除，长按类别项出现删除操作：</p><p><img style="max-width: 100%;height: auto;width: auto\9;" src="//img.reader8.net/uploadfile/jiaocheng/20140148/2740/2014012722402431287.png" alt="SQLite进阶：Android上的SQLite惯用操作"><br></p><p><br></p> </p></div><div style="margin:0 auto;width:300px;height:250px;position:relative;">
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 移动端全站正文 -->
<ins class="adsbygoogle"
style="display:block"
data-ad-client="ca-pub-6147101717324856"
data-ad-slot="1958144088"
data-ad-format="auto"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>
<div class="subn-nav"><a href="//m.reader8.net">读书人网</a> ><a href="//m.reader8.net/jiaocheng/SQL/">SQL Server</a></div><div class="sp-jctu"><h3><span> 热点推荐 </span></h3><ul><li><p><a href="//m.reader8.net/jiaocheng/20140611/2380889.html">批量删除每个数据库中 某表的某列,该怎</a></p></li>
<li><p><a href="//m.reader8.net/jiaocheng/20140611/2380888.html">求sql 算法,该如何解决</a></p></li>
<li><p><a href="//m.reader8.net/jiaocheng/20140610/2376998.html">求一条查询语句！该如何解决</a></p></li>
<li><p><a href="//m.reader8.net/jiaocheng/20140610/2376997.html">请问SQL批量修改数据库语句</a></p></li>
<li><p><a href="//m.reader8.net/jiaocheng/20140609/2373360.html">联合查询更新求指教,该怎么解决</a></p></li>
<li><p><a href="//m.reader8.net/jiaocheng/20140609/2373359.html">sql服务无法启动,该怎么处理</a></p></li>
<li><p><a href="//m.reader8.net/jiaocheng/20140608/2370004.html">下井次数计算sql解决方法</a></p></li>
<li><p><a href="//m.reader8.net/jiaocheng/20140608/2370003.html">SQL SEVER 2008安装后出现的2个范例的</a></p></li>
<li><p><a href="//m.reader8.net/jiaocheng/20140607/2366398.html">【题外话】与数据库有些相关关于Had</a></p></li>
<li><p><a href="//m.reader8.net/jiaocheng/20140607/2366397.html">解一下子型的度</a></p></li>
</ul></div><div style="display:none;">
<script>
var _hmt = _hmt || [];
(function() {
  var hm = document.createElement("script");
  hm.src = "//hm.baidu.com/hm.js?d6151f323a57d16696165e47eee86d53";
  var s = document.getElementsByTagName("script")[0]; 
  s.parentNode.insertBefore(hm, s);
})();
</script></div>
<div class="footer"><p>触屏版 | <a href="//www.reader8.net/jiaocheng/20120621/1833463.html#fromapp">电脑版</a></p><p>读书人网 m.reader8.net</p></div>
<script language="javascript">
function clickme(sad){
var divobjdiv = document.getElementById("divobjdiv" + sad);
if(divobjdiv.style.display =="none"){
divobjdiv.style.display ="block"; 
}else{
divobjdiv.style.display ="none";
}
var wenzi = document.getElementById('divobjimg' + sad);
if(wenzi.innerText == "收起"){
wenzi.innerText = "查看更多";
}else{
    wenzi.innerText = "收起";
  }
}
</script>
<div id="back-top"><a href="#top"><span></span></a></div>
</body>
</html>