[Android Q&A, Help & Troubleshooting] nikoc03:
Hey all, i want to make an android app which presents a form which sends the data inserted in a database when the submit button is pressed..im a newbie but i think i ve got some progress here. i present my code:

package com.example.marialena.practice;

import android.content.ContentValues;

import android.content.Context;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

import java.util.ArrayList;

import java.util.List;

public class DatabaseHandler extends SQLiteOpenHelper {

// All Static variables

// Database Version

private static final int DATABASE_VERSION = 1;

// Database Name

private static final String DATABASE_NAME = "contactsManager";

// Contacts table name

private static final String TABLE_CONTACTS = "contacts";

// Contacts Table Columns names

private static final String KEY_ID = "id";

private static final String KEY_NAME = "name";

private static final String KEY_LAST_NAME = "last_name";

private static final String KEY_ORIGIN = "origin";

public DatabaseHandler(Context context) {super(context, DATABASE_NAME, null, DATABASE_VERSION);}

// Creating Tables

[MENTION=439709]override[/MENTION]

public void onCreate(SQLiteDatabase db) {

String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_CONTACTS + "("

+ KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT,"

+ KEY_LAST_NAME + " TEXT," + KEY_ORIGIN + "TEXT" + ")";

db.execSQL(CREATE_CONTACTS_TABLE);

}

// Upgrading database

[MENTION=439709]override[/MENTION]

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

// Drop older table if existed

db.execSQL("DROP TABLE IF EXISTS " + TABLE_CONTACTS);

// Create tables again

onCreate(db);

}

// Adding new contact

public void addContact(Contact contact) {

SQLiteDatabase db = this.getWritableDatabase();

ContentValues values = new ContentValues();

values.put(KEY_NAME, contact.getName()); // Contact Name

values.put(KEY_LAST_NAME, contact.getLastName()); // Contact last Name

values.put(KEY_ORIGIN, contact.getOrigin()); // Contact Origin

// Inserting Row

db.insert(TABLE_CONTACTS, null, values);

db.close(); // Closing database connection

}

// Getting single contact

Contact getContact(int id) {

SQLiteDatabase db = this.getReadableDatabase();

Cursor cursor = db.query(TABLE_CONTACTS, new String[] { KEY_ID,

KEY_NAME, KEY_LAST_NAME, KEY_ORIGIN }, KEY_ID + "=?",

new String[] { String.valueOf(id) }, null, null, null);

if (cursor != null) cursor.moveToFirst();

Contact contact = new Contact(Integer.parseInt(cursor.getString(0)),

cursor.getString(1), cursor.getString(2),cursor.getString(3));

// return contact

return contact;

}

// Getting All Contacts

public List<Contact> getAllContacts() {

List<Contact> contactList = new ArrayList<Contact>();

// Select All Query

String selectQuery = "SELECT * FROM " + TABLE_CONTACTS;

SQLiteDatabase db = this.getWritableDatabase();

Cursor cursor = db.rawQuery(selectQuery, null);

// looping through all rows and adding to list

if (cursor.moveToFirst()) {

do {

Contact contact = new Contact();

contact.setID(Integer.parseInt(cursor.getString(0)));

contact.setName(cursor.getString(1));

contact.setLastName(cursor.getString(2));

contact.setOrigin(cursor.getString(3));

// Adding contact to list

contactList.add(contact);

} while (cursor.moveToNext());

}

// return contact list

return contactList;

}

// Updating single contact

public int updateContact(Contact contact) {

SQLiteDatabase db = this.getWritableDatabase();

ContentValues values = new ContentValues();

values.put(KEY_NAME, contact.getName());

values.put(KEY_LAST_NAME, contact.getLastName());

values.put(KEY_ORIGIN, contact.getOrigin());

// updating row

return db.update(TABLE_CONTACTS, values, KEY_ID + " = ?",

new String[] { String.valueOf(contact.getID()) });

}

// Deleting single contact

public void deleteContact(Contact contact) {

SQLiteDatabase db = this.getWritableDatabase();

db.delete(TABLE_CONTACTS, KEY_ID + " = ?", new String[] { String.valueOf(contact.getID()) });

db.close();

}

// Getting contacts Count

public int getContactsCount() {

String countQuery = "SELECT * FROM " + TABLE_CONTACTS;

SQLiteDatabase db = this.getReadableDatabase();

Cursor cursor = db.rawQuery(countQuery, null);

cursor.close();

// return count

return cursor.getCount();

}

}

DisplayMessageActivity.java

package com.example.marialena.practice;

import android.content.Intent;

import android.os.Bundle;

import android.util.Log;

import android.view.MenuItem;

import android.widget.TextView;

import java.util.List;

public class DisplayMessageActivity extends MyActivity {

[MENTION=439709]override[/MENTION]

public void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_my);

//receiving data

Intent intent = getIntent();

//manipulating message extraction and thank u message.

String message = "Thank You!";

TextView textView = new TextView(this);

textView.setTextSize(40);

textView.setText(message);

setContentView(textView);

DatabaseHandler db = new DatabaseHandler(this);

/**

* CRUD Operations

* */

// Inserting Contacts

Log.d("Insert: ", "Inserting ..");

db.addContact(new Contact("Ravi", "Alonso","HollowStr"));

// Reading all contacts

Log.d("Reading: ", "Reading all contacts..");

List<Contact> contacts = db.getAllContacts();

for (Contact cn : contacts) {

String log = "Id: "+cn.getID()+" ,Name: " + cn.getName() + " ,Last Name: " + cn.getLastName() + " ,Origin: " + cn.getOrigin();

// Writing Contacts to log

Log.d("Name: ", log);

}

}

[MENTION=439709]override[/MENTION]

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 AndroidManifest.xml.

int id = item.getItemId();

//noinspection SimplifiableIfStatement

if (id == R.id.action_settings) {

return true;

}

return super.onOptionsItemSelected(item);

}

}

MyActivity.java

package com.example.marialena.practice;

import android.content.Intent;

import android.os.Bundle;

import android.support.v7.app.ActionBarActivity;

import android.view.Menu;

import android.view.MenuItem;

import android.view.View;

import android.widget.EditText;

public class MyActivity extends ActionBarActivity {

public final static String EXTRA_MESSAGE = "com.example.marialena.practice.MESSAGE";

[MENTION=439709]override[/MENTION]

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_my);

}

[MENTION=439709]override[/MENTION]

public boolean onCreateOptionsMenu(Menu menu) {

// Inflate the menu; this adds items to the action bar if it is present.

getMenuInflater().inflate(R.menu.menu_my, menu);

return true;

}

[MENTION=439709]override[/MENTION]

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 AndroidManifest.xml.

int id = item.getItemId();

//noinspection SimplifiableIfStatement

if (id == R.id.action_settings) {

return true;

}

return super.onOptionsItemSelected(item);

}

public void sendMessage(View view) {

Intent intent = new Intent(this, DisplayMessageActivity.class);

EditText editText = (EditText) findViewById(R.id.name);

String message = editText.getText().toString();

intent.putExtra(EXTRA_MESSAGE, message);

startActivity(intent);

/* Intent intent2 = new Intent(this, DisplayMessageActivity.class);

EditText editText2 = (EditText) findViewById(R.id.last);

String message2 = editText2.getText().toString();

intent2.putExtra(EXTRA_MESSAGE, message2);

startActivity(intent2);*/

}

}

CONTACT.JAVA

package com.example.marialena.practice;

/**

* Created by Marialena on 7/31/2015.

*/

public class Contact {

//private variables

int _id;

String _name;

String _last_name;

String _origin;

//empty constructor

public Contact(){}

//constructor plus ID

public Contact(int id,String name, String last_name, String origin){

this._id=id;

this._last_name=last_name;

this._name=name;

this._origin=origin;

}

//constructor simple

public Contact(String name, String last_name, String origin){

this._origin=origin;

this._name=name;

this._last_name=last_name;

}

// getting ID

public int getID(){

return this._id;

}

// setting id

public void setID(int id){

this._id = id;

}

// getting name

public String getName(){

return this._name;

}

// setting name

public void setName(String name){

this._name = name;

}

// getting last name

public String getLastName(){

return this._last_name;

}

// setting last name

public void setLastName(String last_name){

this._last_name = last_name;

}

// getting origin

public String getOrigin(){

return this._origin;

}

// setting origin

public void setOrigin(String origin){

this._origin = origin;

}

}