Databases
StackOverflow2013
Postsdbo
POHow do I store integer values of EditText into SQLite Database [Android]
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow do I store integer values of EditText into SQLite Database [Android]
    primarykey
    data
    text
    <p>I am having trouble with storing integer value in SQLite database. <br> Here are my codes.</p> <p>My insert code of the Create_Events.java</p> <pre><code>Button btnCreate = (Button)findViewById(R.id.saveButton); btnCreate.setOnClickListener(new OnClickListener() { @Override public void onClick(View v) { calDB.open(); long _id; EditText txtTitle = (EditText) findViewById(R.id.txtTitle); String title = txtTitle.getText().toString(); EditText txtLocation = (EditText) findViewById(R.id.editText1); String location = txtLocation.getText().toString(); EditText startTime = (EditText) findViewById(R.id.editText2); String startTime = startTime.getText().toString(); _id = calDB.insertEvent(title, location, 0, 0); calDB.close(); } }); </code></pre> <p>CalendarAdapter.java (Database class)</p> <pre><code>package main.page; 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.util.Log; public class CalendarAdapter { public static final String KEY_ROWID = "_id"; public static final String KEY_TITLE = "title"; public static final String KEY_LOCATION = "location"; public static final String KEY_START = "starttime"; public static final String KEY_END = "endtime"; private static final String TAG = "DBAdapter"; private static final String DATABASE_NAME = "anniversary"; private static final String DATABASE_TABLE = "calendar"; private static final int DATABASE_VERSION = 2; private static final String DATABASE_CREATE = "create table calendar(_id integer primary key autoincrement,"+ "title text not null, location text not null, starttime integer, endtime integer);"; private final Context context; private DatabaseHelper DBHelper; private SQLiteDatabase db; public CalendarAdapter(Context ctx) { this.context = ctx; DBHelper = new DatabaseHelper(context); } private static class DatabaseHelper extends SQLiteOpenHelper { DatabaseHelper(Context context) { super(context, DATABASE_NAME, null, DATABASE_VERSION); } @Override public void onCreate(SQLiteDatabase db) { try { db.execSQL(DATABASE_CREATE); }catch(SQLException e) { e.printStackTrace(); } } @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 calendar"); onCreate(db); } } public CalendarAdapter open() throws SQLException { db = DBHelper.getWritableDatabase(); return this; } public void close() { DBHelper.close(); } public long insertEvent(String title, String location, int starttime, int endtime) { ContentValues initialValues = new ContentValues(); initialValues.put(KEY_TITLE, title); initialValues.put(KEY_LOCATION, location); initialValues.put(KEY_START, starttime); initialValues.put(KEY_END, endtime); return db.insert(DATABASE_TABLE, null, initialValues); } public boolean deleteEvent(long rowId) { return db.delete(DATABASE_TABLE, KEY_ROWID + "=" + rowId, null) &gt; 0; } public Cursor getAllEvents() { return db.query(DATABASE_TABLE, new String[] {KEY_ROWID, KEY_TITLE, KEY_LOCATION, KEY_START, KEY_END}, null, null, null, null, null); } public Cursor getEvent(long rowId) throws SQLException { Cursor c = db.query(true, DATABASE_TABLE, new String[] {KEY_ROWID, KEY_TITLE, KEY_LOCATION, KEY_START, KEY_END}, KEY_ROWID + "=" + rowId, null, null, null, null, null); if(c != null) { c.moveToFirst(); } return c; } public boolean updateEvent(long rowId, String title, String location, int starttime, int endtime) { ContentValues args = new ContentValues(); args.put(KEY_TITLE, title); args.put(KEY_LOCATION, location); args.put(KEY_START, starttime); args.put(KEY_END, endtime); return db.update(DATABASE_TABLE, args, KEY_ROWID + "=" + rowId, null) &gt; 0; } } </code></pre> <p>As you can see above, I have managed to store text values from the EditText into the database successfully. So now I am trying to store the starttime(Integer) into database. <br> Any help will be greatly appreciated. Thanks a bunch!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USCallMyName
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COWhat's the problem exactly? It looks like you are always passing in 0 for `starttime`? How do you know it is not being stored?
      singulars
      1. POHow do I store integer values of EditText into SQLite Database [Android]
      1. UScklab
    2. CONo, I put 0 because I want to test whether the text values can be inserted into database. It is inserted into database but when I try to insert from editText the integer cannot be inserted.
      singulars
      1. POHow do I store integer values of EditText into SQLite Database [Android]
      1. USCallMyName
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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