Advertisement
Guest User

Untitled

a guest
Dec 2nd, 2016
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.89 KB | None | 0 0
  1. public static final String TAG = Course.class.getSimpleName();
  2.  
  3. package com.instinctcoder.sqlitedbmultitbl.data.model;
  4.  
  5. /**
  6. * Created by Tan on 1/26/2016.
  7. */
  8. public class Course {
  9.  
  10. public static final String TAG = Course.class.getSimpleName();
  11. public static final String TABLE = "Course";
  12. // Labels Table Columns names
  13. public static final String KEY_CourseId = "CourseId";
  14. public static final String KEY_Name = "Name";
  15.  
  16. private String courseId;
  17. private String name;
  18.  
  19.  
  20. public String getCourseId() {
  21. return courseId;
  22. }
  23.  
  24. public void setCourseId(String courseId) {
  25. this.courseId = courseId;
  26. }
  27.  
  28. public String getName() {
  29. return name;
  30. }
  31.  
  32. public void setName(String name) {
  33. this.name = name;
  34. }
  35. }
  36.  
  37. db.execSQL(CourseRepo.createTable());
  38. db.execSQL(StudentRepo.createTable());
  39. db.execSQL(MajorRepo.createTable());
  40. db.execSQL(StudentCourseRepo.createTable());
  41.  
  42. package com.instinctcoder.sqlitedbmultitbl.data;
  43.  
  44. /**
  45. * Created by Tan on 1/26/2016.
  46. */
  47. import android.content.Context;
  48. import android.database.sqlite.SQLiteDatabase;
  49. import android.database.sqlite.SQLiteOpenHelper;
  50. import android.util.Log;
  51.  
  52. import com.instinctcoder.sqlitedbmultitbl.app.App;
  53. import com.instinctcoder.sqlitedbmultitbl.data.model.Course;
  54. import com.instinctcoder.sqlitedbmultitbl.data.model.Major;
  55. import com.instinctcoder.sqlitedbmultitbl.data.model.Student;
  56. import com.instinctcoder.sqlitedbmultitbl.data.model.StudentCourse;
  57. import com.instinctcoder.sqlitedbmultitbl.data.repo.CourseRepo;
  58. import com.instinctcoder.sqlitedbmultitbl.data.repo.MajorRepo;
  59. import com.instinctcoder.sqlitedbmultitbl.data.repo.StudentCourseRepo;
  60. import com.instinctcoder.sqlitedbmultitbl.data.repo.StudentRepo;
  61.  
  62.  
  63. public class DBHelper extends SQLiteOpenHelper {
  64. //version number to upgrade database version
  65. //each time if you Add, Edit table, you need to change the
  66. //version number.
  67. private static final int DATABASE_VERSION =8;
  68. // Database Name
  69. private static final String DATABASE_NAME = "sqliteDBMultiTbl.db";
  70. private static final String TAG = DBHelper.class.getSimpleName().toString();
  71.  
  72. public DBHelper( ) {
  73. super(App.getContext(), DATABASE_NAME, null, DATABASE_VERSION);
  74. }
  75.  
  76. @Override
  77. public void onCreate(SQLiteDatabase db) {
  78. //All necessary tables you like to create will create here
  79. db.execSQL(CourseRepo.createTable());
  80. db.execSQL(StudentRepo.createTable());
  81. db.execSQL(MajorRepo.createTable());
  82. db.execSQL(StudentCourseRepo.createTable());
  83. }
  84.  
  85. @Override
  86. public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  87. Log.d(TAG, String.format("SQLiteDatabase.onUpgrade(%d -> %d)", oldVersion, newVersion));
  88.  
  89. // Drop table if existed, all data will be gone!!!
  90. db.execSQL("DROP TABLE IF EXISTS " + Course.TABLE);
  91. db.execSQL("DROP TABLE IF EXISTS " + Student.TABLE);
  92. db.execSQL("DROP TABLE IF EXISTS " + Major.TABLE);
  93. db.execSQL("DROP TABLE IF EXISTS " + StudentCourse.TABLE);
  94. onCreate(db);
  95. }
  96.  
  97. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement