lundi 10 août 2015

Display SqLite Select value in textfield

I'm trying to display SQLite table value in text field. This is my code, but it's not working. I have table(SAP_DRQ_TABLE ) with two fields(SAP_DRQ_KEY_METROLAC ,SAP_DRQ_KEY_DRC).

DBHelper.java

private static final String SAP_DRQ_TABLE = "sap_drq";
public static final String SAP_DRQ_KEY_METROLAC = "metrolac";
public static final String SAP_DRQ_KEY_DRC= "drc";

public List<SAP_DRQDatamodel> SAP_DRQDatamodel() {
        // TODO Auto-generated method stub
        List<SAP_DRQDatamodel> drc = new ArrayList<SAP_DRQDatamodel>();

        // Select All Query
        String selectQuery = "SELECT  * FROM " + SAP_DRQ_TABLE +" where"+SAP_DRQ_KEY_METROLAC+"='50'" ;

        SQLiteDatabase db = this.getReadableDatabase();
        Cursor cursor = db.rawQuery(selectQuery, null);

        // looping through all rows and adding to list
        if (cursor.moveToFirst()) {
            do {
                SAP_DRQDatamodel codes = new SAP_DRQDatamodel();
                codes.setdrc(cursor.getString(cursor.getColumnIndex(SAP_DRQ_KEY_DRC)));
            } while (cursor.moveToNext());
        }

        // closing connection
        cursor.close();
        db.close();
        // returning lables
        return drc;
    }

dashbord.java

DBHelper db = new DBHelper(getApplicationContext());
List<SAP_DRQDatamodel> DRQval= db.SAP_DRQDatamodel();
for (SAP_DRQDatamodel DRQ : DRQval){
    mDRQ.setText(DRQ.getdrc());
}

SAP_DRQDATAMODEL

public class SAP_DRQDatamodel {

    public String getmetrolac() {
        return metrolac;
    }

    public void setmetrolac(String metrolac) {
        this.metrolac = metrolac;
    }

    public String getdrc() {
        return drc;
    }

    public void setdrc(String drc) {
        this.drc = drc;
    }

    public String metrolac="", drc="";

}

Aucun commentaire:

Enregistrer un commentaire