StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>This is sample Databse Helper which i used, it works,</p> <pre><code>import java.util.ArrayList; import java.util.LinkedHashMap; import java.util.List; import java.util.Set; import org.example.db.R; import org.example.model.contact; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteDatabase.CursorFactory; import android.database.sqlite.SQLiteOpenHelper; import android.util.Log; public class SQLiteHelper extends SQLiteOpenHelper { // Attributes private Context context; private SQLiteDatabase database; @SuppressWarnings("unused") private interface Table { public static final String CONTACT = "contact"; /** * Constructor * @param context */ public SQLiteHelper(Context context) { this(context, context.getString(R.string.db_name), null, 33); this.context = context; database = getReadableDatabase(); } public SQLiteHelper(Context context, String name, CursorFactory factory, int version) { super(context, name, factory, version); } public Contact getContact(long contactId) { String sql = "SELECT * FROM " + Table.CONTACT + " WHERE " + Contact.Column.ID + " = " + contactId; Contact contact = null; Cursor cursor = database.rawQuery(sql, null); if(cursor.moveToNext()) { contact = getContactFromCursor(cursor); } cursor.close(); return contact; } public List<contact> getContacts() { String sql = "SELECT * FROM " + Table.CONTACT+ " ORDER BY " + Contact.Column.NAME + " ASC"; List<Contact> contacts = new ArrayList<Contact>(); Cursor cursor = database.rawQuery(sql, null); while(cursor.moveToNext()) { Contact contact= getContactFromCursor(cursor); if(contact!= null) { contacts.add(baby); } } cursor.close(); return contacts; } private Baby getContactFromCursor(Cursor cursor) { long id = cursor.getLong(cursor.getColumnIndex(Contact.Column.ID)); String name = cursor.getString(cursor.getColumnIndex(Contact.Column.NAME)); int gender = cursor.getInt(cursor.getColumnIndex(Contact.Column.GENDER)); Contact contact= new Contact(id, name, gender); return contact; } @Override public void onCreate(SQLiteDatabase database) { } @Override public void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) { } public void close() { if(database != null && database.isOpen()) { database.close(); } } public boolean isOpen() { return database != null ? database.isOpen() : false; } } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload