public void sendList(View view) { message = editText.getText().toString(); if (message.length() > 0) { SQLiteDatabase db = NB.getReadableDatabase(); // String command = "select distict title from Notes"; Cursor C = db.query("TextTable", new String[] {"id", "text"}, null, null, null, null, null); C.moveToLast(); int nextpos; if (C.getCount() < 1) { nextpos = 1; } else { nextpos = C.getInt(0); nextpos++; } SQLiteDatabase dataB = NB.getWritableDatabase(); ContentValues vals = new ContentValues(); vals.put("id", nextpos); vals.put("title", Title); vals.put("text", message); // isnew = true; if (isnew) { dataB.insert("TextTable", null, vals); } else { Toast.makeText(getApplicationContext(), "Updated", Toast.LENGTH_SHORT).show(); dataB.update("TextTable", vals, "title=? AND text=?", new String[] {Title, Text}); } dataB.close(); } else { Toast.makeText(getApplicationContext(), "Nothing Entered", Toast.LENGTH_SHORT).show(); } editText.setText(""); NotesContentPage.NCP.finish(); try { Class ourClass = Class.forName("com.example.notetest." + "NotesContentPage"); Intent intent1 = new Intent(NewNote.this, ourClass); intent1.putExtra("NoteSelected", Title); startActivity(intent1); } catch (ClassNotFoundException e) { e.printStackTrace(); } }
@Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_new_note); editText = (EditText) findViewById(R.id.editText1); Title = getIntent().getExtras().getString("title"); String temp = getIntent().getExtras().getString("new"); if (temp.equals("no")) { isnew = false; } else { isnew = true; } if (isnew) { Text = ""; } else { Text = getIntent().getExtras().getString("text"); } setTitle("List: " + Title + ":EditMode"); NB = new NoteBase(this); /* SQLiteDatabase dataB = NB.getWritableDatabase(); ContentValues vals = new ContentValues(); vals.put("id", 4); vals.put("title", "todo"); vals.put("text", "do math"); dataB.insert("TextTable", null, vals); dataB.close(); */ SQLiteDatabase db = NB.getReadableDatabase(); Cursor C = db.query( "TextTable", new String[] {"id", "text"}, "title=? and text=?", new String[] {Title, Text}, null, null, null); if (C == null) { // Toast.makeText(getApplicationContext(), "nope", Toast.LENGTH_SHORT).show(); } else if (!(C.moveToFirst()) || C.getCount() == 0) { // Toast.makeText(getApplicationContext(), "empty", Toast.LENGTH_SHORT).show(); } else { /// Toast.makeText(getApplicationContext(), "gto sometink", Toast.LENGTH_SHORT).show(); C.moveToLast(); do { editText.setText(C.getString(1)); } while (C.moveToPrevious()); } db.close(); NB.close(); String newtext = editText.getText().toString(); editText.setText(""); editText.append(newtext); }