Databases
StackOverflow2013
Postsdbo
POIncrement and insert Integer values on Android SQLite Database
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIncrement and insert Integer values on Android SQLite Database
    primarykey
    data
    text
    <p>I'm trying to insert values on Android SQLite Database. The question is, I'm trying to insert a word, the table has 3 columns, ID, WORD, COUNT.</p> <p>When I insert a word in the database, some method will verify if this word exists on the database. If yes, it will increment the value of COUNT for this word.</p> <p>Example. I have a word "Question" in the database with COUNT value 1, and i want to insert it again, the method will find this word and if I want to insert "qUeSTion" it doesnt matter, it will return "Question" for me when I retrieve the data, and it will increment the value of COUNT from 1 to 2. Got it??</p> <p>SO here is my code. I'm having problems when try to do this, this verification. I dont know what method to use, etc. I'm using SQLiteStatement for insert. But the methods which offers doesn work. Any Idea of what use?</p> <p>Thanks.</p> <p><strong>Class DataHelper</strong></p> <pre><code>public class DataHelper { private static final String DATABASE_NAME = "sms.db"; private static final int DATABASE_VERSION = 1; private static final String TABLE_NAME = "words"; private Context context; private SQLiteDatabase db; private SQLiteStatement insertStmt; private static final String INSERT = "insert into " + TABLE_NAME + "(word) values (?)"; public DataHelper(Context context) { this.context = context; OpenHelper openHelper = new OpenHelper(this.context); this.db = openHelper.getWritableDatabase(); this.insertStmt = this.db.compileStatement(INSERT); } public long insert(String word) { this.insertStmt.bindString(1, word); return this.insertStmt.executeInsert(); } public List&lt;String&gt; selectAll() { List&lt;String&gt; list = new ArrayList&lt;String&gt;(); Cursor cursor = this.db.query(TABLE_NAME, new String[] { "word"}, null, null, null, null, "id desc"); if (cursor.moveToFirst()) { do { list.add(cursor.getString(0)); } while (cursor.moveToNext()); } if (cursor != null &amp;&amp; !cursor.isClosed()) { cursor.close(); } return list; } } </code></pre> <p><strong>Class SMS</strong> <em>This is the class where I get the words and insert in database</em></p> <pre><code>public class SMS extends Activity { private DataHelper dh; private static TextView txtView; final Uri CONTENT_URI = Uri.parse("content://sms/sent"); @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); this.dh = new DataHelper(this); txtView = (TextView)findViewById(R.id.txtView); Cursor cursor = getContentResolver().query(CONTENT_URI, null, null, null, null); String body; if(cursor.moveToFirst()){ body = cursor.getString(cursor.getColumnIndexOrThrow("body")).toString(); if(body == ""){ Toast.makeText(getBaseContext(), "There is no words to save!", Toast.LENGTH_LONG).show(); } else{ StringTokenizer st = new StringTokenizer(body); while(st.hasMoreTokens()){ this.dh.insert(st.nextToken()); Toast.makeText(getBaseContext(), "The set of words has been updated!", Toast.LENGTH_LONG).show(); } List&lt;String&gt; words = this.dh.selectAll(); StringBuilder sb = new StringBuilder(); sb.append("Set of words:\n\n"); for (String w : words) { sb.append(w + " "); } Log.d("EXAMPLE", "words size - " + words.size()); txtView.setText(sb.toString()); } } } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USRoger Câmara
    1. USRoger Câmara
    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
    1. This table or related slice is empty.
    1. COYou should use `db.query()` and `db.update()`
      singulars
      1. POIncrement and insert Integer values on Android SQLite Database
      1. USPentium10
    2. COIn fact I think I should use a where argument on the method. How do I do this? How is the sintax for the where argument for the db.query method?
      singulars
      1. POIncrement and insert Integer values on Android SQLite Database
      1. USRoger Câmara
    3. COLike an SQL string eg: `col1 > 67 and col2 i not null`
      singulars
      1. POIncrement and insert Integer values on Android SQLite Database
      1. USPentium10
 

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