Hi ive got a class containing a button and in the on click event im
trying to call a class that creates a database and displays a query
from the db in a list view this works fine on it's own but when
trying to hook up to the button it doesn't work.
Here is code for the calling class
package project.Maps;
import android.view.View;
import android.view.View.OnClickListener;
import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.os.Bundle;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.content.Intent;
import android.widget.Toast;
import java.util.ArrayList;
import android.app.ListActivity;
public class Screen1 extends Activity {
public void onCreate(final Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
Button button1 = (Button) findViewById(R.id.button1);
button1.setText("click");
button1.setOnClickListener(new OnClickListener() {
public void onClick(View v) {
// Perform action on clicks
;
Intent myIntent = new Intent(v.getContext(),
CreateLineUpDB.class);
Screen1.this.startActivity(myIntent);
startActivity(myIntent);
}}); }}
And Code for the database class
package project.Maps;
import java.util.ArrayList;
import android.app.ListActivity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.os.Bundle;
import android.util.Log;
import android.widget.ArrayAdapter;
public class CreateLineUpDB extends ListActivity {
private final String SAMPLE_DB_NAME = "myFriendsDb";
private final String SAMPLE_TABLE_NAME = "friends";
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
ArrayList<String> results = new ArrayList<String>();
SQLiteDatabase sampleDB = null;
try {
sampleDB = this.openOrCreateDatabase(SAMPLE_DB_NAME,
MODE_PRIVATE, null);
sampleDB.execSQL("CREATE TABLE IF NOT EXISTS " +
SAMPLE_TABLE_NAME +
" (Artist VARCHAR, Stage VARCHAR," +
" Day VARCHAR, TIME VARCHAR);");
sampleDB.execSQL("INSERT INTO " +
SAMPLE_TABLE_NAME +
" Values ('Oasis','Main','Friday','22:00');");
sampleDB.execSQL("INSERT INTO " +
SAMPLE_TABLE_NAME +
" Values ('Rage Against The Machine','Second
stage','Saturday','22:00');");
sampleDB.execSQL("INSERT INTO " +
SAMPLE_TABLE_NAME +
" Values ('Joe McEldery','Pop
Stage','Sunday','20:00');");
Cursor c = sampleDB.rawQuery("SELECT Artist, Stage, Day, Time
FROM " +
SAMPLE_TABLE_NAME +
" where Day=Sunday", null);
if (c != null ) {
if (c.moveToFirst()) {
do {
String firstName =
c.getString(c.getColumnIndex("Artist"));
String age =
c.getString(c.getColumnIndex("Stage"));
results.add("" + firstName + ",Age: " + age);
}while (c.moveToNext());
}
}
this.setListAdapter(new ArrayAdapter<String>(this,
android.R.layout.simple_list_item_1,results));
} catch (SQLiteException se ) {
Log.e(getClass().getSimpleName(), "Could not create or Open the
database");
} finally {
if (sampleDB != null)
sampleDB.execSQL("DELETE FROM " + SAMPLE_TABLE_NAME);
sampleDB.close();
}
}
}
--
You received this message because you are subscribed to the Google
Groups "Android Beginners" group.
NEW! Try asking and tagging your question on Stack Overflow at
http://stackoverflow.com/questions/tagged/android
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-beginners?hl=en
