package com.sample; import java.util.ArrayList; import android.os.Bundle; import android.app.Activity; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.util.Log; import android.view.Menu; import android.view.View; import android.view.View.OnClickListener; import android.widget.ArrayAdapter; import android.widget.Button; import android.widget.EditText; import android.widget.Toast; public class MainActivity extends Activity { Button save,load; EditText name; DataHandler handler; SQLiteDatabase db; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); //CHANGE final ArrayList results = new ArrayList(); save=(Button) findViewById(R.id.save); load=(Button) findViewById(R.id.load); name=(EditText) findViewById(R.id.name); save.setOnClickListener(new OnClickListener(){ @Override public void onClick(View v) { // TODO Auto-generated method stub String getname=name.getText().toString(); handler= new DataHandler(getBaseContext()); handler.open(); long id=handler.insertData(getname); Toast.makeText(getBaseContext(), "Data Inserted", Toast.LENGTH_LONG).show(); handler.close(); } }); load.setOnClickListener(new OnClickListener(){ @Override public void onClick(View v) { // TODO Auto-generated method stub String getName; getName=""; handler= new DataHandler(getBaseContext()); handler.open(); Cursor c= handler.returnData(); if(c.moveToFirst()) { int i = 0; do{ i++; getName=c.getString(0); //results.add("" + i + ": " + getName); Toast.makeText(getBaseContext(), "Mobile No:"+getName, Toast.LENGTH_LONG).show(); //System.out.println(i+":"+getName); }while(c.moveToNext()); } //Log.d(getName, getName); handler.close(); //db.execSQL("select getName from mytable"); //Toast.makeText(getBaseContext(), "Name:"+getName, Toast.LENGTH_LONG).show(); //this.setListAdapter(new ArrayAdapter(this, android.R.layout.simple_list_item_1, results)); } }); } @Override public boolean onCreateOptionsMenu(Menu menu) { // Inflate the menu; this adds items to the action bar if it is present. getMenuInflater().inflate(R.menu.main, menu); return true; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)