Mobile Application Development Practical 26
Question 1
Write a program to insert data in SQLite database using AsyncTask.
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=".MainActivity">
<TextView
android:id="@+id/textView3"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:gravity="center"
android:textSize="25dp"
android:textStyle="bold"
android:text="Student Form" />
<TextView
android:id="@+id/textView4"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Enter Name"
android:layout_marginTop="70dp"
android:layout_marginLeft="70dp"
android:layout_below="@id/textView3"/>
<EditText
android:id="@+id/sname"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginLeft="10dp"
android:ems="10"
android:layout_toRightOf="@id/textView4"
android:layout_alignBaseline="@id/textView4"
android:hint="Enter student name" />
<TextView
android:id="@+id/textView5"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Enter Roll Number"
android:layout_marginTop="20dp"
android:layout_alignRight="@id/textView4"
android:layout_below="@id/textView4"/>
<EditText
android:id="@+id/rollno"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginLeft="10dp"
android:ems="10"
android:layout_toRightOf="@id/textView5"
android:layout_alignBaseline="@id/textView5"
android:hint="Enter student roll number" />
<Button
android:id="@+id/button"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignStart="@id/rollno"
android:layout_below="@id/rollno"
android:layout_marginTop="20dp"
android:text="Add Student" />
</RelativeLayout>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.READ_EXTERNAL_STORAGE"/>
<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.Practical26"
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>MainActivity.java
package com.example.practical26;
import androidx.appcompat.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 {
EditText sname,sroll;
Button b;
DBHandler dbh;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
sname=findViewById(R.id.sname);
sroll=findViewById(R.id.rollno);
b=findViewById(R.id.button);
dbh=new DBHandler(MainActivity.this);
b.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
String studname=sname.getText().toString();
String studroll=sroll.getText().toString();
if(studname.isEmpty()||studroll.isEmpty())
Toast.makeText(getApplicationContext(),"Enter data first",Toast.LENGTH_LONG).show();
else
{
dbh.addStudent(studname,studroll);
Toast.makeText(getApplicationContext(),"Student Added",Toast.LENGTH_LONG).show();
sname.setText("");
sroll.setText("");
}
}
});
}
}DBHandler.java
package com.example.practical26;
import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class DBHandler extends SQLiteOpenHelper {
static final String dbname="studentdb";
static final String tablename="student";
static final String col_roll="roll";
static final String col_name="name";
static int dbversion=1;
public DBHandler(Context c)
{
super(c,dbname,null,dbversion);
}
@Override
public void onCreate(SQLiteDatabase db) {
String query="CREATE TABLE "+tablename+" ("+col_name+" TEXT,"+col_roll+" INTEGER)";
db.execSQL(query);
}
@Override
public void onUpgrade(SQLiteDatabase db, int i, int i1) {
db.execSQL("DROP TABLE IF EXISTS " + tablename);
onCreate(db);
}
public void addStudent(String sname,String sroll){
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(col_name,sname);
values.put(col_roll,sroll);
db.insert(tablename,null,values);
db.close();
}
}
Output
