Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public Makanan getInfoMakan(String dataPagiString){
- Makanan maem = new Makanan();
- SQLiteDatabase db = getReadableDatabase();
- String q = "select * from public_makanan where nama_bahan = '"+dataPagiString+"'";
- Cursor cursor = db.rawQuery(q, null);
- if(cursor.moveToFirst()){
- do{
- for(int i=0;i<cursor.getColumnCount();i++){
- maem.setId_makanan(cursor.getInt(0));
- maem.setNama_bahan(cursor.getString(1));
- maem.setEnergi(cursor.getInt(2));
- maem.setPhewani(cursor.getDouble(3));
- maem.setPnabati(cursor.getDouble(4));
- maem.setLemak(cursor.getDouble(5));
- maem.setHa(cursor.getDouble(6));
- maem.setKalsium(cursor.getDouble(7));
- maem.setFosfor(cursor.getDouble(8));
- maem.setFe(cursor.getDouble(9));
- maem.setVitamin_A(cursor.getDouble(10));
- maem.setVitamin_B(cursor.getDouble(11));
- maem.setVitamin_C(cursor.getDouble(12));
- maem.setNatrium(cursor.getDouble(13));
- maem.setKalium(cursor.getDouble(14));
- maem.setKholesterol(cursor.getDouble(15));
- maem.setAir(cursor.getDouble(16));
- maem.setVitamin_D(cursor.getDouble(17));
- maem.setVitamin_E(cursor.getDouble(18));
- maem.setVitamin_K(cursor.getDouble(19));
- maem.setTitamin(cursor.getDouble(20));
- maem.setRiboflavin(cursor.getDouble(21));
- maem.setNiasin(cursor.getDouble(22));
- maem.setVitamin_B12(cursor.getDouble(23));
- maem.setBDD(cursor.getDouble(24));
- maem.setKelompok(cursor.getString(25));
- maem.setGolongan(cursor.getString(26));
- maem.setHarga(cursor.getInt(33));
- }
- }while(cursor.moveToNext());
- }
- return maem;
- }
Advertisement
Add Comment
Please, Sign In to add comment