Thanks so much On Dec 29, 11:43 am, James Black <[email protected]> wrote: > Change your database version to recreate the table. > On Dec 29, 2011 1:14 PM, "Jeresam515" <[email protected]> wrote: > > > > > > > > > Thanks, I fixed that still have the same error though, here's my new > > code. > > package com.drawing; > > > 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 NotesDbAdapter { > > > public static final String KEY_ROWID = "_id"; > > public static final String KEY_X = "x"; > > public static final String KEY_Y = "y"; > > public static final String KEY_Size = "size"; > > private static final String TAG = "NotesDbAdapter"; > > private DatabaseHelper mDbHelper; > > private SQLiteDatabase mDb; > > private static final String DATABASE_NAME = "data"; > > private static final String DATABASE_TABLE = "notes"; > > private static final int DATABASE_VERSION = 2; > > private static final String DATABASE_CREATE = > > " create table " +DATABASE_TABLE+ " (" > > +KEY_ROWID+ " integer primary key autoincrement, " > > +KEY_X+ " integer, " > > +KEY_Y+ " integer, " > > +KEY_Size+ " integer);"; > > private final Context mCtx; > > > 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 (Exception e) { > > Log.e("dbAdapter", e.getMessage().toString()); > > } > > } > > > @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 notes"); > > onCreate(db); > > } > > > } > > > public NotesDbAdapter(Context ctx) { > > this.mCtx = ctx; > > } > > > public NotesDbAdapter open() throws SQLException { > > mDbHelper = new DatabaseHelper(mCtx); > > mDb = mDbHelper.getWritableDatabase(); > > return this; > > } > > > public void close() { > > mDbHelper.close(); > > } > > > public long createNote(float f, float g, int size) { > > ContentValues initialValues = new ContentValues(); > > initialValues.put(KEY_X, f); > > initialValues.put(KEY_Y, g); > > initialValues.put(KEY_Size, size); > > return mDb.insert(DATABASE_TABLE, null, initialValues); > > } > > > public boolean deleteNote(long rowId) { > > > return mDb.delete(DATABASE_TABLE, KEY_ROWID + "=" + rowId, > > null) > 0; > > } > > > public Cursor fetchAllNotes() { > > > return mDb.query(DATABASE_TABLE, new String[] {KEY_ROWID, > > KEY_X,KEY_Y,KEY_Size}, null, null, null, null, null); > > } > > > public Cursor fetchNote(long rowId) throws SQLException { > > > Cursor mCursor = > > > mDb.query(true, DATABASE_TABLE, new String[] {KEY_ROWID, > > KEY_X,KEY_Y,KEY_Size}, KEY_ROWID + "=" + rowId, null, > > null, null, null, null); > > if (mCursor != null) { > > mCursor.moveToFirst(); > > } > > return mCursor; > > > } > > > public boolean updateNote(long rowId, int x, int y, int size) { > > ContentValues args = new ContentValues(); > > args.put(KEY_X, x); > > args.put(KEY_Y, y); > > args.put(KEY_Size, size); > > return mDb.update(DATABASE_TABLE, args, KEY_ROWID + "=" + > > rowId, null) > 0; > > } > > } > > > On Dec 28, 2:57 pm, Kostya Vasilyev <[email protected]> wrote: > > > Are all these supposed to be mapped to the same column, "_id", or is > > this a > > > copy / paste artifact? > > > > public static final String KEY_ROWID = "_id"; > > > public static final String KEY_X = "_id"; > > > public static final String KEY_Y = "_id"; > > > public static final String KEY_Size = "_id"; > > > > 29 декабря 2011 г. 1:50 пользователь Jeresam515 > > > <[email protected]>написал: > > > > > I did the notepad tutorials, and am using a modified version of that > > > > for my database. I don't understand why my program isn't correctly > > > > writing to it. Help would be greatly appreciated. > > > > > package com.drawing; > > > > > 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 NotesDbAdapter { > > > > > public static final String KEY_ROWID = "_id"; > > > > public static final String KEY_X = "_id"; > > > > public static final String KEY_Y = "_id"; > > > > public static final String KEY_Size = "_id"; > > > > private static final String TAG = "NotesDbAdapter"; > > > > private DatabaseHelper mDbHelper; > > > > private SQLiteDatabase mDb; > > > > private static final String DATABASE_CREATE = > > > > "create table notes (_id integer primary key autoincrement, " > > > > + "title text not null, body text not null);"; > > > > > private static final String DATABASE_NAME = "data"; > > > > private static final String DATABASE_TABLE = "notes"; > > > > private static final int DATABASE_VERSION = 2; > > > > > private final Context mCtx; > > > > > private static class DatabaseHelper extends SQLiteOpenHelper { > > > > > DatabaseHelper(Context context) { > > > > super(context, DATABASE_NAME, null, DATABASE_VERSION); > > > > } > > > > > @Override > > > > public void onCreate(SQLiteDatabase db) { > > > > > db.execSQL(DATABASE_CREATE); > > > > } > > > > > @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 notes"); > > > > onCreate(db); > > > > } > > > > } > > > > > public NotesDbAdapter(Context ctx) { > > > > this.mCtx = ctx; > > > > } > > > > > public NotesDbAdapter open() throws SQLException { > > > > mDbHelper = new DatabaseHelper(mCtx); > > > > mDb = mDbHelper.getWritableDatabase(); > > > > return this; > > > > } > > > > > public void close() { > > > > mDbHelper.close(); > > > > } > > > > > public long createNote(float f, float g, int size) { > > > > ContentValues initialValues = new ContentValues(); > > > > initialValues.put(KEY_X, f); > > > > initialValues.put(KEY_Y, g); > > > > initialValues.put(KEY_Size, size); > > > > return mDb.insert(DATABASE_TABLE, null, initialValues); > > > > } > > > > > public boolean deleteNote(long rowId) { > > > > > return mDb.delete(DATABASE_TABLE, KEY_ROWID + "=" + rowId, > > > > null) > 0; > > > > } > > > > > public Cursor fetchAllNotes() { > > > > > return mDb.query(DATABASE_TABLE, new String[] {KEY_ROWID, > > > > KEY_X,KEY_Y,KEY_Size}, null, null, null, null, null); > > > > } > > > > > public Cursor fetchNote(long rowId) throws SQLException { > > > > > Cursor mCursor = > > > > > mDb.query(true, DATABASE_TABLE, new String[] {KEY_ROWID, > > > > KEY_X,KEY_Y,KEY_Size}, KEY_ROWID + "=" + rowId, null, > > > > null, null, null, null); > > > > if (mCursor != null) { > > > > mCursor.moveToFirst(); > > > > } > > > > return mCursor; > > > > > } > > > > > public boolean updateNote(long rowId, int x, int y, int size) { > > > > ContentValues args = new ContentValues(); > > > > args.put(KEY_X, x); > > > > args.put(KEY_Y, y); > > > > args.put(KEY_Size, size); > > > > return mDb.update(DATABASE_TABLE, args, KEY_ROWID + "=" + > > > > rowId, null) > 0; > > > > } > > > > } > > > > > -- > > > > You received this message because you are subscribed to the Google > > > > Groups "Android Developers" group. > > > > To post to this group, send email to > > [email protected] > > > > To unsubscribe from this group, send email to > > > > [email protected] > > > > For more options, visit this group at > > > >http://groups.google.com/group/android-developers?hl=en > > > -- > > You received this message because you are subscribed to the Google > > Groups "Android Developers" group. > > To post to this group, send email to [email protected] > > To unsubscribe from this group, send email to > > [email protected] > > For more options, visit this group at > >http://groups.google.com/group/android-developers?hl=en
-- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
