How to make Inserts in table creation in Sqlite?

Question

I would like to know how to do INSERT manuals in the Databasehelper class that extends from Sqliteopenhelper.

public class DatabaseHelper extends SQLiteOpenHelper {

private static final String BANCO_DADOS = "Agenda";
private static int VERSAO = 1;


public DatabaseHelper(Context context) {
    super(context, BANCO_DADOS, null, VERSAO);
}

@Override
public void onCreate(SQLiteDatabase db) {

    db.execSQL( "CREATE TABLE amigo (_id INTEGER PRIMARY KEY," +
                " nome TEXT, telefone TEXT, " +
                " email TEXT, categoria INTEGER);"
    );
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}

}

What I wanted was to make Inserts within the onCreate method of the Databasehelper class just as the table was created, but I don’t know how to do.

Answer 1

You can do INSERT the same way you did with CREATE, passing the SQL command in the execSQL function.

It is not recommended to make SQL queries directly from the application. The ideal is to work with content providers (Content Providers) who act as a layer of abstraction between the database and the application, making the database more isolated and easier to implement evolutions or sharing data with other applications.

Also, if you are going to use lists (Recyclerview) to present the data using a Loader to manage it, the use of Content Provider is essential.

More details here about Content Providers: https://developer.android.com/guide/topics/providers/content-providers.html?hl=pt-br