UNIDAD 3 - Creacion de una Base de Datos

 Creacion de una Base de Datos 

Diseño Interfaz 

AdminBD.java 

package com.example.conexiondebasededatos;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import androidx.annotation.Nullable;

public class AdminBD extends SQLiteOpenHelper {

    public  AdminBD (@Nullable Context context, @Nullable String name, @Nullable SQLiteDatabase.CursorFactory factory, int version) {
        super(context, name, factory, version);
    }

    @Override
    public void onCreate(SQLiteDatabase BD)
    {
        BD.execSQL("create table Datos (ID int  primary key, Nombre text, Telefono int)  ");


    }

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


    }
}

MainActivity.java

package com.example.conexiondebasededatos;

import androidx.appcompat.app.AppCompatActivity;

import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.EditText;
import android.widget.Toast;

public class MainActivity extends AppCompatActivity {
    private EditText IDT, NOT, TET;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        IDT = (EditText) findViewById(R.id.IDT);
        NOT = (EditText) findViewById(R.id.NOT);
        TET = (EditText) findViewById(R.id.TET);
    }

    public void BGuardar(View view) {
        AdminBD admin = new AdminBD(this, "BD", null, 1);
        SQLiteDatabase BaseDatos = admin.getWritableDatabase();
        String ID = IDT.getText().toString();
        String Nombre = NOT.getText().toString();
        String Telefono = TET.getText().toString();

        if (!ID.isEmpty() && !Nombre.isEmpty() && !Telefono.isEmpty()) {
            ContentValues Registro = new ContentValues();
            Registro.put("ID", ID);
            Registro.put("Nombre", Nombre);
            Registro.put("Telefono", Telefono);
            BaseDatos.insert("Datos", null, Registro);
            BaseDatos.close();
            IDT.setText("");
            NOT.setText("");
            TET.setText("");
            Toast.makeText(this, "REGISTRO EXITOSO", Toast.LENGTH_LONG).show();
        } else {
            Toast.makeText(this, "INGRESAR CORRECTAMENTE LOS DATOS ", Toast.LENGTH_LONG).show();
        }
    }

    public void BBuscar(View view) {
        AdminBD admin = new AdminBD(this, "BD", null, 1);
        SQLiteDatabase BD1 = admin.getWritableDatabase();
        String ID1 = IDT.getText().toString();


        if (!ID1.isEmpty()) {
            Cursor fila = BD1.rawQuery("Select Nombre, Telefono from Datos where ID =" + ID1, null);
            if (fila.moveToFirst()) {

                NOT.setText(fila.getString(0));
                TET.setText(fila.getString(1));
                BD1.close();
            } else {
                Toast.makeText(this, "NO EXISTE EL USUARIO", Toast.LENGTH_LONG).show();
            }
        }
    }
}

Video Codigo

Video Prueba