// DBHelper.
java
package [Link];
import [Link];
import [Link];
import [Link];
public class DBHelper extends SQLiteOpenHelper {
public static final String DATABASE_NAME = "NotesDB";
public static final int DATABASE_VERSION = 1;
public static final String TABLE_NAME = "notes";
public static final String COL_ID = "id";
public static final String COL_NOTE = "note";
public DBHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
String createTable = "CREATE TABLE " + TABLE_NAME + "("
+ COL_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
+ COL_NOTE + " TEXT)";
[Link](createTable);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldV, int newV) {
[Link]("DROP TABLE IF EXISTS " + TABLE_NAME);
onCreate(db);
}
}
// Add in [Link]
import [Link];
import [Link];
import [Link];
public boolean insertNote(String noteText) {
SQLiteDatabase db = [Link]();
ContentValues values = new ContentValues();
[Link](COL_NOTE, noteText);
long result = [Link](TABLE_NAME, null, values);
return result != -1;
}
public ArrayList<String> getAllNotes() {
ArrayList<String> notes = new ArrayList<>();
SQLiteDatabase db = [Link]();
Cursor cursor = [Link]("SELECT * FROM " + TABLE_NAME, null);
if ([Link]()) {
do {
[Link]([Link]([Link](COL_NOTE)));
} while ([Link]());
}
[Link]();
return notes;
}// Add in [Link]
import [Link];
import [Link];
import [Link];
public boolean insertNote(String noteText) {
SQLiteDatabase db = [Link]();
ContentValues values = new ContentValues();
[Link](COL_NOTE, noteText);
long result = [Link](TABLE_NAME, null, values);
return result != -1;
}
public ArrayList<String> getAllNotes() {
ArrayList<String> notes = new ArrayList<>();
SQLiteDatabase db = [Link]();
Cursor cursor = [Link]("SELECT * FROM " + TABLE_NAME, null);
if ([Link]()) {
do {
[Link]([Link]([Link](COL_NOTE)));
} while ([Link]());
}
[Link]();
return notes;
}
<!-- res/layout/activity_main.xml -->
<LinearLayout xmlns:android="[Link]
android:orientation="vertical"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:padding="16dp">
<EditText
android:id="@+id/etNote"
android:hint="Enter note"
android:layout_width="match_parent"
android:layout_height="wrap_content"/>
<Button
android:id="@+id/btnAdd"
android:text="Add Note"
android:layout_width="wrap_content"
android:layout_height="wrap_content"/>
<TextView
android:id="@+id/tvNotes"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:paddingTop="16dp"/>
</LinearLayout>
// [Link]
package [Link];
import [Link];
import [Link];
import [Link].*;
import [Link];
import [Link];
public class MainActivity extends AppCompatActivity {
EditText etNote;
Button btnAdd;
TextView tvNotes;
DBHelper dbHelper;
@Override
protected void onCreate(Bundle savedInstanceState) {
[Link](savedInstanceState);
setContentView([Link].activity_main);
etNote = findViewById([Link]);
btnAdd = findViewById([Link]);
tvNotes = findViewById([Link]);
dbHelper = new DBHelper(this);
loadNotes();
[Link](new [Link]() {
@Override
public void onClick(View v) {
String note = [Link]().toString();
if (![Link]()) {
[Link](note);
[Link]("");
loadNotes();
}
}
});
}
private void loadNotes() {
ArrayList<String> notes = [Link]();
StringBuilder builder = new StringBuilder();
for (String note : notes) {
[Link]("- ").append(note).append("\n");
}
[Link]([Link]());
}
}
