Tag: Android Sqlite

Android Sqlite Save Data

  1. Create Database Handler
package com.example.sqlite;

import android.content.ContentValues;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.text.TextUtils;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

public class MainActivity extends AppCompatActivity {

    private SQLiteDatabase database;
    private Dbhandaler dbhandaler;

private EditText rolledittext,nameedittext;
private Button savebtn;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        rolledittext = findViewById(R.id.roll);
        nameedittext = findViewById(R.id.name);
        savebtn = findViewById(R.id.save);
        savebtn.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
              Integer  roll = Integer.parseInt(rolledittext.getText().toString().trim()) ;
              String name = nameedittext.getText().toString().trim();

              if (TextUtils.isEmpty(rolledittext.getText().toString().trim() )){
                 rolledittext.setError("Please Fill Data");
              }
              else if (TextUtils.isEmpty(name)){
                  nameedittext.setError("Please Fill Data");
              }

                  try {
                      dbhandaler = new Dbhandaler(MainActivity.this);
                      database = dbhandaler.getWritableDatabase();
                      ContentValues contentValues = new ContentValues();
                      contentValues.put("roll", roll);
                      contentValues.put("name", name);
                      long result = database.insert("STUDENT", null, contentValues);
                      if (result == -1) {
                          return;
                      } else {

                          Toast.makeText(getApplicationContext(), "Data Inserted Successfull", Toast.LENGTH_SHORT).show();
                      }

                  } catch (Exception e) {


              }
            }
        });

    }
}

2. Create ui For Display Form 

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical"
    tools:context=".MainActivity">

    <EditText
        android:id="@+id/roll"
        android:inputType="number"
        android:hint="Enter Roll Number"
        android:layout_width="match_parent"
        android:layout_height="wrap_content" />
    <EditText
        android:id="@+id/name"
        android:inputType="text"
        android:hint="Enter Roll Name"
        android:layout_width="match_parent"
        android:layout_height="wrap_content" />
<Button
    android:text="Save"
    android:id="@+id/save"
    android:layout_width="match_parent"
    android:layout_height="wrap_content" />
</LinearLayout>

3. Handle Save Opreation On MainActivity.java

package com.example.sqlite;

import android.content.ContentValues;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.text.TextUtils;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

public class MainActivity extends AppCompatActivity {

    private SQLiteDatabase database;
    private Dbhandaler dbhandaler;

private EditText rolledittext,nameedittext;
private Button savebtn;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        rolledittext = findViewById(R.id.roll);
        nameedittext = findViewById(R.id.name);
        savebtn = findViewById(R.id.save);
        savebtn.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
              Integer  roll = Integer.parseInt(rolledittext.getText().toString().trim()) ;
              String name = nameedittext.getText().toString().trim();

              if (TextUtils.isEmpty(rolledittext.getText().toString().trim() )){
                 rolledittext.setError("Please Fill Data");
              }
              else if (TextUtils.isEmpty(name)){
                  nameedittext.setError("Please Fill Data");
              }
else {
                  try {
                      dbhandaler = new Dbhandaler(MainActivity.this);
                      database = dbhandaler.getWritableDatabase();
                      ContentValues contentValues = new ContentValues();
                      contentValues.put("roll", roll);
                      contentValues.put("name", name);
                      long result = database.insert("STUDENT", null, contentValues);
                      if (result == -1) {
                          return;
                      } else {

                          Toast.makeText(getApplicationContext(), "Data Inserted Successfull", Toast.LENGTH_SHORT).show();
                      }

                  } catch (Exception e) {

                  }
              }
            }
        });

    }
}