Categories: ANDROID APP

Create a easy enterprise App utilizing SQL Lite Database in Android Studio – for rookies.



This video exhibits the whole steps to create a easy Enterprise App utilizing the SQLite Database in Android Studio. It exhibits easy methods to create the App interface after which write the SQL Question and Insert instructions to play with the database. It takes a quite simple database desk instance to indicate it.

Full supply is accessible at:

We shall be glad to listen to from you concerning any question, ideas or appreciations at: programmerworld1990@gmail.com

Supply code:

/**************************************/

bundle com.instance.mybusinessappyt.mybusinessappyoutube;

import android.content material.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.assist.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.EditText;
import android.widget.TextView;

public class MainActivity extends AppCompatActivity {

non-public EditText editTextStockName;
non-public EditText editTextQuantity;
non-public TextView textViewDisplay;

non-public myDatabaseHandle dbHandle;
non-public SQLiteDatabase myDB;

@Override
protected void onCreate(Bundle savedInstanceState) {
tremendous.onCreate(savedInstanceState);
setContentView(R.structure.activity_main);

editTextStockName = findViewById(R.id.editTextStockName);
editTextQuantity = findViewById(R.id.editTextQuantity);

textViewDisplay = findViewById(R.id.textViewDisplay);

dbHandle = new myDatabaseHandle(this, “FirstDatabase”, null, 1);

myDB = dbHandle.getWritableDatabase();

strive{
String stringCreateTable = “CREATE TABLE firstTable(StockName TEXT, Amount INTEGER)”;
myDB.execSQL(stringCreateTable);
}catch (Exception e){
e.printStackTrace();
}
}

public void writeButton(View view){
ContentValues contentValues = new ContentValues();

contentValues.put(“StockName”, editTextStockName.getText().toString());
contentValues.put(“Amount”, Integer.parseInt(editTextQuantity.getText().toString()));
myDB.insert(“firstTable”, null, contentValues);
}

public void readButton(View view){

String question = “Choose * FROM firstTable WHERE StockName = ‘”+ editTextStockName.getText().toString()+”‘”;

Cursor myCursor = myDB.rawQuery(question, null);

if (myCursor.moveToFirst()){
myCursor.moveToFirst();
textViewDisplay.setText(myCursor.getString(0) + ” — ” + myCursor.getString(1));
}else{
textViewDisplay.setText(“Information Not Discovered … “);
}

}

}
/*************************************/

/*************************************/

bundle com.instance.mybusinessappyt.mybusinessappyoutube;

import android.content material.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class myDatabaseHandle extends SQLiteOpenHelper {

public myDatabaseHandle(Context context, String identify, SQLiteDatabase.CursorFactory manufacturing unit, int model) {
tremendous(context, identify, manufacturing unit, model);
}

@Override
public void onCreate(SQLiteDatabase db) {

}

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

}
}

/**********************************************/

source

linda

Recent Posts

Interactive Chat Games Inspired by Thrones

Have you ever found yourself wishing you could dive into the thrilling world of Westeros,…

2 days ago

Revive Your Memories: Free AI Photo Restoration

In this digital age, preserving memories has become more accessible than ever. However, many of…

5 days ago

Top Horrible Therapist Games to Try

In the ever-evolving landscape of party games, where humor and creativity collide, the "Horrible Therapist"…

5 days ago

How Visors Enhance Player Safety in Football

Football visors are transparent or tinted shields attached to the helmet's face mask. They're primarily…

2 weeks ago

Timeless Wonders Await: Exploring Beijing’s Rich Heritage on Your Trip

Introduction to Beijing Beijing, the capital of China, is a city that beautifully intertwines the…

2 weeks ago

Bangla NewsPaper Surge: 15 Game-Changing Strategies

Introduction to Bangla Newspaper Industry The Bangla newspaper sector has witnessed an incredible transformation over…

3 weeks ago