//你的圖片在andriod studio中是存在R.drawble中的，并且是int型的
//存入數(shù)據(jù)庫的id是自己定義數(shù)據(jù)庫時(shí)設(shè)計(jì)好的，可以參考我的數(shù)據(jù)庫代碼
 
insertdb( R.drawable.你的圖片名,存入數(shù)據(jù)庫的id);
 
//s指你的圖片資源，int型，即R.drawable.你的圖片名
private void insertdb(int s,int id){
 
        //把你的圖片資源轉(zhuǎn)化成位圖
        Bitmap bitmap = BitmapFactory.decodeResource(this.getResources(), s);
 
        //Mysql是自己寫的數(shù)據(jù)庫類，需要自己編寫，下面兩句話是實(shí)例化一個(gè)sqlite數(shù)據(jù)庫對象
        Mysql mySqlLite = new Mysql(this);
        SQLiteDatabase database = mySqlLite.getReadableDatabase();
        
        //設(shè)置一個(gè)size大小，用來壓縮圖片文件
        int size = bitmap.getWidth() * bitmap.getHeight() * 4;
 
        //ByteArrayOutputStream（字節(jié)數(shù)組輸出流）對byte類型數(shù)據(jù)進(jìn)行寫入的類，屬于內(nèi)存操作流
        ByteArrayOutputStream baos= new ByteArrayOutputStream(size);
 
        //壓縮位圖bitmap
        bitmap.compress(Bitmap.CompressFormat.PNG, 100, baos);
 
        //定義一個(gè)byte類型的數(shù)組bytedata存儲(chǔ)位圖字節(jié)流轉(zhuǎn)化成的byte數(shù)組
        byte[] bytedata = baos.toByteArray();
 
        //sql語句是根據(jù)自己需求寫的，不要照抄
        database.execSQL("update 你的表名 set image=? where _id=?",new Object[] {bytedata,id});
    }

//MySQL.java
package 你的包名；
 
import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
 
 
public class Mysql extends SQLiteOpenHelper {
 
    private static final String DB_NAME="INFORM.db";
    private static final int DB_VERSION=1;
 
    public Mysql(Context context){
        super(context,DB_NAME,null,DB_VERSION);
    }
 
    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(
                "CREATE TABLE INFORMATION(" +
                        "_id INTEGER PRIMARY KEY AUTOINCREMENT,"
                        +"NAME TEXT,"
                        +"TITLE TEXT,"
                        +"image blob,"
                        +"TEXTS TEXT);"
        );
 
    
        insertTest(db, "程序員", "程序員.exe無響應(yīng)","祝你有美好的一天");
        insertTest(db, "程序員", "已停止運(yùn)行","下輩子再也不用sqlite了");
 
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
 
    }
 
    public void insertTest(SQLiteDatabase db,String name,String title,String texts){
        ContentValues value=new ContentValues();
        value.put("NAME",name);
        value.put("TITLE",title);
        value.put("TEXTS",texts);
        db.insert("INFORMTION",null,value);
    }
}

package 你的包名;
 
import androidx.appcompat.app.AppCompatActivity;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Bundle;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;
import com.example.garden.database.Mydb;
 
public class SearchResult extends AppCompatActivity implements AdapterView.OnItemClickListener {
 
    //定義游標(biāo)
    private Cursor cursor;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_search_result);
 
        Intent rit = getIntent();
        String text = rit.getStringExtra("key");
 
        ListView listview=findViewById(R.id.listview);
 
        //幫助器和管理器兩個(gè)老朋友了，實(shí)例化數(shù)據(jù)庫對象
        SQLiteOpenHelper helper=new Mydb(this);
        SQLiteDatabase db=helper.getWritableDatabase();
 
        //游標(biāo)讀取數(shù)據(jù)庫
        cursor=db.rawQuery("select * from KNOW where name like '%"+text+"%'",null);
        cursor.moveToFirst();
 
        //數(shù)據(jù)庫的簡單游標(biāo)適配器，簡單來說就是往模板填充內(nèi)容的一個(gè)橋梁
        SimpleCursorAdapter mAdapter=new SimpleCursorAdapter(this,R.layout.item_list,
                cursor,new String[]{"NAME","image","TITLE"},new int[]{R.id.iv1,R.id.iv2,R.id.iv3},0);//自己的xml組件名R.id.iv1,R.id.iv2,R.id.iv3與數(shù)據(jù)庫字段名"NAME","image","TITLE"對應(yīng)，更多用法自己查
 
        //僅僅是上面的簡單游標(biāo)適配器是不能讀取圖片的，重點(diǎn)來了，此處用到了ViewBinder
        SimpleCursorAdapter.ViewBinder binder=new SimpleCursorAdapter.ViewBinder() {
            @Override
            public boolean setViewValue(View view, Cursor cursor, int columnIndex) {
 
        //判斷是否是ImageView，這個(gè)判斷非常關(guān)鍵，詳細(xì)可以按ctr去查找ViewBinder，就去文檔看，不要找其他資料，如果想真的搞懂一定要看！
                if (view instanceof ImageView) {
                    ImageView imageView = (ImageView) view;
 
           imageView.setImageBitmap(readImageFromDb(cursor.getString(cursor.getColumnIndex("_id"))));//為imageView配置id所對應(yīng)的圖片   
                    return true;
                }
                return false;
            }
        };
 
        //配置ViewBinder
        mAdapter.setViewBinder(binder);
        //配置適配器
        listview.setAdapter(mAdapter);
        //點(diǎn)擊監(jiān)聽器
        listview.setOnItemClickListener(this);
 
   }
 
    //
    @SuppressLint("Range")
    private Bitmap readImage(String id) {
 
    //至于為什么又要實(shí)例化，是因?yàn)閟qlite不能同時(shí)使用，術(shù)語不專業(yè)，總之要重新實(shí)例化，不然會(huì)報(bào)錯(cuò)
        Mysql mySqlLite2 = new Mysql(this);
        SQLiteDatabase database2 = mySqlLite2.getReadableDatabase();
 
        Bitmap image= null;
        byte[] bytes;
        Cursor cursor = database2.rawQuery( "SELECT * FROM INFORMATION WHERE _id = ?", new String[]{id});
        if (cursor.moveToFirst()) {
            if ((bytes = cursor.getBlob(cursor.getColumnIndex("image"))) != null) {
                image= BitmapFactory.decodeByteArray(bytes, 0, bytes.length);
            }
        }
        cursor.close();
        return image;
    }
 
 
    //listview的點(diǎn)擊事件
    @Override
    public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
        //此處寫點(diǎn)擊事件，我用來傳值以及跳轉(zhuǎn)頁面
        Intent it=new Intent(this, Show.class);
        it.putExtra("ID",(int)id-1);
        startActivity(it);
        finish();
    }
}