String sql ="insert into "+ TABLE_NAME
+" ("+ ID +","+ NAME +","+TAG+","+ STATUS +","+ IMGPATH +","+ IMG
+")"+" values ("+ getCursor().getCount() +",\'"+ name +"\',\'"+tag+"\',\'"+ status +"\',\'"+ imgPath +"\',\'"+ img
+"\')";
注意:这样写的sql语句 参数两边要加’ 例:‘参数’。转义 \’
二.Cursor(游标)的理解
privateListlist=new ArrayList();
publicList<String> queryAllTag() {
Cursor cursor = getCursor();
if (cursor !=null&& cursor.moveToFirst()) {
if (cursor.getCount() >0) {
add(cursor);
while (cursor.moveToNext()) {
add(cursor);
}
}
}
returnlist;
}
privatevoid add(Cursor cursor){
String s = cursor.getString(cursor.getColumnIndex("Tag"));
list.add(s);
}