hi
I am beginner for the android .now i createdone application in
androidwhich is to connecting the database and showing the datain the
screen but i hava lot of problem 1) connection is made but the data is
not showing in emulator
i want to inset update delete the data from database but i have
stopped in the startig point to take the data from database and show
on emulator plz help me
i have sent amy code if any mistake in the code plz tel me or give me
some perfect code to give me those answer
package com.DataBaseWork;
import java.util.ArrayList;
import android.app.ListActivity;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.widget.ArrayAdapter;
import android.widget.EditText;
public class DataBaseWork extends ListActivity {
private final String MY_DATABASE_NAME = "myCoolDB_2";
private final String MY_DATABASE_TABLE = "Users";
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle icicle) {
super.onCreate(icicle);
EditText et = new EditText(this);
et.setSelection(et.getText().length());
/* Will hold the 'Output' we want to display at the end. */
ArrayList<String> results = new ArrayList<String>();
SQLiteDatabase myDB = null;
try {
myDB =this.openOrCreateDatabase
(MY_DATABASE_NAME,MODE_WORLD_READABLE,null);
/* Create the Database (no Errors if it already exists)
*/
//this.createDatabase(MY_DATABASE_NAME, 1,
MODE_PRIVATE, null);
/* Open the DB and remember it */
//myDB = this.openDatabase(MY_DATABASE_NAME, null);
/* Create a Table in the Database. */
myDB.execSQL("CREATE TABLE IF NOT EXISTS "
+ MY_DATABASE_TABLE
+ " (LastName VARCHAR,
FirstName VARCHAR,"
+ " Country VARCHAR,
Age INT(3));");
myDB.execSQL("INSERT INTO "
+ MY_DATABASE_TABLE
+ " (LastName,
FirstName, Country, Age)"
+ " VALUES ('Gramlich',
'Nicolas', 'Germany', 20);");
myDB.execSQL("INSERT INTO "
+ MY_DATABASE_TABLE
+ " (LastName,
FirstName, Country, Age)"
+ " VALUES ('Doe',
'John', 'US', 34);");
/* Query for some results with Selection and
Projection. */
/*Cursor c = myDB.query(true, "SELECT FirstName,Age" +
" FROM " +
MY_DATABASE_TABLE
+ " WHERE Age >
10 LIMIT 7;",
null,null,null,null,null, null,
MY_DATABASE_NAME);*/
/*Cursor c = myDB.query(MY_DATABASE_TABLE, new String[]
{"FirstName","Age"},null,null,null,null,null);*/
Cursor c = myDB.rawQuery("SELECT FirstName,Age" +
" FROM " + MY_DATABASE_TABLE ,null);
//Log.i(tag,"value seleted ");
int firstNameColumn = c.getColumnIndex("FirstName");
int ageColumn = c.getColumnIndex("Age");
if (c != null) {
if (c.isFirst()) {
int i = 0;
do {
i++;
String firstName =
c.getString(firstNameColumn);
int age = c.getInt(ageColumn);
String ageColumName =
c.getColumnName(ageColumn);
results.add("" + i + ": " +
firstName
+ " (" + ageColumName + ": " +
age + ")");
//c.moveToFirst();
} while (c.moveToFirst());
}
}
} catch (SQLException e)
{
Log.e ("Exception on query:-", e.toString());
} finally {
if (myDB != null)
myDB.close();
}
this.setListAdapter(new ArrayAdapter<String>(this,
android.R.layout.simple_list_item_1, results));
}
}
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~----------~----~----~----~------~----~------~--~---
