MAD Lab Programs 11 - 15 : WEB VIEW, LIST VIEW, SPINNER VIEW, OPTION MENU, CURD operations using - SQLite

Lab 11: WEB VIEW

Aim:  Write an Android application program that demonstrates Web view in mobile applications development.

Code:

AndroidManifest.xml

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="com.example.admin.webview">
    <uses-permission android:name="android.permission.INTERNET"/>
    <application
        android:allowBackup="true"
        android:icon="@mipmap/ic_launcher"
        android:label="@string/app_name"
        android:roundIcon="@mipmap/ic_launcher_round"
        android:supportsRtl="true"
        android:theme="@style/AppTheme">
        <activity android:name=".MainActivity">
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />

                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>
    </application>

</manifest>


MainActivity.java

package com.example.admin.webview;

import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.webkit.WebView;

public class MainActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

       WebView t=(WebView)findViewById(R.id.webview1);
        t.loadUrl("https://www.google.com");
        //t.loadUrl("file:///android_asset/mypage.html");
    }
}

activity_main.xml

<?xml version = "1.0" encoding = "utf-8"?>
<RelativeLayout
    android:id = "@+id/activity_main"
    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:paddingLeft = "16dp"
    android:paddingRight = "16dp"
    android:paddingTop = "16dp"
    android:paddingBottom = "16dp"
    tools:context = ".MainActivity">

    <WebView
        android:id = "@+id/webview1"
        android:layout_width = "match_parent"
        android:layout_height = "match_parent"
        android:layout_alignParentStart = "true"
        android:layout_alignParentTop = "true"
        android:layout_marginStart = "82dp"
        android:layout_marginTop = "169dp" />
</RelativeLayout>

Result:

 


LAB 12: LIST VIEW

Aim: Write an Android application program that demonstrates List view in mobile applications development

Code: 

MainActivity.java

package com.example.admin.listview;

import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import android.widget.Toast;

public class MainActivity extends AppCompatActivity {
    String[] fruits = {"apple", "Orange", "Grapes"};

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
       // final ArrayAdapter<String> adapter = new ArrayAdapter<String>(this, R.layout.name_list, fruits);
         final ArrayAdapter<String> adapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, fruits);
        ListView listView = (ListView) findViewById(R.id.listview1);
        listView.setAdapter(adapter);
        listView.setOnItemClickListener(new AdapterView.OnItemClickListener() {

            @Override
            public void onItemClick(AdapterView<?> adapterView, View view,
                                    int position, long l) {
                // TODO Auto-generated method stub
                String value = adapter.getItem(position);
                Toast.makeText(getApplicationContext(),position + " " + value, Toast.LENGTH_SHORT).show();


            }

        });
    }
}


activity_main.xml

<?xml version = "1.0" encoding = "utf-8"?>
<RelativeLayout
    android:id = "@+id/activity_main"
    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:paddingLeft = "16dp"
    android:paddingRight = "16dp"
    android:paddingTop = "16dp"
    android:paddingBottom = "16dp"
    tools:context = ".MainActivity">

    <ListView
        android:id = "@+id/listview1"
        android:layout_width = "324dp"
        android:layout_height = "403dp"
        android:layout_alignParentEnd = "true"
        android:layout_alignParentBottom = "true"
        android:layout_marginEnd = "18dp"
        android:layout_marginBottom = "92dp" />
</RelativeLayout>


Result:

Lab 13: SPINNER VIEW

Aim: Write an Android application program that demonstrates Spinner view in mobile applications development.

Code:

MainActivity.java

package com.example.admin.spinerview;

import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.Spinner;
import android.widget.Toast;

public class MainActivity extends AppCompatActivity implements AdapterView.OnItemSelectedListener{

    String[] branchNames={"CSE","EEE","ECE","MECH","PET","CIV"};
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
//Getting the instance of Spinner and applying OnItemSelectedListener on it
        Spinner spin = (Spinner) findViewById(R.id.spinner1);
        spin.setOnItemSelectedListener(this);

//Creating the ArrayAdapter instance having the bank name list
        ArrayAdapter aa = new ArrayAdapter(this,android.R.layout.simple_spinner_item,branchNames);
        aa.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
//Setting the ArrayAdapter data on the Spinner
        spin.setAdapter(aa);
    }


    //Performing action onItemSelected and onNothing selected
    @Override



    public void onItemSelected(AdapterView<?> arg0, View arg1, int position, long id) {
        Toast.makeText(getApplicationContext(), branchNames[position], Toast.LENGTH_LONG).show();
    }

    @Override
    public void onNothingSelected(AdapterView<?> arg0) {
// TODO Auto-generated method stub

    }
}

activity_main.xml

<?xml version = "1.0" encoding = "utf-8"?>
<RelativeLayout
    android:id = "@+id/activity_main"
    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:paddingLeft = "16dp"
    android:paddingRight = "16dp"
    android:paddingTop = "16dp"
    android:paddingBottom = "16dp"
    tools:context = ".MainActivity">

    <Spinner
        android:id = "@+id/spinner1"
        android:layout_width = "match_parent"
        android:layout_height = "wrap_content"
        android:layout_alignParentTop = "true"
        android:layout_centerHorizontal = "true"
        android:layout_marginTop = "114dp" />

</RelativeLayout> 

Result:




Lab 14: OPTION MENU

Aim: Write an Android application program that demonstrates Option menu in mobile applications development.

Code:


MainActivity.java

package com.example.admin.optionmenu;

import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuInflater;

public class MainActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
    }

    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        MenuInflater inflater = getMenuInflater();
        inflater.inflate(R.menu.main_menu,menu);
        return true;
    }
}

activity_main.xml



activity_main.xml

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout
    android:id="@+id/activity_main"
    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:paddingLeft="16dp"
    android:paddingRight="16dp"
    android:paddingTop="16dp"
    android:paddingBottom="16dp"
    tools:context=".MainActivity">

</RelativeLayout>

 main_menu.xml

<?xml version="1.0" encoding="utf-8"?>
<menu xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:android="http://schemas.android.com/apk/res/android">
    <item
        android:id = "@+id/about_us_id"
        android:title="About Us"
        app:showAsAction="always" />

    <item
        android:id = "@+id/settings_id"
        android:title="Settings"
        app:showAsAction="never" />

    <item
        android:id = "@+id/contact_id"
        android:title="Contact Us"
        app:showAsAction="never" />

</menu>

 

Result:


LAB 15: CURD operations using - SQLite

Aim: Design a student mark sheet app to perform CURD operations using SQLite

Code:

MainActivity.java


DatabaseHelper.java

package com.example.admin.sqliteexample1;

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

import static android.icu.lang.UProperty.NAME;
import static android.os.Build.ID;
import static android.provider.Contacts.SettingsColumns.KEY;
import static java.sql.Types.INTEGER;
import static java.text.Collator.PRIMARY;
import static org.xmlpull.v1.XmlPullParser.TEXT;

/**
 * Created by Admin on 5/9/2018.
 */

public class DatabaseHelper extends SQLiteOpenHelper {
    public static final String DATABASE_NAME = "STUDNET.db";
    public static final String TABLE_NAME = "STUDNET_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, String name, SQLiteDatabase.CursorFactory factory, int version) {
    public DatabaseHelper(Context context ) {
       // super(context, name, factory, version);
        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 );
        onCreate(db);
    }

    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);
        if (result == -1)
            return false;
            else
        return true;
    }

    public Cursor getAllData() {
        SQLiteDatabase db = this.getWritableDatabase();
        Cursor res = db.rawQuery("select * from "+TABLE_NAME,null);
        return res;
    }

    public boolean updateData(String id,String name,String surname,String marks) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(col_1,id);
        contentValues.put(col_2,name);
        contentValues.put(col_3,surname);
        contentValues.put(col_4,marks);
        db.update(TABLE_NAME, contentValues, "ID = ?",new String[] { id });
        return true;
    }


    public Integer deleteData (String id) {
        SQLiteDatabase db = this.getWritableDatabase();
        return db.delete(TABLE_NAME, "ID = ?",new String[] {id});
    }

}

MainActivity.java

package com.example.admin.sqliteexample1;

import android.app.AlertDialog;
import android.database.Cursor;
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 editName, editSurName,editMarks,editTextid;
    Button btnAddData, btnviewAll, btnUpdate, btnDelete;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        myDb = new DatabaseHelper(this);
        editName = (EditText) findViewById(R.id.editText);
        editSurName = (EditText) findViewById(R.id.editText2);
        editMarks = (EditText) findViewById(R.id.editText3);
        editTextid = (EditText) findViewById(R.id.editText4);
        btnAddData = (Button) findViewById(R.id.button);
        btnviewAll = (Button) findViewById(R.id.button2);
        btnUpdate = (Button) findViewById(R.id.button3);
        btnDelete = (Button) findViewById(R.id.button4);

        AddData();
        viewAll();
        UpdateData();
        DeleteData();
    }

    public void DeleteData() {
        btnDelete.setOnClickListener(
                new View.OnClickListener() {
                    @Override
                    public void onClick(View v) {
                        Integer deletedRows = myDb.deleteData(editTextid.getText().toString());
                        if(deletedRows > 0)
                            Toast.makeText(MainActivity.this,"Data Deleted",Toast.LENGTH_LONG).show();
                        else
                            Toast.makeText(MainActivity.this,"Data not Deleted",Toast.LENGTH_LONG).show();
                    }
                }
        );
    }



    public void UpdateData() {
        btnUpdate.setOnClickListener(
                new View.OnClickListener() {
                    @Override
                    public void onClick(View v) {
                        boolean isUpdate = myDb.updateData(editTextid.getText().toString(),
                                editName.getText().toString(),

                       editSurName.getText().toString(),editMarks.getText().toString());

                        if(isUpdate == true)
                            Toast.makeText(MainActivity.this,"Data Updated",Toast.LENGTH_LONG).show();
                        else
                            Toast.makeText(MainActivity.this,"Data not Updated",Toast.LENGTH_LONG).show();
                    }
                }
        );
    }


    public  void AddData() {
        btnAddData.setOnClickListener(
                new View.OnClickListener() {
                    @Override
                    public void onClick(View v) {
                        boolean isInserted = myDb.insertData(editName.getText().toString(),
                                editSurName.getText().toString(),
                                editMarks.getText().toString() );
                        if(isInserted == true)
                            Toast.makeText(MainActivity.this,"Data Inserted",Toast.LENGTH_LONG).show();
                        else
                            Toast.makeText(MainActivity.this,"Data not Inserted",Toast.LENGTH_LONG).show();
                    }
                }
        );
    }


    public void viewAll() {
        btnviewAll.setOnClickListener(
                new View.OnClickListener() {
                    @Override
                    public void onClick(View v) {
                        Cursor res = myDb.getAllData();
                        if(res.getCount() == 0) {
                            // show message
                            showMessage("Error","No Data Found...");
                            return;
                        }

                        StringBuffer buffer = new StringBuffer();
                        while (res.moveToNext()) {
                            buffer.append("Id :"+ res.getString (0)+"\n");
                            buffer.append("Name :"+ res.getString(1)+"\n");
                            buffer.append("Surname :"+ res.getString(2)+"\n");
                            buffer.append("Marks :"+ res.getString(3)+"\n\n");
                        }

                        // Show all data
                        showMessage("Data",buffer.toString());
                    }
                }
        );
    }

    public void showMessage(String title,String Message){
        AlertDialog.Builder builder = new AlertDialog.Builder(this);
        builder.setCancelable(true);
        builder.setTitle(title);

        builder.setMessage(Message);
        builder.show();
    }
}

activity_main.xml

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout
    android:id="@+id/activity_main"
    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:paddingLeft="16dp"
    android:paddingRight="16dp"
    android:paddingTop="16dp"
    android:paddingBottom="16dp"
    tools:context=".MainActivity">

    <TextView
        android:id="@+id/textView"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignStart="@+id/textView4"
        android:layout_below="@+id/editText4"
        android:layout_marginTop="16dp"
        android:text="Name" />

    <TextView
        android:id="@+id/textView2"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignEnd="@+id/textView"
        android:layout_below="@+id/textView"
        android:layout_marginTop="46dp"
        android:text="SurName" />

    <TextView
        android:id="@+id/textView3"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignStart="@+id/textView2"
        android:layout_below="@+id/textView2"
        android:layout_marginTop="53dp"
        android:text="Mark" />

    <EditText
        android:id="@+id/editText"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentEnd="true"
        android:layout_alignTop="@+id/textView"
        android:ems="10"
        android:inputType="textPersonName"
        android:text=" " />

    <EditText
        android:id="@+id/editText2"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentEnd="true"
        android:layout_alignTop="@+id/textView2"
        android:ems="10"
        android:inputType="textPersonName"
        android:text=" " />

    <EditText
        android:id="@+id/editText3"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignStart="@+id/editText2"
        android:layout_alignTop="@+id/textView3"
        android:ems="10"
        android:inputType="textPersonName"
        android:text=" " />

    <Button
        android:id="@+id/button"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_below="@+id/editText3"
        android:layout_marginEnd="16dp"
        android:layout_marginTop="61dp"
        android:layout_toStartOf="@+id/editText3"
        android:text="ADD" />

    <Button
        android:id="@+id/button2"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignBottom="@+id/button"
        android:layout_marginStart="14dp"
        android:layout_toEndOf="@+id/button"
        android:text="VIEW ALL DATA" />

    <TextView
        android:id="@+id/textView4"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignBaseline="@+id/editText4"
        android:layout_alignBottom="@+id/editText4"
        android:layout_alignStart="@+id/button"
        android:layout_marginStart="22dp"
        android:text="ID" />

    <EditText
        android:id="@+id/editText4"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentEnd="true"
        android:layout_alignParentTop="true"
        android:ems="10"
        android:inputType="textPersonName"
        android:text=" " />

    <Button
        android:id="@+id/button3"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignStart="@+id/textView3"
        android:layout_below="@+id/button"
        android:layout_marginTop="25dp"
        android:text="Update" />

    <Button
        android:id="@+id/button4"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignBaseline="@+id/button3"
        android:layout_alignBottom="@+id/button3"
        android:layout_alignStart="@+id/button2"
        android:text="Delete" />
</RelativeLayout>

 Result:


Comments

Post a Comment

Popular posts from this blog

MICROCONTROLLER AND EMBEDDED SYSTEMS LABORATORY Part A

Image
1. Write a program to multiply two 16 bit binary numbers. Program:  area multiply, code, readonly entry ldr r5,=value1 ldrh r0,[r5]  ldr r6,=value2 ldrh r1,[r6] mul r3,r1,r0 stop b stop value1 DCD 0x08 value2 DCD 0x03 end Program explanation and Demo:  MCES Lab 1 2. Write a program to find the sum of first 10 integer numbers. Program: AREA ADDITION, CODE, READONLY ENTRY ;MARK FIRST INSTRUCTION TO EXECUTE MOV r0, #10 ; STORE INTEGER NUMBER IN R0 MOV r1,r0  ADDIT SUBS r1, r1, #1 ; SUBTRACTION CMP r1, #0 ; COMPARISON BEQ DONE ADD r3,r0,r1 ; ADDITION MOV r0,r3 ; RESULT     BNE ADDIT ; BRANCH TO THE LOOP IF NOT EQUAL DONE LDR R4,=RES STR R0,[R4]   LDR R5,[R4] STOP B STOP AREA DATA1,DATA,READWRITE RES DCD 0X000 END ;MARK END OF FILE Program explanation and Demo:  MCES Lab 2      3. Write a program to find factorial of a number. Program :  AREA FACT,READONLY,CODE ;Write ...
Read more

DBMS Lab 15-16: Design and implementation of COMPANY database. Design and implementation of MOVIE DATABASE.

Image
  Consider the schema for COMPANY Database:     •       EMPLOYEE ( SSN , Name, Address, Salary, Sex ) •       DEPARTMENT ( DNo , DName, MgrSSN ) •       PROJECT ( PNo , PName, PLocation, DNo ) •       WORKS_FOR( SSN,Dno ) •       WORKS_ON ( SSN, Pno , Hours ) •           SCHEMA DIAGRAM: ER DIAGRAM: CREATE ALL TABLES:   CREATE TABLE EMPLOYEE(SSN INT PRIMARY KEY,ENAME VARCHAR(20),DOB DATE,ADDRESS VARCHAR(40),SALARY REAL,SEX ENUM('MALE','FEMALE')); CREATE TABLE DEPARTMENT(DNO INT PRIMARY KEY, DNAME VARCHAR(30), MGR_SSN INT, FOREIGN KEY(MGR_SSN) REFERENCES EMPLOYEE(SSN)); CREATE TABLE PROJECT(PNO INT PRIMARY KEY, PNAME VARCHAR(40), PLOCATION VARCHAR(30), DNO INT, FOREIGN KEY(DNO) REFERENCES DEPARTMENT(DNO)); CREATE TABLE WORKS_FOR(SSN INT,DNO INT,PRIMARY KEY(SSN,DNO), FOREIGN KEY(SSN) REFERENCE...
Read more

Microcontroller and Embedded systems Questions and Scheme of Evaluation

Image
First Internals 1. (a). List the key differences between Microprocessor & Microcontroller (b). Interpret the concept of Pipeline in ARM Processors with respect to 3, 5 and 6 stages 2. (a). Explain the concept of Combined Cache and Tightly Coupled Memory as part of Core Extension in ARM processors (b). Compare RISC Processors and CISC Processors by considering appropriate parameters 3. Explain the components of the typical Embedded System Hardware with a neat diagram 4. Summarize the ARM Core data flow model with a neat diagram 5. Classify (only names) the ARM Instructions set and show the operation of the following instructions with the syntax and example (i). LDR (ii). BL (iii). SMULL (iv). LDMIA 6. Illustrate the operation of Barrel Shifter for the following ARM instructions, write the value at r7 after executing each instruction along with CPSR conditional flag nzcv bit value (i) MOV r7,r5, LSL #2 (Consider r5=0x80000004) (ii) MOV r7,r5, LSR #2 (Consider r5=0x00000008) ...
Read more