Beiträge von henny

public class Entry {
	private long id;
	private double BMI;
	


	public long getId() {
		return id;
	}


	public void setId(long id) {
		this.id = id;
	}


	public double getBMI() {
		return BMI;
	}


	public void setBMI(double BMI) {
		this.BMI = BMI;
	}
	
	@Override
	public String toString() {
		
		return String.format("Your last BMI: %d " , BMI);
	}
}

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


public class MySQLiteHelper extends SQLiteOpenHelper {
	
	private static final String DATABASE_NAME = "BMITrend.db";
	private static final int DATABASE_VERSION = 1;


	
	private static final String TABLE_CREATE_BMIVERLAUF = ""
			+"create table BMIVERLAUF("
			+"  ID integer primary key autoincrement, "
			+   "BMI double)";
			


	public MySQLiteHelper(Context context) {
		super(context, DATABASE_NAME, null, DATABASE_VERSION);
	}


	@Override
	public void onCreate(SQLiteDatabase database) {
		database.execSQL(TABLE_CREATE_BMIVERLAUF);
	}


	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		Log.w(MySQLiteHelper.class.getName(),
			"Upgrading database from version " + oldVersion + " to "
					+ newVersion + ", which will destroy all old data");
	db.execSQL("DROP TABLE IF EXISTS SCANITEM");
	onCreate(db);
}
}

import java.util.ArrayList;
import java.util.List;
import de.fasterworm.bmidroid.MySQLiteHelper;
import de.fasterworm.bmidroid.Entry;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;




public class VerlaufDataSource {


	
	private SQLiteDatabase database;
	private MySQLiteHelper dbHelper;
	private String[] allColumns = { "ID","BMI"};


	
	
	public VerlaufDataSource(Context context) {
		dbHelper = new MySQLiteHelper(context);
	}
	
	public void open() throws SQLException {
		database = dbHelper.getWritableDatabase();
	}


	public void close() {
		dbHelper.close();
	}
	
	public Entry createEntry(double BMI) {
		ContentValues values = new ContentValues();
		values.put("BMI", BMI);


		long insertId = database.insert("BMIVERLAUF", null,
				values);
		
		
		Cursor cursor = database.query("BMIVERLAUF",allColumns, "ID = " + insertId, null, null, null, null);
		cursor.moveToFirst();
	
		return cursorToEntry(cursor);
	}


	protected List<Entry> getAllEntries() {
		List<Entry> EntriesList = new ArrayList<Entry>();
		EntriesList = new ArrayList<Entry>();
		
		Cursor cursor = database.query("BMIVERLAUF", allColumns, null, null, null, null, null);
		cursor.moveToFirst();
		
		if(cursor.getCount() == 0) return EntriesList;
		
		
		while (cursor.isAfterLast() == false) {
			Entry entry = cursorToEntry(cursor);
			EntriesList.add(entry);
			cursor.moveToNext();
		} 	


		cursor.close();
		
		return EntriesList;
	}
	


	private Entry cursorToEntry(Cursor cursor) {
		Entry entry = new Entry();
		entry.setId(cursor.getLong(0));
		entry.setBMI(cursor.getDouble(1));


		return entry;
	}
	
}