Skip to main content

Application to Create, Insert, update and Delete operation on the database



Q12.Create an application to Create, Insert, update and Delete operation on the database

File consists :

1.activity_main.xml
2.Main_Activity.java
3.kDatabaseAdapter.java
4.Message.java

activity_main.xml



<?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"     
tools:context="com.haldar.kishan.progm12.MainActivity"> 
 
<EditText         
android:id="@+id/user"         
android:layout_width="wrap_content"         
android:layout_height="wrap_content" 
android:layout_alignParentTop="true" 
 android:layout_centerHorizontal="true"         
 android:layout_marginTop="12dp" 
 android:ems="15"         
android:inputType="textPersonName"         
android:hint="username" /> 

<EditText 
 android:id="@+id/pass"         
android:layout_width="wrap_content" 
 android:layout_height="wrap_content"         
 android:layout_alignLeft="@+id/user" 
 android:layout_alignStart="@+id/user" 
 android:layout_below="@+id/user"         
 android:layout_marginTop="18dp" 
  android:ems="14" 
  android:inputType="textPersonName" 
  android:hint="password" 
  android:layout_alignRight="@+id/name" 
  android:layout_alignEnd="@+id/name" />

  <Button 
   android:id="@+id/adduser"         
   android:layout_width="match_parent"         
   android:layout_height="wrap_content"         
   android:layout_marginTop="15dp" 
   android:text="add user" 
   android:onClick="addUser" 
   android:layout_below="@+id/pass"         
   android:layout_alignLeft="@+id/name" 
   android:layout_alignStart="@+id/name"         
   android:layout_alignRight="@+id/user" 
   android:layout_alignEnd="@+id/user" />

    <Button         
     android:id="@+id/ViewAllDetail"         
     android:layout_width="match_parent"         
     android:layout_height="wrap_content" 
     android:onClick="viewDetails" 
     android:layout_marginTop="20dp" 
     android:text="View All Details" 
     android:layout_below="@+id/adduser" 
     android:layout_alignLeft="@+id/pass" 
     android:layout_alignStart="@+id/pass" 
     android:layout_alignRight="@+id/adduser" 
     android:layout_alignEnd="@+id/adduser" />

    <EditText 
      android:id="@+id/name" 
      android:layout_width="wrap_content" 
      android:layout_height="wrap_content"         
      android:layout_marginTop="23dp"         
      android:ems="15" 
      android:inputType="textPersonName" 
      android:hint="Enter the value For Any Operation" 
      android:layout_below="@+id/ViewAllDetail"         
      android:layout_alignParentRight="true"         
      android:layout_alignParentEnd="true"         
      android:layout_marginRight="32dp" 
      android:layout_marginEnd="32dp" />

    <Button         
     android:id="@+id/button"         
     android:onClick="getDetails" 
     android:layout_width="match_parent" 
     android:layout_height="wrap_content"         
     android:text="get details"         
     android:layout_marginTop="15dp" 
     android:layout_below="@+id/name" 
     android:layout_alignLeft="@+id/ViewAllDetail"         
     android:layout_alignStart="@+id/ViewAllDetail" 
     android:layout_alignRight="@+id/ViewAllDetail"         
     android:layout_alignEnd="@+id/ViewAllDetail" />

    <Button 
     android:id="@+id/update"         
     android:onClick="update" 
     android:layout_width="wrap_content" 
     android:layout_height="wrap_content"         
     android:layout_alignLeft="@+id/button"         
     android:layout_alignStart="@+id/button"         
     android:layout_below="@+id/button" 
     android:layout_marginTop="12dp" 
     android:text="update" />

    <Button 
     android:id="@+id/delete" 
     android:layout_width="wrap_content" 
     android:layout_height="wrap_content" 
     android:text="delete"         
     android:onClick="delete"         
     android:layout_alignBaseline="@+id/update" 
     android:layout_alignBottom="@+id/update"         
    android:layout_toRightOf="@+id/update" 
    android:layout_toEndOf="@+id/update"         
    android:layout_marginLeft="14dp"         
    android:layout_marginStart="14dp" />

    <Button         
     android:id="@+id/clear"         
     android:onClick="clearRec"         
     android:layout_width="wrap_content"         
     android:layout_height="wrap_content"         
     android:text="clear" 
     android:layout_below="@+id/update"         
     android:layout_alignLeft="@+id/update" 
     android:layout_alignStart="@+id/update" 
     android:layout_marginTop="13dp" />
</RelativeLayout>



MainActivity.java




package com.haldar.kishan.progm12;

import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.support.v7.widget.PopupMenu;
import android.view.MenuItem;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;

public class MainActivity extends AppCompatActivity {
EditText userName,password,myname;
    kDatabaseAdapter myhelper;
    String user1,pass1;
    @Override    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        userName=(EditText)findViewById(R.id.user);
        password=(EditText)findViewById(R.id.pass);
        myname=(EditText)findViewById(R.id.name);

        myhelper=new kDatabaseAdapter(this);
    }

    public void addUser(View view) {
        user1 = userName.getText().toString();
        pass1 = password.getText().toString();
        if (user1.matches("") || pass1.matches("")) {
            Message.message(this, "Enter the all required field");
        } else {

            long id = myhelper.insert(user1, pass1);
            if (id < 0) {
                Message.message(this, "Unsuccessful");
            } else {
                Message.message(this, "successful Inserted Row");
            }
        }
    }

    public void viewDetails(View view) {
        String dataMsg=myhelper.getAllData();
        Message.message(this,dataMsg);
    }

    public void getDetails(View view) {
        String s1 = myname.getText().toString();
        //kishan 123456        if (s1 == null || s1.trim().equals("")) {
            Message.message(this, "Please Enter the Name for Details");
        } else {
            String mydata = myhelper.getData(s1);
            Message.message(this, mydata);
        }
    }

    public void  update(View view) {

        String s1 = myname.getText().toString();
        //kishan 123456        if (s1 == null || s1.trim().equals("")) {
            Message.message(this, "Please Enter Two Name Variable as oldName NewName");
        } else {
            String oldName = s1.substring(0, s1.indexOf(" "));
            String newName = s1.substring(s1.indexOf(" ") + 1);
            int count = myhelper.updateName(oldName, newName);
            Message.message(this, "" + count);
        }
    }


    public void delete(View view) {
        String s1 = myname.getText().toString();
        if (s1 == null || s1.trim().equals("")) {
            Message.message(this, "Please Enter the Name for Delete");
        } else {
            int count = myhelper.deleteRow(s1);
            Message.message(this, "" + count);
        }
    }

    public void clearRec(View view) {
      myhelper.clearAll();
        Message.message(this,"All Rows deleted Successfully");

    }
}





kDatabaseAdapter.java




package com.haldar.kishan.progm12;

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

/** * Created by SISTER on 15-04-2017. */
public class kDatabaseAdapter {
  kHelper myhelper;
    public  kDatabaseAdapter(Context context){
     myhelper=new kHelper(context);
    }

    public long insert(String name,String password){
        SQLiteDatabase db=myhelper.getWritableDatabase();
        ContentValues contentval=new ContentValues();
        contentval.put(kHelper.NAME,name);
        contentval.put(kHelper.PASSWORD,password);
        long id=db.insert(kHelper.TABLE_NAME,null,contentval);
        return id;
    }

    public  String getAllData(){
        SQLiteDatabase db=myhelper.getWritableDatabase();
        String[] columns={kHelper.UID,kHelper.NAME,kHelper.PASSWORD};
        Cursor pointer=db.query(kHelper.TABLE_NAME,columns,null,null,null,null,null);
       StringBuffer myBuffer=new StringBuffer();
       while (pointer.moveToNext()){
           int cid=pointer.getInt(0);
           String name=pointer.getString(1);
           String password=pointer.getString(2);
           myBuffer.append(cid+ " "+name+" "+password+"\n");
       }
       return myBuffer.toString();
    }

    public String getData(String name){
       //select name,password from kTable where name=? AND password=?; 


 SQLiteDatabase db=myhelper.getWritableDatabase();
        String[] columns={kHelper.UID,kHelper.NAME,kHelper.PASSWORD};
        String[] selectionArgs={name};
        Cursor pointer=db.query(kHelper.TABLE_NAME,columns,
                kHelper.NAME +" =?",
                selectionArgs,null,null,null);
        StringBuffer myBuffer=new StringBuffer();
        while (pointer.moveToNext()){
            int index0=pointer.getColumnIndex(kHelper.UID);
            int index1=pointer.getColumnIndex(kHelper.NAME);
            int index2=pointer.getColumnIndex(kHelper.PASSWORD);
           int personId=pointer.getInt(index0);
           String PersonName=pointer.getString(index1);
            String PersonPassword=pointer.getString(index2);
            myBuffer.append(personId+" "+PersonName+" "+PersonPassword+"\n");
        }
         return myBuffer.toString();
    }

   public int updateName(String oldName,String newName){
     //UPDATE kTable SET NAME='kishan' where Name=? test        


SQLiteDatabase db=myhelper.getWritableDatabase();
       ContentValues contentVal=new ContentValues();
       contentVal.put(kHelper.NAME,newName);
       String[] whereArg={oldName};
       int count=db.update(kHelper.TABLE_NAME,contentVal,kHelper.NAME+"=?",whereArg);
       return count;
   }

   public int deleteRow(String name){
       //DELETE * FROM kTable where name='kishan'        


SQLiteDatabase db=myhelper.getWritableDatabase();
       String[] whereArgs={name};
       int count= db.delete(kHelper.TABLE_NAME,kHelper.NAME+"=?",whereArgs);
       return count;
   }

    public void clearAll(){
        SQLiteDatabase db=myhelper.getWritableDatabase();
        db.delete(kHelper.TABLE_NAME,null,null);
    }

    static class kHelper  extends SQLiteOpenHelper{
        private static final String DATABASE_NAME="khDatabase.db";
        private static final String TABLE_NAME="khTable";
        private static final int DATABASE_VERSION=3;
        private static final String UID="_id";
        private static final String NAME="Name";
        private static final String PASSWORD="Password";
        private static final String CREATE_TABLE="CREATE TABLE "+TABLE_NAME+"


("+UID+" INTEGER PRIMARY KEY AUTOINCREMENT,"+NAME+" VARCHAR(255),"+PASSWORD+" VARCHAR(255))";
        private static final String DROP_TABLE="DROP TABLE IF EXISTS" +TABLE_NAME;
        private Context context;

        public kHelper(Context context){
            super(context,DATABASE_NAME,null,DATABASE_VERSION);
            this.context=context;
            Message.message(context,"Constructor Called");
        }
        @Override        public void onCreate(SQLiteDatabase db) {
            //CREATE TABLE khTable(_id,INTEGER PRIMARY KEY AUTOINCREMENT,Name VARCHAR(255)); 






 try {
                db.execSQL(CREATE_TABLE);
                Message.message(context,"OnCreate Called");
            } catch (SQLException e) {
                Message.message(context,""+e);
            }

        }

        @Override        public void onUpgrade(SQLiteDatabase db, int i, int i1) {
            try {
                db.execSQL(DROP_TABLE);
                onCreate(db);
                Message.message(context,"Onupgrade called");
            } catch (SQLException e) {
                Message.message(context,""+e);
            }
        }
    }
}







Message.java




package com.haldar.kishan.progm12;

import android.content.Context;
import android.widget.Toast;

/** * Created by SISTER on 15-04-2017. */
public class Message {
    public static void message(Context context,String msg){
        Toast.makeText(context,msg,Toast.LENGTH_LONG).show();
    }
}


 






 















Labels:





























Comments











Post a Comment






























Popular posts from this blog





















Maximum possible number of monsters you can defeat?




























 Q).Maximum possible number of monsters you can defeat?  =>Introduction: While playing an RPG game, you were assigned to complete one of the hardest quests in this game. There are n monsters you'll need to defeat in this quest. Each monster i is described with two integer numbers - poweri and bonusi. To defeat this monster, you'll need at least poweri experience points. If you try fighting this monster without having enough experience points, you lose immediately. You will also gain bonusi experience points if you defeat this monster. You can defeat monsters in any order. The quest turned out to be very hard - you try to defeat the monsters but keep losing repeatedly. Your friend told you that this quest is impossible to complete. Knowing that, you're interested, what is the maximum possible number of monsters you can defeat? (Question difficulty level: Hardest) => Input: The first line contains an integer, n, denoting the number of monsters. The next line contains an




















Post a Comment









Read more































Count Frequency of Character in Any Sentence using C++




























 Q)Write the C++ program for character frequency count for any sentence => Program : #include<iostream> #include<string> #include<iomanip> using namespace std; int main(){ string mystr; cout<<"Enter the Any Sentence  for character frequency count \n"; getline(cin,mystr); int charFreq[26]={0}; for(int i=0;i<mystr.length();i++){     int index=mystr[i]-'a';     charFreq[index]++; } cout<<"\n****************************************\n"; cout<<"\nSentence : "<<mystr<<endl<<endl; cout<<setw(12)<<"Character"<<setw(12)<<"Frequency"<<endl<<endl; for(int i=0;i<26;i++){     if(charFreq[i]!=0){         cout<<setw(6)<<char(i+'a')<<setw(10)<<charFreq[i]<<" times \n";     } } } =>Output :




















Post a Comment









Read more