Scribd
Upload
6 views7 pages

Database Example

The document contains an Android application code that includes an XML layout for user input fields (name, surname, and marks) and a button to add data. It also features a DatabaseHelper class for managing a SQLite database with methods to insert, update, delete, and retrieve student data. The MainActivity class handles user interactions and integrates the database operations with the UI components.

Uploaded by

adithyankajith4
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
6 views7 pages

Database Example

The document contains an Android application code that includes an XML layout for user input fields (name, surname, and marks) and a button to add data. It also features a DatabaseHelper class for managing a SQLite database with methods to insert, update, delete, and retrieve student data. The MainActivity class handles user interactions and integrates the database operations with the UI components.

Uploaded by

adithyankajith4
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Activity_main.

xml
<RelativeLayout>
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:textAppearance="?android:attr/textAppearanceLarge"
android:text="Name"
android:id="@+id/textView"
android:layout_alignParentTop="true"
android:layout_alignParentLeft="true"
android:layout_alignParentStart="true" />

<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:textAppearance="?android:attr/textAppearanceLarge"
android:text="Surname"
android:id="@+id/textView2"
android:layout_below="@+id/editText_name"
android:layout_alignParentLeft="true"
android:layout_alignParentStart="true" />

<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:textAppearance="?android:attr/textAppearanceLarge"
android:text="Marks"
android:id="@+id/textView3"
android:layout_below="@+id/editText_surname"
android:layout_alignParentLeft="true"
android:layout_alignParentStart="true" />

<EditText
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:id="@+id/editText_name"
android:layout_alignTop="@+id/textView"
android:layout_toRightOf="@+id/textView"
android:layout_toEndOf="@+id/textView" />

<EditText
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:id="@+id/editText_surname"
android:layout_alignTop="@+id/textView2"
android:layout_toRightOf="@+id/textView2"
android:layout_toEndOf="@+id/textView2" />

<EditText
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:id="@+id/editText_Marks"
android:layout_below="@+id/editText_surname"
android:layout_toRightOf="@+id/textView3"
android:layout_toEndOf="@+id/textView3" />
<Button
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Add Data"
android:id="@+id/button_add"
android:layout_below="@+id/editText_Marks"
android:layout_alignParentLeft="true"
android:layout_alignParentStart="true"
android:layout_marginTop="76dp" />
</RelativeLayout>

[Link]

public class DatabaseHelper extends SQLiteOpenHelper {


public static final String DATABASE_NAME = "[Link]";
public static final String TABLE_NAME = "student_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) {


super(context, DATABASE_NAME, null, 1);
}

@Override
public void onCreate(SQLiteDatabase db) {
[Link]("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)
{
[Link]("DROP TABLE IF EXISTS "+TABLE_NAME);
onCreate(db);
}

public boolean insertData(String name,String surname,String marks) {


SQLiteDatabase db = [Link]();
ContentValues contentValues = new ContentValues();
[Link](COL_2,name);
[Link](COL_3,surname);
[Link](COL_4,marks);
long result = [Link](TABLE_NAME,null ,contentValues);
if(result == -1)
return false;
else
return true;
}

public Cursor getAllData() {


SQLiteDatabase db = [Link]();
Cursor res = [Link]("select * from "+TABLE_NAME,null);
return res;
}

public boolean updateData(String id,String name,String surname,String


marks) {
SQLiteDatabase db = [Link]();
ContentValues contentValues = new ContentValues();
[Link](COL_1,id);
[Link](COL_2,name);
[Link](COL_3,surname);
[Link](COL_4,marks);
[Link](TABLE_NAME, contentValues, "ID = ?",new String[] { id });
return true;
}

public Integer deleteData (String id) {


SQLiteDatabase db = [Link]();
return [Link](TABLE_NAME, "ID = ?",new String[] {id});
}
}
[Link]
public class MainActivity extends ActionBarActivity {
DatabaseHelper myDb;
EditText editName,editSurname,editMarks ,editTextId;
Button btnAddData;
Button btnviewAll;
Button btnDelete;

Button btnviewUpdate;
@Override
protected void onCreate(Bundle savedInstanceState) {
[Link](savedInstanceState);
setContentView([Link].activity_main);
myDb = new DatabaseHelper(this);

editName = (EditText)findViewById([Link].editText_name);
editSurname = (EditText)findViewById([Link].editText_surname);
editMarks = (EditText)findViewById([Link].editText_Marks);
editTextId = (EditText)findViewById([Link].editText_id);
btnAddData = (Button)findViewById([Link].button_add);
btnviewAll = (Button)findViewById([Link].button_viewAll);
btnviewUpdate= (Button)findViewById([Link].button_update);
btnDelete= (Button)findViewById([Link].button_delete);
AddData();
viewAll();
UpdateData();
DeleteData();
}
public void DeleteData() {
[Link](
new [Link]() {
@Override
public void onClick(View v) {
Integer deletedRows =
[Link]([Link]().toString());
if(deletedRows > 0)
[Link]([Link],"Data
Deleted",Toast.LENGTH_LONG).show();
else
[Link]([Link],"Data not
Deleted",Toast.LENGTH_LONG).show();
}
}
);
}
public void UpdateData() {
[Link](
new [Link]() {
@Override
public void onClick(View v) {
boolean isUpdate =
[Link]([Link]().toString(),
[Link]().toString(),
[Link]().toString(),[Link]().toStri
ng());
if(isUpdate == true)
[Link]([Link],"Data
Update",Toast.LENGTH_LONG).show();
else
[Link]([Link],"Data not
Updated",Toast.LENGTH_LONG).show();
}
}
);
}
public void AddData() {
[Link](
new [Link]() {
@Override
public void onClick(View v) {
boolean isInserted =
[Link]([Link]().toString(),
[Link]().toString(),
[Link]().toString() );
if(isInserted == true)
[Link]([Link],"Data
Inserted",Toast.LENGTH_LONG).show();
else
[Link]([Link],"Data not
Inserted",Toast.LENGTH_LONG).show();
}
}
);
}

public void viewAll() {


[Link](
new [Link]() {
@Override
public void onClick(View v) {
Cursor res = [Link]();
if([Link]() == 0) {
// show message
showMessage("Error","Nothing found");
return;
}
StringBuffer buffer = new StringBuffer();
while ([Link]()) {
[Link]("Id :"+ [Link](0)+"\n");
[Link]("Name :"+ [Link](1)+"\n");
[Link]("Surname :"+ [Link](2)+"\n");
[Link]("Marks :"+ [Link](3)+"\n\n");
}

// Show all data


showMessage("Data",[Link]());
}
}
);
}

public void showMessage(String title,String Message){


[Link] builder = new [Link](this);
[Link](true);
[Link](title);
[Link](Message);
[Link]();
}

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

@Override
public boolean onOptionsItemSelected(MenuItem item) {
// Handle action bar item clicks here. The action bar will
// automatically handle clicks on the Home/Up button, so long
// as you specify a parent activity in [Link].
int id = [Link]();

//noinspection SimplifiableIfStatement
if (id == [Link].action_settings) {
return true;
}
return [Link](item);
}
}

You might also like