Advertisement
Guest User

Untitled

a guest
Jul 25th, 2016
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.05 KB | None | 0 0
  1. NetworkUtils utils = new NetworkUtils(getApplicationContext());
  2. if(utils.isConnectingToInternet())
  3. {
  4. getSpinnerData();
  5. }
  6. else
  7. {
  8. List<VideoJson> videoList = db.getAllVideos();
  9. Log.e("List is","=> "+videoList);
  10. adapter = new VideoAdapter(videoList, this);
  11. recyclerView.setAdapter(adapter);
  12. }
  13. }
  14.  
  15. private void parseData(JSONArray array) {
  16. for (int i = 0; i < array.length(); i++) {
  17. VideoJson model = new VideoJson();
  18. JSONObject json = null;
  19. try {
  20. json = array.getJSONObject(i);
  21. String vedio_name = json.getString(Config.TAG_VIDEO_TEXT);
  22. String vedio_url = json.getString(Config.TAG_VIDEO_URL);
  23. String vedio_img = json.getString(Config.TAG_VIDEO_IMAGE);
  24. model.setName_video(vedio_name);
  25. model.setImageUrl_video(vedio_url);
  26. model.setVedio_thambnail(vedio_img);
  27. Log.e("name","is =>"+vedio_name);
  28. Log.e("url","is =>"+vedio_url);
  29. Log.e("image","is =>"+vedio_img);
  30. db.addVideos(model);
  31. Log.e("database","value is"+db);
  32. } catch (JSONException e) {
  33. e.printStackTrace();
  34. }
  35.  
  36. public class VideoDataBase extends SQLiteOpenHelper {
  37.  
  38. private static final int DB_VERSION = 4;
  39. private static final String DB_NAME = "SocialApp";
  40. private static final String TABLE_VIDEOS= "videos";
  41.  
  42. private static final String KEY_VIDEO_ID = "video_id";
  43. private static final String KEY_VIDEO_NAME = "video_id_text";
  44. private static final String KEY_VIDEO_URL ="video_id_url";
  45. private static final String KEY_VIDEO_THUMBNAIL ="video_thumb";
  46.  
  47.  
  48.  
  49. private static final String CREATE_TABLE_VIDEO = "CREATE TABLE "
  50. + TABLE_VIDEOS
  51. + " ( "
  52. + KEY_VIDEO_ID + " INTEGER PRIMARY KEY, "
  53. + KEY_VIDEO_NAME + " TEXT, "
  54. + KEY_VIDEO_URL + " TEXT, "
  55. + KEY_VIDEO_THUMBNAIL + " TEXT) ";
  56. public VideoDataBase(Context context) {
  57. super(context, DB_NAME, null, DB_VERSION);
  58. }
  59.  
  60. @Override
  61. public void onCreate(SQLiteDatabase db) {
  62. db.execSQL(CREATE_TABLE_VIDEO);
  63. Log.e("table name","==>"+CREATE_TABLE_VIDEO);
  64. }
  65.  
  66. @Override
  67. public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  68. Log.w(TextDataBase.class.getName(),
  69. "Upgrading database from version " + oldVersion + " to "
  70. + newVersion + ", which will destroy all old data");
  71. db.execSQL("DROP TABLE IF EXISTS "+TABLE_VIDEOS);
  72. onCreate(db);
  73. }
  74.  
  75. public void addVideos(VideoJson model){
  76. SQLiteDatabase db = this.getWritableDatabase();
  77. try{
  78. ContentValues values = new ContentValues();
  79. values.put(KEY_VIDEO_NAME, model.getName_video());
  80. values.put(KEY_VIDEO_URL, model.getImageUrl_video());
  81. values.put(KEY_VIDEO_THUMBNAIL, model.getVedio_thambnail());
  82. db.insert(TABLE_VIDEOS, null, values);
  83. Log.e("this db","value is"+values);
  84. db.close();
  85. }catch (Exception e){
  86. Log.e("problem",e+"");
  87. }
  88. }
  89.  
  90. public List<VideoJson> getAllVideos() {
  91. SQLiteDatabase db = this.getReadableDatabase();
  92. List<VideoJson> videoList = null;
  93. try{
  94. videoList = new ArrayList<VideoJson>();
  95. String QUERY = "SELECT * FROM "+TABLE_VIDEOS;
  96. Cursor cursor = db.rawQuery(QUERY, null);
  97. if(!cursor.isLast())
  98. {
  99. while (cursor.moveToNext())
  100. {
  101. VideoJson videolist = new VideoJson();
  102. videolist.setVideo_id(cursor.getInt(0));
  103. videolist.setName_video(cursor.getString(1));
  104. videolist.setImageUrl_video(cursor.getString(2));
  105. videolist.setVedio_thambnail(cursor.getString(3));
  106.  
  107. videoList.add(videolist);
  108. }
  109. }
  110. db.close();
  111. }catch (Exception e){
  112. Log.e("error",e+"");
  113. }
  114. return videoList;
  115. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement