Skip to main content

Posts

Showing posts with the label sqlite tables

A complete reference to Database Helper Class in SQLite in ANDROID

For COMPLETE TUTORIALS see here : DABASEHELPER CLASS : 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; public class DBAdapter { public static final String KEY_ROWID = "id"; public static final String KEY_NAME = "title"; public static final String KEY_NICKNAME = "duedate"; private static final String DATABASE_NAME = "assinDB.db"; private static final String DATABASE_TABLE = "assignments"; private static final int DATABASE_VERSION = 2; private final Context context; private DatabaseHelper ObjectDBHelper; private SQLiteDatabase db; public DBAdapter(Context ctx) { context = ctx; } private static class DatabaseHelper extends SQLiteOpenHelper { public DatabaseHelper(Context con...

Get a single record from SQLite in ANDROID

For COMPLETE TUTORIALS see here : in DATABASE HELPER class: String[] coloumns = new String[] { KEY_ROWID, KEY_NAME, KEY_NICKNAME }; // calling elements in an array Cursor c = db.query(DATABASE_TABLE, coloumns, KEY_ROWID + "=" + l,null, null, null, null); if (c != null) { c.moveToFirst(); String name = c.getString(1); // since name is in position 1 ie second coloumn return name; } return null; in sqlite.java : String s =editinfo.getText().toString(); long l=Long.parseLong(s); DBAdapter adapter=new DBAdapter(SQliteExample.this); adapter.open(); String returnedname=adapter.returnName(l); String returnednickname=adapter.returnickname(l); adapter.close(); editName.setText(returnedname); editNickName.setText(returnednickname);

Get all records from SQLite in ANDROID

For COMPLETE TUTORIALS see here : in DABASEHELPER CLASS : String[] coloumns = new String[] { KEY_ROWID, KEY_NAME,KEY_NICKNAME }; // calling all elements in an array Cursor c = db.query(DATABASE_TABLE, coloumns, null, null, null, null,null);// basically reading a database need cursor String result = " ";// since string is to be returned System.out.println("count of cursor=====>>" + c.getCount()); int iRowid = c.getColumnIndex(KEY_ROWID); // calling each row values int iRowName = c.getColumnIndex(KEY_NAME); int iRowNickName = c.getColumnIndex(KEY_NICKNAME); if (c.moveToFirst()) { c.moveToFirst(); for (int i = 0; i " + iRowid + " "+ iRowName); c.moveToNext(); } } c.close(); db.close(); return result; in sqlite.java : TextView infotext=(TextView) findViewById(R.id.tvsqlinfo); DBAdapter info = new DBAdapter(this); ...