Scribd Logo
Upload

Welcome to Scribd!

  • 5 views

    Sqlitedatabase Program: Activity - Main - XML Code

    Uploaded by

    Bhushan Karguppi
    The document describes code for an Android application that uses SQLiteDatabase to perform CRUD operations. It includes XML layout code and Java code for activities and database classes to insert, update, delete and view student data from a database table.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Sqlitedatabase Program: Activity - Main - XML Code

    Uploaded by

    Bhushan Karguppi
    5 views9 pages
    The document describes code for an Android application that uses SQLiteDatabase to perform CRUD operations. It includes XML layout code and Java code for activities and database classes to insert, update, delete and view student data from a database table.

    Original Title

    26

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes code for an Android application that uses SQLiteDatabase to perform CRUD operations. It includes XML layout code and Java code for activities and database classes to insert, update, delete and view student data from a database table.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    5 views9 pages

    Sqlitedatabase Program: Activity - Main - XML Code

    Uploaded by

    Bhushan Karguppi
    The document describes code for an Android application that uses SQLiteDatabase to perform CRUD operations. It includes XML layout code and Java code for activities and database classes to insert, update, delete and view student data from a database table.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 9

    SQLiteDatabase Program

    Activity_main.xml code:-
    <?xml version="1.0" encoding="utf-8"?>
    <RelativeLayout 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">

    <TextView
    android:layout_width="match_parent"
    android:layout_height="wrap_content"
    android:text="Please enter the below details"
    android:textSize="20dp"
    android:gravity="center"
    android:layout_marginTop="20dp"
    android:id="@+id/info"
    />
    <EditText
    android:layout_width="match_parent"
    android:layout_height="wrap_content"
    android:id="@+id/name"
    android:layout_below="@+id/info"
    android:hint="Name"
    />
    <EditText
    android:layout_width="match_parent"
    android:layout_height="wrap_content"
    android:id="@+id/contact"
    android:layout_below="@+id/name"
    android:hint="Contact"
    />
    <EditText
    android:layout_width="match_parent"
    android:layout_height="wrap_content"
    android:id="@+id/dob"
    android:layout_below="@+id/contact"
    android:hint="Date of birth"
    />
    <Button
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_below="@+id/dob"
    android:layout_marginTop="50dp"

    android:text="Insert"
    android:id="@+id/insert"
    />
    <Button
    android:id="@+id/update"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_toRightOf="@+id/insert"
    android:layout_alignBottom="@+id/insert"
    android:layout_marginLeft="10dp"
    android:text="Update"

    />
    <Button
    android:id="@+id/view"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_toRightOf="@+id/update"
    android:layout_alignBottom="@+id/update"
    android:layout_marginLeft="10dp"
    android:text="View"
    />
    <Button
    android:id="@+id/delete"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:layout_toRightOf="@+id/view"
    android:layout_alignBottom="@+id/view"
    android:layout_marginLeft="10dp"
    android:text="Delete"
    />
    </RelativeLayout>

    MainActivity.java code:-

    package com.example.database;

    import androidx.appcompat.app.AlertDialog;
    import androidx.appcompat.app.AppCompatActivity;

    import android.database.Cursor;
    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 {


    EditText name,contact,dob;
    Button insert,delete,view,update;
    Database db;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    name = (EditText) findViewById(R.id.name);
    contact = (EditText) findViewById(R.id.contact);
    dob = (EditText) findViewById(R.id.dob);

    insert = (Button) findViewById(R.id.insert);


    update = (Button) findViewById(R.id.update);
    view = (Button) findViewById(R.id.view);
    delete = (Button) findViewById(R.id.delete);
    db = new Database(this);
    insert.setOnClickListener(new View.OnClickListener() {
    @Override
    public void onClick(View view) {
    String user = name.getText().toString();
    String con = contact.getText().toString();
    String date = dob.getText().toString();
    Boolean check = db.insertData(user,con,date);
    if(check == true){
    Toast.makeText(MainActivity.this, "Data inserted successfully",
    Toast.LENGTH_SHORT).show();
    }
    else{
    Toast.makeText(MainActivity.this, "Data failed to insert",
    Toast.LENGTH_SHORT).show();
    }
    }
    });
    update.setOnClickListener(new View.OnClickListener() {
    @Override
    public void onClick(View view) {
    String user = name.getText().toString();
    String con = contact.getText().toString();
    String date = dob.getText().toString();
    Boolean check = db.updateData(user,con,date);
    if(check == true){
    Toast.makeText(MainActivity.this, "Data updated successfully",
    Toast.LENGTH_SHORT).show();
    }
    else{
    Toast.makeText(MainActivity.this, "Data failed to update",
    Toast.LENGTH_SHORT).show();
    }
    }
    });
    delete.setOnClickListener(new View.OnClickListener() {
    @Override
    public void onClick(View view) {
    String user = name.getText().toString();
    Boolean check = db.deleteData(user);
    if(check == true){
    Toast.makeText(MainActivity.this, "Data deleted successfully",
    Toast.LENGTH_SHORT).show();
    }
    else{
    Toast.makeText(MainActivity.this, "Data failed to delete",
    Toast.LENGTH_SHORT).show();
    }
    }
    });
    view.setOnClickListener(new View.OnClickListener() {
    @Override
    public void onClick(View view) {
    Cursor res = db.getData();
    if(res.getCount() == 0){
    Toast.makeText(MainActivity.this, "No data", Toast.LENGTH_SHORT).show();
    return;
    }
    StringBuffer buffer = new StringBuffer();
    while(res.moveToNext()){
    buffer.append("Name: "+res.getString(0)+"\n");
    buffer.append("Contact: "+res.getString(1)+"\n");
    buffer.append("Date of Birth: "+res.getString(2)+"\n\n");
    }
    AlertDialog.Builder builder = new AlertDialog.Builder(MainActivity.this);
    builder.setCancelable(true);
    builder.setTitle("Student Information");
    builder.setMessage(buffer.toString());
    builder.show();
    }
    });
    }
    }
    Database.java code:-
    package com.example.database;

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

    public class Database extends SQLiteOpenHelper {


    public Database(Context context) {
    super(context, "Userdata.db", null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
    db.execSQL("create Table studentInfo(name TEXT primary key,contact TEXT,dob TEXT)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int i, int i1) {
    db.execSQL("drop Table if exists studentInfo");
    }
    public Boolean insertData(String name,String contact,String dob){
    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues contentValues = new ContentValues();
    contentValues.put("name",name);
    contentValues.put("contact",contact);
    contentValues.put("dob",dob);
    long result = db.insert("studentInfo",null,contentValues);
    if (result == -1){
    return false;
    }
    else {
    return true;
    }
    }
    public Boolean updateData(String name,String contact,String dob) {
    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues contentValues = new ContentValues();
    contentValues.put("contact", contact);
    contentValues.put("dob", dob);
    Cursor crs = db.rawQuery("Select * from studentInfo where name=?", new String[]{name});
    if (crs.getCount() > 0) {
    long result = db.update("studentInfo", contentValues, "name=?", new String[]{name});
    if (result == -1) {
    return false;
    } else {
    return true;
    }
    } else {
    return false;
    }
    }
    public Boolean deleteData(String name) {
    SQLiteDatabase db = this.getWritableDatabase();
    Cursor crs = db.rawQuery("Select * from studentInfo where name=?", new String[]{name});
    if (crs.getCount() > 0) {
    long result = db.delete("studentInfo", "name=?", new String[]{name});
    if (result == -1) {
    return false;
    } else {
    return true;
    }
    } else {
    return false;
    }
    }
    public Cursor getData(){
    SQLiteDatabase db = this.getWritableDatabase();
    Cursor crs = db.rawQuery("Select * from studentInfo",null);
    return crs;
    }
    }
    Output:-

    You might also like