package com.outp.inp;
import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Bundle;
import android.util.Log;
import android.widget.Toast;
public class myact extends Activity {
public static final String KEY_ROWID = "_id";
public static final String KEY_VEHICLE = "vehicle";
public static final String KEY_ROUTE = "route";
public static final String KEY_COUNTRY = "country";
public static final String KEY_CITY = "city";
private static final String TAG = "DBAdapter";
private static final String DATABASE_NAME = "publicTransport";
private static final String DATABASE_TABLE = "vehicleTable";
private static final int DATABASE_VERSION = 1;
long id;
Cursor c;
private static final String DATABASE_CREATE =
"create table vehicleTable (_id integer primary key
autoincrement, "
+ "vehicle text not null, route text not null, "
+ "country text not null,city text not null);";
private final Context context=this;
private DatabaseHelper DBHelper;
private SQLiteDatabase sqlitedatabase;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
DBHelper = new DatabaseHelper(context);
sqlitedatabase = DBHelper.getWritableDatabase();
id = insertRow(
"12c/2","<Dum Dum
Park>,<Howrah>","India","Kolkata");
id = insertRow(
"227","<Bangur>,<Khidirpur>","India","Kolkata");
Toast.makeText(this, "new \n\n"+id,Toast.LENGTH_LONG).show();
Cursor c = getAllRows();
if (c.moveToFirst())
{
do {
DisplayRow(c);
} while (c.moveToNext());
}
sqlitedatabase.close();
}
private static class DatabaseHelper extends SQLiteOpenHelper
{
DatabaseHelper(Context context)
{
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
public void onCreate(SQLiteDatabase db)
{
db.execSQL(DATABASE_CREATE);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion,
int newVersion)
{
Log.w(TAG, "Upgrading database from version " +
oldVersion
+ " to "
+ newVersion + ", which will destroy all old data");
db.execSQL("DROP TABLE IF EXISTS titles");
onCreate(db);
}
}
public long insertRow(String vehicle, String route, String
country,String city)
{
ContentValues initialValues = new ContentValues();
initialValues.put(KEY_VEHICLE, vehicle);
initialValues.put(KEY_ROUTE, route);
initialValues.put(KEY_COUNTRY, country);
initialValues.put(KEY_CITY, city);
return sqlitedatabase.insert(DATABASE_TABLE, null,
initialValues);
}
public Cursor getAllRows()
{
return sqlitedatabase.query(DATABASE_TABLE, new String[] {
KEY_ROWID,
KEY_VEHICLE,
KEY_ROUTE,
KEY_COUNTRY,
KEY_CITY},
null,
null,
null,
null,
null);
}
public void DisplayRow(Cursor c)
{
Toast.makeText(this,
"id: " + c.getString(0) + "\n" +
"VEHICLE: " + c.getString(1) + "\n" +
"ROUTE: " + c.getString(2) + "\n" +
"COUNTRY: " + c.getString(3)+
"CITY: " + c.getString(4),
Toast.LENGTH_LONG).show();
}
}
-------------------------------------
According to me the out put of these prgrm should be
1 "12c/2","<Dum Dum Park>,<Howrah>","India","Kolkata"
2 "227","<Bangur>,<Khidirpur>","India","Kolkata"
But Out put is coming as--
1 "12c/2","<Dum Dum Park>,<Howrah>","India","Kolkata"
2 "227","<Bangur>,<Khidirpur>","India","Kolkata"
1 "12c/2","<Dum Dum Park>,<Howrah>","India","Kolkata"
2 "227","<Bangur>,<Khidirpur>","India","Kolkata"
I have seen others prgrmms too that's giving same output twice . Can
any one please explain??
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
