SQLite Insert

MainActivity.java

import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
public class MainActivity extends AppCompatActivity {
  DataBaseHelper myDb;
  EditText txtName, txtSurName, txtMarks;
  Button btnClick;
  @Override 
   protected void onCreate(Bundle savedInstanceState) {
   super.onCreate(savedInstanceState);
   setContentView(R.layout.activity_main);
   myDb = new DataBaseHelper(this);
   txtName = (EditText) findViewById(R.id.idName);
   txtSurName = (EditText) findViewById(R.id.idSurname);
   txtMarks = (EditText) findViewById(R.id.idMarks);
   btnClick = (Button) findViewById(R.id.idBtn);
   btnClick.setOnClickListener(new View.OnClickListener() {
    @Override 
     public void onClick(View v) {
     ClickMe();
   }
  });
 }
  private void ClickMe() {
   String name = txtName.getText().toString();
   String surname = txtSurName.getText().toString();
   String marks = txtMarks.getText().toString();
   Boolean result = myDb.insertData(name, surname, marks);
  
  if (result == true) {
    Toast.makeText(this, "Data Inserted Successfully", Toast.LENGTH_SHORT).show();
   
  } else {
    Toast.makeText(this, "Data Insertion Failed", Toast.LENGTH_SHORT).show();
  }
 }
}

DBHelper.java

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

  public class DataBaseHelper extends SQLiteOpenHelper {
  public static final String DATABASE_NAME = "Student.db";
  public static final String TABLE_NAME = "Student_table";
  public static final String COL_1 = "ID";
  public static final String COL_2 = "NAME";
  public static final String COL_3 = "SURNAME";
  public static final String COL_4 = "MARKS";
  public DataBaseHelper(Context context) {
   super(context, DATABASE_NAME, null, 1);
 }
 @Override 
  public void onCreate(SQLiteDatabase db) {
   db.execSQL("CREATE TABLE " + TABLE_NAME + " (ID INTEGER PRIMARY KEY AUTOINCREMENT,NAME TEXT,SURNAME TEXT,MARKS INTEGER)");
  
 }
  @Override 
   public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
   db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
  
 }
 public boolean insertData(String name, String surname, String marks) {
    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues contentValues = new ContentValues();
    contentValues.put(COL_2, name);
    contentValues.put(COL_3, surname);
    contentValues.put(COL_4, marks);
    long result = db.insert(TABLE_NAME, null, contentValues);
    db.close();
    //To Check Whether Data is Inserted in DataBase 
     if(result==-1){ 
         return false; 
         }else{ 
             return true; 
     } 
     } 
    } 
  

activity_main.xml

<?xml version="1.0" encoding="utf-8"?>  
<LinearLayout
    xmlns:android="http://schemas.android.com/apk/res/android" 
    xmlns:tools="http://schemas.android.com/tools"
     android:layout_width="match_parent" 
     android:layout_height="match_parent" 
     android:paddingBottom="@dimen/activity_vertical_margin"
     android:paddingLeft="@dimen/activity_horizontal_margin" 
     android:paddingRight="@dimen/activity_horizontal_margin" 
     android:paddingTop="@dimen/activity_vertical_margin" 
     tools:context="anu.com.sqlite.MainActivity" 
     android:orientation="vertical"> 
    
    <EditText 
     android:id="@+id/idName" 
     android:layout_width="match_parent" 
     android:layout_height="wrap_content" 
     android:hint="NAME" /> 
    
    <EditText 
     android:id="@+id/idSurname" 
     android:layout_width="match_parent"
     android:layout_height="wrap_content"
     android:hint="SURNAME" /> 
    
    <EditText 
     android:id="@+id/idMarks" 
     android:layout_width="match_parent"
     android:layout_height="wrap_content" 
     android:inputType="number" 
     android:hint="MARKS" />
    
    <Button 
     android:id="@+id/idBtn" 
     android:layout_width="match_parent" 
     android:layout_height="wrap_content"
     android:text="INSERT" />  
</LinearLayout> ​ 

Share this

Author : Android Code Tutorial