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
