I wants to make a expert system with android platform using CF method. So, I have designed my application with indication table in multiple checkbox list form. If indication was checked, there is a diseases diagnose and the solution.
Problem : how I can import/show indication data from table sqlite to checkbox list form? Please help, if anyone understand about my problem.
DBAdapter.java
public class DBAdapter extends SQLiteOpenHelper {
public static final String ROW_KODE = "id";
public static final String ROW_NAMA = "nama";
private static final String DATABASE_NAME = "pakar_ayam";
private static final int DATABASE_VERSION = 1;
private static final String tabel_gejala = "tbl_gejala";
private static final String CREATE_tabel_gejala = "CREATE TABLE" +
tabel_gejala + " ( " + ROW_KODE + " TEXT, " + ROW_NAMA + " TEXT);";
public DBAdapter(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION );
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL(CREATE_tabel_gejala);
ContentValues isiGejala = new ContentValues();
isiGejala.put(ROW_KODE, "G01");
isiGejala.put(ROW_NAMA, "Bersin");
db.insert(tabel_gejala, null, isiGejala);
isiGejala.put(ROW_KODE, "G02");
isiGejala.put(ROW_NAMA, "Diare");
db.insert(tabel_gejala, null, isiGejala);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion){
// TODO Auto-generated method stub
db.execSQL("DROP TABLE IF EXISTS " + tabel_gejala);
onCreate(db);
}
}
Aucun commentaire:
Enregistrer un commentaire