android 中sqlite的使用

非常好的一份总结 
http://blog.csdn.net/shulianghan/article/details/19028665
一份实例 实现注册登录
http://greatverve.cnblogs.com/archive/2011/12/26/android-sqlite-login.html

利用databaseHelper实现删除：
db.delete(table,"name=?",string[]{});
sql语句：delete from TableName where CulunnName = ?;//如果要删除的不是常数，则先用？代替
              sql.setString(1,value);//这里的value是string变量 用来存放需要删除的值
利用databaseHelper实现遍历:

Cursor cursor = db.query("Person", new String[]{"name","id","number"}, null, null, null, null, null);
        while (cursor.moveToNext()) {
            int id = cursor.getInt(cursor.getColumnIndex("id"));
            String name = cursor.getString(cursor.getColumnIndex("name"));
            String number = cursor.getString(cursor.getColumnIndex("number"));
            SQliteDomain listDB = new SQliteDomain(name, id, number);
            listArrayDB.add(listDB);
        }