如何在Android中的Gridview中显示以下代码中的数据库值 [英] How Do I Display The Database Values In Gridview In Android For The Following Code

问题描述

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;
	}

}

推荐答案

这篇关于如何在Android中的Gridview中显示以下代码中的数据库值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！