Click here to Skip to main content
15,886,518 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Java
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;
	}

}
Posted
Updated 11-Mar-14 8:40am
v2
Comments
BupeChombaDerrick 12-Mar-14 15:12pm    
Use a cursorAdapter for that.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900