How to use SQLite in Android Studio

//Your picture exists in android studio and is int type//The id stored in the database is designed when defining the database by yourself. You can refer to my database code 
insertdb( .Your picture name,Saved in the databaseid);
 
//s refers to your image resource, int type, that is, your image nameprivate void insertdb(int s,int id){
 
        //Convert your image resources into bitmaps        Bitmap bitmap = ((), s);
 
        //Mysql is a database class written by itself and needs to be written by itself. The following two sentences are to instantiate a sqlite database object        Mysql mySqlLite = new Mysql(this);
        SQLiteDatabase database = ();
        
        //Set a size to compress image files        int size = () * () * 4;
 
        //ByteArrayOutputStream (byte array output stream) class that writes byte type data, belongs to the memory operation stream        ByteArrayOutputStream baos= new ByteArrayOutputStream(size);
 
        //Compress bitmap bitmap        (, 100, baos);
 
        //Define an array of byte type bytedata to store the byte array converted into byte byte stream bytes        byte[] bytedata = ();
 
        //The sql statement is written according to your needs, do not copy it according to the        ("update Your table name set image=? where _id=?",new Object[] {bytedata,id});
    }

//
package Your bag name；
 
import ;
import ;
import ;
import ;
 
 
public class Mysql extends SQLiteOpenHelper {
 
    private static final String DB_NAME="";
    private static final int DB_VERSION=1;
 
    public Mysql(Context context){
        super(context,DB_NAME,null,DB_VERSION);
    }
 
    @Override
    public void onCreate(SQLiteDatabase db) {
        (
                "CREATE TABLE INFORMATION(" +
                        "_id INTEGER PRIMARY KEY AUTOINCREMENT,"
                        +"NAME TEXT,"
                        +"TITLE TEXT,"
                        +"image blob,"
                        +"TEXTS TEXT);"
        );
 
    
        insertTest(db, "programmer", "Programmer.exe is not responding","Have a nice day");
        insertTest(db, "programmer", "Stopped","Never use sqlite in the next life");
 
    @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();
        ("NAME",name);
        ("TITLE",title);
        ("TEXTS",texts);
        ("INFORMTION",null,value);
    }
}

package Your bag name;
 
import ;
import ;
import ;
import ;
import ;
import ;
import ;
import ;
import ;
import ;
import ;
 
public class SearchResult extends AppCompatActivity implements  {
 
    //Define cursor    private Cursor cursor;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        (savedInstanceState);
        setContentView(.activity_search_result);
 
        Intent rit = getIntent();
        String text = ("key");
 
        ListView listview=findViewById();
 
        //The helper and manager are two old friends, instantiating the database object        SQLiteOpenHelper helper=new Mydb(this);
        SQLiteDatabase db=();
 
        //Cursor reads the database        cursor=("select * from KNOW where name like '%"+text+"%'",null);
        ();
 
        //The database's simple cursor adapter is a bridge to fill the content into the template.        SimpleCursorAdapter mAdapter=new SimpleCursorAdapter(this,.item_list,
                cursor,new String[]{"NAME","image","TITLE"},new int[]{.iv1,.iv2,.iv3},0);//The name of your own xml component.iv1,.iv2, and.iv3 corresponds to the database field names "NAME", "image", "TITLE". Check more usage by yourself 
        //The simple cursor adapter above cannot read pictures. Here comes the point, ViewBinder is used here         binder=new () {
            @Override
            public boolean setViewValue(View view, Cursor cursor, int columnIndex) {
 
        //Judge whether it is an ImageView. This judgment is very critical. You can press ctr to find the ViewBinder in detail, and go to the document to read it. Don’t look for other information. If you really want to understand it, you must read it!                if (view instanceof ImageView) {
                    ImageView imageView = (ImageView) view;
 
           (readImageFromDb((("_id"))));//Configure the image corresponding to the id for imageView                    return true;
                }
                return false;
            }
        };
 
        //Configure ViewBinder        (binder);
        //Configure the adapter        (mAdapter);
        //Click the listener        (this);
 
   }
 
    //
    @SuppressLint("Range")
    private Bitmap readImage(String id) {
 
    //As for the reason why it needs to be instantiated, it is because SQLite cannot be used at the same time, and the terminology is not professional. In short, it needs to be re-instified, otherwise it will report an error        Mysql mySqlLite2 = new Mysql(this);
        SQLiteDatabase database2 = ();
 
        Bitmap image= null;
        byte[] bytes;
        Cursor cursor = ( "SELECT * FROM INFORMATION WHERE _id = ?", new String[]{id});
        if (()) {
            if ((bytes = (("image"))) != null) {
                image= (bytes, 0, );
            }
        }
        ();
        return image;
    }
 
 
    //listview click event    @Override
    public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
        // Write a click event here, I use it to pass the value and jump to the page        Intent it=new Intent(this, );
        ("ID",(int)id-1);
        startActivity(it);
        finish();
    }
}