Xz7xgJGe

1public class DBAdapter {
2
3public static final String KEY_ROWID = "_id";
4public static final String KEY_NOTE = "note";
5public static final String KEY_USER = "user";
6private static final String TAG = "DBAdapter";
7private static final String DATABASE_NAME = "MyDB";
8private static final String DATABASE_TABLE = "notes";
9private static final int DATABASE_VERSION = 1;
10private static final String DATABASE_CREATE =
11        "create table notes (_id integer primary key autoincrement, "
12                + "note text not null, user text not null);";
13private final Context context;
14private DatabaseHelper DBHelper;
15private SQLiteDatabase db;
16
17public DBAdapter(Context ctx) {
18    this.context = ctx;
19    DBHelper = new DatabaseHelper(context);
20}
21
22private static class DatabaseHelper extends SQLiteOpenHelper {
23    DatabaseHelper(Context context) {
24        super(context, DATABASE_NAME, null, DATABASE_VERSION);
25    }
26
27    @Override
28    public void onCreate(SQLiteDatabase db) {
29        try {
30            db.execSQL(DATABASE_CREATE);
31        } catch (SQLException e) {
32            e.printStackTrace();
33        }
34    }
35
36    @Override
37    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
38        Log.w(TAG, "Upgrading database from version " + oldVersion + " to "
39                + newVersion + ", which will destroy all old data");
40        db.execSQL("DROP TABLE IF EXISTS notes");
41        onCreate(db);
42    }
43}
44
45
46//---opens the database---
47public DBAdapter open() throws SQLException {
48    db = DBHelper.getWritableDatabase();
49    return this;
50}
51
52
53//---closes the database---
54public void close() {
55    DBHelper.close();
56}
57
58
59//---insert a contact into the database---
60public long insertNote(String note, String user) {
61    ContentValues initialValues = new ContentValues();
62    initialValues.put(KEY_NOTE, note);
63    initialValues.put(KEY_USER, user);
64    return db.insert(DATABASE_TABLE, null, initialValues);
65}
66
67
68//---deletes a particular contact---
69public boolean deleteNote(long rowId) {
70    return db.delete(DATABASE_TABLE, KEY_ROWID + "=" + rowId, null) > 0;
71}
72
73
74//---retrieves all the contacts---
75public Cursor getAllNotes() {
76    return db.query(DATABASE_TABLE, new String[]{KEY_ROWID, KEY_NOTE, KEY_USER},
77            null, null, null, null, null);
78}
79
80
81//---retrieves a particular contact---
82public Cursor getNote(long rowId) throws SQLException {
83    Cursor mCursor = db.query(true, DATABASE_TABLE, new String[]{KEY_ROWID,
84                    KEY_NOTE, KEY_USER}, KEY_ROWID + "=" + rowId, null,
85            null, null, null, null);
86    if (mCursor != null) {
87        mCursor.moveToFirst();
88    }
89    return mCursor;
90}
91
92
93//---updates a contact---
94public boolean updateNote(long rowId, String name, String email) {
95    ContentValues args = new ContentValues();
96    args.put(KEY_NOTE, name);
97    args.put(KEY_USER, email);
98    return db.update(DATABASE_TABLE, args, KEY_ROWID + "=" + rowId, null) > 0;
99}
100	
101@Override
102protected void onCreate(Bundle savedInstanceState) {
103    super.onCreate(savedInstanceState);
104    setContentView(R.layout.activity_main);
105
106    Button dbButton = (Button) findViewById(R.id.dbBtn);
107    Button selectAllBtn = (Button) findViewById(R.id.selectAllBtn);
108    final EditText dbText = (EditText) findViewById(R.id.dbText);
109    final EditText dbTextSecond = (EditText) findViewById(R.id.dbTextSecond);
110
111
112    final DBAdapter db = new DBAdapter(MainActivity.this);
113
114    dbButton.setOnClickListener(new View.OnClickListener() {
115        @Override
116        public void onClick(View v) {
117            db.open();
118            db.insertNote(dbText.getText().toString(), dbTextSecond.getText().toString());
119            db.close();
120            Toast.makeText(getBaseContext(), "Inserted", Toast.LENGTH_SHORT).show();
121        }
122    });
123@Override
124protected void onStart() {
125    super.onStart();
126}