Google Android - это несложно

Код: Выделить всё

public AddNews(String date, String DataAfterDate) {
			if (date == "now")
				LinkForNews = "http://radio24.ua/feeds/newsList.do";
			else {
				LinkForNews = "http://radio24.ua/feeds/newsList.do?fromTime=";
				LinkForNews = LinkForNews.concat(date);
				LinkForNews = LinkForNews.concat("&older=true");
			}
			dd = DataAfterDate;
		}

		public void run() {
			if(!AddingNews){
				AddingNews = true;
				Log.e("AddNews", "Start add news");
			if (InternetConnection()) {
				JSONParser jParser = new JSONParser();
				JSONObject jObject = jParser.getJSONFromUrl(LinkForNews);
				JSONArray jArray = new JSONArray();
				try {
					jArray = jObject.getJSONArray("radio24");
					for (int i = 0; i < jArray.length(); i++) {
						JSONObject jLocalObject = jArray.getJSONObject(i);
						id_news = jLocalObject.getInt("id");
						name_news = jLocalObject.getString("name");
						annotation_news = jLocalObject.getString("annotation");
						summary_news = jLocalObject.getString("summary");
						updateDate_news = jLocalObject.getString("updatedDate");
						imgnormalPath = jLocalObject.getString("imgnormalPath");
						imgsmallPath = jLocalObject.getString("imgsmallPath");
						InputStream is = (InputStream) new URL(imgsmallPath)
								.getContent();
						smallImage = Drawable.createFromStream(is, "srcName");
						AddToBD(id_news, name_news, annotation_news,
								summary_news, updateDate_news, imgsmallPath,
								imgnormalPath, DrawableToBlob(smallImage), null);

					}
				} catch (Exception e) {
					e.printStackTrace();
				}
				BDInListView d = new BDInListView(dd);
				d.start();
				while (d.isAlive()) {
				}
				
				
			}
			
		}				Log.e("AddNews", "Finish add news");

			AddingNews = false;
			}
	}

Код: Выделить всё

package com.example.radio;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;


public class ClassForBD extends SQLiteOpenHelper {
	// константы для конструктора
		private static final String DB_NAME = "DataBaseRadio24.db";
		private static final int DB_VERSION = 1;
	public ClassForBD(Context context) {
		super(context, DB_NAME, null, DB_VERSION);
		
		// TODO Auto-generated constructor stub
	}
	
	@Override
	public void onCreate(SQLiteDatabase db) {
		// TODO Auto-generated method stub
		db.execSQL("create table NewsRadio24 ("
		          + "ID_In_Site integer,"
		          + "Name text,"
		          + "Annotation text,"
		          + "Summary text,"
		          + "UpdateDate text,"
		          + "SmallImagePath text,"
		          + "NormalImagePath text,"
		          + "SmallImage blob,"
		          + "NormalImage blob"
		          + ");");
	
	}

	@Override
	public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
		// TODO Auto-generated method stub

	}
}

Код: Выделить всё

	public void AddToBD(int id, String name, String annotation, String summary,
			String updateDate, String SmallImagePath, String NormalImagePath,
			byte[] smallImageBlob, byte[] normImageBlob) {

		SQLiteDatabase BD = DBClass.getWritableDatabase();
		ContentValues cv = new ContentValues();
		cv.put("Id_In_Site", id);
		cv.put("Name", name);
		cv.put("Annotation", annotation);
		cv.put("Summary", summary);
		cv.put("UpdateDate", StringToMilisec(updateDate));
		cv.put("SmallImagePath", SmallImagePath);
		cv.put("NormalImagePath", NormalImagePath);
		cv.put("SmallImage", smallImageBlob);
		cv.put("NormalImage", normImageBlob);
		BD.insert("NewsRadio24", null, cv);
		cv.clear();
	}

Код: Выделить всё

 db.beginTransaction();
        try {
            addItems();
            db.setTransactionSuccessful();

        }catch {
            //Error in between database transaction 
        }finally {
                db.endTransaction();

        }