jeudi 15 octobre 2015

how to get details in list view from sqlite database in android

i want display all details in list view from sqlite database. and how to set custom adopter in main activity please help me. my code is here....

public class MainActivity extends Activity {

    EditText eid,ename;
    Button add;
    public DatabaseClass mdb=null;
    public Cursor c=null;
    public SQLiteDatabase db=null;
    public static final String DATABASE_NAME="Sample.db";
    public static final int DATABASE_VERSION=1;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        eid=(EditText)findViewById(R.id.rid);
        ename=(EditText)findViewById(R.id.rname);
        add=(Button)findViewById(R.id.radd);        
        mdb=new DatabaseClass(getApplicationContext(), DATABASE_NAME, null, DATABASE_VERSION);

        add.setOnClickListener(new View.OnClickListener() {         
            @Override
            public void onClick(View arg0) {
                // TODO Auto-generated method stub
                db = mdb.getWritableDatabase();
                ContentValues cv=new ContentValues();
                int id=Integer.parseInt(eid.getText().toString());
                String name=ename.getText().toString();

                cv.put("ID",id );
                cv.put("NAME",name );
                db.insert("DEMO", null, cv);

            }
        }); 

    }
}

database class

public class DatabaseClass extends SQLiteOpenHelper{

    public DatabaseClass(Context context, String name, CursorFactory factory,
            int version) {
        super(context, name, factory, version);
        // TODO Auto-generated constructor stub
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        db.execSQL("CREATE TABLE DEMO(ID INTEGER,NAME VARCHAR);");

    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
{
        // TODO Auto-generated method stub

    }

}

Aucun commentaire:

Enregistrer un commentaire