INDEX

Sr.no Practical Title Date

1 Write an Android application that accepts user’s name
and displays a greeting message for the user
2 Write an Android application that accepts’ user’s name
from one activity and displays a greeting message for the
user on the other activity
3 Write an Android application that accepts a website URL
from the user and displays it using a web browser app
4 Write an Android application to send email using an
Intent.
5 Write an Android application to send SMS using an
Intent
6 Write an Android application to customise the action bar
of an app.
7 Write a program to change the text color of a TextView
on a button click
8 Write a program to create an EMP(EmpId, name, salary)
table using SQLite database. Perform CRUD operations
on it.
 Practical 1
1.Write an Android application that
accepts user’s name and displays a
greeting message for the user

Program:
MainActivity.java:
package com.example.practicals;

import androidx.appcompat.app.AppCompatActivity;

import android.annotation.SuppressLint;
import android.graphics.Color;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.CompoundButton;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;
import android.widget.ToggleButton;

import org.w3c.dom.Text;

public class MainActivity extends AppCompatActivity {

private EditText textView;
private TextView textView1;
private Button button;
@SuppressLint("MissingInflatedId")
@Override
protected void onCreate(Bundle savedInstanceState)
{ super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);

textView1=findViewById(R.id.textView2);
textView=findViewById(R.id.textView);
button=findViewById(R.id.button3);

button.setOnClickListener(new View.OnClickListener()
{ @Override
public void onClick(View v)
{ textView1.setText(textView.getText().toString());
}
});

}
}

XML Layout Resource:

<?xml version="1.0" encoding="utf-8"?>
<androidx.constraintlayout.widget.ConstraintLayout
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=".MainActivity">

<EditText
android:id="@+id/textView"
 android:layout_width="174dp"
android:layout_height="52dp"
android:layout_marginStart="16dp"
android:layout_marginTop="76dp"
android:hint="Name"
android:paddingStart="10dp"
android:textSize="30sp"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toTopOf="parent" />

<TextView
android:id="@+id/textView2"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginTop="316dp"
android:layout_marginEnd="86dp"
android:textColor="#000000"
android:textSize="30sp"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintTop_toTopOf="parent" />

<Button
android:id="@+id/button3"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginStart="12dp"
android:layout_marginTop="37dp"
android:text="Button"
app:layout_constraintStart_toEndOf="@+id/textView"
app:layout_constraintTop_toBottomOf="@+id/textView" />

</androidx.constraintlayout.widget.ConstraintLayout>
Practical 2:
1. Write an Android application that
accepts’ user’s name from one activity
and displays a greeting message for the
user on the other activity

Program:
MainActivity.java:
package com.example.practicals;

import androidx.appcompat.app.AppCompatActivity;

import android.annotation.SuppressLint;
import android.content.Intent;
import android.graphics.Color;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.CompoundButton;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;
import android.widget.ToggleButton;

import org.w3c.dom.Text;

public class MainActivity extends AppCompatActivity {

private EditText textView;

private Button button;

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

textView=findViewById(R.id.textView);
button=findViewById(R.id.button3);

button.setOnClickListener(new View.OnClickListener()
{ @Override
public void onClick(View v) {
Intent i=new Intent(getApplicationContext(),MainActivity2.class);
 i.putExtra("key",textView.getText().toString());
startActivity(i);
finish();
}
});

}
}

MainActivity2.java:
package com.example.practicals;

import androidx.appcompat.app.AppCompatActivity;

import android.os.Bundle;
import android.widget.TextView;

public class MainActivity2 extends AppCompatActivity {

private TextView textView;
@Override
protected void onCreate(Bundle savedInstanceState)
{ super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main2);

textView=findViewById(R.id.textView2);

String name=getIntent().getStringExtra("key");
textView.setText(name);
}
}

activity_main.xml:
<?xml version="1.0" encoding="utf-8"?>
<androidx.constraintlayout.widget.ConstraintLayout
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=".MainActivity">

<EditText
android:id="@+id/textView"
android:layout_width="174dp"
android:layout_height="52dp"
android:layout_marginStart="16dp"
android:layout_marginTop="76dp"
android:hint="Name"
android:paddingStart="10dp"
android:textSize="30sp"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toTopOf="parent" />
 <Button
android:id="@+id/button3"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginStart="12dp"
android:layout_marginTop="37dp"
android:text="Button"
app:layout_constraintStart_toEndOf="@+id/textView"
app:layout_constraintTop_toBottomOf="@+id/textView" />

</androidx.constraintlayout.widget.ConstraintLayout>

activity_main2.xml:
<?xml version="1.0" encoding="utf-8"?>
<androidx.constraintlayout.widget.ConstraintLayout
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=".MainActivity2">
<TextView
android:id="@+id/textView2"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginTop="316dp"
android:layout_marginEnd="86dp"
android:textColor="#000000"
android:textSize="30sp"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintTop_toTopOf="parent" />

</androidx.constraintlayout.widget.ConstraintLayout>
Practical 3
Write an Android application that
accepts a website URL from the user and
displays it using a web browser app
Program:
MainActivity.java:
package com.example.practicals;

import androidx.appcompat.app.AppCompatActivity;

import android.annotation.SuppressLint;
import android.content.Intent;
import android.graphics.Color;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.CompoundButton;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;
import android.widget.ToggleButton;

import org.w3c.dom.Text;

public class MainActivity extends AppCompatActivity {

private EditText textView;

private Button button;

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

textView=findViewById(R.id.textView);
button=findViewById(R.id.button3);

button.setOnClickListener(new View.OnClickListener()
{ @Override
public void onClick(View v) {
Intent i=new Intent(getApplicationContext(),MainActivity2.class);
i.putExtra("key",textView.getText().toString());
startActivity(i);
finish();
}
});

}
}
MainActivity2.java:
package com.example.practicals;

import androidx.appcompat.app.AppCompatActivity;

import android.annotation.SuppressLint;
import android.os.Bundle;
import android.webkit.WebView;
import android.widget.TextView;

public class MainActivity2 extends AppCompatActivity {

private WebView webView;
@SuppressLint("MissingInflatedId")
@Override
protected void onCreate(Bundle savedInstanceState)
{ super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main2);

webView=findViewById(R.id.webView);
webView.loadUrl(getIntent().getStringExtra("key"));
}
}

activity_main.xml:
<?xml version="1.0" encoding="utf-8"?>
<androidx.constraintlayout.widget.ConstraintLayout
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=".MainActivity">

<EditText
android:id="@+id/textView"
android:layout_width="174dp"
android:layout_height="52dp"
android:layout_marginStart="16dp"
android:layout_marginTop="76dp"
android:hint="Name"
android:paddingStart="10dp"
android:textSize="30sp"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toTopOf="parent" />

<Button
android:id="@+id/button3"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginStart="12dp"
android:layout_marginTop="37dp"
android:text="Button"
 app:layout_constraintStart_toEndOf="@+id/textView"
app:layout_constraintTop_toBottomOf="@+id/textView" />

</androidx.constraintlayout.widget.ConstraintLayout>

activity_main2.xml:
<?xml version="1.0" encoding="utf-8"?>
<androidx.constraintlayout.widget.ConstraintLayout
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=".MainActivity2">

<WebView
android:id="@+id/webView"
android:layout_width="0dp"
android:layout_height="0dp"
android:layout_marginStart="1dp"
android:layout_marginTop="1dp"
android:layout_marginEnd="1dp"
android:layout_marginBottom="1dp"
app:layout_constraintBottom_toBottomOf="parent"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toTopOf="parent" />
</androidx.constraintlayout.widget.ConstraintLayout>

Android Manifest.xml:
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools">
<uses-permission android:name="android.permission.INTERNET"/>
<application
android:allowBackup="true"
android:dataExtractionRules="@xml/data_extraction_rules"
android:fullBackupContent="@xml/backup_rules"
android:icon="@mipmap/ic_launcher"
android:label="@string/app_name"
android:roundIcon="@mipmap/ic_launcher_round"
android:supportsRtl="true"
android:theme="@style/Theme.Practicals"
tools:targetApi="31">
<activity
android:name=".MainActivity"
android:exported="true">
<intent-filter>
<action android:name="android.intent.action.MAIN" />

<category android:name="android.intent.category.LAUNCHER" />

</intent-filter>

<meta-data
android:name="android.app.lib_name"
android:value="" />
</activity>
</application>
</manifest>
Practical 4: Email Intents
Problem Statement: Write an Android application to send email using an Intent.
Program:
MainActivity.java:
package com.example.intentemail;

import android.os.Bundle;
import android.app.Activity;
import android.content.Intent;
import android.view.Menu;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;

public class MainActivity extends Activity {

EditText editTextTo,editTextSubject,editTextMessage;
Button send;
@Override
protected void onCreate(Bundle savedInstanceState)
{ super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);

editTextTo=(EditText)findViewById(R.id.editText1);
editTextSubject=(EditText)findViewById(R.id.editText2);
editTextMessage=(EditText)findViewById(R.id.editText3);

send=(Button)findViewById(R.id.button1);

send.setOnClickListener(new OnClickListener(){

@Override
public void onClick(View arg0) {
String to=editTextTo.getText().toString();
String subject=editTextSubject.getText().toString();
String message=editTextMessage.getText().toString();

Intent email = new Intent(Intent.ACTION_SEND);

email.putExtra(Intent.EXTRA_EMAIL, new String[]{ to});
email.putExtra(Intent.EXTRA_SUBJECT, subject);
email.putExtra(Intent.EXTRA_TEXT, message);

//need this to prompts email client only

email.setType("message/rfc822");

startActivity(Intent.createChooser(email, "Choose an Email

client :"));

});
}

@Override
 public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is
present.
getMenuInflater().inflate(R.menu.activity_main, menu);
return true;
}

activity_main.xml:
<?xml version="1.0" encoding="utf-8"?>
<androidx.constraintlayout.widget.ConstraintLayout
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=".MainActivity">

<EditText
android:id="@+id/editText1"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentTop="true"
android:layout_alignParentRight="true"
android:layout_marginBottom="15dp"
android:ems="10"
app:layout_constraintBottom_toTopOf="@+id/textView2"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintStart_toStartOf="parent" />

<EditText
android:id="@+id/editText2"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_below="@+id/editText1"
android:layout_alignLeft="@+id/editText1"
android:layout_marginTop="3dp"
android:ems="10"
app:layout_constraintStart_toStartOf="@+id/editText1"
app:layout_constraintTop_toBottomOf="@+id/editText1">

<requestFocus />
</EditText>

<EditText
android:id="@+id/editText3"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_below="@+id/editText2"
android:layout_alignLeft="@+id/editText2"
android:ems="10"
android:inputType="textMultiLine"
app:layout_constraintStart_toStartOf="@+id/editText2"
app:layout_constraintTop_toBottomOf="@+id/editText2" />
 <TextView
android:id="@+id/textView1"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignBaseline="@+id/editText1"
android:layout_alignBottom="@+id/editText1"
android:layout_alignParentLeft="true"
android:layout_marginStart="11dp"
android:layout_marginTop="156dp"
android:text="To:"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toTopOf="parent" />

<TextView
android:id="@+id/textView2"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignBaseline="@+id/editText2"
android:layout_alignBottom="@+id/editText2"
android:layout_alignParentLeft="true"
android:layout_marginStart="11dp"
android:layout_marginTop="31dp"
android:text="Subject:"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toBottomOf="@+id/textView1" />

<TextView
android:id="@+id/textView3"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignBaseline="@+id/editText3"
android:layout_alignBottom="@+id/editText3"
android:layout_alignParentLeft="true"
android:layout_marginStart="11dp"
android:layout_marginTop="23dp"
android:text="Message:"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toBottomOf="@+id/textView2" />

<Button
android:id="@+id/button1"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_below="@+id/editText3"
android:layout_alignLeft="@+id/editText3"
android:layout_marginStart="19dp"
android:layout_marginTop="67dp"
android:text="Send"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toBottomOf="@+id/editText3" />

</androidx.constraintlayout.widget.ConstraintLayout>
Output:
Practical 5: Sending SMS
Write an Android application to send SMS using an Intent.
Program:
mainActivity.java
package com.example.message;

import androidx.appcompat.app.AppCompatActivity;

import android.content.Intent;
import android.net.Uri;
import android.os.Bundle;
import android.telephony.SmsManager;
import android.view.View;
import android.widget.EditText;
import android.widget.ImageButton;
import android.widget.Toast;

public class MainActivity extends AppCompatActivity {

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

//There are two aways to send the sms first intent and second is
sms manger

ImageButton btnSend = findViewById(R.id.btnSend);

EditText etPhone = findViewById(R.id.etPhone);
EditText etMessage = findViewById(R.id.etMessage);

btnSend.setOnClickListener(
new View.OnClickListener()
{ @Override
public void onClick(View v)
{ String destPhoneNo
="smsto:"+etPhone.getText().toString();
String mesg = etMessage.getText().toString();

Intent i = new Intent(Intent.ACTION_SENDTO);

i.setData(Uri.parse(destPhoneNo));
i.putExtra("sms_body",mesg);
startActivity(i);

/*SmsManager smsManager = SmsManager.getDefault();

smsManager.sendTextMessage(destPhoneNo,null,mesg,null,null);
Toast.makeText(getApplicationContext(),"SMS
Send",Toast.LENGTH_LONG).show();*/

}
}
);
}
}

XML layout Resourse:

<?xml version="1.0" encoding="utf-8"?>
<androidx.constraintlayout.widget.ConstraintLayout
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=".MainActivity">

<EditText
android:id="@+id/etPhone"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginStart="42dp"
android:layout_marginTop="82dp"
android:layout_marginEnd="159dp"
android:layout_marginBottom="37dp"
android:ems="10"
android:hint="Phone no"
android:inputType="phone"
app:layout_constraintBottom_toTopOf="@+id/etMessage"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintHorizontal_bias="1.0"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toTopOf="parent"
tools:ignore="TouchTargetSizeCheck,SpeakableTextPresentCheck" />

<EditText
android:id="@+id/etMessage"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginStart="42dp"
android:layout_marginTop="32dp"
android:layout_marginEnd="25dp"
android:layout_marginBottom="522dp"
android:ems="10"
android:gravity="start|top"
android:hint="Enter a message"
android:inputType="textMultiLine"
app:layout_constraintBottom_toBottomOf="parent"
app:layout_constraintEnd_toStartOf="@+id/btnSend"
app:layout_constraintHorizontal_bias="0.333"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toBottomOf="@+id/etPhone"
tools:ignore="TouchTargetSizeCheck,SpeakableTextPresentCheck" />

<ImageButton
android:id="@+id/btnSend"
android:layout_width="56dp"
android:layout_height="52dp"
android:layout_marginStart="27dp"
android:layout_marginTop="185dp"
android:src="@drawable/message"
app:layout_constraintStart_toEndOf="@+id/etMessage"
app:layout_constraintTop_toTopOf="parent"

tools:ignore="MissingConstraints,TouchTargetSizeCheck,SpeakableTextPresentC
heck" />
</androidx.constraintlayout.widget.ConstraintLayout>
 AndroidManiFest.xml:
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools">
<uses-permission android:name="android.permission.SEND_SMS"/>
<uses-permission android:name="android.permission.SEND_SMS"/>

<application
android:allowBackup="true"
android:dataExtractionRules="@xml/data_extraction_rules"
android:fullBackupContent="@xml/backup_rules"
android:icon="@mipmap/ic_launcher"
android:label="@string/app_name"
android:supportsRtl="true"
android:theme="@style/Theme.Message"
tools:targetApi="31">
<activity
android:name=".MainActivity"
android:exported="true">
<intent-filter>
<action android:name="android.intent.action.MAIN" />

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

</manifest>
Practical 6: Action Bar and Options Menu
Problem Statement:
Write an Android application to customize
the action bar of an app.
Program:
mainActivity.java
package com.example.action_bar;

import androidx.annotation.NonNull;
import androidx.appcompat.app.ActionBar;
import androidx.appcompat.app.AppCompatActivity;

import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.widget.Toast;

public class MainActivity extends AppCompatActivity {

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

ActionBar actionBar = getSupportActionBar();

actionBar.setTitle("Action Bar");
actionBar.setSubtitle("Design a custom Action Bar");

actionBar.setIcon(R.mipmap.ic_launcher);
actionBar.setDisplayUseLogoEnabled(true);
actionBar.setDisplayHomeAsUpEnabled(true);
}

@Override
public boolean onCreateOptionsMenu(Menu menu)
{ getMenuInflater().inflate(R.menu.main,menu);
return super.onCreateOptionsMenu(menu);
}

@Override
public boolean onOptionsItemSelected(@NonNull MenuItem item)
{ switch (item.getItemId()){
case R.id.search:
Toast.makeText(getApplicationContext(),"search
selected",Toast.LENGTH_LONG).show();
break;
case R.id.refresh:
Toast.makeText(getApplicationContext(),"refresh
selected",Toast.LENGTH_LONG).show();
break;
case R.id.setting:
Toast.makeText(getApplicationContext(),"setting
selected",Toast.LENGTH_LONG).show();
break;
}
return super.onOptionsItemSelected(item);
}
}
main.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/search"
android:icon="@drawable/ic_search"
android:orderInCategory="100"
android:title="search"
app:actionViewClass="android.widget.SearchView"
app:showAsAction="always" />
<item
android:id="@+id/refresh"
android:icon="@drawable/ic_refresh"
android:orderInCategory="100"
android:title="Refresh"
app:showAsAction="always" />
<item
android:id="@+id/setting"
android:orderInCategory="100"
android:title="Setting"
app:showAsAction="never"/>
</menu>
 Practical 7
1. Write a program to change the text color of a TextView on a
button click
Program:
MainActivity.Java:
package com.example.practicals;

import androidx.appcompat.app.AppCompatActivity;

import android.annotation.SuppressLint;
import android.graphics.Color;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.TextView;

public class MainActivity extends AppCompatActivity {

private TextView textView;
private Button button;
@SuppressLint("MissingInflatedId")
@Override
protected void onCreate(Bundle savedInstanceState)
{ super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);

textView=findViewById(R.id.texteview);
button=findViewById(R.id.button);

button.setOnClickListener(new View.OnClickListener()
{ @Override
public void onClick(View view)
{ textView.setTextColor(Color.RED);
}
});
}
}

Xml Resource File:

Activity_main.xml:
<?xml version="1.0" encoding="utf-8"?>
<androidx.constraintlayout.widget.ConstraintLayout
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=".MainActivity">

<TextView
android:id="@+id/texteview"
android:layout_width="313dp"
android:layout_height="0dp"
android:layout_marginTop="28dp"
android:layout_marginBottom="207dp"
android:text="Hello World!"
android:textSize="40sp"
app:layout_constraintBottom_toTopOf="@+id/button"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintHorizontal_bias="0.276"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toTopOf="parent"
app:layout_constraintVertical_bias="0.043" />

<Button
android:id="@+id/button"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginStart="89dp"
android:layout_marginBottom="360dp"
android:text="Change Color"
app:layout_constraintBottom_toBottomOf="parent"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toBottomOf="@+id/texteview" />

</androidx.constraintlayout.widget.ConstraintLayout>
Practical 8: SQLite Problem
Statement:
Write a program to create an EMP(EmpId, name,
salary) table using SQLite database. Perform CRUD
operations on it.
Program:
package com.example.practical_10;

import androidx.appcompat.app.AppCompatActivity;

import android.annotation.SuppressLint;
import android.os.Bundle;
import android.widget.TextView;
import android.widget.Toast;

import com.example.practical_10.data.MyDbHandler;
import com.example.practical_10.models.contacts;

public class MainActivity extends AppCompatActivity

{ TextView textView;
String create="";
@SuppressLint("MissingInflatedId")
@Override
protected void onCreate(Bundle savedInstanceState)
{ super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);

MyDbHandler mydb=new MyDbHandler(MainActivity.this);

contacts Monish=new contacts();

Monish.setName("Monish");
Monish.setNumber("9702138690");

mydb.addContact(Monish);

Params.Class:
package com.example.practical_10.params;

public class Params {

public static final int DB_VERSION=1;

public static final String DB_NAME="db";
public static final String TABLE_NAME="table1";

public static final String KEY_NAME="name";

public static final String KEY_PHONE="phone";
}
Contacts.class(Java):
package com.example.practical_10.models;

public class contacts

{ private String name;
private String number;

public contacts(String name, String number)

{ this.name = name;
this.number = number;
}

public contacts() {

public String getName()

{ return name;
}

public void setName(String name)

{ this.name = name;
}

public String getNumber()

{ return number;
}

public void setNumber(String number)

{ this.number =number;}
}

MyDbHandler.class:
package com.example.practical_10.data;

import android.content.ContentValues;
import android.content.Context;
import android.content.SharedPreferences;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

import com.example.practical_10.MainActivity;
import com.example.practical_10.models.contacts;
import com.example.practical_10.params.Params;

public class MyDbHandler extends SQLiteOpenHelper

{ public MyDbHandler(Context context){
super(context, Params.DB_NAME,null,Params.DB_VERSION);
}
 @Override
public void onCreate(SQLiteDatabase db) {
String create= "CREATE TABLE "+Params.DB_NAME+ "
("+Params.KEY_NAME+" INTEGER PRIMARY KEY, "
+Params.KEY_PHONE+" TEXT"+" )";

Log.d("dbmonish","Succesfully Inserted : ");

db.execSQL(create);
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
{

public void addContact(contacts contact)

{
SQLiteDatabase db=this.getWritableDatabase();
ContentValues contentValues=new ContentValues();
contentValues.put(Params.KEY_NAME,contact.getName());
contentValues.put(Params.KEY_PHONE,contact.getNumber());

db.insert(Params.TABLE_NAME,null,contentValues);
Log.d("Inserted","Successfully inserted");

db.close();
}
}

Output :