Inserting values to SQLite table in Android

Question

I am new in android app developement  I tried to insert values to SQLite database through the below code   public class cashbook extends Activity         Override     public void onCreate Bundle savedInstanceState             super onCreate savedInstanceState           setContentView R layout main           SQLiteDatabase db           db   openOrCreateDatabase               cashbookdata db                SQLiteDatabase CREATE IF NECESSARY               null                         final String Create CashBook                CREATE TABLE CashData                   id INTEGER PRIMARY KEY AUTOINCREMENT                  Description TEXT                   Amount REAL                  Trans INTEGER                   EntryDate TEXT              db execSQL Create CashBook             final String Insert Data  INSERT INTO CashData VALUES 2  Electricity  500 1  04 06 2011             db execSQL Insert Data     It shows error on emulator -  The application CashBook has stopped unexpectedly   The database and table created   but the value insertion is not working  Please help me to resolve this issue  Thanks

User · Answer

I recommend to create a method just for inserting and than use ContentValues  For further info https   www tutorialspoint com android android sqlite database htm  public boolean insertToTable String DESCRIPTION  String AMOUNT  String TRNS        SQLiteDatabase db   this getWritableDatabase         ContentValues contentValues   new ContentValues        contentValues put  this is  DESCRIPTION       contentValues put  5000  AMOUNT       contentValues put  TRAN  TRNS       db insert  Your table name  null contentValues        return true

User · Answer

public class TestingData extends Activity       Called when the activity is first created      Override public void onCreate Bundle savedInstanceState        super onCreate savedInstanceState       setContentView R layout main        SQLiteDatabase db      db   openOrCreateDatabase           TestingData db            SQLiteDatabase CREATE IF NECESSARY           null                    then see this link link

User · Answer

I see it is an old thread but I had the same error   I found the explanation here   http   developer android com reference android database sqlite SQLiteDatabase html     void execSQL String sql    Execute a single SQL statement that is NOT a SELECT or any other SQL statement that    returns data       void execSQL String sql  Object   bindArgs          Execute a single SQL statement that is NOT a SELECT INSERT UPDATE DELETE

User · Answer

okk this is fully working code edit it as per your requirement  public class TestProjectActivity extends Activity    Override public void onCreate Bundle savedInstanceState        super onCreate savedInstanceState       setContentView R layout main       SQLiteDatabase db      db   openOrCreateDatabase   Temp db           SQLiteDatabase CREATE IF NECESSARY          null                 try           final String CREATE TABLE CONTAIN    CREATE TABLE IF NOT EXISTS tbl Contain                       ID INTEGER primary key AUTOINCREMENT                      DESCRIPTION TEXT                      expirydate DATETIME                      AMOUNT TEXT                      TRNS TEXT      isdefault TEXT             db execSQL CREATE TABLE CONTAIN           Toast makeText TestProjectActivity this   table created    Toast LENGTH LONG  show            String sql                INSERT or replace INTO tbl Contain  DESCRIPTION  expirydate  AMOUNT  TRNS isdefault  VALUES  this is   03 04 2005   5000   tran   y                             db execSQL sql             catch  Exception e            Toast makeText TestProjectActivity this   ERROR   e toString    Toast LENGTH LONG  show            Hope this is useful for you   do not use TEXT for date field may be that was casing problem still getting problem let me know   Pragna

User · Answer

Since you are new to Android development you may not know about Content Providers  which are database abstractions  They may not be the right thing for your project  but you should check them out  http   developer android com guide topics providers content-providers html

User · Answer

Seems odd to be inserting a value into an automatically incrementing field   Also  have you tried the insert   method instead of execSQL   ContentValues insertValues   new ContentValues    insertValues put  Description    Electricity    insertValues put  Amount   500   insertValues put  Trans   1   insertValues put  EntryDate    04 06 2011    db insert  CashData   null  insertValues

User · Answer

okkk you have take id INTEGER PRIMARY KEY AUTOINCREMENT and still u r passing value    that is the problem    for more detail  see this still getting problem then post code and logcat

User · Answer

You ll find debugging errors like this a lot easier if you catch any errors thrown from the execSQL call  eg    try           db execSQL Create CashBook         catch  Exception e             Log e  ERROR   e toString

[android] Inserting values to SQLite table in Android

Examples related to android

Examples related to sqlite