给一段代码:
Cursor cur = mSQLiteDatabase.rawQuery("select * from Friends", null);
if (cur.moveToFirst())
{
do{
byte[] b = cur.getBlob(cur.getColumnIndex("name"));
String s;
try {
s = new String(b, "GBK");
TextView tv = (TextView)findViewById(R.id.text);
tv.setText(s);
} catch (UnsupportedEncodingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}while(cur.moveToNext());
}