- 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) {
}
}
}
});
}
}
OLEETECH 