The following slides give an Android SQLite project.

Slide 12.1: An Android SQLite project
Slide 12.2: Manifest file
Slide 12.3: Layout XML code
Slide 12.4: Strings and the R file

Slide 12.5: Java source code
Slide 12.6: TestDatabase.java
Slide 12.7: TestDatabase.java (cont.)
Slide 12.8: TestDatabase.java (cont.)
Slide 12.9: TestDatabase.java (cont.)
Slide 12.10: TestDatabase.java (cont.)

Slide 12.11: CommentsDataSource.java
Slide 12.12: CommentsDataSource.java (cont.)
Slide 12.13: CommentsDataSource.java (cont.)
Slide 12.14: CommentsDataSource.java (cont.)
Slide 12.15: CommentsDataSource.java (cont.)
Slide 12.16: CommentsDataSource.java (cont.)

Slide 12.17: MySQLiteHelper.java
Slide 12.18: MySQLiteHelper.java (cont.)
Slide 12.19: MySQLiteHelper.java (cont.)

Slide 12.20: Comment.java

  ☂ References

Slide 12.a: Android SQLite construction (video: 25:52 minutes)
The code is correct, but you may need to use an emulator with a high API like API 35 in order to make it work.







      “Just say NO to drugs;”    
      “Well, if I’m talking to my drugs...    
      I probably already said yes.”